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?
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?
mr madali i dont have a command prompt on my chrome book
ReplyDeleteMr.Madali this is my new blog http://lalakers5.blogspot.com/
ReplyDelete