Interested to Buy Any Domain ? << Click Here >> for more details...
What is DCL in MySQL?
- 1 Answers
- 1395 Views
- I also Faced
- E-Mail Answers
DCL is a short form for Data Control Language including commands which are concerned with User rights, permissions and other controls within the database system.
A list of queries for DCL:
GRANT
REVOKE
| Is This Answer Correct ? | 0 Yes | 0 No |
A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.
what if you really want to store the timestamp data, such as the publication date of the article?
how we connect the data base in any programme
Write a query to retrieve a hundred books starting from 20th.
Explain MySQL locks?
How many ways we can we find the current date using MySQL?
What is a tinyint?
What is the difference Delete and Drop ?
How to change the database engine in mysql?
How to update info already in a table and delete a row(s) from a table.
How to create and drop view in mysql?
What is pdo in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
