CREATE TABLE `fans` (
`id` int(20) NOT NULL,
`team` varchar(10) DEFAULT NULL,
`nationality` varchar(20) DEFAULT NULL,
`fanCount` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('1','Barcelona','Germany','12000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('2','Barcelona','Spain','18000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('3','Barcelona','China','13000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('4','Barcelona','USA','15000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('5','Barcelona','Italy','11000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('6','Real Madri','France','19000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('7','Real Madri','Germany','13000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('8','Real Madri','USA','17000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('9','Real Madri','Korea','16000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('10','Real Madri','UK','12000');
`id` int(20) NOT NULL,
`team` varchar(10) DEFAULT NULL,
`nationality` varchar(20) DEFAULT NULL,
`fanCount` int(10) DEFAULT NULL,
PRIMARY KEY (`id`)
) insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('1','Barcelona','Germany','12000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('2','Barcelona','Spain','18000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('3','Barcelona','China','13000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('4','Barcelona','USA','15000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('5','Barcelona','Italy','11000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('6','Real Madri','France','19000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('7','Real Madri','Germany','13000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('8','Real Madri','USA','17000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('9','Real Madri','Korea','16000');
insert into `fans` (`id`, `team`, `nationality`, `fanCount`) values('10','Real Madri','UK','12000');
解决方案 »
- mysql 分组查询
- php连接mysql 导入文本文件(含中文)出现乱码
- 求一条sql语句
- 测试mysql.Access denied for user 'ODBC'@'localhost' (using password: NO) 怎样解决?
- 求助 一个关联问题
- 求SQL语句,有N多的部门,取出每个部门销售冠军和季军
- [高分!急!]请问如何在 MySQL 里同时使用两条互斥的语句?
- 如何设置mysql的库环境?
- 在一文章的表,想修改文章内容中几个字为另外几个字,要怎么写?
- sql合并表的简单问题
- 【新手求教】linux系统是64位的,为什么系统时间过了2038年后mysql就无法启动了
- Mysql5.7版本,连接上没法操作的问题,急求大神的指点,万分感谢
你是这个意思吗?