1. SHOW CREATE TABLE tbA;

2. UPDATE tbA JOIN tbB ON tbA.`id`=tbB.a`id` SET tbA.`name`=tbB.`name`;

3. SELECT * FROM tbA WHERE `name` LIKE BINARY ‘%中文%’;

4. INSERT INTO tbA (`bid`, `name`) (SELECT `id`, `name` FROM tbB);

5. INSERT INTO tbA (`bid`, `name`, `count`) VALUES (10, ‘abc’, 1) ON DUPLICATE KEY UPDATE `count`=`count`+1; # UNIQUE KEY `name` (`bid`,`name`)

6. SELECT *, COUNT(DISTINCT name) FROM table GROUP BY name