数据库学了基础的创建表单,DDL语言之后,安装了MySQL软件,准备按照操作创建表单。
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:49ed6e38-3351-43a1-9ea9-1d6387fff14c
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:13ef3f2f-7f48-494c-b7db-40eee913e8b5
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:e85fa2f9-276f-4d23-817d-4b688139c621
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:60bc3e45-31a8-493b-8f8d-6c7ede77958d
后来排查单引号和逗号,发现数据库的create拼写错误,犯了低级错误,经过仔细排查修改如下:
1 create table stuinfo(
2 name VARCHAR(20) NOT NULL Comment '姓名',
3 profession VARCHAR(50) NOT NULL Comment '专业',
4 stunumber int Comment '学生编号',
5 sex CHAR(10) Comment '性别',
6 age int Comment '年龄',
7 score int Comment '分数',
8 birthdate date Comment '出生年月日',
9 grade char(30) Comment '年级',
10 residence VARCHAR(200) NOT NULL Comment '居住地址',
11 cardnumber int Comment '身份证'
12 ) Comment '学生信息表' ;
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:011d5304-c955-45d5-bed4-f529950be1cb
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:c677f0d5-98a8-4f56-95cf-86c02f30f24a
mysql> create table stuinfo(
-> name VARCHAR(20) NOT NULL Comment '姓名',
-> profession VARCHAR(50) NOT NULL Comment '专业',
-> stunumber int Comment '学生编号',
-> sex CHAR(10) Comment '性别',
-> age int Comment '年龄',
-> score int Comment '分数',
-> birthdate date Comment '出生年月日',
-> grade char(30) Comment '年级',
-> residence VARCHAR(200) NOT NULL Comment '居住地址',
-> cardnumber int Comment '身份证'
-> ) Comment '学生信息表' ;
Query OK, 0 rows affected (0.06 sec)
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:400b0701-de98-4eca-b244-572aad828a29
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:5dd15fe0-5d40-4643-a9e8-6a03fec6f856
11:54:58
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:27026eed-b55e-46cc-a297-124a221f59e1
[En]
[TencentCloudSDKException] code:FailedOperation.ServiceIsolate message:service is stopped due to arrears, please recharge your account in Tencent Cloud requestId:8d2e2703-bfc4-47d5-afbf-405a3d949c1b
Original: https://www.cnblogs.com/mm150144978/p/16129372.html
Author: 大海之星
Title: 数据库MySQL语法问题,碰到ERROR 1064 (42000)
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/562731/
转载文章受原作者版权保护。转载请注明原作者出处!