1、数据库操作
show databases;
use <database>;
show DATABASES ;
use spiders;
show tables ;
select *from user;
CREATE TABLE `Testtable` (
`test_id` BIGINT(32) NOT NULL AUTO_INCREMENT COMMENT '测试ID',
`test_name` VARCHAR(255) NOT NULL COMMENT '测试名称',
`test_source` VARCHAR(255) DEFAULT NULL COMMENT '客户来源',
`test_phone` VARCHAR(255) DEFAULT NULL COMMENT '客户电话',
`test_level` VARCHAR(255) DEFAULT NULL COMMENT '客户级别',
PRIMARY KEY (`test_id`)
) ENGINE =INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
select *from Testtable;
#增加列
ALTER TABLE Testtable ADD columnName varchar(30);
#修改列名称
ALTER TABLE Testtable CHANGE columnName test_columnName VARCHAR(30);
#删除列
ALTER TABLE Testtable DROP COLUMN test_columnName;
#批量修改
ALTER TABLE Testtable CHANGE test_id test_Id BIGINT(12) NOT NULL ,
CHANGE test_name test_Name VARCHAR(32) NOT NULL ,
CHANGE test_source test_Source VARCHAR(32) NOT NULL;
INSERT INTO Testtable(test_Id, test_Name, test_Source, test_phone, test_level) VALUES
('1', '孔陈亮','易二三', '13143433764', 'iOS开发工程师');
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| spiders |
| sys |
+--------------------+
5 rows in set (0.06 sec)
mysql> use spiders;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-------------------+
| Tables_in_spiders |
+-------------------+
| student |
| user |
+-------------------+
2 rows in set (0.00 sec)
mysql> select *form student;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'form student' at line 1
mysql> select *from student;
+------------+------+-----+
| id | name | age |
+------------+------+-----+
| 2019092501 | kcl | 28 |
+------------+------+-----+
1 row in set (0.00 sec)
mysql>
//只需要类添加 @RestController 即可，默认类中的方法都会以 json 的格式返回
@RestController
public class HelloController {
@RequestMapping(value = "/hello", method = RequestMethod.GET)
public String say() {
return "Hello Spring Boot";
}
}
