Category: MySQL

How run a transactional query in MySQL on Ubuntu using Python is shown here. Contents ▼1. Run a transactional query in MySQL on Ubuntu▼2. Prerequisites▼3. Creating Python code to insert data with False of “autocommit” in MySQL on Ubuntu3-1. Creating Python code3-2. Results3-3. Confirming results of select query by connecting to MySQL from a terminal3-4. Results when commit is executed3-5. Confirming results after connecting to MySQL from a terminal.▼4. Reference▼1. Run a transactional query in MySQL on Ubuntu Regarding SQL Server on Ubuntu, how to execute a transactional query using Java and Python were shown in the past. regarding MySQL on Ubuntu, pyodbc is used for the connection to MySQL. … Continue reading “Python -Run a transactional query in MySQL on Ubuntu No.103”

How to implement the error handling and retry with some interval in MySQL on Ubuntu by Python is shown in this blog. Contents ▼1. Why do we need an error handling and an retry logic?▼2. Prerequisites▼3. Creating the Python code to implement the error handling & retry logic3-1. Developing a python code for an error handling and a retry logic3-2. Results for this code▼4.  Others: Confirming the listening port of MySQL▼5. Reference▼1. Why do we need an error handling and an retry logic? We often use a cloud service and a remote service through the network. if the network intermittently cause something problems, the client application cannot access these services and … Continue reading “Python – Error handling & Retry in MySQL on Ubuntu  No.101”

How to save the results of select query in MySQL on Ubuntu through pyodbc into a local file using python is shown in this blog. Contents ▼1. Save data of MySQL on Ubuntu into a file▼2. Prerequisites▼3. Python code to save results of select query for MySQL into a file3-1. Creating python code3-2. Results of this code▼4. Reference▼1. Save data of MySQL on Ubuntu into a file In the past, how to save data My MySQL into a file using Java was provided in this blog as below. in this case, it will be implemented by Python. Java -Save the results of select for MySQL into a file No.85 ▼2. Prerequisites How … Continue reading “Python – Save data of MySQL into a local file  No.99”