Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

How do I check to see if a value is an integer in MySQL?

I see that within MySQL there are Cast() and Convert() functions to create integers from values, but is there any …

mysql
Php - Your PHP installation appears to be missing the MySQL extension which is required by WordPress

How do I fix the error below? Your PHP installation appears to be missing the MySQL extension which is required …

php mysql wordpress nas
How do you connect to a MySQL database using Oracle SQL Developer?

I have Oracle SQL Developer already installed and am able to connect to and query Oracle databases. Using Help -&…

mysql oracle oracle-sqldeveloper
SHOW PROCESSLIST in MySQL command: sleep

When I run SHOW PROCESSLIST in MySQL database, I get this output: mysql> show full processlist; +--------+------+-----------+…

mysql processlist
How to display UTF-8 characters in phpMyAdmin?

I have my database properly set to UTF-8 and am dealing with a database containing Japanese characters. If I do …

mysql unicode utf-8 phpmyadmin
GROUP BY having MAX date

I have problem when executing this code: SELECT * FROM tblpm n WHERE date_updated=(SELECT MAX(date_updated) FROM tblpm …

mysql sql optimization greatest-n-per-group
How to prepend a string to a column value in MySQL?

I need a SQL update statement for updating a particular field of all the rows with a string "test" to …

mysql sql-update
mysql query order by multiple items

is is possible to order by multiple rows? I want my users to be sorted by last_activity, but at …

mysql sql-order-by
Why can't a text column have a default value in MySQL?

If you try to create a TEXT column on a table, and give it a default value in MySQL, you …

mysql default-value
Connection Java-MySql : Public Key Retrieval is not allowed

I try to connect MySql database with Java using connector 8.0.11. Everything seems to be ok but I have this exception: …

java mysql exception connector