Command Line Client(建库,建表)

Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.55-community MySQL Community Server (GPL)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database test_1
->
->
-> alter database test_1
->
->
->
->
-> default character set gbk
-> default collate gbk_chinese_ci;
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 'alter database test_1

 


default character set gbk
default collate gbk_chinese_' at line 4
mysql> create database test_1;
Query OK, 1 row affected (0.01 sec)

mysql> alter database test_1;
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 '' at line 1
mysql> alter database test_1
-> default character set gbk
-> default collate gbk_chinese_ci;
Query OK, 1 row affected (0.00 sec)

mysql> use test_1;
Database changed
mysql> create table students
-> <
-> stu_id int not null auto_increment,
-> stu_name char(50) not null,
-> stu_sex char(1) not null default 'F',
-> primary key(stu_id)
-> >engine=InnoDB;
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 '<
stu_id int not null auto_increment,
stu_name char(50) not null,
stu_sex char(1' at line 2
mysql> create table students
-> (
-> stu_id int not null auto_increment,
-> stu_name char(50) not null,
-> stu_sex char(1) not null default 'F',
-> primary key(stu_id)
-> )engine=InnoDB;
Query OK, 0 rows affected (0.01 sec)

 

命令以“;”结束,或者如提示Commands end with ; or \g.

帮助:Type 'help;' or '\h' for help.

清空: Type '\c' to clear the current input statement.

建库:create database test_1;

建表:create table students
-> (
-> stu_id int not null auto_increment,
-> stu_name char(50) not null,
-> stu_sex char(1) not null default 'F',
-> primary key(stu_id)
-> )engine=InnoDB;

posted @   N_zero  阅读(897)  评论(0编辑  收藏  举报
编辑推荐:
· .NET制作智能桌面机器人:结合BotSharp智能体框架开发语音交互
· 软件产品开发中常见的10个问题及处理方法
· .NET 原生驾驭 AI 新基建实战系列:向量数据库的应用与畅想
· 从问题排查到源码分析:ActiveMQ消费端频繁日志刷屏的秘密
· 一次Java后端服务间歇性响应慢的问题排查记录
阅读排行:
· 互联网不景气了那就玩玩嵌入式吧,用纯.NET开发并制作一个智能桌面机器人(四):结合BotSharp
· Vite CVE-2025-30208 安全漏洞
· 《HelloGitHub》第 108 期
· MQ 如何保证数据一致性?
· 一个基于 .NET 开源免费的异地组网和内网穿透工具
点击右上角即可分享
微信分享提示