Top "Mysql-error-1242" questions

Error 1242: Subquery returns more than 1 row

Using GROUP_CONCAT on subquery in MySQL

I have a MySQL query in which I want to include a list of ID's from another table. On the …

Read More
mysql sql group-concat mysql-error-1242
#1242 - Subquery returns more than 1 row - mysql

I am trying to make a select statement that selects the image names from a MySQL database. The table is …

Read More
mysql mysql-error-1242
error : #1242 - Subquery returns more than 1 row

I got an error: #1242 - Subquery returns more than 1 row when i run this sql. CREATE VIEW test AS SELECT …

Read More
mysql sql mysql-error-1242
Multiple rows output into variables in MySQL

The following query seems to only work when there is one single entry with dateOfBirth set to 1975-02-28. It …

Read More
mysql subquery mysql-error-1242
MySQL Benchmark

I am trying to use MySQL benchmark to test some queries. But, I am running to an error. SELECT benchmark (10000, (…

Read More
php mysql benchmarking mysql-error-1242