有关索引的问题
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
请问哪里错了呢
------解决方案--------------------mysql> create table payment_2006(
-> 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)
没问题啊
------解决方案--------------------tbale修改为table