如果是5以上, SELECT a1.column_name FROM information_schema.columns a1 WHERE table_schema='databasename' AND table_name='tablsename' and column_name='字段'否则没有办法
select 1 from information_schema.columns where table_name='xxx' and column_name='xxxxx';
select * from information_schema_columns where table_name='aaa' and columns_name='bbb';
就是test.sql 用mysql_front打开能执行的
SELECT * FROM information_schema.columns WHERE table_name='表' and column_name='字段'
SELECT a1.column_name FROM information_schema.columns a1 WHERE table_schema='databasename' AND table_name='tablsename' and column_name='字段'否则没有办法
where table_name='aaa' and columns_name='bbb';
FROM information_schema.columns
WHERE table_name='表' and column_name='字段'