Php数据库资料统计问题!!谢谢~~
数据库字段:id (自动编号) 、 name(人名) 、mom(某个时期...
作者 巴豆 发布于 2003-08-00 分类:php基础编程
如题?
逛论坛交流:language 是mysql的关键字吗
不是
错了,应该是foreign是关键字吗?
foreign是关键字
对了那nums是吗
关键字也可用,但要加特殊引号“`”(和表格一样)就可以用,
我就经常用index
不敢用了,昨天一个同事的程序就因为起了foreign的字段,我也没当回事,就是过不去忽然想起关键字来
自己看吧,action|add|aggregate|all|
alter|after|and|as|
asc|avg|avg_row_length|auto_increment|
between|bigint|bit|binary|
blob|bool|both|by|
cascade|case|char|character|
change|check|checksum|column|
columns|comment|constraint|create|
cross|current_date|current_time|current_timestamp|
data|database|databases|date|
datetime|day|day_hour|day_minute|
day_second|dayofmonth|dayofweek|dayofyear|
dec|decimal|default|delayed|
delay_key_write|delete|desc|describe|
distinct|distinctrow|double|drop|
end|else|escape|escaped|
enclosed|enum|explain|exists|
fields|file|first|float|
float4|float8|flush|foreign|
from|for|full|function|
global|grant|grants|group|
having|heap|high_priority|hour|
hour_minute|hour_second|hosts|identified|
ignore|in|index|infile|
inner|insert|insert_id|int|
integer|interval|int1|int2|
int3|int4|int8|into|
if|is|isam|join|
key|keys|kill|last_insert_id|
leading|left|length|like|
lines|limit|load|local|
lock|logs|long|longblob|
longtext|low_priority|max|max_rows|
match|mediumblob|mediumtext|mediumint|
middleint|min_rows|minute|minute_second|
modify|month|monthname|myisam|
natural|numeric|no|not|
null|on|optimize|option|
optionally|or|order|outer|
outfile|pack_keys|partial|password|
precision|primary|procedure|process|
processlist|privileges|read|real|
references|reload|regexp|rename|
replace|restrict|returns|revoke|
rlike|row|rows|second|
select|set|show|shutdown|
smallint|soname|sql_big_tables|sql_big_selects|
sql_low_priority_updates|sql_log_off|sql_log_update|sql_select_limit|
sql_small_result|sql_big_result|sql_warnings|straight_join|
starting|status|string|table|
tables|temporary|terminated|text|
then|time|timestamp|tinyblob|
tinytext|tinyint|trailing|to|
type|use|using|unique|
unlock|unsigned|update|usage|
values|varchar|variables|varying|
varbinary|with|write|when|
where|year|year_month|zerofill|
看看
多谢
9 条回复
回复