Das deutsche Python-Forum

Code: Alles auswählen

import mysql.connector

try:
    conn = mysql.connector.connect\
        (host='localhost',
        database='newbase',
        user='root',
        password='Nevada80#')

#Creating a cursor object using the cursor() method
cursor = conn.cursor()       ################ Zeile 11, Ursache für den Syntaxfehler  #########

#Dropping EMPLOYEE table if already exists.
cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")

#Creating table as per requirement
sql ='''CREATE TABLE EMPLOYEE(
   FIRST_NAME CHAR(20) NOT NULL,
   LAST_NAME CHAR(20),
   AGE INT,
   SEX CHAR(1),
   INCOME FLOAT
)'''
cursor.execute(sql)

#Closing the connection
conn.close()

Code: Alles auswählen

import mysql.connector as connector

try:
    connection = connector.connect(
    		host='localhost',
        	database='newbase',
        	user='root',
        	password='Wuerdeichnichtoeffentlichmachen!'
        	)

    cursor = connection.cursor(buffered=True)
    cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")

    sql ='''CREATE TABLE EMPLOYEE(
   		FIRST_NAME CHAR(20) NOT NULL,
   		LAST_NAME CHAR(20),
   		AGE INT,
   		SEX CHAR(1),
   		INCOME FLOAT
		)'''
    cursor.execute(sql)
    connection.close()
except:
    print('Hier stimmt was nicht')

Code: Alles auswählen

>>> try:
	text = "Hallo"
except:
	pass

>>> text
'Hallo'