no quoting. delimiter = '"' ### Whether the CSV files contain a header. ### If `header` is true, the first line will be skipped. header = true ### Whether the CSV contains any NULL value. ### If `not-null` the LOAD DATA statement. 5.3.1.3.3 header • Whether all CSV files contain a header row. • If header is true, the first row will be used as the column names. If header is false, the first row is not special LINES TERMINATED BY is not customizable. • There cannot be line prefixes (LINES STARTING BY). • The header cannot be simply skipped (IGNORE n LINES). It must be valid column names if present. 167 5.3.1

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE id fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE id fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE id fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE id fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough

terminators. terminator = '' ### Whether the CSV files contain a header. ### If `header` is true, the first line will be skipped. header = true ### Whether the CSV contains any NULL value. ### If `not-null` the LOAD DATA statement. 5.3.1.3.4 header • Whether all CSV files contain a header row. • If header is true, the first row will be used as the column names. If header is false, the first row is not special the LOAD DATA statement. Some examples: • There cannot be line prefixes (LINES STARTING BY). • The header cannot be simply skipped (IGNORE n LINES). It must be valid column names if present. 5.3.1.4 Strict

terminators. terminator = '' ### Whether the CSV files contain a header. ### If `header` is true, the first line will be skipped. header = true ### Whether the CSV contains any NULL value. ### If `not-null` the LOAD DATA statement. 5.3.1.3.4 header • Whether all CSV files contain a header row. • If header is true, the first row will be used as the column names. If header is false, the first row is not special the LOAD DATA statement. Some examples: • There cannot be line prefixes (LINES STARTING BY). • The header cannot be simply skipped (IGNORE n LINES). It must be valid column names if present. 5.3.1.4 Strict

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE id fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE id fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough

5) -> None: connection = create_connection() txn_log_header = f"/* txn {thread_id} */" if thread_id != 1: txn_log_header = "\t" + txn_log_header with connection: with connection.cursor() as cursor: cursor: cursor.execute("BEGIN OPTIMISTIC") 568 print(f'{txn_log_header} BEGIN OPTIMISTIC') time.sleep(1) try: # read the price of book select_book_for_update = "SELECT `price`, `stock` FROM books �→ WHERE fetchone() if book is None: raise Exception("book_id not exist") price, stock = book print(f'{txn_log_header} {select_book_for_update} successful' �→ ) if stock < amount: raise Exception("book not enough