Answers for "mysql versions"

SQL
4

mysql version

# console
mysql --version
mysql -V

# sql query
SHOW VARIABLES LIKE ‘%version%’;
Posted by: Guest on June-03-2020
8

mysql version

# Console:
mysql -V
mysql --version
# Query:
SHOW VARIABLES LIKE "%version%";
# PHPMyAdmin Interface, on the right side:
> Database server > Server version
Posted by: Guest on August-13-2021
1

what is my mysql version

Mysql version
mysql -V
Posted by: Guest on October-14-2020
0

mysql version query

SHOW VARIABLES LIKE ‘%version%’;
Posted by: Guest on June-21-2021
0

mysql version

mysqld --version
Posted by: Guest on May-05-2020
0

python and mysql connectivity

import pymysql

############### CONFIGURE THIS ###################
# Open database connection
db = pymysql.connect("database_host","username","password","database_name")
##################################################

# prepare a cursor object using cursor() method
cursor = db.cursor()

# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")

# Fetch a single row using fetchone() method.
data = cursor.fetchone()
print ("Database version : {0}".format(data))

# disconnect from server
db.close()
Posted by: Guest on May-16-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language