insert - Read For Learn

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2

There is a single quote in $submitsubject or $submit_message Why is this a problem? The single quote char terminates the string in MySQL and everything past that is treated as a sql command. You REALLY don’t want to write your sql like that. At best, your application will break intermittently (as you’re observing) and at worst, you have just introduced … Read more

How to set initial value and auto increment in MySQL?

Use this: or if you haven’t already added an id column, also add it

Solutions for INSERT OR UPDATE on SQL Server

Assume a table structure of MyTable(KEY, datafield1, datafield2…). Often I want to either update an existing record, or insert a new record if it doesn’t exist. Essentially: What’s the best performing way to write this?

SQL – IF EXISTS UPDATE ELSE INSERT INTO

What I’m trying to do is INSERT subscribers in my database, but IF EXISTS it should UPDATE the row, ELSE INSERT INTO a new row. Ofcourse I connect to the database first and GET the $name, $email and $birthday from the url string. This works, but just adds the new row; Here’s what I tried; … Read more

How to do a batch insert in MySQL

From the MySQL manual INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example:

java: use StringBuilder to insert at the beginning

Warning: It defeats the purpose of StringBuilder, but it does what you asked. Better technique (although still not ideal): Reverse each string you want to insert. Append each string to a StringBuilder. Reverse the entire StringBuilder when you’re done. This will turn an O(n²) solution into O(n).

How to copy a row and insert in same table with a autoincrement field in MySQL?

Use INSERT … SELECT: where c1, c2, … are all the columns except id. If you want to explicitly insert with an id of 2 then include that in your INSERT column list and your SELECT: You’ll have to take care of a possible duplicate id of 2 in the second case of course.

Get the new record primary key ID from MySQL insert query?

You need to use the LAST_INSERT_ID() function: http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id Eg: This will get you back the PRIMARY KEY value of the last row that you inserted: The ID that was generated is maintained in the server on a per-connection basis. This means that the value returned by the function to a given client is the first … Read more

MySQL date formats – difficulty Inserting a date

Put the date in single quotes and move the parenthesis (after the ‘yes’) to the end: But you can always use dates without STR_TO_DATE() function, just use the (Y-m-d) ‘20120101’ or ‘2012-01-01’ format. Check the MySQL docs: Date and Time Literals

Object of class DateTime could not be converted to string

Because $newDate is an object of type DateTime, not a string. The documentation is explicit: Returns new DateTime object formatted according to the specified format. If you want to convert from a string to DateTime back to string to change the format, call DateTime::format at the end to get a formatted string out of your DateTime. ShareFollowa

+ More