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; +--+--+--+-+-+---+ | Field

Re: Three Questions :

2004-11-24 Thread SGreen
. 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. 1. mysql

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(128) binary NOT NULL

Re: Fwd: Three Questions

2004-11-16 Thread Michael Stassen
, 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 warning (0.00 sec) mysql desc board

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 desc board

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; Query OK, 0 rows affected, 0 warning (0.00 sec) mysql desc

Re: Three Questions

2004-11-12 Thread Brent Baisley
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) binary NOT NULL, - title varchar(128) binary NOT NULL, - ) ENGINE=MYISAM