Top "Mysql" questions

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

select count(*) from table of mysql in php

I am able to get both the value and row of the mysql query result. But I am struggling to …

php mysql count
How do I specify unique constraint for multiple columns in MySQL?

I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want to make the columns …

mysql unique-constraint composite-key database-table
Lost connection to MySQL server at 'reading initial communication packet', system error: 0

I am getting error: "Lost connection to MySQL server at 'reading initial communication packet, system error: 0" while I am going …

php mysql
MySQL "NOT IN" query

I wanted to run a simple query to throw up all the rows of Table1 where a principal column value …

sql mysql
Maximum length for MySQL type text

I'm creating a form for sending private messages and want to set the maxlength value of a textarea appropriate to …

mysql database
MySQL root access from all hosts

I've installed MySQL server on a remote Ubuntu machine. The root user is defined in the mysql.user table this …

mysql authentication
PDOException SQLSTATE[HY000] [2002] No such file or directory

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH …

php mysql laravel pdo
Duplicating a MySQL table, indices, and data

How do I copy or clone or duplicate the data, structure, and indices of a MySQL table to a new …

mysql
How to show the last queries executed on MySQL?

Is there any query/way to show the last queries executed on ALL servers?

mysql logging
For loop example in MySQL

In MySQL, I have this stored procedure with a For loop in it: DELIMITER $$ CREATE PROCEDURE ABC() BEGIN DECLARE a …

mysql for-loop