Solved, I forgot to add the encoding when initializing Connection: before was: con = DriverManager.getConnection(“jdbc:mysql:///dbname”, “user”, “pass”); now (working): con = DriverManager.getConnection(“jdbc:mysql:///dbname?useUnicode=true&characterEncoding=utf-8”, “user”, “pass”);
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html For case1: INSERT INTO TAB_STUDENT(name_student, id_teacher_fk) SELECT ‘Joe The Student’, id_teacher FROM TAB_TEACHER WHERE name_teacher=”Professor Jack” LIMIT 1 For case2 you just have to do 2 separate insert statements
To insert a single row of data: INSERT INTO USERS VALUES (1, ‘Mike’, ‘Jones’); To do an insert on specific columns (as opposed to all of them) you must specify the columns you want to update. INSERT INTO USERS (FIRST_NAME, LAST_NAME) VALUES (‘Stephen’, ‘Jiang’); To insert multiple rows of data in SQL Server 2008 or … Read more
Assuming that you want to group the data before you generate the key with the sequence, it sounds like you want something like INSERT INTO HISTORICAL_CAR_STATS ( HISTORICAL_CAR_STATS_ID, YEAR, MONTH, MAKE, MODEL, REGION, AVG_MSRP, CNT) SELECT MY_SEQ.nextval, year, month, make, model, region, avg_msrp, cnt FROM (SELECT ‘2010’ year, ’12’ month, ‘ALL’ make, ‘ALL’ model, REGION, … Read more
That probably means that your id is an AUTO_INCREMENT integer and you’re trying to send a string. You should specify a column list and omit it from your INSERT. INSERT INTO workorders (column1, column2) VALUES (?, ?)
You could modify your INSERT to be something like this: INSERT INTO tablename (tag) SELECT $tag FROM tablename WHERE NOT EXISTS( SELECT tag FROM tablename WHERE tag = $tag ) LIMIT 1 Where $tag is the tag (properly quoted or as a placeholder of course) that you want to add if it isn’t already there. … Read more
Sure, you can use slice indexing: a_list[1:1] = b_list Just to demonstrate the general algorithm, if you were to implement the my_extend function in a hypothetical custom list class, it would look like this: def my_extend(self, other_list, index): self[index:index] = other_list But don’t actually make that a function, just use the slice notation when you … Read more
For me it is working like this (mybatis 3.x) .. The id must be set auto increment in mysql table <insert id=”createEmpty” parameterType=”Project” useGeneratedKeys=”true” keyProperty=”project.projectId” keyColumn=”PROJECT_ID”> INSERT INTO PROJECT (TITLE,DESCRIPTION) VALUES (#{title},#{description}) </insert> NOTE keyProperty=”project.projectId” and useGeneratedKeys=”true” my interface is: public int createEmpty(@Param(“project”) Project project, @Param(“title”) String title, @Param(“description”) String description); finally to get the … Read more
For MS SQL Server: SCOPE_IDENTITY() will return you the last generated identity value within your current scope: SELECT SCOPE_IDENTITY() AS NewID
If you’re trying to use a dict to specify both the column names and the values, you can’t do that, at least not directly. That’s really inherent in SQL. If you don’t specify the list of column names, you have to specify them in CREATE TABLE order—which you can’t do with a dict, because a … Read more