该sql运行于mysql 无 SELECTCONCAT('SELECT ',GROUP_CONCAT(COLUMN_NAME),' FROM ',TABLE_NAME)FROMinformation_schema. COLUMNSWHERETABLE_NAME = 'worker'; 其中 表名为worker SELECTCONCAT("UPDATE worker SET ",GROUP_CONCAT(COLUMN_NAME,"= ()")," WHERE
该sql运行于mysqlSELECT CONCAT( 'SELECT ', GROUP_CONCAT(COLUMN_NAME), ' FROM ', TABLE_NAME ) FROM information_schema. COLUMNS WHERE TABLE_NAME = 'worker'; 其中 表名为worker
SELECT CONCAT( "UPDATE worker SET ", GROUP_CONCAT( COLUMN_NAME, "= ()" ), " WHERE Id = " ) FROM information_schema. COLUMNS WHERE TABLE_NAME = 'worker';
SELECT
CONCAT(
'INSERT INTO worker( ',
GROUP_CONCAT(COLUMN_NAME),
') VALUES (',
GROUP_CONCAT(
CONCAT('()')
),
')'
)
FROM
information_schema. COLUMNS
WHERE
TABLE_NAME = 'worker' ;SELECT
CONCAT(
'private ',
(
CASE
WHEN DATA_TYPE = 'varchar' THEN 'String '
WHEN DATA_TYPE = 'datetime' THEN
'Date '
WHEN DATA_TYPE = 'int' THEN
'int '
WHEN DATA_TYPE = 'float' THEN
'float '
END
),
COLUMN_NAME,' ; //',COLUMN_COMMENT
)
FROM
information_schema. COLUMNS
WHERE TABLE_NAME = 'worker' ;
java怎么学习？java怎么入门？java在哪学？java怎么学才快？不用担心，这里为大家提供了java速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
广告Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
244
收藏
