Database 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

Database, Programming

IT Nursery

Surrogate vs. natural/business keys [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

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

Database, Programming

IT Nursery

What scalability problems have you encountered using a NoSQL data store? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so ...

June 3, 2022
0 Comments