27 lines
4.8 KiB
Plaintext
Executable File
27 lines
4.8 KiB
Plaintext
Executable File
UPDATE user SET type='wx',gsname='哇哈哈',enable='1',appids='333334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id = 8
|
|
ERROR 1054 (42S22) at line 1: Unknown column 'id' in 'where clause'
|
|
UPDATE user SET type='wx',gsname='哇哈哈',enable='1',appids='333334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id='8'
|
|
ERROR 1054 (42S22) at line 1: Unknown column 'id' in 'where clause'
|
|
UPDATE qiye SET type='wx',gsname='哇哈哈',enable='1',appids='333334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id='8'
|
|
UPDATE qiye SET type='zfb',gsname='你好啊',enable='1',appids='546411111111144444',mchid='12121212121212121212121212121212',ckkeys='100.00',secert='',maxjine='' WHERE id='7'
|
|
ERROR 1406 (22001) at line 1: Data too long for column 'mchid' at row 1
|
|
UPDATE qiye SET type='zfb',gsname='你好啊',enable='1',appids='546411111111144444',ckkeys='12121212121212121212121212121212',maxjine='100.00' WHERE id='7'
|
|
UPDATE qiye SET type='zfb',gsname='你好啊',enable='0',appids='546411111111144444',ckkeys='12121212121212121212121212121212',maxjine='100.00' WHERE id='7'
|
|
UPDATE qiye SET type='zfb',gsname='你好啊',enable='0',appids='546411111111144444',ckkeys='12121212121212121212121212121212',maxjine='9700' WHERE id='7'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='333334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='你好啊',enable='1',appids='111111111111111111',mchid='213131424',ckkeys='12121212121212121212121212121212',secert='87948729874294387829652562858252',maxjine='100.00' WHERE id='4'
|
|
UPDATE qiye SET type='zfb',gsname='你好啊',enable='1',appids='546411111111144444',ckkeys='12121212121212121212121212121212',maxjine='9700.00' WHERE id='7'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='0',appids='333334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='333334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='003334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='400000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='003334245345353454',mchid='543535345',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='100000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='003334245345353454',mchid='543535345222',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',maxjine='100000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='003334245345353454',mchid='543535345222',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',zzdgr='1',maxjine='100000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='003334245345353454',mchid='11535345222',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',zzdgr='1',maxjine='100000.00' WHERE id='8'
|
|
UPDATE qiye SET type='wx',gsname='流弊科技',enable='1',appids='223334245345353454',mchid='11535345222',ckkeys='53454353453535355353534534535345',secert='53453453535353535345353535353535',zzdgr='1',maxjine='100000.00' WHERE id='8'
|
|
UPDATE qiye SET type='zfbpc',gsname='你好啊',enable='1',appids='546411111111144444',ckkeys='12121212121212121212121212121212'zzdgr='1',,maxjine='9700.00' WHERE id='7'
|
|
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'zzdgr='1',,maxjine='9700.00' WHERE id='7'' at line 1
|
|
UPDATE qiye SET type='zfbpc',gsname='你好啊',enable='1',appids='546411111111144444',ckkeys='12121212121212121212121212121212'zzdgr='1',,maxjine='9700.00' WHERE id='7'
|
|
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'zzdgr='1',,maxjine='9700.00' WHERE id='7'' at line 1
|
|
UPDATE qiye SET type='zfbpc',gsname='你好啊',enable='1',appids='546411111111144444',ckkeys='12121212121212121212121212121212',zzdgr='1',maxjine='9700.00' WHERE id='7'
|