MySQL Flashcards
1
Q
What is MySQL?
A
MySQL is a relational database that uses SQL
2
Q
Database vs Table
A
A database is a collection of tables. Tables are groups of data within the database.
3
Q
What are foreign keys in MySQL?
A
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.
4
Q
What is MySQL workbench?
A
MySQL Workbench is a GUI web interface for interacting with MySQL databases
5
Q
PHP+MySQL: WHen should you use post vs get?
A
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,
