如何用nat123做网站,河南平台网站建设设计,wordpress自定义菜单文章,上海网站建设shwzzz一、mysql常用语句
登录MySQLmysql -u root -p列出所有数据库SHOW DATABASES;创建一个新数据库CREATE DATABASE test;删除一个数据库DROP DATABASE test;对一个数据库进行操作时USE test;列出当前数据库的所有表SHOW TABLES;要查看一个表的结构DESC students;创建表CREATE TAB…一、mysql常用语句
登录MySQLmysql -u root -p列出所有数据库SHOW DATABASES;创建一个新数据库CREATE DATABASE test;删除一个数据库DROP DATABASE test;对一个数据库进行操作时USE test;列出当前数据库的所有表SHOW TABLES;要查看一个表的结构DESC students;创建表CREATE TABLE删除表DROP TABLE退出MySQLEXIT 二、sql常用语句
查询
所有数据SELECT * FROM students;条件查询SELECT * FROM students WHERE score 80;更多的条件SELECT * FROM students WHERE (score 80 OR score 90) AND gender ‘M’;从students表中返回id、score和name这三列SELECT id, score, name FROM students;排序SELECT id, name, gender, score FROM students ORDER BY score;加上DESC表示“倒序”SELECT id, name, gender, score FROM students ORDER BY score DESC;
插入
插入一条新记录INSERT INTO students (class_id, name, gender, score) VALUES (2, ‘大牛’, ‘M’, 80);一次性添加多条记录INSERT INTO students (class_id, name, gender, score) VALUES (1, ‘大宝’, ‘M’, 87), (2, ‘二宝’, ‘M’, 81);
修改
基本语法UPDATE students SET name‘大牛’, score66 WHERE id1;更新字段时可以使用表达式UPDATE students SET scorescore10 WHERE score80;
删除
删除students表中id1的记录DELETE FROM students WHERE id1;
