PDA

View Full Version : mysql


bongbox
10-27-2003, 12:37 PM
i want to make a database using mysql instead of msaccess it will only contain 2 datas name and message.. how do i do this with mysql?

freddycodes
10-27-2003, 12:52 PM
Do you already have MySQL installed and configured?

If so, log into the MySQL console.


mysql>create table whatevernameIyuwant (
id int (11) not null unsigned auto_increment primary key,
name varchar(100),
message text
);



Thats pretty much it, I gave it an auto-incrementing primary key just so we could associate an id to the name and message purely for querying the database and whatnot.