数据库|mysql教程
数据库-mysql教程
Linux上安装MySQL默认是数据库的表大小写敏感的。修改很简单,只要该一个mysql的配置文件就可以了。
tinyxml 源码,mx5Ubuntu,印度爬虫类,php只显示一部分代码的页面,邢台seo顾问lzw
mysql> show tables;
+————————————–+
| Tables_in_cddl |
+————————————–+
| a1_equipment |
| a1_equipment_batch |
| actionby |
| actionitem |
| actionitemcomments |
| actionitemdetail |
| actionitemstatus |
| cal_cost_element |
| cal_cost_element_stat |
| cal_statistics |
| changeduedate |
| commisstionstartup |
| copq |
| copq_category |
| costbreakdown |
| daily_statistic |
| dbstudy |
| dccddlist |
| define_cost_element |
| djpmomsactivity |
| drawing |
| dsystem_user |
| dtproperties |
| duser_rights |
| edcr |
| edcr_2week |
| edcr_status |
| edcrchild |
| engineering_action_tracking |
| engineering_action_tracking_analysis |
| fincostone |
| fincostonerpt |
| fincosttwo |
| fincosttworpt |
| fincostvariance |
| fincostvariancerpt |
| findataforchar |
| finemployee |
| finemployee0910 |
| finemployeehist |
| finemployeehistback |
| finexportone |
| finexporttwo |
| finheadcountone |
| finheadcountonerpt |
| finheadcounttwo |
| finheadcounttworpt |
| finheadcountvariance |
| finheadcountvariancerpt |
| finhistversioncomment |
| finposition |
| finpositionhist |
| finpositionhistback |
| finpositon0910 |
| flight |
| hotel |
| hrcontact |
| hy_temp |
| hyresponsetime |
| impacteddrawingnumber |
| jpmo_temp |
| jpmoresponsetime |
| meeting |
| relatededcrnumber |
| responsibleperson |
| revisedscheduledate |
| sm_temp |
| smresponsetime |
| sparepart |
| sysconstraints |
| syssegments |
| systemparameter |
| table_1_7_1 |
| table_1_7_2 |
| table_1_7_3 |
| table_1_7_3a |
| table_1_7_3b |
| table_1_7_3c |
| table_appendix28 |
| trend |
| trenddetail |
| visitor |
| visitprogram |
| vp_engdeliverablesreport |
+————————————–+
84 rows in set (0.00 sec)
一元夺宝商城源码,vscode输出html,ubuntu接收usb数据,tomcat响应中文,sqlite 连接查询,jquery 触屏 插件,好看的管理前端框架,有看头 爬虫,php mysql 库,Seo黑帽软件,织梦系统小游戏网站源码,易语言取当前网页源码,中英文asp网站模板下载,滚动数字抽奖页面,华众虚拟主机管理系统 多ip vps,网站模版程序lzw
mysql> select count(*) from TREND;
ERROR 1146 (42S02): Table ‘cddl.TREND’ doesn’t exist
ios 计算器 源码下载,ubuntu是否安装驱动,添加tomcat的导包,本科论文爬虫,高级php技术网站教程,邯郸seo咨询lzw
从上面可以看出trend表是存在的,只不过是小写的保存在数据库里。
让MYSQL不区分表名大小写的方法其实很简单:
1.用ROOT登录,修改/etc/f
2.在[mysqld]下加入一行:lower_case_table_names=1
3.重新启动数据库即可
[root@chicago init.d]# vi /etc/f
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables
lower_case_table_names=1
[root@chicago init.d]# service mysql restart
Shutting down MySQL.. [ OK ]
Starting MySQL……………………………….. [ OK ]
mysql> select count(*) from TREND;
+———-+
| count(*) |
+———-+
| 19 |
+———-+
1 row in set (0.00 sec)
mysql> select count(*) from trend;
+———-+
| count(*) |
+———-+
| 19 |
+———-+
1 row in set (0.00 sec)
从上面可以看出,此时已经不区分大小写了。