What's wrong with the sql syntax of the following code? Red line hint

clipboard.png

Jul.01,2022

there seems to be nothing wrong with your SQL. Make sure it's not the editor that has a problem with SQL syntax parsing. You can take the SQL to have a look.


syntax is fine. Keywords are preferably capitalized, and field names are best not to use keywords. For example, repeat with keywords such as `name` package.


CREATE TABLE IF NOT EXISTS recommends uppercase. SQL statements are best written in a special SQL client editor for easy inspection.


what is this sql written in? it looks like it is in IDEA. Some IDE will have default verification rules, but there is no egg use

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bc93bf-301b5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bc93bf-301b5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?