自动生成 Insert、Update SQL（MySQL）

SELECT
    CONCAT(
        'INSERT INTO ',
        CONCAT( '`', table_name, '`' ),
        ' (',
        GROUP_CONCAT( CONCAT( '`', COLUMN_NAME, '`' ) ),
        ') VALUE (',
        GROUP_CONCAT( CONCAT( '@', COLUMN_NAME ) ),
        ');' 
    ) 
FROM
    information_schema.COLUMNS 
WHERE
    table_schema = 'tsc_small' 
    AND table_name = 'users' 
    AND column_key != 'PRI'

SELECT
    CONCAT( 'UPDATE ', CONCAT( '`', table_name, '`' ), GROUP_CONCAT( CONCAT( ' SET `', COLUMN_NAME, '` = @', COLUMN_NAME ) ), ' WHERE ...;' ) 
FROM
    information_schema.COLUMNS 
WHERE
    table_schema = 'tsc_small' 
    AND table_name = 'users' 
    AND column_key != 'PRI'

SELECT
  CONCAT(
    CONCAT(
      'INSERT INTO ',
      CONCAT( '`', table_name, '`' ),
      ' (',
      GROUP_CONCAT( CONCAT( '`', COLUMN_NAME, '`' ) ),
      ') VALUE (',
      GROUP_CONCAT( CONCAT( '@', COLUMN_NAME ) ),
      ')' 
    ),
    ' ON DUPLICATE KEY UPDATE ',
    CONCAT(
    GROUP_CONCAT( CONCAT( '`', COLUMN_NAME, '`=@', COLUMN_NAME ) )) 
  ) 
FROM
  information_schema.COLUMNS 
WHERE
  table_schema = 'cross_over_repurchase' 
  AND table_name = 'user'