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
Previous: Phpstorm xdebug debugging, phpstorm always can not capture, the browser displays 504 timeout
Next: How do rss feeds (such as rsshub) apply to your own projects?
the user guesses the score of a game, which is about < table > < thead > < tr > < th > id < th > < th > team1 (home team scores) < th > < th > team2 (visiting team scores) < th > < tr > < thead > < tbody > < tr > < td > 1 < td > < td > 1 < ...
SQL quotation marks backslash escape can be bypassed by double-byte injection. Can this problem be avoided by transferring utf-8 first? ...
I successfully run the following sql statement to find the ideal data exec sp_executesql N Select * FROM FC_Repair WHERE F_RepairDepartmentId in ( ace7f0e7-f158-4587-920d-e76546885198 , bf421a22-786b-40fd-8af...
problem description as follows, I created an attempt. I want group by to group the sum by RD.SKU and the RD.QTYRECEIVED field is sumsum, but I want to display the six fields of select instead of just showing RD.SKU and sumsum,. The simple point is, th...
The sql statement is as follows SELECT sum(case when CONVERT(varchar(100), b.BillDate, 112) >= 20180101 AND CONVERT(varchar(100), b.BillDate, 112) < 20180126 then b.totalmoney else 0 end)AS , sum(case when CONVERT(varchar(100), b.BillDate, 11...