September 19, 2008

How do I go about making a MySQL database?

mysql
amadeus93lee asked:


I’ve searched on the internet and in Dreamweaver help, but I can’t find clear instructions on how to make a MySQL database. Can anyone help?

Tags: , ,

Filed under Programming & Design by administrator

Permalink Print

Comments on How do I go about making a MySQL database?

September 20, 2008

Expt @ 8:52 pm

Get the administrative GUI for the database and it is simple to work with.

September 22, 2008

Arundhati Bakshi @ 3:27 am

create database database_name;

ramya nandavarik @ 5:06 am

on linux command prompt
type
mysql
then u ll get this prompt “>”
then type show databases;
u ll get a list of existin ones
next chhose a name and type
create database database_name;
next type
use database_name;
now createtables
create table table_name(attribute_name1 type,
attribute_name2 type,
………….
);
type can be int,char,varchar(n),,,,,,,,
next use
insert into table_name values(’sjhg’,'jefh’,,,,,,,,,,,,,,,,,,);
then u can view by
select * from table_name;

September 25, 2008

Tanmoy @ 7:22 am

ramya nandavarik ias very right follow him