{"id":74657,"date":"2022-05-17T22:14:21","date_gmt":"2022-05-18T02:14:21","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/?p=74657"},"modified":"2022-05-17T22:14:23","modified_gmt":"2022-05-18T02:14:23","slug":"python-and-mysql-operations-code-examples","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=74657","title":{"rendered":"Python and MySQL Operations. Code Examples"},"content":{"rendered":"\n

#!\/usr\/bin\/env python# coding: utf-8
# In[1]:<\/p>\n\n\n\n

import mysql.connector<\/p>\n\n\n\n

# In[2]:<\/p>\n\n\n\n

# create a database connection<\/p>\n\n\n\n

# In[3]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””)
print(mydb)<\/p>\n\n\n\n

# In[4]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””)
mycursor = mydb.cursor()
mycursor.execute(“drop DATABASE mydatabase”);mycursor.execute(“CREATE DATABASE mydatabase”);<\/p>\n\n\n\n

# In[5]:<\/p>\n\n\n\n

# check if database exists<\/p>\n\n\n\n

# In[6]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””)
mycursor = mydb.cursor()
mycursor.execute(“SHOW DATABASES”)
for x in mycursor:  print(x)<\/p>\n\n\n\n

# In[7]:<\/p>\n\n\n\n

# connect to the database and see if you can connect<\/p>\n\n\n\n

# In[8]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””,  database=”mydatabase”)<\/p>\n\n\n\n

# In[9]:<\/p>\n\n\n\n

# Create table<\/p>\n\n\n\n

# In[10]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””,  database=”mydatabase”)
mycursor = mydb.cursor()
mycursor.execute(“CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))”)<\/p>\n\n\n\n

# In[11]:<\/p>\n\n\n\n

# Check if the Table Exists<\/p>\n\n\n\n

# In[12]:<\/p>\n\n\n\n

import mysql.connector
”’mydb = mysql.connector.connect(  host=”localhost”,  user=”yourusername”,  password=”yourpassword”,  database=”mydatabase”)”’
mycursor = mydb.cursor()
mycursor.execute(“SHOW TABLES”)
for x in mycursor:  print(x)<\/p>\n\n\n\n

# In[13]:<\/p>\n\n\n\n

# Create table with primary key<\/p>\n\n\n\n

# In[14]:<\/p>\n\n\n\n

mycursor.execute(“CREATE TABLE customers_p (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255))”)<\/p>\n\n\n\n

# In[15]:<\/p>\n\n\n\n

# Create primary key for an existing table<\/p>\n\n\n\n

# In[16]:<\/p>\n\n\n\n

mycursor.execute(“ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY”)<\/p>\n\n\n\n

# In[17]:<\/p>\n\n\n\n

# insert into tables<\/p>\n\n\n\n

# In[18]:<\/p>\n\n\n\n

sql = “INSERT INTO customers (name, address) VALUES (%s, %s)”val = (“John”, “Highway 21”)mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, “record inserted.”)<\/p>\n\n\n\n

# In[19]:<\/p>\n\n\n\n

# insert multiple rows<\/p>\n\n\n\n

# In[20]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “INSERT INTO customers (name, address) VALUES (%s, %s)”val = [  (‘Peter’, ‘Lowstreet 4’),  (‘Amy’, ‘Apple st 652’),  (‘Hannah’, ‘Mountain 21’),  (‘Michael’, ‘Valley 345’),  (‘Sandy’, ‘Ocean blvd 2’),  (‘Betty’, ‘Green Grass 1’),  (‘Richard’, ‘Sky st 331’),  (‘Susan’, ‘One way 98’),  (‘Vicky’, ‘Yellow Garden 2’),  (‘Ben’, ‘Park Lane 38’),  (‘William’, ‘Central st 954’),  (‘Chuck’, ‘Main Road 989’),  (‘Viola’, ‘Sideway 1633’)]
mycursor.executemany(sql, val)
mydb.commit()
print(mycursor.rowcount, “was inserted.”)<\/p>\n\n\n\n

# In[21]:<\/p>\n\n\n\n

# get the inserted row id<\/p>\n\n\n\n

# In[22]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “INSERT INTO customers (name, address) VALUES (%s, %s)”val = (“Michelle”, “Blue Village”)mycursor.execute(sql, val)
mydb.commit()
print(“1 record inserted, ID:”, mycursor.lastrowid);<\/p>\n\n\n\n

# In[23]:<\/p>\n\n\n\n

