Kuanzisha tabia kwa Python

Kuanzisha tabia

Kwenye kuanzisha tabia kwenye MySQL, tumekuwa na uigizo "CREATE TABLE".

Umbaliwe kwamba unafasiri jina la vifungu kwenye kuanzisha kina.

Mfano

Kuanzisha tabia "customers":

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))")

Mfano wa Kufanya

Ikiwa kinaingia kwa kusikitisha kwa mtaani hii, tunapofikia kwamba umekuwa mwenye tabia yako.

Kukagua ukili tabia

Unaweza kutumia uigizo "SHOW TABLES" kushahariri tabia zote za vifungu, kwa kubadilika ukili tabia:

Mfano

Inaonyesha orodha ya vifungu vya mifungu ya mifumo:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("SHOW TABLES")
for x in mycursor:
  print(x)

Mfano wa Kufanya

Mwili wa kina

Kwenye kuanzisha tabia, unapaswa kumaliza kila rekodi kwa kumuea koma kinachotaka.

Hiiweza kufikia hii kwa kufasiri PRIMARY KEY.

Tunatumia kipindi cha "INT AUTO_INCREMENT PRIMARY KEY", hii inakamilisha kipimo cha kina kwa kila mazungumzo. Kuanza kutoka 1, kila mazungumzo huzingatia 1.

Mfano

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, 
name VARCHAR(255), address VARCHAR(255))")

Mfano wa Kufanya

Ikiwa taabu ikianza, tumekuwa na uwanja wa ALTER TABLE kifungu cha taabu:

Mfano

Kuzia Kipimo cha Kina kutoka Kwa Taabu ya Ilizolewa:

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
mycursor.execute("ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY")

Mfano wa Kufanya