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;
Comments on How do I go about making a MySQL database?
Get the administrative GUI for the database and it is simple to work with.
create database database_name;
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;
ramya nandavarik ias very right follow him