Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
Try to write a query on multiple lines, it's more readable and the sql error tells you the line that now make sense.
Like this:
SELECT *
FROM
users AS u
INNER JOIN
clients AS c
WHERE u.id = c.id
AND u.foo = 'bar'
GROUP BY c.city
ORDER BY c.age ASC
LIMIT 0, 100 -
ivrat2607y@localghost i needed use this at writeing stored procedures and triggers lol its hell but at normal queries i like a bi more compact way
-
@jAsE I can't tell if your being sarcastic but imo MSSQL errors are like clap infested turds. Disgusting to smell and makes your eyes go die slowly in a hole.
Most useless things are mysql error messages lol
undefined