Top "Mysql" questions

Installing PDO driver on MySQL Linux server

I was suggested, not long ago, to change my code to use PDO in order to parameterize my queries and …

php mysql pdo phpmyadmin installation

MySQL - Get row number on select

Can I run a select statement and get the row number if the items are sorted? I have a table …

mysql sql row-number

How do I convert from BLOB to TEXT in MySQL?

I have a whole lot of records where text has been stored in a blob in MySQL. For ease of …

sql mysql blobs

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I can't make a simple connection to the server for some reason. I install the newest MySQL Community 8.0 database along …

mysql node.js

#1273 - Unknown collation: 'utf8mb4_unicode_ci' cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. …

mysql wordpress phpmyadmin cpanel

How do I get the current time zone of MySQL?

Anyone knows if there is such a function in MySQL? UPDATE This doesn't output any valid info: mysql> SELECT @@…

mysql timezone

Change One Cell's Data in mysql

How can I change the data in only one cell of a mysql table. I have problem with UPDATE because …

mysql sql-update

Adding a new SQL column with a default value

I am looking for the syntax to add a column to a MySQL database with a default value of 0 Reference

sql mysql

Export MySQL data to Excel in PHP

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text …

php mysql excel export

MySQL high CPU usage

Recently my server CPU has been going very high. CPU load averages 13.91 (1 min) 11.72 (5 mins) 8.01 (15 mins) and my site has only …

mysql cpu-usage