![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
诠释你的Mr贾
这个作者很懒,什么都没留下…
展开
-
用户+删除+导入数据库
**修改用户密码** ALTER USER 'jiazhijun'@'127.0.0.1' IDENTIFIED BY '123123'; **修改名字** RENAME USER 'jiazhijun'@'127.0.0.1' TO 'jiazhijun2'@'127.0.0.1' **授予除了GRANT(授权)权限的所有权限** GRANT ALL PRIVILEGES ON *.* TO 'jiazhijun2'@'127.0.0.1' **删除某个权限** REVOKE DROP ON *.* F原创 2020-10-26 10:34:34 · 85 阅读 · 0 评论 -
mysql 事务+索引
## 事务 CREATE DATABASE shop CHARACTER SET utf8 COLLATE utf8_general_ci USE shop CREATE TABLE `acount`( `id` INT(3) NOT NULL AUTO_INCREMENT , `name` VARCHAR(30) NOT NULL, `money` DECIMAL (9,2) NOT NULL, PRIMARY KEY(`id`) )ENGINE=INNODB DEFAULT CHARSET.原创 2020-10-11 21:25:57 · 45 阅读 · 0 评论 -
day02 mysql
SELECT s.`studentno`,`studentname`,`subjectname`,`studentresult` -- s.studentno ambitious but studentname unique FROM `student` s INNER JOIN `result` r ON s.studentno=r.studentno INNER JOIN `subject` sub ON r.subjectno=sub.subjectno WHERE `subjectname`原创 2020-10-10 09:44:48 · 94 阅读 · 0 评论 -
2020-10-02-数据库day1笔记
数据库基本语句 show databases;//展示数据库 use school;//使用数据库 show tables;//展示表 --单行注释; /* */多行注释 create database [if not exists] westos;//创建数据库 drop database [if exists] westos; --创造表 CREATE TABLE IF NOT EXISTS `student`( `id` INT(4) NOT NULL AUTO_INCREMENT COMMENT原创 2020-10-02 22:23:37 · 53 阅读 · 0 评论