This SQL statement runs in mysql without SELECTCONCAT (SELECT, GROUP_CONCAT (COLUMN_NAME), FROM, TABLE_NAME) tables. The table name is workerSELECTCONCAT (UPDATEworkerSET, GROUP_CONCAT (COLUMN_NAME, (), WHERE
This SQL statement runs in mysql without SELECTCONCAT ('select', GROUP_CONCAT (COLUMN_NAME), 'from', TABLE_NAME) FROMinformation_schema. COLUMNSWHERETABLE_NAME = 'worker'; the table name is worker SELECTCONCAT ("UPDATE worker SET", GROUP_CONCAT (COLUMN_NAME, "= ()"), "WHERE
This SQL statement runs in mysql <无>
SELECTCONCAT ('select', GROUP_CONCAT (COLUMN_NAME), 'from', TABLE_NAME) FROMinformation_schema. COLUMNSWHERETABLE_NAME = 'worker'; the table name is worker.
SELECTCONCAT("UPDATE worker SET ",GROUP_CONCAT(COLUMN_NAME,"= ()")," WHERE Id = ")FROMinformation_schema. COLUMNSWHERETABLE_NAME = 'worker';
SELECT CONCAT( 'INSERT INTO worker( ', GROUP_CONCAT(COLUMN_NAME), ') VALUES (', GROUP_CONCAT( CONCAT('()') ), ')' )FROM information_schema. COLUMNSWHERE 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. COLUMNSWHERE TABLE_NAME = 'worker' ;