日期:2014-05-16  浏览次数:20789 次

有关索引的问题
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