About 55,100 results
Open links in new tab
  1. ERROR 1064 (42000): You have an error in your SQL syntax;

    I have a MySQL commands: CREATE DATABASE IF NOT EXISTS courses; USE courses CREATE TABLE IF NOT EXISTS teachers( id INT(10) UNSIGNED PRIMARY KEY NOT NULL …

  2. SQL Error: 0, SQLState: 08S01 Communications link failure

    May 9, 2013 · SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate] Asked 12 years, 7 months ago Modified 5 years, 5 months ago Viewed 301k times

  3. What can SQL CODE -104 (error) represent? - Stack Overflow

    Aug 19, 2016 · What can SQL CODE -104 (error) represent? Asked 12 years, 9 months ago Modified 9 years, 3 months ago Viewed 122k times

  4. PostgreSQL - SQL state: 42601 syntax error - Stack Overflow

    I would like to know how to use a dynamic query inside a function. I've tried lots of ways, however, when I try to compile my function a message SQL 42601 is displayed. The code that I use: CREAT...

  5. Login to Microsoft SQL Server Error: 18456 - Stack Overflow

    Jul 8, 2016 · I am getting this error while trying to connect to the SQL Server. Microsoft SQL Server Error: 18456 Can anybody tell me what the error code means?

  6. PostgreSQL ERROR: 42P01: relation "[Table]" does not exist

    10 While using npg package as your data store ORM you are expecting the ORM framework (Entity Framework in our case) to generate the sql statement you might face a PostgreSQL exception the …

  7. SQL Error: ORA-00942 table or view does not exist

    insert into user1.customer (name,surname) values ('michael','jackson'); The result will be "ORA-00942: table or view does not exist" even though user2 does have insert and select privileges on …

  8. How to solve DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502

    Dec 17, 2018 · How to solve DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502 [closed] Asked 10 years, 3 months ago Modified 5 years, 9 months ago Viewed 68k times

  9. SQL state: 42601 syntax error at or near "11" - Stack Overflow

    May 18, 2013 · You're building SQL using string manipulation so you have to properly quote everything just like in any other language. There are a : quote_ident: quote an identifier such as a table name. …

  10. SQL column reference "id" is ambiguous - Stack Overflow

    ERROR: column reference "id" is ambiguous LINE 1: SELECT id, name FROM person ^ DETAIL: It could refer to either a PL/pgSQL variable or a table column. QUERY: SELECT id, name FROM …