fork download
copy 
  1. import mysql.connector
  2. mycon = mysql.connector.connect(
  3.      host='localhost',
  4.      user='root', 
  5.      password='password',
  6.      database='School')
  7. if mycon.is_connected():
  8.    print('Database connected')
  9. cursor = mycon.cursor()
  10. sql ="SELECT * FROM STUDENT WHERE Stream='Medical'"
  11. cursor.execute(sql)
  12. records = cursor.fetchall()
  13. print("Answer is:")
  14. for rec in records:
  15. print(rec)
  16. mycon.close()
Success #stdin #stdout 0.02s 25952KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
import mysql.connector
mycon = mysql.connector.connect(
     host='localhost',
     user='root', 
     password='password',
     database='School')
if mycon.is_connected():
   print('Database connected')
cursor = mycon.cursor()
sql ="SELECT * FROM STUDENT WHERE Stream='Medical'"
cursor.execute(sql)
records = cursor.fetchall()
print("Answer is:")
for rec in records:
print(rec)
mycon.close()
https://ideone.com/zOondt
language:
PHP (php 7.3.5)
created:
12 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!