Python_prac/p23.py at master · Ravin199822/Python_prac · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
import mysql.connector


# Type Status in MySQL command line client   -----> we will get information about mySQL


# # Create connection
# conn=mysql.connector.connect(host='localhost', username='root', password='java')
# print(conn)                                                                        # o/p: <mysql.connector.connection.MySQLConnection object at 0x00F4C880>


# # my_cursor=conn.cursor()
# # query="CREATE DATABASE p_database"
# # my_cursor.execute(query)
# # conn.commit()
# # conn.close()


# my_cursor=conn.cursor()                                 # o/p: ('employees',)
# query="SHOW DATABASES"                                  #      ('information_schema',)
# my_cursor.execute(query)                                #      ('mysql',)
#                                                         #      ('new_database',)
# for database_name in my_cursor:                         #      ('p_database',)
#     print(database_name)                                #      ('performance_schema',)
# conn.commit()                                           #      ('sakila',)
# conn.close()                                            #      ('sales',)
#                                                         #      ('sys',)
#                                                         #      ('world',)

# # This gives me tuple


# # To get output in list

# my_cursor=conn.cursor()
# query="SHOW DATABASES"
# my_cursor.execute(query)
# print(my_cursor.fetchall())                    # o/p: [('employees',), ('information_schema',), ('mysql',), ('new_database',), ('p_database',), ('performance_schema',), ('sakila',), ('sales',), ('sys',), ('world',)]
# conn.commit()
# conn.close()


# # If i want to use created database
# conn=mysql.connector.connect(host='localhost', username='root', password='java', database='p_database')
# my_cursor=conn.cursor()
# my_cursor.execute("CREATE TABLE student(name VARCHAR(255), age INT)")
# conn.commit()
# conn.close()


# conn=mysql.connector.connect(host='localhost', username='root', password='java', database='p_database')
# my_cursor=conn.cursor()
# query="INSERT INTO student(name, age) VALUES(%s,%s)"                   # in MYSQL---> %s   and in SQLITE---->?
# values=[
#     ('Ravin',22),
#     ('Rupen',29),
#     ('Renish',28),
#     ('Rockey',27),
#     ('Rock',26),
#     ('Rensom',25),
#     ('Ram',24),
#     ('Ronny',23)]

# # my_cursor.execute(query, values)           # only for one value

# my_cursor.executemany(query, values)         # for many values
# conn.commit()
# conn.close()


# conn=mysql.connector.connect(host='localhost', username='root', password='java', database='p_database')
# my_cursor=conn.cursor()
# query="select * from student"
# my_cursor.execute(query)
# for columns in my_cursor:
#     print(columns)
# conn.commit()
# conn.close()


# # o/p: ('Ravin', 22)
# #      ('Ravin', 22)
# #      ('Rupen', 29)
# #      ('Renish', 28)
# #      ('Rockey', 27)
# #      ('Rock', 26)
# #      ('Rensom', 25)
# #      ('Ram', 24)
# #      ('Ronny', 23)


conn=mysql.connector.connect(host='localhost', username='root', password='java', database='p_database')
my_cursor=conn.cursor()
query="select * from student"
my_cursor.execute(query)
print(my_cursor.fetchall())     # o/p: [('Ravin', 22), ('Ravin', 22), ('Rupen', 29), ('Renish', 28), ('Rockey', 27), ('Rock', 26), ('Rensom', 25), ('Ram', 24), ('Ronny', 23)]
conn.commit()
conn.close()