Syntax and Queries MySQL Commands: Show databases; Create database db_name; Use dbname; Show tables; Create table tb_name(id int, name varchar(20)); Desc tb_name; Insert into tb_name values(101 , ‘name of person’); Insert into tb_name (id) values(102); Update tb_name set name=’person name’ where id=102; Select * from tb_name; Delete from tb_name where id=102; Drop table tb_name; Drop database db_name; Rename table tb_old_name to tb_new_name; Alter table customer add (remark varchar(20)); Alter table customer modify remark varchar(25); Alter table customer modify remark varchar(20);…

Read More Read More

MySQL Interview Questions – Set 14 MySQL Interview Questions – Set 13 MySQL Interview Questions – Set 12 MySQL Interview Questions – Set 11 MySQL Interview Questions – Set 10 MySQL Interview Questions – Set 09 MySQL Interview Questions – Set 08 MySQL Interview Questions – Set 07 MySQL Interview Questions – Set 06 MySQL Interview Questions – Set 05 MySQL Interview Questions – Set 04 MySQL Interview Questions – Set 03 MySQL Interview Questions – Set 02 MySQL Interview…

Read More Read More

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 the data. The commands in DML are Insert, Select, etc. Data Control Languages (DCL) are related to the Grant and permissions. In short, the authorization…

Read More Read More

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 In MySQL, there are several drivers available for connecting to the database from different programming languages. The correct answer depends on the context of the question. Generally, the main drivers used to connect to MySQL databases are: MySQL Connector/J: This is the official JDBC driver for MySQL. It allows Java applications to connect to MySQL databases…

Read More Read More

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. In MySQL, as well as in database management systems in general, the primary key and candidate key are both key concepts (pun intended!) in database design, but they…

Read More Read More

Federated tables are tables that point to the tables located on other databases on some other server. Federated tables in MySQL allow you to access data from a remote MySQL database as if it were a local table. This feature enables you to integrate data from multiple databases across different servers seamlessly. By using federated tables, you can perform queries that involve data from both local and remote databases without having to manually synchronize the data. It’s like having a…

Read More Read More

To perform batch mode in MySQL, we use the following command: mysql; mysql mysql.out; To run MySQL in batch mode, you can use the command-line tool and pass SQL statements from a file rather than typing them interactively. This is particularly useful for executing a series of SQL commands or scripts. You can run MySQL in batch mode using the following command: mysql -u username -p password database_name < batch_file.sql Replace “username” with your MySQL username, “password” with your password,…

Read More Read More