This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 9 months, 2 weeks ago
Modified: 9 months, 2 weeks ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

Error 1242: Subquery returns more than 1 row

Error Code	SQLSTATE	Error	Description
1242	21000	ER_SUBQUERY_NO_1_ROW	Subquery returns more than 1 row

Possible Causes and Solutions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ MariaDB Error Codes 1200 to 1299 ↑
Error 1200: The server is not configured as slave
Error 1201: Could not initialize master info structure
Error 1202: Could not create slave thread; check system resources
Error 1203: User already has more than 'max_user_connections' active connections
Error 1204: You may only use constant expressions with SET
Error 1205: Lock wait timeout exceeded; try restarting transaction
Error 1206: The total number of locks exceeds the lock table size
Error 1207: Update locks cannot be acquired during a READ UNCOMMITTED transaction
Error 1208: DROP DATABASE not allowed while thread is holding global read lock
Error 1209: CREATE DATABASE not allowed while thread is holding global read lock
Error 1210: Incorrect arguments to
Error 1211: is not allowed to create new users
Error 1212: Incorrect table definition; all MERGE tables must be in the same database
Error 1213: Deadlock found when trying to get lock; try restarting transaction
Error 1214: The used table type doesn't support FULLTEXT indexes
Error 1215: Cannot add foreign key constraint
Error 1216: Cannot add or update a child row: a foreign key constraint fails
Error 1217: Cannot delete or update a parent row: a foreign key constraint fails
Error 1218: Error connecting to master
Error 1219: Error running query on master
Error 1220: Error when executing command
Error 1221: Incorrect usage of
Error 1222: The used SELECT statements have a different number of columns
Error 1223: Can't execute the query because you have a conflicting read lock
Error 1224: Mixing of transactional and non-transactional tables is disabled
Error 1225: Option used twice in statement
Error 1226: User has exceeded the resource
Error 1227: Access denied; you need (at least one of) the privilege(s) for this operation
Error 1228: Variable is a SESSION variable and can't be used with SET GLOBAL
Error 1229: Variable is a GLOBAL variable and should be set with SET GLOBAL
Error 1230: Variable doesn't have a default value
Error 1231: Variable can't be set to the value of
Error 1232: Incorrect argument type to variable
Error 1233: Variable can only be set, not read
Error 1234: Incorrect usage/placement
Error 1235: This version of MariaDB doesn't yet support
Error 1236: Got fatal error from master when reading data from binary log
Error 1237: Slave SQL thread ignored the query because of replicate-*-table rules
Error 1238: Variable is a
Error 1239: Incorrect foreign key definition
Error 1240: Key reference and table reference don't match
Error 1241: Operand should contain column(s)
Error 1242: Subquery returns more than 1 row
Error 1243: Unknown prepared statement handler given
Error 1244: Help database is corrupt or does not exist
Error 1245: Cyclic reference on subqueries
Error 1246: Converting column from to
Error 1247: Reference not supported
Error 1248: Every derived table must have its own alias
Error 1249: Select was reduced during optimization
Error 1250: Table from one of the SELECTs cannot be used
Error 1251: Client does not support authentication protocol requested by server
Error 1252: All parts of a SPATIAL index must be NOT NULL
Error 1253: COLLATION is not valid for CHARACTER SET
Error 1254: Slave is already running
Error 1255: Slave already has been stopped
Error 1256: Uncompressed data size too large
Error 1257: ZLIB: Not enough memory
Error 1258: ZLIB: Not enough room in the output buffer
Error 1259: ZLIB: Input data corrupted
Error 1260: Row was cut by GROUP_CONCAT()
Error 1261: Row doesn't contain data for all columns
Error 1262: Row was truncated; it contained more data than there were input columns
Error 1263: Column set to default value; NULL supplied to NOT NULL columnError 1263: Column set to default value; NULL supplied to NOT NULL column
Error 1264: Out of range value for column
Error 1265: Data truncated for column
Error 1266: Using storage engine for table
Error 1267: Illegal mix of collations for operation
Error 1268: Cannot drop one or more of the requested users
Error 1269: Can't revoke all privileges for one or more of the requested users
Error 1270: Illegal mix of collations for operation
Error 1271: Illegal mix of collations for operation
Error 1272: Variable is not a variable component (can't be used as XXXX.variable_name)
Error 1273: Unknown collation
Error 1274: SSL parameters in CHANGE MASTER are ignored because this MariaDB slave was compiled without SSL support
Error 1275: Server is running in --secure-auth mode, but has a password in the old format
Error 1276: Field or reference of SELECT was resolved in SELECT
Error 1277: Incorrect parameter or combination of parameters for START SLAVE UNTIL
Error 1278: It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL
Error 1279: SQL thread is not to be started so UNTIL options are ignored
Error 1280: Incorrect index name
Error 1281: Incorrect catalog name
Error 1282: Query cache failed to set size; new query cache size is
Error 1283: Column cannot be part of FULLTEXT index
Error 1284: Unknown key cache
Error 1285: MariaDB is started in --skip-name-resolve mode
Error 1286: Unknown storage engine
Error 1287: is deprecated and will be removed in a future release. Please use instead
Error 1288: The target table of the is not updatable
Error 1289: The feature is disabled; you need MariaDB built with to have it working
Error 1290: The MariaDB server is running with the option so it cannot execute this statement
Error 1291: Column has duplicated value
Error 1292: Truncated incorrect value
Error 1293: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Error 1294: Invalid ON UPDATE clause
Error 1295: This command is not supported in the prepared statement protocol yet
Error 1296: Got error from
Error 1297: Got temporary error from
Error 1298: Unknown or incorrect time zone
Error 1299: Invalid TIMESTAMP value in column at row

Error 1242: Subquery returns more than 1 row

Contents

Possible Causes and Solutions

Products

Services

Pricing

Resources

About Us

Download MariaDB