mysql学习

xiaoxiao2025-05-03  13

http://www.runoob.com/mysql/mysql-install.html

书籍:https://pan.baidu.com/s/1fIVAXZnZH7u_DDRIyjLTRQ mysql登陆: mysql -uroot -p 输入密码 增加用户: mysql > create user 'dog''@''localhost'identified by '123'; 查看用户: mysql>select user,host from mysql.user; 删除用户: mysql> drop user 'dog'@'localhost'; 查看数据库: mysql>show databases; 创建数据库: mysql>create database students; 删除数据库: mysql>drop database students; 查看数据库表: mysql>use mysql; mysql>show tables; 增加数据库表: mysql>use students; mysql>create table pet(         name varchar(20),        #名字         owner varchar(20),       #主人         species varchar(20),     #种类         sex char(1),            

转载请注明原文地址: https://www.6miu.com/read-5029694.html

最新回复(0)