Wednesday, 19 February 2014

How can handle this ERROR 1242 (21000): Subquery returns more than 1 row

How can handle this ERROR 1242 (21000): Subquery returns more than 1 row



1.Writing Subqueries - Rose India

Description:Quantified Subqueries A quantified subquery can use the all
comparison operators for several types of tests. The general syntax is :
Value_1 {=|>|<|>=|<=|<>} {ANY ...



2.MySQL :: MySQL 5.0 Reference Manual :: C.3 Server Error ...

Description:Error: 1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk
Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK) Message: isamchk Error: 1002
SQLSTATE: HY000 (ER_NO



3.Handling Runtime Errors - Oracle Documentation

Description:This component can store up to 70 characters. To get the full
text of messages longer than 70 characters, you must use the sqlglm()
function (discussed later).



4.MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: B.3 ...

Description:Error: 1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk
Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK) Message: isamchk Error: 1002
SQLSTATE: HY000 (ER_NO



5.MySQL Error Codes - Brian Dunning

Description:Descriptions of all MySQL error codes. ... About this database
This is a free public resource. It is unmoderated and operates on the
"public virtue" system.



6.Handling Runtime Errors - Oracle Documentation

Description:Error Handling Alternatives Error handling involves detecting
errors in SQL statements as they occur, and making the error messages
available to the program's user.



7.Sybase World - Blogger

Description:Sybase is a World of Genius Techies. Want to say here "Sybase
Runs Index Runs when Index Runs Whole World Runs"



8.SQL error messages and exceptions - Apache Software Foundation

Description:Table 1. Class 01: Warning; SQLSTATE Message Text; 01001: An
attempt to update or delete an already deleted row was made: No row was
updated or deleted.



9.DB2 9 - Codes - SQLSTATE values and common error codes

Description:Table 3. Class Code 01: Warning; SQLSTATE Value Meaning;
01xxx: Valid warning SQLSTATEs returned by an SQL routine. Also used for
RAISE_ERROR and SIGNAL.



10.Sybase World: Sybase IQ material - Quick Ref

Description:07-10-2009 · For more than 20 years, Sybase has been a leader
in developing and expanding innovative database technology for emerging
markets. In Sybase World I have ...

No comments:

Post a Comment