分类查询:select author,count() from tb_car group by author;
远程插入:mysql -uroot -p123456 -h192.168.43.230 -P13306 INFO < tb_channel.sql
库
创建数据库: create database name charset='utf8';
删除数据库: drop database name
查看数据库: show databases;
如下创建数据库:
createtable tb_user(
id int notnull auto_increment,
usernamevarchar(20)notnull,
age int,
genderenum(‘男’,’女’,’保密’),primarykey(id))engine= myisam defaultcharset=utf8;
评论区