1、Select * from chuang_AgentInfo Where UserName='成都' --在MySql工具里面查询有记录
2、以下代码查询上面语句,没有记录table.row.count为0
MySqlCommand thisCommand = new MySqlCommand();
thisCommand.CommandTimeout = 0;
// make sure connection is open
MySqlConne ......
是windows环境,还有使用load data local in file "D:\pet.txt" into table pet;怎么不能把文件导入进去啊?
我是刚学数据库。
load data local infile "D:\pet.txt" into table pet;
in file -> infile
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
&n ......
例如: 姓名 年龄 地址 等级
小王 19 江西省南昌市西湖区XXX号江西省南昌市西湖区XXX号 金卡
& ......
我的一个程序要用到bdb存储一些东西,但管理的时候,希望用mysql来管理,这样方便!
MySQL 5.1分发版有
引用
MySQL 5.1分发版有
SQL code:
Your MySQL connection id is 10216
Server version: 5.1.37-log Source distribution
mysql> select version();
+------------+
| version() |
+--- ......
例子:
SELECT *
from (
SELECT *
from (
SELECT c. * , r. *
from RIGHT_TEST AS c
LEFT JOIN authorize_table AS r ON r.TABLE_NO =1
AND c.TABLE_ID = r.TABLE_REC_ID
and(( $$_PUB_IN_RIGHT_TYPE <=-10 and $$_PUC_DEPART_TYPE = 2 and $$_PUC_DEPART_ID1 = 1 )
OR ......
哪位仁兄帮忙给看看下面什么原因???
090918 16:50:09 [Note] /usr/sbin/mysqld-max: Normal shutdown
090918 16:50:11 InnoDB: Starting shutdown...
090918 16:50:15 InnoDB: Shutdown completed; log sequence number 0 1179760410
090918 16:50:15 [Note] /usr/sbin/mysqld-max: ......