Programming
C
C++
Java
Python
Web Technology
JavaScript
PHP
HTML
CSS
Database
SQL
ORACLE
DWH
Practice
Html
Css
Php
JavaScript
Example
C
C++
Python
Java
JavaScript
PHP
HTML
CSS
SQL
Interview Que
C
C++
Python
Java
JavaScript
PHP
HTML
CSS
SQL
More
About Me
Contact Us
☰
HOME
USER CORNER
CONTACT | HELP
ABOUT AIMTOCODE
PYTHON OVERVIEW
PYTHON HISTORY
PYTHON FEATURES
PYTHON VARIABLES
PYTHON KEYWORDS
PYTHON LITERALS
PYTHON COMMENTS
PYTHON OOPs
OBJECT
CLASS
CONSTRUCTORS
INHERITANCE
POLYMORPHISM
DATA ABSTRACTION
ENCAPSULATION
PYTHON DATA TYPE
NUMBER DATA TYPE
STRING DATA TYPE
LIST DATA TYPE
TUPLE DATA TYPE
DICTIONARY DATA TYPE
PYTHON OPERATOR
ARITHMETIC OPERATORS
COMPATISON OPERATORS
ASSIGNMENT OPERATORS
LOGICAL OPERATORS
BITWISE OPERATORS
MEMBERSHIP OPERATORS
IDENTITY OPERATORS
CONDITIONAL STATEMENT
IF STATEMENT
IF-ELSE STATEMENT
ELIF STATEMENT
NESTED-IF STATEMENT
PYTHON LOOPS
FOR LOOP
WHILE LOOP
DO-WHILE LOOP
PYTHON STRINGS
STRING INDEXING & SPLITING
STRING OPERATORS
STRING METHODS
PYTHON TUPLE
TUPLE INTRODUCTION
BUILT-IN FUNCTIONS
PYTHON SET
CREATING SET
ADDING ITEMS TO SET
REMOVING ITEMS FROM SET
SET INTERSECTION
SET UNION
FROZEN SETS
BUILT-IN METHODS
BUILT-IN FUNCTION
PYTHON DICTIONARY
CREATING DICTIONARY
ACCESSING VALUES
DELETING ELEMENTS
BUILT-IN FUNCTIONS
BUIL-IN METHODS
PYTHON FUNCTIONS
CREATING A FUNCTION
FUNCTION CALLING
PARAMETERS IN FUNCTION
PYTHON ARGUMENTS
REQUIRED ARGUMENT
KEYWORD ARGUMENT
DEFAULT ARGUMENT
VARIABLE-LENTH ARGUMENT
PYTHON FILES I/O
PYTHON DATE & TIME
PYTHON MATH MODULE
PYTHON OS MODULE
PYTHON ADVANCE
PYTHON EXCEPTIONS
PYTHON REG EXPRESSION
PYTHON SEND EMAILS
PYTHON MULTITHREADING
PYTHON MySQL
DB CONNECTION
CREATE DATABASE
CREATE TABLE
INSERT OPERATION
UPDATE OPERATION
DELETE OPERATION
PYTHON GUI
BUTTONS
CANVAS
CHECK BUTTON
COMBO BOX
ENTRY
FRAME
LABEL
LABEL FRAME
LIST BOX
MENU
MESSAGE
tk_optionMenu
PANED WINDOW
RADIO BUTTON
SCROLL BAR
SPIN BOX
TEXT
TREEVIEW
Python MySQL Create Table
Create Table
Steps for creating MySQL tables in Python
To create a table in MySQL, use the "CREATE TABLE" statement.
Make sure you have defined the name of the database while you create the connection.
Syntax:
CREATE TABLE student (id INT, name VARCHAR(255))
Example:
Creating Table using Primary Key
Example: