Skip to content

Tag: sql

What’s the scope of table aliases?

This question is in the context of Sqlite but I wonder in general what’s the rule for aliases. Suppose I have the following query: The question is, will the two t1’s and t2’s clash? in my experience with multiple database vendors they won’t clash, but, could it confuse the optimizer to…

SQL select column with conditions JAVA

I tried to get specific value where the column of names in my database contains “jansen”,but when i run my code it shows error like this here is my code [and here is my database in Sqlyog] Answer You should put quotes around string values in your SQL statement. Another issue you may run into later…

SQL: JOIN vs LEFT OUTER JOIN?

I have multiple SQL queries that look similar where one uses JOIN and another LEFT OUTER JOIN. I played around with SQL and found that it the same results are returned. The codebase uses JOIN and LEFT OUTER JOIN interchangeably. While LEFT JOIN seems to be interchangeable with LEFT OUTER JOIN, I cannot I cann…

React Form won’t save date

I’ve created a basic form in React to save a name, category, and date if available to an SQL table. My form is acting fine – it’s submitting correctly and saving the new entries. The problem is, while it saves the name and the category fine, if you choose a date (using the HTML date picker) …

Making a table with a foreign key

I’m creating a SQL database in Oracle. I have created this table: And I tried creating a second table that has a foreign key referencing it: I get this error: ORA-00904: “LID”: invalid identifier 00904. 00000 – “%s: invalid identifier” Answer Defining a foreign key on a col…

How do I properly input an sql where clause in VBA?

The where clause in the code below is throwing me an error. I just can’t seem to get the syntax right. Answer The values of the variables need to be added to the SQL, not their names, and the values need to be in an appropriate format. The following code will add the dates in yyyy-mm-dd format.