On Duplicate Key Update same as insert
I’ve searched around but didn’t find if it’s possible. I’ve this MySQL query: INSERT INTO table (id,a,b,c,d,e,f,g) VALUES (1,2,3,4,5,6,7,8) Field id has a … Read more
MySQL
How to fix “Incorrect string value” errors?
After noticing an application tended to discard random emails due to incorrect string value errors, I went though and switched many text columns … Read more
MySQL date format DD/MM/YYYY select query?
I’m a bit confused on how to order by date formats. For the format YYYY-MM-DD you would do this: …ORDER BY date DESC… … Read more
Throw an error preventing a table update in a MySQL trigger
If I have a trigger before the update on a table, how can I throw an error that prevents the update on that … Read more
Delimiters in MySQL
I often see people are using Delimiters. I tried myself to find out what are delimiters and what is their purpose. After 20 … Read more
ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
I want to begin writing queries in MySQL. show grants shows: +————————————–+ | Grants for @localhost | +————————————–+ | GRANT USAGE ON *.* … Read more
Is there a way to only install the mysql client (Linux)? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions about general computing hardware … Read more
Copy table without copying data
CREATE TABLE foo SELECT * FROM bar copies the table foo and duplicates it as a new table called bar. How can I … Read more
Is there a naming convention for MySQL?
Here’s how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. foo, foo_bar, etc. I … Read more
How to recover MySQL database from .myd, .myi, .frm files
How to restore one of my MySQL databases from .myd, .myi, .frm files? 11 Answers 11