RHEL7/Mysql SQL DB/Table example

最新推荐文章于 2025-03-05 23:50:07 发布

原创最新推荐文章于 2025-03-05 23:50:07 发布 · 162 阅读

0 ·

CC 4.0 BY-SA版权

RHEL 同时被 2 个专栏收录

59 篇文章

订阅专栏

Mysql

8 篇文章

订阅专栏

本文详细介绍了如何在MariaDB中创建用户、数据库及权限分配，并通过具体的SQL语句演示了表结构的设计、数据插入以及基本的数据查询和更新操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

### create user
MariaDB [(none)]> create user 'training'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

##########create new DB training
MariaDB [(none)]>create database training DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

MariaDB [(none)]> grant all privileges on `training`.* to 'training'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye
##########

#############Table create

CREATE TABLE `student` (
`id` int(11) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`sex` varchar(8) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`major` varchar(32) DEFAULT NULL
) ;

INSERT INTO student(id,name,sex,age,major) VALUES(1,'ZhangSan','M',18,'Computer');
INSERT INTO student(id,name,sex,age,major) VALUES(2,'LiSi','F',21,'Manager');
INSERT INTO student(id,name,sex,age,major) VALUES(3,'wangwu','F',19,'electronic');

CREATE TABLE `course` (
`id` int(11) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`score` int(11) DEFAULT NULL
) ;

INSERT INTO course(id,name,score) VALUES(1,'SQL', 4);
INSERT INTO course(id,name,score) VALUES(2,'Chinese',3);
INSERT INTO course(id,name,score) VALUES(3,'Math',2);

CREATE TABLE `sc` (
`id` int(11) DEFAULT NULL,
`Stu_id` int(11) DEFAULT NULL,
`Course_id` int(11) DEFAULT NULL,
`make` int(11) DEFAULT NULL
) ;

INSERT INTO sc(id,Stu_id,Course_id,make) VALUES(1,1,1,88);
INSERT INTO sc(id,Stu_id,Course_id,make) VALUES(2,2,1,90);
INSERT INTO sc(id,Stu_id,Course_id,make) VALUES(3,2,2,70);
INSERT INTO sc(id,Stu_id,Course_id,make) VALUES(4,3,3,79);

### Update
select * from course WHERE id=3;
UPDATE course SET score = 3 WHERE id=3;

select * from course WHERE id=3;

#### select

select * from student WHERE age>18;

select * from student WHERE age>18 ORDER BY age DESC;