PHPize Online / SQLize Online  /  SQLtest Online

CREATE TABLE `chat` ( `msgId` int(11) NOT NULL AUTO_INCREMENT, `msgFrom` varchar(255) NOT NULL, `msgChatId` varchar(255) NOT NULL, `msgText` mediumtext NOT NULL, PRIMARY KEY (`msgId`) ); INSERT INTO chat (msgChatId, msgFrom, msgText) VALUES('123', 'worker', 'test'); INSERT INTO chat (msgChatId, msgFrom, msgText) VALUES('123', 'worker', 'test 2'); INSERT INTO chat (msgChatId, msgFrom, msgText) VALUES('456', 'worker', 'test'); INSERT INTO chat (msgChatId, msgFrom, msgText) VALUES('123', 'client', 'test client');