CREATE DATABASE IF NOT EXISTS `shirodb` CHARACTER SET utf8mb4; USE `shirodb`; CREATE TABLE `user` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '编号', `name` VARCHAR(30) DEFAULT NULL COMMENT '用户名', `pwd` VARCHAR(50) DEFAULT NULL COMMENT '密码', `rid` BIGINT(20) DEFAULT NULL COMMENT '角色编号', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表'; UPDATE `shirodb`.`user` SET `name` = 'Rose' WHERE `id` = '2'; SELECT id,NAME,pwd,rid FROM USER WHERE (NAME = 'Jack')
CREATE DATABASE IF NOT EXISTS `shirodb` CHARACTER SET utf8mb4;
USE `shirodb`;CREATE TABLE `user` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` VARCHAR(30) DEFAULT NULL COMMENT '用户名',
`pwd` VARCHAR(50) DEFAULT NULL COMMENT '密码',
`rid` BIGINT(20) DEFAULT NULL COMMENT '角色编号',
PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';UPDATE `shirodb`.`user` SET `name` = 'Rose' WHERE `id` = '2';
SELECT id,NAME,pwd,rid FROM USER WHERE (NAME = 'Jack')
Shiro框架整合Spring-Boot开发的Web应用数据库准备部分------MySQL
最新推荐文章于 2024-10-08 11:31:42 发布