chevron_left chevron_right
Login Register invert_colors photo_library
Thread Rating:
  • 0 Vote(s) - 0 Average


filter_list A Story about `Magic`
Author
Message
RE: A Story about `Magic` #21
(10-21-2017, 12:53 AM)phyrrus9 Wrote: Of course! Backticks are an extremely important piece of not only the English language but computer science.

Definitely so.

For example, on the computing side of things namely MySQL (which I'm sure you know), try creating a column name (or table name) with two separate words without using backticks. I don't like substituting with underscores and that's where I utilize backticks on a large scale. On topic, I shall read your solution and establish a conclusion.
EDIT: Typo.

Reply

RE: A Story about `Magic` #22
(10-21-2017, 03:56 AM)mothered Wrote:
(10-21-2017, 12:53 AM)phyrrus9 Wrote: Of course! Backticks are an extremely important piece of not only the English language but computer science.

Definitely so.

For example, on the computing side of things namely MySQL (which I'm sure you know), try creating a column name (or table name) with two separate words without using backticks. I don't like substituting with underscores and that's where I utilize backticks on a large scale. On topic, I shall read your solution and establish a conclusion.
EDIT: Typo.

I've gotten so used to the following syntax (bonus points if you can name it)

Code:
SELECT
               T.a
              ,C.b
  FROM [Table1] AS [T]
  INNER JOIN [Table2] AS [C]
    ON [T].[c] == [C].[c]
I will keep that list up to date at all times. Check often for new materials!

Reply

RE: A Story about `Magic` #23
(10-21-2017, 10:31 AM)phyrrus9 Wrote: I've gotten so used to the following syntax (bonus points if you can name it)

Code:
SELECT
              T.a
             ,C.b
 FROM [Table1] AS [T]
 INNER JOIN [Table2] AS [C]
   ON [T].[c] == [C].[c]

Nice use of JOIN clause and finally I've come across someone who applies the ALIAS.

Judging by the square brackets, looks like SQL Server

Reply

RE: A Story about `Magic` #24
(10-21-2017, 02:06 PM)mothered Wrote:
(10-21-2017, 10:31 AM)phyrrus9 Wrote: I've gotten so used to the following syntax (bonus points if you can name it)

Code:
SELECT
              T.a
             ,C.b
 FROM [Table1] AS [T]
 INNER JOIN [Table2] AS [C]
   ON [T].[c] == [C].[c]

Nice use of JOIN clause and finally I've come across someone who applies the ALIAS.

Judging by the square brackets, looks like SQL Server

Always alias yer shit....gets uber confusing if you dont (or long).
Yes, it's T-SQL. I hate the way they do it, but I am quite fond of the brackets
I will keep that list up to date at all times. Check often for new materials!

Reply






Users browsing this thread: 1 Guest(s)