Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL, LIKE - Coggle Diagram
SQL
DOUBTS
ALIASING
WHAT IF A COLUMN ALREADY EXIST IN A TABLE WITH THE NAME WE USE TO ALIAS SOME OTHER COLUMN
i dont think so it should cause a problem becuase sql will simply subtitite that word with the word we wanted whereever it appears in the query
How does the sql which tables column we are aliasing
what all things can be aliased
table name
column name
something else doubt ??
can i use a alised word both for table name and column name simultaneously
till when are they aliased words remembered
till we hit quit or exit ????
is there a way to store the aliases for more time
HOW IT ACTUALLY WORKS
IS IT LIKE SQL SUBSITUTES THE WORD IN ALL THE QUERIES WE DO ??? IF YES CAN IT BE OVERRIDDEN FOR SOME CASE
WHERE
Can i use conditions for columns that i am not selecting in the query to pin point ?
for example
if i am selecting column1 but in the where clause use condition column2 = "24"
USE OF DOT .
DATABASE.TABLE_NAME
BUT YOU ALSO USED IN FIELDS LIKE Info.date
here you have doubt
CAN WE SE;ECT DIFFERENT COLUMNS FROM DIFFERENT TABLES SIMULTANEOUSLY
but i think the table must have some relation for that to happen
comments
,--,/
asterik
/
LIKE
%
any number and typeof characters