Python Forum
Error in Database connectivity with python3.7
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error in Database connectivity with python3.7
#8
(May-09-2019, 07:32 AM)srm Wrote: It does not even go upto this line it stops at very first line of connection...is it becos there is also sql server 2012 installed on same machine which also takes first instance as localhost???not getting it...

(May-08-2019, 09:59 AM)srm Wrote: ok sir,when I tried the above mention code..there is no error or result..output is blank.

so, which of your two statements is correct?
both your databases are on localhost, just listen on different port

import pymysql
conn=pymysql.connect('localhost','root','mcse@123','mysqldb')
print("Connection Succeeded")
cmd=conn.cursor()
cmd.execute('create table emp(empid int,empname char(10))')
cmd.execute("insert into emp values(111,'asha')")
cmd.commit()
cmd.execute('select * from emp')
result=cmd.fetchall()
for row in result:
    print(row)
conn.close()
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
RE: Error in Database connectivity with python3.7 - by buran - May-09-2019, 07:42 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Jira Connectivity Shyam 1 395 Apr-17-2024, 08:55 AM
Last Post: Abhishikt
  Understanding and debugging memory error crashes with python3.10.10 Arkaik 5 2,249 Apr-18-2023, 03:22 AM
Last Post: Larz60+
  error 1102 (42000) incorrect database name 's' Anldra12 4 1,765 Jun-08-2022, 09:00 AM
Last Post: Anldra12
  mySQL Database error not resolving. cybertooth 2 3,299 Aug-30-2021, 05:45 PM
Last Post: ibreeden
  Error creating database with python and form? shams 3 2,420 Aug-02-2021, 02:00 PM
Last Post: deanhystad
Bug maximum recursion depth exceeded while calling a Python object error in python3 Prezess 4 3,828 Aug-02-2020, 02:21 PM
Last Post: deanhystad
  import yaml error for python3 maiya 4 13,298 Jul-15-2020, 06:07 PM
Last Post: Gribouillis
  Mysql-Python Connectivity Error aryamanurs 2 3,531 Apr-29-2020, 02:21 PM
Last Post: aryamanurs
  Error in Python3.6:free() Corrupted unsorted chunks error sameer_k 2 3,947 Mar-18-2020, 09:37 AM
Last Post: sameer_k
  Error after installing Python3.8.2: "No module named 'apt_pkg'" Chromie 3 3,957 Mar-09-2020, 08:20 PM
Last Post: micseydel

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020