+ Reply to Thread
Results 1 to 3 of 3
  1. Junior Member Registered Member
    Join Date
    May 2016
    Posts
    2
    #1

    Default Need help with C170 course (Datamangagement- applications)

    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?
    Reply With Quote Quote  

  2. SS -->
  3. Junior Member Registered Member
    Join Date
    May 2016
    Posts
    2
    #2
    I forgot to mention that I am taking the course through WGU
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    May 2016
    Posts
    1,632

    Certifications
    70-461, ITIL V3 F, ITIL OSA, ITIL ST
    #3
    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?
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks