Computer scienceProgramming languagesPythonPython libraries

Working with SQLite

Insert Data

Report a typo

Let's put into practice what we have learned about inserting data safely. Below you have the structure of the Customers table:

CustomerID	CustomerName	Address	City	PostalCode	Country
1	Gerhard Häring	Rosenweg 20	Berlin	97215	Germany

Select all valid ways to insert the customer Naomi Ceder, with the address of 1220 Fifth Ave from the New York city, the postal code of 10002, and the country of United States.

Select one or more options from the list

customer = (2, 'Naomi Ceder', '1220 Fifth Ave', 'New York', 10002, 'United States') cursor.execute('INSERT INTO Customers VALUES (?)', customer)

cursor.execute("INSERT INTO Customers (CustomerName, Address, City, PostalCode, Country) VALUES ('Naomi Ceder', '1220 Fifth Ave', 'New York', 10002, 'United States');")

customer = (2, 'Naomi Ceder', '1220 Fifth Ave', 'New York', 10002, 'United States') cursor.execute('INSERT INTO Customers VALUES (?, ?, ?, ?, ?, ?)', customer)

cursor.execute("INSERT INTO Customers VALUES ('Naomi Ceder', '1220 Fifth Ave');")

___

Create a free account to access the full topic