php连接mysql出错 Table 'test.user' doesn't exist
16lz
2021-01-22
如果是我自己建的数据库的话mysql_select_db("mysql");
就选择不到,换成系统的还是出错.
源码
<?php
mysql_connect("localhost","root","123");
mysql_select_db("mysql");
echomysql_errno().":".mysql_error()."\n";
mysql_select_db("test");
mysql_query("SELECT*FROMuser");
echomysql_errno().":".mysql_error()."\n";
?>
错误提示
Warning:mysql_query()[http://www.mysql.com/doc]:Table'test.user'doesn'texistinE:\客户网站\php\index3.phponline8
1146:Table'test.user'doesn'texist
附:
mysql
MySQLSupportenabled
ActivePersistentLinks0
ActiveLinks0
ClientAPIversion5.0.22
DirectiveLocalValueMasterValue
mysql.allow_persistentOnOn
mysql.connect_timeout6060
mysql.default_hostnovaluenovalue
mysql.default_passwordnovaluenovalue
mysql.default_portnovaluenovalue
mysql.default_socketnovaluenovalue
mysql.default_usernovaluenovalue
mysql.max_linksUnlimitedUnlimited
mysql.max_persistentUnlimitedUnlimited
mysql.trace_modeOnOn
Table'test.user'doesn'texist
没有user这个表
就选择不到,换成系统的还是出错.
源码
<?php
mysql_connect("localhost","root","123");
mysql_select_db("mysql");
echomysql_errno().":".mysql_error()."\n";
mysql_select_db("test");
mysql_query("SELECT*FROMuser");
echomysql_errno().":".mysql_error()."\n";
?>
错误提示
Warning:mysql_query()[http://www.mysql.com/doc]:Table'test.user'doesn'texistinE:\客户网站\php\index3.phponline8
1146:Table'test.user'doesn'texist
附:
mysql
MySQLSupportenabled
ActivePersistentLinks0
ActiveLinks0
ClientAPIversion5.0.22
DirectiveLocalValueMasterValue
mysql.allow_persistentOnOn
mysql.connect_timeout6060
mysql.default_hostnovaluenovalue
mysql.default_passwordnovaluenovalue
mysql.default_portnovaluenovalue
mysql.default_socketnovaluenovalue
mysql.default_usernovaluenovalue
mysql.max_linksUnlimitedUnlimited
mysql.max_persistentUnlimitedUnlimited
mysql.trace_modeOnOn
5 个解决方案
#1
Table'test.user'doesn'texist
没有user这个表
更多相关文章
- RedHat6.0下源码安装MySQL5.5.27
- AppScan安全问题解决方案
- PLSQL乱码解决方案
- Red Hat5下源码安装mysql5.6过程记录
- 数据库不支持中文解决方案(mysql)
- Mysql替代解决方案Cassandra
- 微信 Tinker 的一切都在这里,包括源码
- Android开源框架源码鉴赏:Fresco
- MediaPlayer源码存在的内存泄漏问题,释放资源的正确方式