Help with date & time inserting into myqsl table.

[Francis]

Look at that:

 

Error

 

SQL request:

 

CREATE TABLE feedback(

Name varchar( 30 ) ,

COMMENT longtext,

commentDatedate( yy / mm / dd ) ,

commentTimetime( hh : mm : ss )

)

 

MySQL answered:Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(yy/mm/dd), commentTime time(hh:mm:ss) )' at line 1

 

What is my problem?

 

My query:

 

CREATE TABLE feedback 
(
Name varchar(30),
Comment longtext,
commentDate date(yy/mm/dd),
commentTime time(hh:mm:ss)
)

[Barand]

use

CREATE TABLE feedback 
(
Name varchar(30),
Comment longtext,
commentDate date,
commentTime time
)