There is an unprintable character 30 (RecordSeparator) inserted between purchase_date and the ‘ in the INSERT statement. Just remove the text (‘purchase_date’) and rewrite it by hand it should be fine.
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 (?, ?)
The main problem you have with all the variations you’ve tried is that both \n and \r are escape characters that are only escaped when you use them in a double-quoted string. In PHP, there is a big difference between ‘\r\n’ and “\r\n”. Note the single-quotes in the first, and double-quotes in the second. So: … Read more
Use MySQL’s STR_TO_DATE() function to parse the string that you’re attempting to insert: INSERT INTO tblInquiry (fldInquiryReceivedDateTime) VALUES (STR_TO_DATE(‘5/15/2012 8:06:26 AM’, ‘%c/%e/%Y %r’))
According to MySQL documentation, you should be able to just enclose that datetime string in single quotes, (‘YYYY-MM-DD HH:MM:SS’) and it should work. Look here: Date and Time Literals So, in your case, the command should be as follows: UPDATE products SET former_date=”2011-12-18 13:17:17″ WHERE id=1
there’s a better way # Larger example rows = [(‘2006-03-28’, ‘BUY’, ‘IBM’, 1000, 45.00), (‘2006-04-05’, ‘BUY’, ‘MSOFT’, 1000, 72.00), (‘2006-04-06’, ‘SELL’, ‘IBM’, 500, 53.00)] c.executemany(‘insert into stocks values (?,?,?,?,?)’, rows) connection.commit()
Consider creating a Calendar table. The first table I create in any database I work with, is a table of numbers, 1 to 1000000. Such a table is useful for lots of purposes, like implementing loops in SQL. Also, it can be used to generate the second table I create on any database I work … Read more
First of all: STOP concatenating together your SQL code!! This is an invitation to hackers everywhere to attack you with SQL injection! Use parametrized queries instead! I would use this solution: create a single SqlCommand with a parametrized query, and execute that: string stmt = “INSERT INTO dbo.Test(id, name) VALUES(@ID, @Name)”; SqlCommand cmd = new … Read more
This is not related to transactions not working. Instead, it’s about Spring Data JDBC considering your instance an existing instance that needs updating (instead of inserting). You can verify this is the problem by activating logging for org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate. You should see an update but no insert. By default, Spring Data JDBC considers an entity as … Read more
If you want fast inserts, first thing you need is proper hardware. That assumes sufficient amount of RAM, an SSD instead of mechanical drives and rather powerful CPU. Since you use InnoDB, what you want is to optimize it since default config is designed for slow and old machines. Here’s a great read about configuring … Read more