I want to generically use any SQL database(I'm using jdbc, it works if the driver and the URL are provided).
It seems, that different DBMS use different quoting for table names.
For example, I have the following in MySQL:
SELECT * FROM
tablename
;
while it is
SELECT * FROM [tablename];
in MS SQL Server.
Is there an "uniform" quoting that all databases support? Or is there a jdbc method that gives me tells me the correct quoting?
Asked by dan1st
(103 rep)
Dec 19, 2019, 12:48 PM
Last activity: Dec 19, 2019, 03:11 PM
Last activity: Dec 19, 2019, 03:11 PM