Bagian tutorial Python MySQL ini menunjukkan cara menggunakan MySQL Connector/Python untuk mengakses database MySQL
Di bagian ini, Anda akan mempelajari cara terhubung ke database MySQL dan melakukan operasi database umum seperti SELECT, INSERT, UPDATE dan DELETE dengan Python
Selain itu, Anda akan mempelajari beberapa teknik berguna seperti cara memanggil prosedur tersimpan MySQL dari Python, dan cara bekerja dengan data MySQL BLOB
Perhatikan bahwa semua tutorial di bagian ini menggunakan Python 3
Jika Anda ingin mempelajari pemrograman Python atau menyegarkan kembali pengetahuan Python Anda dengan cepat, Anda dapat melihat tutorial Python
Python MySQL Connector adalah driver Python yang membantu mengintegrasikan Python dan MySQL. Pustaka Python MySQL ini memungkinkan konversi antara tipe data Python dan MySQL. API Konektor MySQL diimplementasikan menggunakan Python murni dan tidak memerlukan perpustakaan pihak ketiga.
Tutorial Python MySQL ini akan membantu mempelajari cara menggunakan MySQL dengan Python dari dasar hingga mahir, termasuk semua fungsi dan kueri yang diperlukan yang dijelaskan secara mendetail dengan bantuan contoh Python MySQL yang bagus. Jadi, mari kita mulai
Instalasi
Untuk menginstal modul konektor Python-mysql, seseorang harus memiliki Python dan PIP, yang sudah diinstal sebelumnya di sistem mereka. Jika Python dan pip sudah terpasang ketik perintah di bawah ini di terminal
pip3 install mysql-connector-pythonCatatan. Jika Python tidak ada, buka Bagaimana cara menginstal Python di Windows dan Linux?
Menghubungkan ke Server MySQL
Kita dapat terhubung ke server MySQL menggunakan metode connect().
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3
INSERT INTO table_name (column_names) VALUES (data)_4
INSERT INTO table_name (column_names) VALUES (data)5 INSERT INTO table_name (column_names) VALUES (data)6
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)_8
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Catatan. Untuk informasi selengkapnya, lihat Menghubungkan database MySQL menggunakan MySQL-Connector Python
Membuat Basis Data
Setelah terhubung ke server MySQL mari kita lihat cara membuat database MySQL menggunakan Python. Untuk ini, pertama-tama kita akan membuat objek kursor() dan kemudian akan meneruskan perintah SQL sebagai string ke metode eksekusi(). Perintah SQL untuk membuat database adalah –
CREATE DATABASE DATABASE_NAME_Contoh. Membuat database MySQL dengan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)6
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)7('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)8 INSERT INTO table_name (column_names) VALUES (data)4
Keluaran
Membuat Tabel
Untuk membuat tabel kita akan mengikuti pendekatan yang sama yaitu menulis perintah SQL sebagai string dan kemudian meneruskannya ke metode execution() dari objek kursor. Perintah SQL untuk membuat tabel adalah –
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_Contoh. Membuat tabel MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME_02
CREATE DATABASE DATABASE_NAME_03CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME05
CREATE DATABASE DATABASE_NAME_06CREATE DATABASE DATABASE_NAME07
CREATE DATABASE DATABASE_NAME_06CREATE DATABASE DATABASE_NAME09
CREATE DATABASE DATABASE_NAME_06CREATE DATABASE DATABASE_NAME11
CREATE DATABASE DATABASE_NAME_06CREATE DATABASE DATABASE_NAME13
CREATE DATABASE DATABASE_NAME_06CREATE DATABASE DATABASE_NAME15
CREATE DATABASE DATABASE_NAME_06CREATE DATABASE DATABASE_NAME17
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME_19
CREATE DATABASE DATABASE_NAME_20
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Masukkan Data ke dalam Tabel
Untuk memasukkan data ke dalam tabel MySQL Insert into query digunakan.
Sintaksis
INSERT INTO table_name (column_names) VALUES (data)Contoh 1. Menyisipkan Baris Tunggal
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME56CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME58
CREATE DATABASE DATABASE_NAME59CREATE DATABASE DATABASE_NAME60CREATE DATABASE DATABASE_NAME61________1______60________1______61CREATE DATABASE DATABASE_NAME60CREATE DATABASE DATABASE_NAME61CREATE DATABASE DATABASE_NAME60CREATE DATABASE DATABASE_NAME61________1______60________1______69
CREATE DATABASE DATABASE_NAME70CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME72CREATE DATABASE DATABASE_NAME73CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE DATABASE DATABASE_NAME75________8______4CREATE DATABASE DATABASE_NAME77CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE DATABASE DATABASE_NAME79________8______4CREATE DATABASE DATABASE_NAME1_______4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
CREATE DATABASE DATABASE_NAME_84
CREATE DATABASE DATABASE_NAME_85
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Contoh 2. Menyisipkan Beberapa Baris
Untuk menyisipkan beberapa nilai sekaligus, metode executionmany() digunakan. Metode ini mengulang melalui urutan parameter, meneruskan parameter saat ini ke metode eksekusi
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME56CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME58
CREATE DATABASE DATABASE_NAME59CREATE DATABASE DATABASE_NAME60CREATE DATABASE DATABASE_NAME61________1______60________1______61CREATE DATABASE DATABASE_NAME60CREATE DATABASE DATABASE_NAME61CREATE DATABASE DATABASE_NAME60CREATE DATABASE DATABASE_NAME61________1______60________1______69
CREATE DATABASE DATABASE_NAME70CREATE DATABASE DATABASE_NAME8 CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );37CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );38CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE DATABASE DATABASE_NAME75________8______4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );42CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );44________8______4____4____8_______8_______4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );48CREATE DATABASE DATABASE_NAME72CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );50________8______4CREATE DATABASE DATABASE_NAME75CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );54CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );44CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );46____4____8________7
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );48CREATE DATABASE DATABASE_NAME72CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );62________8______4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );64CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );66CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE DATABASE DATABASE_NAME79CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );70____4____8________7
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );48CREATE DATABASE DATABASE_NAME72CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );74________8______4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );76CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );78CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );44CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );82____4____8________7
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );48CREATE DATABASE DATABASE_NAME72CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );86________8______4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );64CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );90CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE DATABASE DATABASE_NAME79CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );70____4____8________7
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );48CREATE DATABASE DATABASE_NAME72CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );98________8______4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );76CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4 INSERT INTO table_name (column_names) VALUES (data)02CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );44CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4 INSERT INTO table_name (column_names) VALUES (data)06________7_____4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );48CREATE DATABASE DATABASE_NAME72 INSERT INTO table_name (column_names) VALUES (data)10CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE DATABASE DATABASE_NAME75CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4 INSERT INTO table_name (column_names) VALUES (data)14CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );44CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4________1______81________19____19_____
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)_21
CREATE DATABASE DATABASE_NAME_85
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Mengambil Data
Kita dapat menggunakan kueri pemilihan pada tabel MySQL dengan cara berikut –
- Untuk memilih kolom atribut tertentu dari tabel, kami menulis nama atribut
- Untuk memilih semua kolom atribut dari tabel, kami menggunakan simbol bintang '*'
Contoh. Pilih data dari tabel MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)58CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)60
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)63CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)65
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)67 INSERT INTO table_name (column_names) VALUES (data)68 INSERT INTO table_name (column_names) VALUES (data)69 INSERT INTO table_name (column_names) VALUES (data)70
INSERT INTO table_name (column_names) VALUES (data)_71 INSERT INTO table_name (column_names) VALUES (data)5 INSERT INTO table_name (column_names) VALUES (data)73
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Dimana Klausa
Di mana klausa digunakan dalam database MySQL untuk memfilter data sesuai kondisi yang diperlukan. Anda dapat mengambil, menghapus, atau memperbarui kumpulan data tertentu di database MySQL dengan menggunakan klausa where
Sintaksis
PILIH kolom1, kolom2, …. kolom DARI [NAMA TABEL] DI MANA [KETENTUAN];
Contoh. Dimana klausa di MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)_58CREATE DATABASE DATABASE_NAME8 SELECT attr1, attr2 FROM table_name10
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)63CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)65
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)67 INSERT INTO table_name (column_names) VALUES (data)68 INSERT INTO table_name (column_names) VALUES (data)69 INSERT INTO table_name (column_names) VALUES (data)70
INSERT INTO table_name (column_names) VALUES (data)_71 INSERT INTO table_name (column_names) VALUES (data)5 INSERT INTO table_name (column_names) VALUES (data)73
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)Pesan Berdasarkan Klausul
OrderBy digunakan untuk mengatur hasil yang ditetapkan dalam urutan menaik atau menurun. Secara default, itu selalu dalam urutan menaik kecuali "DESC" disebutkan, yang mengaturnya dalam urutan menurun. "ASC" juga dapat digunakan untuk mengaturnya secara eksplisit dalam urutan menaik. Tapi, umumnya tidak dilakukan dengan cara ini karena default sudah melakukan itu
Sintaksis
SELECT column1, column2 FROM table_name ORDER BY column_name ASC|DESC;Contoh. Klausa Order By di MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)58CREATE DATABASE DATABASE_NAME8 SELECT attr1, attr2 FROM table_name60
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)63CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)65
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)67 INSERT INTO table_name (column_names) VALUES (data)68 INSERT INTO table_name (column_names) VALUES (data)69 INSERT INTO table_name (column_names) VALUES (data)70
INSERT INTO table_name (column_names) VALUES (data)_71 INSERT INTO table_name (column_names) VALUES (data)5 INSERT INTO table_name (column_names) VALUES (data)73
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Klausul Batas
Klausa Limit digunakan dalam SQL untuk mengontrol atau membatasi jumlah rekaman dalam rangkaian hasil yang dikembalikan dari kueri yang dibuat. Secara default, SQL memberikan jumlah record yang diperlukan mulai dari atas tetapi memungkinkan penggunaan kata kunci OFFSET. OFFSET memungkinkan Anda memulai dari baris khusus dan mendapatkan jumlah baris hasil yang diperlukan
Sintaksis
SELECT * FROM tablename LIMIT limit; SELECT * FROM tablename LIMIT limit OFFSET offset;Contoh. Limit Clause di MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)58CREATE DATABASE DATABASE_NAME8 SELECT * FROM table_name10
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)63CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)65
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );_0
INSERT INTO table_name (column_names) VALUES (data)67 INSERT INTO table_name (column_names) VALUES (data)68 INSERT INTO table_name (column_names) VALUES (data)69 INSERT INTO table_name (column_names) VALUES (data)70
INSERT INTO table_name (column_names) VALUES (data)_71 INSERT INTO table_name (column_names) VALUES (data)5 INSERT INTO table_name (column_names) VALUES (data)73
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)Perbaharui data
Kueri pembaruan digunakan untuk mengubah nilai yang ada dalam database. Dengan menggunakan pembaruan nilai tertentu dapat diperbaiki atau diperbarui. Ini hanya memengaruhi data dan bukan struktur tabel. Keuntungan dasar yang diberikan oleh perintah ini adalah membuat tabel tetap akurat
Sintaksis
CREATE DATABASE DATABASE_NAME_0Contoh. Perbarui tabel MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)58CREATE DATABASE DATABASE_NAME8 SELECT * FROM table_name60
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE DATABASE DATABASE_NAME_85
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Hapus Data dari Tabel
Kita dapat menggunakan kueri Hapus untuk menghapus data dari tabel di MySQL
Sintaksis
CREATE DATABASE DATABASE_NAME_1Contoh. Hapus Data dari tabel MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)_58CREATE DATABASE DATABASE_NAME8 SELECT * FROM table_name99
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE DATABASE DATABASE_NAME_85
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Jatuhkan Tabel
Perintah jatuhkan memengaruhi struktur tabel dan bukan data. Ini digunakan untuk menghapus tabel yang sudah ada. Untuk kasus di mana Anda tidak yakin apakah tabel yang akan dihapus ada atau tidak, perintah DROP TABLE IF EXISTS digunakan. Kedua kasus akan dibahas dalam contoh berikut
Sintaksis
CREATE DATABASE DATABASE_NAME_2Pertama-tama, mari kita lihat daftar tabel di database kita
Kita dapat melihat bahwa ada dua meja untuk siswa, jadi mari kita tinggalkan meja kedua
Contoh 1. Drop Table di MySQL menggunakan Python
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)58CREATE DATABASE DATABASE_NAME8('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)38
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE DATABASE DATABASE_NAME_85
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Keluaran
Contoh 2. Jatuhkan Tabel jika ada
Python3
CREATE DATABASE DATABASE_NAME_3
CREATE DATABASE DATABASE_NAME4 CREATE DATABASE DATABASE_NAME5
CREATE DATABASE DATABASE_NAME_6
CREATE DATABASE DATABASE_NAME7CREATE DATABASE DATABASE_NAME8 CREATE DATABASE DATABASE_NAME9
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );1CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );6CREATE DATABASE DATABASE_NAME8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );8CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0 INSERT INTO table_name (column_names) VALUES (data)1CREATE DATABASE DATABASE_NAME8 INSERT INTO table_name (column_names) VALUES (data)3CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );4
CREATE TABLE ( column_name_1 column_Data_type, column_name_2 column_Data_type, : : column_name_n column_Data_type );0('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)3CREATE DATABASE DATABASE_NAME8 ('Nikhil', 'CSE', 98, 'A', 18) ('Nisha', 'CSE', 99, 'A', 18)5
INSERT INTO table_name (column_names) VALUES (data)_4
('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)2
________51______3CREATE DATABASE DATABASE_NAME8 ('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)5
CREATE DATABASE DATABASE_NAME_6
INSERT INTO table_name (column_names) VALUES (data)_58CREATE DATABASE DATABASE_NAME8('Rohan', 'MAE', 43, 'B', 20) ('Amit', 'ECE', 24, 'A', 21) ('Anil', 'MAE', 45, 'B', 20) ('Megha', 'ECE', 55, 'A', 22)77
INSERT INTO table_name (column_names) VALUES (data)_61
CREATE DATABASE DATABASE_NAME_85
CREATE DATABASE DATABASE_NAME_22
INSERT INTO table_name (column_names) VALUES (data)_9
Contoh di atas, tidak akan membuat error dan output apapun karena kita telah menggunakan query Drop Table is existing. Jika kita hanya akan menggunakan tabel Drop Employee lalu ProgrammingError. 1051 (42S02). Tabel tidak diketahui 'gfg. Karyawan 'dibesarkan