Top "Mysql" questions

MySQL joins and COUNT(*) from another table

I have two tables: groups and group_members. The groups table contains all the information for each group, such as …

mysql count group-by left-join having

MacOSX homebrew mysql root password

For some reason MySQL stopped giving access for root. Uninstalled and reinstalled with Homebrew. Fresh install, fresh tables but when …

mysql

Getting raw SQL query string from PDO prepared statements

Is there a way to get the raw SQL string executed when calling PDOStatement::execute() on a prepared statement? For …

php sql mysql pdo pdostatement

MySQL "ERROR 1005 (HY000): Can't create table 'foo.#sql-12c_4' (errno: 150)"

I was working on creating some tables in database foo, but every time I end up with errno 150 regarding the …

mysql foreign-keys mysql-error-1005

How to execute MySQL command from the host to container running MySQL server?

I have followed the instruction in https://registry.hub.docker.com/_/mysql/ to pull an image and running a container …

mysql docker linux-containers

MySQL Insert with While Loop

I'm trying to create a bunch of records in my MySQL database. This is a one time creation so I …

mysql while-loop

How to insert new row to database with AUTO_INCREMENT column without specifying column names?

I have a table with the following columns: id - INT UNSIGNED AUTO_INCREMENT name - VARCHAR(20) group - VARCHAR(20) …

sql mysql insert auto-increment

Alternative to Intersect in MySQL

I need to implement the following query in MySQL. (select * from emovis_reporting where (id=3 and cut_name= '全プロセス' …

mysql intersect

INNER JOIN same table

I am trying to get some rows from the same table. It's a user table: user has user_id and …

mysql sql join self-join

MySQL query to select events between start/end date

I have a MySQL table named 'events' that contains event data. The important columns are 'start' and 'end' which contain …

mysql sql date date-range