Need help with C170 course (Datamangagement- applications)
sql noob4
Registered Users Posts: 2 ■□□□□□□□□□
All right I am desperate at this point.
I have followed the courses instructions to download and install xampp and sample database.
I am able to connect to my sqlserver and specify user, login with password, etc., but after logging in and using the USE database command it seems most commands simply do not work at all. Checking time works with SELECT NOW(), but other commands such as "set USER=sampadm" doesn't work at all, not does the alias command.
It seems that the distribution I am using (MariaDB) uses completely different syntx than the book describles.
Should I not bother trying out the commands and only learn the syntax out of the book.
Are most of the examples in the book just hypothetical?
What am I doing wrong?
I have followed the courses instructions to download and install xampp and sample database.
I am able to connect to my sqlserver and specify user, login with password, etc., but after logging in and using the USE database command it seems most commands simply do not work at all. Checking time works with SELECT NOW(), but other commands such as "set USER=sampadm" doesn't work at all, not does the alias command.
It seems that the distribution I am using (MariaDB) uses completely different syntx than the book describles.
Should I not bother trying out the commands and only learn the syntax out of the book.
Are most of the examples in the book just hypothetical?
What am I doing wrong?
Comments
-
sql noob4
Registered Users Posts: 2 ■□□□□□□□□□
I forgot to mention that I am taking the course through WGU
-
DatabaseHead
Member Posts: 2,754 ■■■■■■■■■■
Select NOW() doesn't need a database to work since it's calling a function. Just like using editor for math. Can you run a simple select statement?