mysql> CREATE TBALE PAYMENT_2006(
-> COUNTRY_ID SMALLINT ,
-> PAYMENT_DATA DATETIME ,
-> AMOUNT DECIMAL(15,2),
-> KEY IDX_FK_COUNTRY_ID(COUNTRY_ID)
-> )ENGINE=MYISAM;
ERROR 1064 (42000): 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 'TBALE PAYMENT_2006(
COUNTRY_ID SMALLINT ,
PAYMENT_DATA DATETIME ,
AMOUNT DECIMAL' at line 1请问哪里错了呢
-> COUNTRY_ID SMALLINT ,
-> PAYMENT_DATA DATETIME ,
-> AMOUNT DECIMAL(15,2),
-> KEY IDX_FK_COUNTRY_ID(COUNTRY_ID)
-> )ENGINE=MYISAM;
ERROR 1064 (42000): 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 'TBALE PAYMENT_2006(
COUNTRY_ID SMALLINT ,
PAYMENT_DATA DATETIME ,
AMOUNT DECIMAL' at line 1请问哪里错了呢
-> country_id smallint,
-> pryment_data datetime,
-> amount decimal(15,2),
-> key idx_fk_country_id(country_id)
-> )engine=myisam;
Query OK, 0 rows affected (0.13 sec)没问题啊
->country_id smallint,
->payment_data datetime,
->amount decimal(15,2),
->key idx_fk_country_id(country_id)
->)engine=myisam;