Code:
SET INSERT_ID=1;
INSERT INTO test (insert_id,column1) VALUES (1,'column1value');
SET INSERT_ID=2;
INSERT INTO test (insert_id,column1,column2,column3) VALUES (2,'column1value','
column2value ,'column3value');
SET INSERT_ID=3;
INSERT INTO test1 (insert_id,column1,column2,column3) VALUES (3,'column1value','
column2value ,'column3value');
UPDATE test set chat = Concat(chat, '
New User 49: bhjg '),seller_count = '0',buyer_count = '0',total = LENGTH(chat) - LENGTH(REPLACE(chat, '
', '')),chat_end = now() where chat_id = '7ee090-88f0';
UPDATE test set chat = Concat(chat, '
New User 49: sdf '),seller_count = '0',buyer_count = '0',total = LENGTH(chat) - LENGTH(REPLACE(chat, '
', '')),chat_end = now() where chat_id = '7ee0-f0';
UPDATE test set chat = Concat(chat, '
User Build27: this is good '),seller_count = '0',buyer_count = '0',total = LENGTH(chat) - LENGTH(REPLACE(chat, '
', '')),chat_end = now() where chat_id = 'f072-00e0';
UPDATE test set chat = Concat(chat, '
User Build27: sdf '),seller_count = '0',buyer_count = '0',total = LENGTH(chat) - LENGTH(REPLACE(chat, '
', '')),chat_end = now() where chat_id = 'f06f-8f0';
UPDATE test set chat = Concat(chat, '
New User 49: 2 '),seller_count = '0',buyer_count = '0',total_chat_lines = LENGTH(chat) - LENGTH(REPLACE(chat, '
', '')),chat_end = now() where chat_id = '2311-rs';
SET INSERT_ID=4;
INSERT INTO test3 (
insert_id,
column1,
column2,
column3,
VALUES
(
4,
column1value,
column2value,
column3value
);