Create a UNIQUE constraint on your subs_email column, if one does not already exist: ALTER TABLE subs ADD UNIQUE (subs_email) Use INSERT … ON DUPLICATE KEY UPDATE: INSERT INTO subs (subs_name, subs_email, subs_birthday) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE subs_name = VALUES(subs_name), subs_birthday = VALUES(subs_birthday) You can use the VALUES(col_name) function in the … Read more
Pressing ESC quits from insert mode to normal mode, where you can press : to type in a command. Press i again to back to insert mode, and you are good to go. I’m not a Vim guru, so someone else can be more experienced and give you other options.
REPLACE internally performs a delete and then an insert. This can cause problems if you have a foreign key constraint pointing at that row. In this situation the REPLACE could fail or worse: if your foreign key is set to cascade delete, the REPLACE will cause rows from other tables to be deleted. This can … Read more
Use insert() method of List to add the item, here the index would be 0 to add it in the beginning. Example: List<String> list = [“B”, “C”, “D”]; list.insert(0, “A”); // at index 0 we are adding A // list now becomes [“A”, “B”, “C”, “D”]
Set the auto increment field to NULL or 0 if you want it to be auto magically assigned…
From the manual: With ON DUPLICATE KEY UPDATE, the affected-rows value per row is 1 if the row is inserted as a new row and 2 if an existing row is updated.
If your DBMS does not impose limitations on which table you select from when you execute an insert, try: INSERT INTO x_table(instance, user, item) SELECT 919191, 123, 456 FROM dual WHERE NOT EXISTS (SELECT * FROM x_table WHERE user = 123 AND item = 456) In this, dual is a table with one row only … Read more
The value 3172978990 is greater than 2147483647 – the maximum value for INT – hence the error. MySQL integer types and their ranges are listed here. Also note that the (10) in INT(10) does not define the “size” of an integer. It specifies the display width of the column. This information is advisory only. To … Read more
Jai is correct that you should use INSERT … ON DUPLICATE KEY UPDATE. Note that you do not need to include datenum in the update clause since it’s the unique key, so it should not change. You do need to include all of the other columns from your table. You can use the VALUES() function … Read more
timestamp (or date or time columns) do NOT have “a format”. Any formatting you see is applied by the SQL client you are using. To insert the current time use current_timestamp as documented in the manual: INSERT into “Group” (name,createddate) VALUES (‘Test’, current_timestamp); To display that value in a different format change the configuration of … Read more