Can I use where true instead of where 1 conditions when concatenating where conditions in sql statements?

1 the result is that true, is tested after using where true

all conditions are null
the first condition is null
all are not null

can get the right result, and where 1 can get the right result. After google, it is found that no one has done so. Why

SELECT * FROM `table` WHERE 1=1
SELECT * FROM `table` WHERE TRUE
SELECT * FROM `table` WHERE 1

Sql jdbc

Nov.12,2021

it is generally believed that the compatibility of where 1 is better than that of where true, because different databases deal with boolean differently, which can easily lead to some problems.

Previous: Ios iframe scrolling cannot trigger scrolling of the parent page

Next: Click events are given on the line chart and bar chart of Vue's echarts, respectively, and then jump to the corresponding page

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-1bf206c-31de2.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-1bf206c-31de2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?