網(wǎng)絡(luò)請(qǐng)求和數(shù)據(jù)庫(kù)查詢(xún)關(guān)系
比如打開(kāi)一個(gè)網(wǎng)址：http://host/getuser?id=23嘱么，
或許數(shù)據(jù)庫(kù)查詢(xún)方式：
select * from table_name where id=23
select * from table_name where id='23'
select * from table_name where id="23"
select * from table_name where id=(23)
select * from table_name where id=('23')
select * from table_name where id=("23")
常見(jiàn)的一些各個(gè)數(shù)據(jù)庫(kù)的拋出異澄媸伲總結(jié)
- MySQL Error Style:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'' at line 1
- MSSQL ASPX Error:
Server Error in '/' Application
- MSAccess (Apache PHP):
Fatal error: Uncaught exception 'com_exception' with message Source: Microsoft JET Database Engine
- MSAccesss (IIS ASP):
Microsoft JET Database Engine error '80040e14'
- Oracle Error:
ORA-00933: SQL command not properly ended
- ODBC Error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
- PostgreSQL Error:
PSQLException: ERROR: unterminated quoted string at or near "'" Position: 1
or
Query failed: ERROR: syntax error at or near
"'" at character 56 in /www/site/test.php on line 121.
- MS SQL Server: Error:
Microsoft SQL Native Client error %u201880040e14%u2019
Unclosed quotation mark after the character string
