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)
Success #stdin #stdout 0.03s 25908KB
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)
https://ideone.com/VaHj1f
language:
PHP (php 7.3.5)
created:
6 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!