MySQL Archives - Page 2 of 38

MySQL, Programming

IT Nursery

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’

Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' I have gone through several other posts and was ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

How do I turn off the mysql password validation?

It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

Maximum number of records in a MySQL database table

What is the upper limit of records for MySQL database table. I’m wondering about autoincrement field. What would happen if I add milions ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

On duplicate key ignore? [duplicate]

This question already has answers here: “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE” (12 answers) Closed 9 years ago. I’m trying ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

Easiest way to copy a table from one database to another?

What is the best method to copy the data from a table in one database to a table in another database when the ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

How to get ER model of database from server with Workbench

Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench? 4 ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

MySQL stored procedure vs function, which would I use when?

I’m looking at MySQL stored procedures and functions. What is the real difference? They seem to be similar, but a function has more ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

How to create a database from shell command?

I’m looking for something like createdb in PostgreSQL or any other solution that would allow me to create database with a help of ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

Binary Data in MySQL [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 2, 2022
0 Comments