Top "Mysql" questions

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

What is the maximum length of data I can put in a BLOB column in MySQL?

What is the maximum length of data I can put in a BLOB column in MySQL?

mysql blob
PDO with INSERT INTO through prepared statements

On my adventure through the jungles of PHP: Data Objects I've encountered a problem with executing MySQL queries through prepared …

php mysql sql pdo
MySQL SELECT LIKE or REGEXP to match multiple words in one record

The field table.name contains 'Stylus Photo 2100' and with the following query SELECT `name` FROM `table` WHERE `name` LIKE …

mysql regex select sql-like
setting multiple column using one update

How to set multiple columns of a table using update query in mysql?

mysql
How to generate the whole database script in MySQL Workbench?

I want to take the whole database. Where do I find the database file? And is there a way to …

mysql sql database mysql-workbench
Using union and order by clause in mysql

I want to use order by with union in mysql query. I am fetching different types of record based on …

mysql sql sql-order-by union
How do you debug MySQL stored procedures?

My current process for debugging stored procedures is very simple. I create a table called "debug" where I insert variable …

mysql database debugging stored-procedures
phpMyAdmin - can't connect - invalid setings - ever since I added a root password - locked out

I run XAMPP, a few days back i had set up a password for the root password through phpmyadmin I …

mysql phpmyadmin root
After MySQL install via Brew, I get the error - The server quit without updating PID file

Ok, I've searched all over and have spent quite a bit of my time installing, uninstalling, trying various option but …

mysql homebrew
How to get the mysql table columns data type?

I want to get the column data type of a mysql table. Thought I could use MYSQLFIELD structure but it …

mysql