用于替代手写insert语句
生成后自行编辑所需要的字段即可
-- python版占位符
SELECT
CONCAT( 'insert into ', table_name, '(', GROUP_CONCAT( COLUMN_NAME ),
') value (', GROUP_CONCAT( '%s' ), ')' )
FROM
information_schema.COLUMNS
WHERE
table_schema = 'your database'
AND table_name = 'your table'
AND column_key != 'PRI'
-- php版占位符
SELECT
CONCAT( 'insert into ', table_name, '(', GROUP_CONCAT( COLUMN_NAME ),
') value (', GROUP_CONCAT( ''':', COLUMN_NAME, '''' ), ')' )
FROM
information_schema.COLUMNS
WHERE
table_schema = 'your database'
AND table_name = 'your table'
AND column_key != 'PRI'