# Select Records<\/p>\n\n\n\n

# In[24]:<\/p>\n\n\n\n

import mysql.connector<\/p>\n\n\n\n

mycursor = mydb.cursor()
mycursor.execute(“SELECT * FROM customers”)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[25]:<\/p>\n\n\n\n

# select columns<\/p>\n\n\n\n

# In[26]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
mycursor.execute(“SELECT name, address FROM customers”)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[27]:<\/p>\n\n\n\n

#fetch only one row<\/p>\n\n\n\n

# In[28]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
mycursor.execute(“SELECT * FROM customers”)
myresult = mycursor.fetchone()
print(myresult)<\/p>\n\n\n\n

# In[29]:<\/p>\n\n\n\n

# use where condition<\/p>\n\n\n\n

# In[30]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””,  database=”mydatabase”)
mycursor = mydb.cursor()
sql = “SELECT * FROM customers WHERE address =’Park Lane 38′”
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[31]:<\/p>\n\n\n\n

# Prevent SQL Injection<\/p>\n\n\n\n

# In[32]:<\/p>\n\n\n\n

import mysql.connector
mydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””,  database=”mydatabase”)
mycursor = mydb.cursor()
sql = “SELECT * FROM customers WHERE address = %s”adr = (“Yellow Garden 2”, )
mycursor.execute(sql, adr)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[33]:<\/p>\n\n\n\n

# order by<\/p>\n\n\n\n

# In[34]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “SELECT * FROM customers ORDER BY name”
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[35]:<\/p>\n\n\n\n

# order by desc<\/p>\n\n\n\n

# In[36]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “SELECT * FROM customers ORDER BY name DESC”
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[37]:<\/p>\n\n\n\n

# Delete From By<\/p>\n\n\n\n

# In[38]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “DELETE FROM customers WHERE address = ‘Mountain 21′”
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, “record(s) deleted”)<\/p>\n\n\n\n

# In[39]:<\/p>\n\n\n\n

# delete with SQL Injection<\/p>\n\n\n\n

# In[40]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “DELETE FROM customers WHERE address = %s”adr = (“Yellow Garden 2”, )
mycursor.execute(sql, adr)
mydb.commit()
print(mycursor.rowcount, “record(s) deleted”)<\/p>\n\n\n\n

# In[41]:<\/p>\n\n\n\n

# drop tables<\/p>\n\n\n\n

# In[42]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “DROP TABLE customers”
mycursor.execute(sql)<\/p>\n\n\n\n

# In[43]:<\/p>\n\n\n\n

# drop table only if exists<\/p>\n\n\n\n

# In[44]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “DROP TABLE IF EXISTS customers”
mycursor.execute(sql)<\/p>\n\n\n\n

# In[45]:<\/p>\n\n\n\n

mycursor.execute(“CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255))”)<\/p>\n\n\n\n

# In[46]:<\/p>\n\n\n\n

#MySQL Update Table<\/p>\n\n\n\n

# In[47]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “UPDATE customers SET address = ‘Canyon 123’ WHERE address = ‘Valley 345′”
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, “record(s) affected”)<\/p>\n\n\n\n

# In[48]:<\/p>\n\n\n\n

# update with SQL Injection<\/p>\n\n\n\n

# In[49]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
sql = “UPDATE customers SET address = %s WHERE address = %s”val = (“Valley 345”, “Canyon 123”)
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, “record(s) affected”)<\/p>\n\n\n\n

# In[50]:<\/p>\n\n\n\n

# limit results<\/p>\n\n\n\n

# In[51]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
mycursor.execute(“SELECT * FROM customers LIMIT 5”)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[52]:<\/p>\n\n\n\n

# Limit from a different position<\/p>\n\n\n\n

# In[53]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
mycursor.execute(“SELECT * FROM customers LIMIT 5 OFFSET 2”)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[54]:<\/p>\n\n\n\n

# create table users<\/p>\n\n\n\n

# In[55]:<\/p>\n\n\n\n

mycursor = mydb.cursor()
mycursor.execute(“CREATE TABLE products (id varchar(100), name VARCHAR(255), address VARCHAR(255))”)<\/p>\n\n\n\n

# In[56]:<\/p>\n\n\n\n

mycursor = mydb.cursor()mycursor.execute(“CREATE TABLE users (id varchar(100), name VARCHAR(255), fav VARCHAR(255))”)<\/p>\n\n\n\n

# In[57]:<\/p>\n\n\n\n

