How Shell, Perl, Python and PHP access MySQL database

This article mainly shows you "Shell, Perl, Python, PHP how to access MySQL database", the content is easy to understand, clear, hope to help you solve your doubts, the following let Xiaobian lead you to study and learn "Shell, Perl, Python, PHP how to access MySQL database" this article.

Write a simple bash script to test the program, enter a test case file, output the use cases and results that failed the test, and then save the results to the database. How to access the database directly in the bash script? Since you can manipulate the database directly with the mysql command in shell, you should also be able to manipulate the database by calling mysql in shell script. For example, use the following bash shell script to query the database:

Bash

#! / bin/bashmysql-uvpsee-ppassword test connect ('dbi:mysql:test',' vpsee', 'password'); $query = "select * from test_mark"; $cursor = $db- > prepare ($query); $cursor- > execute;while (@ row = $cursor- > fetchrow_array) {print "@ row\ n";}

Python

#! / usr/bin/pythonimport MySQLdbdb = MySQLdb.Connect ("localhost", "vpsee", "password", "test") cursor = db.cursor () query = "SELECT * FROM test_mark" cursor.execute (query) while (1): row = cursor.fetchone () if row = = None: break print "% s,% s,% s"% (row [0], row [1], row [2] Row [3])

PHP

#! / usr/bin/php above is all the content of the article "how to access MySQL database by Shell, Perl, Python, PHP". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!