SQL code:
--建立临时表，问题1
create TEMPORARY table tmp_table(s1 int,s2 varchar(30))
--select * from tmp_table
--建立临时变量，问题2
set @v=0;
--循环执行插入操作，问题3
while @v<20 do
insert into tmp_table values(@v,concat('测试数据:', @v))
set @v=@v+1
end while
......
mysql 中一个表中字段如下: id value create_time 三个字段
如数据有:
1 test1 2009-9-10
1 test2 2009-9-11
2 testg 2009-9-10
3 testu 2009-9-11
3 testn 2009-9-10
我要想得到的结果是当id相同时，只取create ......
Java code:
import java.sql.*;
public class DBTester1 {
public static void main(String[] args) throws Exception {
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new co ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf.fgjqib + cf.fjyqib + cf.fgnb + cf.fxz + cf.fcc + cf.fsc + cf.fqzb + cf.fjfz + cf.fzgn + cf.fmf + cf. ......
090929 18:14:02 [Note] Plugin 'FEDERATED' is disabled.
090929 18:14:02 [Note] Plugin 'InnoDB' is disabled.
D:\mysql5.1\bin\mysqld: Too many arguments (first extra is 'd:/mysql5.1/my.ini').
Use --verbose --help to get a list of available options
090929 18:14:02 [ER ......
大家好！
我使用
CommonDBUtils操作mysql数据库！
可以执行select语句，但是不能执行insert语句
一下是异常
java.sql.SQLException: Feature not implemented Query: insert into Computer_Ignorance_Article(CIA_Title,CIA_Link,CIA_Type_Id) values(?,?,?) Parameters: [1, 1254321163453.html, 0]
......
最新文章 : mysql