摘要:
转自:http://www.phpweblog.net/kiyone/archive/2008/08/22/5644.htmlmysql insert的几点操作(DELAYED 、IGNORE、ON DUPLICATE KEY UPDATE )INSERT语法INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expr, 阅读全文
摘要:
转自:http://zhe.521168707.blog.163.com/blog/static/10135150020112210135141/?fromdm&fromSearch&isFromSearchEngine=yes重命名表ALTER TABLE tbl1 RENAME tbl2;.重命名表RENAME TABLE old_table TO backup_table;重命名多个表RENAME TABLE old_table TO backup_table, new_table TO old_table;.把表从一个库移动到另一个库RENAME TABLE db1.t 阅读全文