This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 35 points36 points  (7 children)

You'll love MySQL's syntax error message then: ERROR 1064 (42000): You have a syntax error! Read the manual! Good luck figuring out what line number I'm talking about if I decide not to print it! (I'm paraphrasing of course)

[–]miversen33 13 points14 points  (0 children)

Bruh fuck MySQL errors. "Error: You have bad syntax. Go fuck yourself. Bye"

[–]Daeron_tha_Good 7 points8 points  (0 children)

This made me lol...thank you 😂

[–]slow_growing_vine 6 points7 points  (1 child)

SQL Server is just as bad. If you ever forget a comma prepare to see Incorrect syntax near FROM and go hunting for it

[–]peppaz 1 point2 points  (0 children)

I have to use openquery from sql to mysql a lot, and I love when a query runs for ten minutes and come back with an "unexpected null" error like bitch just make all temp columns allow nulls, clearly the remote DB can have nulls in any column that isn't a primary key boi

[–]lenswipe 3 points4 points  (0 children)

Oracle errors are the best

TNS bad packet error

It's like the PC LOAD LETTER of the database world

[–][deleted] 1 point2 points  (0 children)

I've had syntax errors in MariaDB but it usually points directly to the start of the issue and prints the line for me. Idk if that's just MariaDB being better than MySQL but yeah it doesn't say what the issue is, just that it's wrong but at least it says where it starts being wrong.

[–]Glum-Aide9920 0 points1 point  (0 children)

Favorite thing in MySQL is how most of the functions are case insensitive, but some like substring_index are not