4ay3bUzq

1CREATE TABLE IF NOT EXISTS `table1` (
2`id` char(10) NOT NULL DEFAULT '',
3`field1` char(10) DEFAULT NULL,
4`field2` char(10) DEFAULT NULL,
5PRIMARY KEY (`id`)
6);
7INSERT INTO table1 VALUES
8( '1001', 'row1 col1', 'row1 col2' ),
9( '1002', 'row2 col1', 'row2 col2' ),
10( '1003', 'row3 col1', 'row3 col2' );