摘要: 1.sql语句逻辑执行顺序 (7) SELECT (8) DISTINCT <select_list> (1) FROM <left_table> (3) <join_type> JOIN <right_table> (2) ON <join_condition> (4) WHERE <where_ 阅读全文
posted @ 2018-02-28 15:57 kakawith 阅读(285) 评论(0) 推荐(1) 编辑
摘要: #移除主键时需要先解除递增,才能解除主键 alter table info modify id int null , drop PRIMARY key 一.用户权限 1.创建用户 create user 'hanshe'@'127.0.0.1' IDENTIFIED by '123'; -- 创建用 阅读全文
posted @ 2018-02-28 08:27 kakawith 阅读(236) 评论(0) 推荐(1) 编辑