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?

Comments

Expt on 28 August, 2008 at 12:56 pm #

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


Arundhati Bakshi on 29 August, 2008 at 12:54 am #

create database database_name;


ramya nandavarik on 31 August, 2008 at 6:30 pm #

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;


Tanmoy on 1 September, 2008 at 2:09 pm #

ramya nandavarik ias very right follow him


Post a Comment
Name:
Email:
Website:
Comments: