I'm confused by this line in one of the examples: uid int not null auto_increment. Why do we need not null?

Could you go over when to use char versus varchar? What are some things that are helpful to keep in mind when using these?

Just to confirm my understanding, is char() a set number of character and varchar() variable number a characters up until the number identified in the parentethese?

Is it possible to have multiple datatypes within one column?

Can we review signed and unsigned integers?

Can you review ENUM syntax? In the example you give with "cat" preceding "dog", would you have to specify the enum sorting in the query?

Could you explain more about inserting data with auto-increment?

can you explain a situation where it would be wise to use something like auto_increment?


Does last_insert_id remember the last id that you, personally, inserted, or does it find the last id that was inserted into the tabl
e, regardless of who did the inserting? If the latter is the case, how is that different from querying "select max(UID) from staff;"?

Can you explain more about auto increment and last_insert_id().

What happens to the other values that follow when we override a certain auto_increment value? Lets say we have uid 1,2,3,4 and we overrode 2 with 250. Do 3, and 4 still remain the same or do they automatically increase to 251, and 252?

do you get notified if you overwrite a preexistent key from an auto_increment counted table?

Where is the data stored and how?

I'm still a little confused about mysqldump. Could you please explain it more in class?

Is it possible to make the dump automatic? Like how you can have autosave on certain programs.

Could you please elaborate on how dump files work?

how do we track the changes we have made and undo them if needed (or would we rely on version control eg. like git pull requests)?

Can you add a primary key later if you didn’t when creating the table?

So is there no way to add a new column to the table after it has already been created and had items added into it?

If you want to update a table to include another column and drop it, will it delete the rows previously in the table? How do you preserve the data?

- also need a primary key for the table for q1 for best practice?

- is there any modes to have it be machine-checked before deleting the entire table? If not is there no way to save the data if that ever happens?

- in what situations would you want a table without a key column?