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 Stream, COUNT(*) FROM STUDENT GROUP BY Stream'
  11. cursor.execute(sql)
  12. data = cursor.fetchall()
  13. print("Answer is:")
  14. for rec in data:
  15.     print(rec)
  16. mycon.close()
Success #stdin #stdout 0.02s 25940KB
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 Stream, COUNT(*) FROM STUDENT GROUP BY Stream'
cursor.execute(sql)
data = cursor.fetchall()
print("Answer is:")
for rec in data:
    print(rec)
mycon.close()
https://ideone.com/3HW3Fy
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!