Python MySQL Drop Table







googletag.cmd.push(function() { googletag.display('div-gpt-ad-1422003450156-2'); });



Python MySQL Drop Table



❮ Previous
Next ❯


Delete a Table


You can delete an existing table by using
the "DROP TABLE" statement:




Example


Delete the table "customers":



import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
 
user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)

mycursor =
mydb.cursor()

sql = "DROP TABLE customers"

mycursor.execute(sql)

Run example »




Drop Only if Exist



If the the table you want to delete is already deleted, or for any other
reason does not exist, you can use the IF EXISTS keyword to avoid getting an
error.





Example


Delete the table "customers" if it exists:



import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
 
user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)

mycursor =
mydb.cursor()

sql = "DROP TABLE IF EXISTS customers"

mycursor.execute(sql)

Run example »




❮ Previous
Next ❯

-

Popular posts from this blog

Python Lists

<!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> Python Lists ❮ Previous Next ❯ Python Collections (Arrays) There are four collection data types in the Python programming language: List is a collection which is ordered and changeable. Allows duplicate members. Tuple is a collection which is ordered and unchangeable. Allows duplicate members. Set is a collection which is unordered and unindexed. No duplicate members. Dictionary is a collection which is unordered, changeable and indexed. No duplicate members. When choosing a collection type, it is useful to understand the properties of that type. Choosing the right type for a particular data set could mean retention of meaning, and, it could mean an increase in efficiency or security. List A list is a collection which is ordered and changeable. In Python lists are written with square brackets. Example Create a List: thislist = ["apple", "banana", ...
Read more

Aion

Image
Aion - 6+ , 5417 Aion - . MMORPG, World of Warcraft, World of Tanks My Lineage II . CryEngine. , . : Aion https://ru.4game.com/aion/ Aion , . , , . , , . , , , . . , , , . . : . , . , , . , , . 12 , 2 : ( ). ( ). ( ). ( ) ( ). ( ). , . , : . . , . , , . . , , . Aion, , . , . , . : . . . . , : , , , , , . , , , . : Aion https://ru.4game.com/aion/install/ : . , . , . , Aion . , . . , . , . , , . . : . . . , ( !), MMORPG Aion . , . ...
Read more

JavaScript Array Iteration Methods

<!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> JavaScript Array Iteration Methods ❮ Previous Next ❯ Array iteration methods operate on every array item. Array.forEach() The forEach() method Calls a function once for each array element. Example var txt = ""; var numbers = [4, 9, 16, 25]; numbers.forEach(myFunction); function myFunction(value, index, array) {     txt = txt + item + "<br>"; } Try it Yourself » Note that the function takes 3 arguments: The item value The item index The array itself Array.forEach() is not supported in Internet Explorer 8 or earlier: Method forEach() Yes 9.0 Yes Yes Yes Array.map() The map() method creates a new array by performing a function on each array element. This example multiplies each array value by 2: Example var numbers1 = [4, 9, 16, 25]; var numbers2 = numbers1.map(myFunction); function m...
Read more