MySQL Archives - IT Nursery

MySQL, Programming

IT Nursery

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 ...

June 4, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 4, 2022
0 Comments

MySQL, Programming

IT Nursery

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... ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 *.* ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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

June 3, 2022
0 Comments