Category: MySQL

Enable Binary Logs In MySQL Server 0

Enable Binary Logs In MySQL Server

Overview : The binary log contains events that describe database changes such as table creation operations or changes to table data. It also contains events...

Shares 0
DML (Data Manipulation Language) Commands in MySQL 0

DML (Data Manipulation Language) Commands in MySQL

Data Manipulation Language (DML) statements or commands are used for managing data within tables. Some commands of DML are: Some commands of DML are: SELECT...

Shares 0
DDL (Data Definition Language) Commands in MySQL 0

DDL (Data Definition Language) Commands in MySQL

DDL statements or commands are used to define and modify the database structure of your tables or schema. When you execute a DDL statement, it...

Shares 0
MySQL Interview Questions & Answers part 3 0

MySQL Interview Questions & Answers part 3

Q: – Explain "CHECK TABLE" statement? The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB...

Shares 0
MySQL Interview Questions & Answers part 2 0

MySQL Interview Questions & Answers part 2

Q: – Explain the terms "mysqlimport", "mysqldump", "mysqladmin" and "mysqlcheck"? mysqlimport for importing data files, mysqldump for making backups, mysqladmin for server administration, and mysqlcheck...

Shares 0
MySQL Interview Questions & Answers part 1 0

MySQL Interview Questions & Answers part 1

Q: – What is REPLCAE statement, and how do I use it? The REPLACE statement is the same as using an INSERT INTO command. The...

Shares 0