.
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.
&
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;
+--+--+--+-+-+-
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
-- 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(
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
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
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