# insert into users<\/p>\n\n\n\n

# In[58]:<\/p>\n\n\n\n

sql = “INSERT INTO users (id, name, fav) VALUES (%s, %s, %s)”val = [  (‘1’, ‘John’, ‘4’),  (‘2’, ‘Apple’, ’55’)      ]<\/p>\n\n\n\n

# In[59]:<\/p>\n\n\n\n

sql = “INSERT INTO products (id, name) VALUES (%s, %s)”val = [  (‘4’, ‘chocolate’),  (‘5’, ‘Milk’)    ]<\/p>\n\n\n\n

# In[60]:<\/p>\n\n\n\n

sql = “SELECT   users.name AS user,   products.name AS favorite   FROM users   INNER JOIN products ON users.fav = products.id”
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:  print(x)<\/p>\n\n\n\n

# In[ ]:<\/p>\n\n\n\n

<\/p>\n\n\n\n

Ref: W3Schools.<\/p>\n","protected":false},"excerpt":{"rendered":"

#!\/usr\/bin\/env python# coding: utf-8# In[1]: import mysql.connector # In[2]: # create a database connection # In[3]: import mysql.connectormydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””)print(mydb) # In[4]: import mysql.connectormydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””)mycursor = mydb.cursor()mycursor.execute(“drop DATABASE mydatabase”);mycursor.execute(“CREATE DATABASE mydatabase”); # In[5]: # check if database exists # In[6]: import mysql.connectormydb = mysql.connector.connect(  host=”localhost”,  user=”root”,  password=””)mycursor = … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1428],"tags":[],"class_list":["post-74657","post","type-post","status-publish","format-standard","hentry","category-python","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":74659,"url":"http:\/\/bangla.sitestree.com\/?p=74659","url_meta":{"origin":74657,"position":0},"title":"Python and MongoDB Operations. Code Example","author":"Sayed","date":"May 17, 2022","format":false,"excerpt":"#!\/usr\/bin\/env python# coding: utf-8# In[63]: import pymongo; # In[64]: import pymongomyclient = pymongo.MongoClient(\"mongodb:\/\/localhost:27017\/\")mydb = myclient[\"mydatabase\"] # In[65]: # Check if database exist # In[66]: print(myclient.list_database_names()) # In[67]: dblist = myclient.list_database_names()if \"mydatabase\" in dblist:\u00a0 print(\"The database exists.\") # In[68]: # Create a collection # In[69]: import pymongomyclient = pymongo.MongoClient(\"mongodb:\/\/localhost:27017\/\")mydb = myclient[\"mydatabase\"]mycol\u2026","rel":"","context":"In "Python"","block_context":{"text":"Python","link":"http:\/\/bangla.sitestree.com\/?cat=1428"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7003,"url":"http:\/\/bangla.sitestree.com\/?p=7003","url_meta":{"origin":74657,"position":1},"title":"MongoDB Java","author":"Author-Check- Article-or-Video","date":"March 16, 2015","format":false,"excerpt":"Done By Raju(DU) MongoDB Java Installation \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf\u0983 Java program \u098f MongoDB \u09ac\u09cd\u09af\u09be\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09be\u09b0 \u09aa\u09c2\u09b0\u09cd\u09ac\u09c7 \u0986\u09ae\u09be\u09a6\u09c7\u09b0\u0995\u09c7 \u09a8\u09bf\u09b6\u09cd\u099a\u09bf\u09a4 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7 \u09af\u09c7 MongoDB JDBC Driver \u098f\u09ac\u0982 Java \u0986\u09ae\u09be\u09a6\u09c7\u09b0 machine \u098f \u09aa\u09c2\u09b0\u09cd\u09ac\u09c7 \u09a5\u09c7\u0995\u09c7\u0987 \u09b0\u09df\u09c7\u099b\u09c7\u0964 \u0986\u09aa\u09a8\u09bf \u0986\u09b0\u0993 Java tutorial \u09a6\u09c7\u0996\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u09a8 \u0986\u09aa\u09a8\u09be\u09b0 machine \u098f Java installation \u0995\u09b0\u09be\u09b0 \u099c\u09a8\u09cd\u09af\u0964 \u098f\u0996\u09a8 \u09a6\u09c7\u0996\u09ac\u09c7 \u0995\u09bf\u09ad\u09be\u09ac\u09c7 MongoDB JDBC driver \u099f\u09bf\u2026","rel":"","context":"In "\u09ae\u0999\u09cd\u0997 \u09a1\u09bf \u09ac\u09bf \u0964 MongoDB"","block_context":{"text":"\u09ae\u0999\u09cd\u0997 \u09a1\u09bf \u09ac\u09bf \u0964 MongoDB","link":"http:\/\/bangla.sitestree.com\/?cat=222"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69091,"url":"http:\/\/bangla.sitestree.com\/?p=69091","url_meta":{"origin":74657,"position":2},"title":"MySql Administration SQL Commands #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Using MySQL, AdministrationWorkshop RequirementsYou should have access to the MySQL command line client software.Various different PRIVILEGES on the MySQL ServerIntroductionIn the other MySQL Virtual Workshops we have used commands that are pretty much applicable to anyone. This part of the MySQL series is aimed at giving a rudimentary understanding of\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9115,"url":"http:\/\/bangla.sitestree.com\/?p=9115","url_meta":{"origin":74657,"position":3},"title":"\u0985\u09cd\u09af\u09be\u09aa \u098f\u09ae \u098f\u09b2 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf (AppML PHP)","author":"Author-Check- Article-or-Video","date":"May 29, 2015","format":false,"excerpt":"\u09b0\u09bf\u09a6\u0993\u09df\u09be\u09a8 \u09ac\u09bf\u09a8 \u09b6\u09be\u09ae\u09c0\u09ae \u00a0 \u09af\u09a6\u09bf \u0995\u09cb\u09a8\u0993 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u09c7 \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6\u09af\u09cb\u0997\u09cd\u09af\u09a4\u09be \u09a5\u09be\u0995\u09c7 \u09a4\u09be\u09b9\u09b2\u09c7 \u09a4\u09be\u09b9\u09b2\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u09a8\u09bf\u09b0\u09cd\u09a6\u09c7\u09b6 \u09ae\u09cb\u09a4\u09be\u09ac\u09c7\u0995 \u0985\u09cd\u09af\u09be\u09aa \u098f\u09ae \u098f\u09b2 \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0 \u098f\u09aa\u09cd\u09b2\u09bf\u0995\u09c7\u09b6\u09a8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09b8\u09ae\u09cd\u09ad\u09ac \u09b9\u09ac\u09c7\u0964 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u09b8\u09c7 \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6\u09af\u09cb\u0997\u09cd\u09af\u09a4\u09be \u09a8\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u0993\u09df\u09c7\u09ac\u09ae\u09cd\u09af\u09be\u099f\u09cd\u09b0\u09bf\u0995\u09cd\u09b8\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u09aa\u09cd\u09b0\u09af\u09cb\u099c\u09cd\u09af \u0989\u09aa\u09a6\u09c7\u09b6 \u09a6\u09c7\u0996\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u00a0 \u099f\u09c7\u09b8\u09cd\u099f \u09aa\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u099f\u09c7\u09b8\u09cd\u099f \u09aa\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7 customers.htm \u09b0\u09c2\u09aa\u09c7 (\u09ac\u09be \u0985\u09a8\u09cd\u09af\u0995\u09cb\u09a8\u0993 \u09b0\u09c2\u09aa\u09c7) \u09aa\u09bf\u098f\u0987\u09aa\u09bf\u2026","rel":"","context":"In "AppML : Application Modeling Language"","block_context":{"text":"AppML : Application Modeling Language","link":"http:\/\/bangla.sitestree.com\/?cat=796"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9118,"url":"http:\/\/bangla.sitestree.com\/?p=9118","url_meta":{"origin":74657,"position":4},"title":"\u0985\u09cd\u09af\u09be\u09aa \u098f\u09ae \u098f\u09b2 \u09a1\u099f \u09a8\u09c7\u099f (AppML .NET)","author":"Author-Check- Article-or-Video","date":"May 29, 2015","format":false,"excerpt":"\u09b0\u09bf\u09a6\u0993\u09df\u09be\u09a8 \u09ac\u09bf\u09a8 \u09b6\u09be\u09ae\u09c0\u09ae \u00a0 \u09a1\u099f \u09a8\u09c7\u099f \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6\u09af\u09cb\u0997\u09cd\u09af\u09a4\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u09a8\u09bf\u099a\u09c7\u09b0 \u09aa\u09cd\u09b0\u0995\u09cd\u09b0\u09bf\u09df\u09be\u09df \u0985\u09cd\u09af\u09be\u09aa \u098f\u09ae \u098f\u09b2 \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0 \u098f\u09aa\u09cd\u09b2\u09bf\u0995\u09c7\u09b6\u09a8 \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09af\u09be\u09ac\u09c7, \u09aa\u09cd\u09b0\u09ac\u09c7\u09b6\u09af\u09cb\u0997\u09cd\u09af\u09a4\u09be \u09a8\u09be \u09a5\u09be\u0995\u09b2\u09c7 \u0993\u09df\u09c7\u09ac\u09ae\u09cd\u09af\u09be\u099f\u09cd\u09b0\u09bf\u0995\u09cd\u09b8\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u09aa\u09cd\u09b0\u09af\u09cb\u099c\u09cd\u09af \u09aa\u09cd\u09b0\u0995\u09cd\u09b0\u09bf\u09df\u09be \u0985\u09a8\u09c1\u09b8\u09b0\u09a3 \u0995\u09b0\u09a4\u09c7 \u09b9\u09ac\u09c7\u0964 \u00a0 \u099f\u09c7\u09b8\u09cd\u099f \u09aa\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be \u09aa\u09cd\u09b0\u09a5\u09ae\u09c7 \u099f\u09c7\u09b8\u09cd\u099f \u09aa\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09c7 \u09b8\u09c7\u099f\u09bf\u0995\u09c7 \u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf \u09b8\u09be\u09b0\u09cd\u09ad\u09be\u09b0\u09c7 customers.htm \u09a8\u09be\u09ae \u09a6\u09bf\u09df\u09c7(\u09ac\u09be \u0985\u09a8\u09cd\u09af \u0995\u09cb\u09a8\u0993 \u09a8\u09be\u09ae\u0993 \u099a\u09b2\u09ac\u09c7) \u09b8\u0982\u09b0\u0995\u09cd\u09b7\u09a3\u2026","rel":"","context":"In "AppML : Application Modeling Language"","block_context":{"text":"AppML : Application Modeling Language","link":"http:\/\/bangla.sitestree.com\/?cat=796"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6085,"url":"http:\/\/bangla.sitestree.com\/?p=6085","url_meta":{"origin":74657,"position":5},"title":"\u09aa\u09bf\u098f\u0987\u099a\u09aa\u09bf : \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be (PHP Create a MySQL Database)","author":"Author-Check- Article-or-Video","date":"February 24, 2015","format":false,"excerpt":"Sheikh Mahfuzur Rahman \u00a0 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u098f\u0995 \u09ac\u09be \u09a4\u09be\u09b0\u0993 \u09ac\u09c7\u09b6\u09bf \u099f\u09c7\u09ac\u09b2 \u09a8\u09bf\u09df\u09c7 \u0997\u09a0\u09bf\u09a4\u0964 \u0995\u09cb\u09a8 MySQL \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u09ac\u09be \u09ae\u09c1\u0981\u099b\u09c7 \u09a6\u09bf\u09a4\u09c7 \u099a\u09be\u0987\u09b2\u09c7 \u0986\u09aa\u09a8\u09be\u09b0 \u09ac\u09bf\u09b6\u09c7\u09b7 \u09a7\u09b0\u09a3\u09c7\u09b0 \u0986\u0987\u09a8\u0997\u09a4 \u0985\u09a7\u09bf\u0995\u09be\u09b0 \u09b2\u09be\u0997\u09ac\u09c7 \u09af\u09be CREATE \u09a8\u09be\u09ae\u09c7 \u09aa\u09b0\u09bf\u099a\u09bf\u09a4\u0964 MySQLi \u098f\u09ac\u0982 PDO \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09c7 \u098f\u0995\u099f\u09bf \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09be CREATE DATABASE \u09b8\u09cd\u099f\u09c7\u099f\u09ae\u09c7\u09a8\u09cd\u099f \u09ae\u09be\u0987\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2-\u098f \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09a4\u09c8\u09b0\u09bf \u0995\u09b0\u09a4\u09c7 \u09ac\u09cd\u09af\u09ac\u09b9\u09c3\u09a4\u2026","rel":"","context":"In "\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial"","block_context":{"text":"\u09aa\u09bf \u098f\u0987\u099a \u09aa\u09bf \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 \u0964 PHP tutorial","link":"http:\/\/bangla.sitestree.com\/?cat=172"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/74657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=74657"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/74657\/revisions"}],"predecessor-version":[{"id":74658,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/74657\/revisions\/74658"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=74657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=74657"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=74657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}