In LOAD DATA local infile 'file.csv', it sounds like the keyword ""local""  sends data to the server to be read.  That sounds like it is making the data reading process be an external process instead of a local one.  So I am confused as to why the keyword is ""local""?

You said that when using LOAD DATA, the column names in the tsv should match the column names in the MySQL table.  What if there are spaces, unusual characters, or superscripts in the column names (ex: ""Acceleration (m/s^2)"")?

Is there any drawback to just giving varchar(x) some massive number for x, such as 2**10? 

How can we add columns to a table without wiping out the pre-existing data?

How can we index columns in a pre-existing table without modifying the table creation file?

I'm a little confused on the difference between primary keys and indexes. Could you provide an example of what they look like on table?

Can you explain why it’s easier for software to parse a TSV file over CSV? I thought we could specify what the delimiter is. 

Can you over innoDB more in class?

I think this will be clearer if we see examples in class, but I'm a bit confused as to how using index(col_name) is different than doing select * from table where col_name = desired value. Does doing this the select way take O(n) time for some reason? Also, what information can you get using an indexed column? 

I'm a little confused why a key would be updated and set null in the subordinate table, could you give an example of this?

If a pet dies and its owner only has one pet, will both the owner and the pet be removed from the owner and the pet table?

I'm still confused as to why the order of the drop tables commands matters. Why is it that "if we dropped the album table first, it would immediately render all the foreign keys in the track table invalid"?

having some trouble understanding how index speeds up queries, can you give an example

Would you ever use an index on a primary key?

How does an index treat rows with the same entry for the index column (ex. two people with the same name)?

Is there a way to auto assign IDs without a matching column in a CSV file?

So to keep referential integrity, do we need to use the foreign key and index clauses when creating tables?

Related to Q2: Is referential integrity a two-way street? Does saying an owner must have a pet mean the owner table must have a column with the primary key of the pet table?