[SOLVED] datetime help

[sasori]

im practicing to build a database, i was building a customerorderinfo database with 3 tables

- customer table

- item table

- item_order table

 

but am having problem creating a datetime in the item_order table

here's my supposed to be syntax in item_order table

 

CREATE TABLE item_order (
cust_id BIGINT,
item_order SERIAL,
date  <---  this is the part i don't know what to place LOL

 

???

[Hooker]

This will enter the current date/time when the record is inserted:

  date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

 

Two other points though, unless you're going to have over 2 billion customers, BIGINT is unessisary and is bad practice as far as mysql performance goes. "SERIAL" is just an ALIAS for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, so again.. look into INT or TINYINT

[sasori]

This will enter the current date/time when the record is inserted:

  date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

 

Two other points though, unless you're going to have over 2 billion customers, BIGINT is unessisary and is bad practice as far as mysql performance goes. "SERIAL" is just an ALIAS for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, so again.. look into INT or TINYINT

 

thanks for the tips sir.. but what about the YYYY-MM-DD and HH:MM:SS thing goes ?

[Hooker]

by default MYSQL will use the format the current date/time to YYYY-MM-DD HH:MM:SS in the column when you do the insert, you can remove the "DEFAULT CURRENT_TIMESTAMP" and look up how to change the format around here if nessisary:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

[sasori]

sir i got another question about that null thing.. should i set primary keys as NULL or NOT NULL ?

[Hooker]

primary keys need to be NOT NULL because they're unique keys.