数据库MySQL语法问题,碰到ERROR 1064 (42000)

数据库学了基础的创建表单,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

数据库MySQL语法问题,碰到ERROR 1064 (42000)

[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)

数据库MySQL语法问题,碰到ERROR 1064 (42000)

[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/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球