摘要: -- Mysql 基础INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....);UPDATE tb_name SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'DELETE FROM 表名称 WHERE 列名称 = 值// 列出不同(distinct)的值,重复值去掉SELECT DISTINCT username FROM tb_name; // top SELECT TOP number|per 阅读全文
posted @ 2013-07-10 15:44 Kiwi0921 阅读(249) 评论(0) 推荐(0) 编辑