MySQL

Question 1

What is MySQL?

Answer 1

MySQL is a relational database that uses SQL

Question 2

Database vs Table

Answer 2

A database is a collection of tables. Tables are groups of data within the database.

Question 3

What are foreign keys in MySQL?

Answer 3

Foreign keys are columns in a table that connect the table with other tables by linking the foreign keys with another table’s primary keys.

Question 4

What is MySQL workbench?

Answer 4

MySQL Workbench is a GUI web interface for interacting with MySQL databases

Question 5

PHP+MySQL: WHen should you use post vs get?

Answer 5

Use get when there are no side effects from querying a db. Use post when the form submission has side effects such as modification of a database or subscription to a service,