Wednesday, April 15, 2015

Homework5

On a piece of paper,
 Write the syntax of the following MySQL commands  &
 give at least one example of the command.

1. Create a User.
2. Grant privileges to a user.
3. CREATE- allows them to create new tables or databases
4.  DROP- allows them to them to delete tables or databases
5. DELETE- allows them to delete rows from tables 
6. INSERT- allows them to insert rows into tables
7. SELECT- allows them to use the Select command to read through databases
8. UPDATE- allow them to update table rows
9. What is the SQL command to view the current user
10. What does SQL stand for?

2 comments:

  1. mr madali i dont have a command prompt on my chrome book

    ReplyDelete
  2. Mr.Madali this is my new blog http://lalakers5.blogspot.com/

    ReplyDelete