What is MySQL?
MySQL is an open-source relational database management system (RDBMS) known for scalability and reliability.
What versions of MySQL are available?
It is available as a free Community Edition, commercial versions, and cloud deployments.
What are the main MySQL administration tools?
MySQL CLI, MySQL Workbench, and phpMyAdmin.
What is MySQL CLI used for?
It allows users to interact with the MySQL server and data through commands.
What is MySQL Workbench used for?
It combines SQL development, database administration, and database design tools.
What is phpMyAdmin?
phpMyAdmin is a web-based graphical interface used to manage MySQL databases.
Who commonly uses phpMyAdmin?
Web hosting providers and individual website owners often use it.
How can databases and tables be created in MySQL?
They can be created through the command line, graphical interfaces, or API calls.
Can table structures be modified after creation in phpMyAdmin?
Yes, columns and table settings can be added or changed after creation.
Why is phpMyAdmin useful for creating tables?
It provides an intuitive interface for creating databases, tables, and columns, and makes later changes easy.
How can backups and restores be performed in MySQL?
Both command-line tools and phpMyAdmin can be used for backup and restore tasks.
What is the purpose of import and export functions in MySQL?
They help populate tables and save database data to files.
When is manual insertion in phpMyAdmin useful?
It is useful for inserting small amounts of data.
How are primary keys created in MySQL?
A primary key is created by defining a primary index on one or more columns.
What is AUTO_INCREMENT used for in MySQL?
It automatically generates sequential numeric values for a column.
What can be defined when creating foreign keys in MySQL?
Actions such as ON DELETE and ON UPDATE can be set.
What is the default null setting for columns in phpMyAdmin?
Columns are set to NOT NULL by default.
Can MySQL columns be restricted to unique values only?
Yes, columns can be configured with a unique constraint.
