Majorly SQL commands can be divided into three categories, i.e., DDL, DML & DCL. Data Definition Language (DDL) deals with all the database schemas, and it defines how the data should reside in the database. Commands like CreateTABLE and ALTER TABLE are part of DDL. Data Manipulative Language (DML) deals with operations and manipulations on …
MySQL Interview Questions
Following are the drivers available in MySQL: PHP Driver JDBC Driver ODBC Driver C WRAPPER PYTHON Driver PERL Driver RUBY Driver CAP11PHP Driver Ado.net5.mxz
To identify each row of a table, we will use a primary key. For a table, there exists only one primary key. A candidate key is a column or a set of columns, which can be used to uniquely identify any record in the database without having to reference any other data.
Federated tables are tables that point to the tables located on other databases on some other server.
To perform batch mode in MySQL, we use the following command: mysql; mysql mysql.out;
It is a system for file management developed by IBM, which allows records to access sequentially or even randomly.
InnoDB is a storage database for SQL. The ACID-transactions are also provided in InnoDB and also includes support for the foreign key. Initially owned by InnobaseOY now belongs to Oracle Corporation after it acquired the latter since 2005.
The SELECT command is used to view the content of the table in MySQL. Explain Access Control Lists. An ACL is a list of permissions that are associated with an object. MySQL keeps the Access Control Lists cached in memory, and whenever the user tries to authenticate or execute a command, MySQL checks the permission …
In MySQL, the “i-am-a-dummy” flag makes the MySQL engine to deny the UPDATE and DELETE commands unless the WHERE clause is present.
In MySQL, regular expressions are used in queries for searching a pattern in a string. * Matches 0 more instances of the string preceding it. + matches one more instances of the string preceding it. ? Matches 0 or 1 instances of the string preceding it. . Matches a single character. [abc] matches a or …