mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
Straight from
http://www.mysql.com/doc/C/r/Creating_tables.html
Look over
http://www.mysql.com/doc/index.html
Enjoy
M;)
-----Original Message-----
From: louie miranda [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 19, 2001 8:25 PM
To: [EMAIL PROTECTED]
Subject: how to create a table and a column..?
i know this is easy for some of you guys,
im just starting making some tables and column..
and can't figure out how, ive read the manual and can't seem
to understand it yet fully.
just want to try this but can't seem to work..
i tried creating a table and a column..
like..
mysql> CREATE TABLE tableone;
it has error..
how can i make a table w/ column?
hmm..
thanks
louie
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php