Re: Three Questions :

2004-11-24 Thread SGreen
. 3. http://dev.mysql.com/doc/mysql/en/Date_and_time_type_overview.html http://dev.mysql.com/doc/mysql/en/Using_DATE.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine litlpooh <[EMAIL PROTECTED]> wrote on 11/24/2004 09:44:22 AM: > I have three questions about mysql. &

Three Questions :

2004-11-24 Thread litlpooh
I have three questions about mysql. 1. mysql> CREATE TABLE board ( -> boardid char(6) binary NOT NULL, -> title varchar(128) binary NOT NULL, -> ) ENGINE=MYISAM; Query OK, 0 rows affected, 0 warning (0.00 sec) mysql> desc board; +--+--+--+-+-+-

Re: Fwd: Three Questions

2004-11-16 Thread Michael Stassen
D]> Date: Fri, 12 Nov 2004 16:46:02 +0900 Subject: Three Questions To: [EMAIL PROTECTED] I have three questions about mysql. 1. mysql> CREATE TABLE board ( -> boardid char(6) binary NOT NULL, -> title varchar(128) binary NOT NULL, -> ) ENGINE=MYISAM; Query OK, 0 rows affected, 0 wa

Fwd: Three Questions

2004-11-16 Thread litlpooh
-- Forwarded message -- From: litlpooh <[EMAIL PROTECTED]> Date: Fri, 12 Nov 2004 16:46:02 +0900 Subject: Three Questions To: [EMAIL PROTECTED] I have three questions about mysql. 1. mysql> CREATE TABLE board ( -> boardid char(6) binary NOT NULL, -> title varchar(

Re: Three Questions

2004-11-12 Thread Brent Baisley
millisecond detail. But if you want to track time in millisecond detail, you should probably use FLOAT, where milliseconds would be the decimal value. On Nov 12, 2004, at 2:46 AM, litlpooh wrote: I have three questions about mysql. 1. mysql> CREATE TABLE board ( -> boardid char(6

Re: Three Questions

2004-11-12 Thread Alec . Cawley
litlpooh <[EMAIL PROTECTED]> wrote on 12/11/2004 07:46:02: > I have three questions about mysql. > > > 1. > mysql> CREATE TABLE board ( > -> boardid char(6) binary NOT NULL, > -> title varchar(128) binary NOT NULL, > -> ) ENGINE=MYISAM; > Q

Three Questions

2004-11-12 Thread litlpooh
I have three questions about mysql. 1. mysql> CREATE TABLE board ( -> boardid char(6) binary NOT NULL, -> title varchar(128) binary NOT NULL, -> ) ENGINE=MYISAM; Query OK, 0 rows affected, 0 warning (0.00 sec) mysql