0

What is the best mysql practice?

I know it's cap insensitive, but does using all caps commands help reading the code? CREATE VIEW [Brazil Customers] AS SELECT CustomerName, ContactName FROM Customers WHERE Country = "Brazil"; For newb like me it looks like it's easier to separate what's what. But what about others? Trying to make a cheat sheet for myself and would like to do it right from the beginning. Cheers!

7th Feb 2019, 5:37 PM
Scadian Force
Scadian Force - avatar
2 Antworten
+ 1
Using caps for sql keywords is a good practice to read/debug your code better To practice sql, i recomment this online interactive sql training : https://sqlbolt.com
7th Feb 2019, 8:11 PM
Dominique Abou Samah
Dominique Abou Samah - avatar
+ 1
I tried your link, it's awesome. I will add it to my ToDo list. Cheers!
7th Feb 2019, 8:43 PM
Scadian Force
Scadian Force - avatar