Rrc en 21:57 12 mar 2016

2016-03-12T21:57:44Z

Página nueva

__NOTOC__
* [[:#MySQL-4 | MySQL-4.py]]

== MySQL-4.py ==

<syntaxhighlight lang="python" line="GESHI_FANCY_LINE_NUMBERS">

#!/usr/bin/python3
#-*-coding: utf-8 -*-

import mysql.connector
from mysql.connector import errorcode

config = {
'user': 'PythonClase',
'password': 'Py800se',
'host': '127.0.0.1',
'database': 'PythonClase',
'raise_on_warnings': True,
'unix_socket': '/var/lib/mysql/mysql.sock'
}

try:
Conn = mysql.connector.connect(**config)
except mysql.connector.Error as err:
if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
print( "UsuarioNombre o Contraseña incorrecto" )
elif err.errno == errorcode.ER_BAD_DB_ERROR:
print( "Base de Datos no existe" )
else:
print( err )

Cursor = Conn.cursor()

Query = "INSERT INTO TablaDePrueba values ( NULL, 'Valor 1' )";

Cursor.execute( Query )

Conn.commit()

Query = "INSERT INTO TablaDePrueba ( CampoDePueba ) values ( 'Valor 2' )";

Cursor.execute( Query )

Conn.commit()

Conn.close()

print( "Mira en la TablaDePrueba a ver los registros nuevos" )

</syntaxhighlight>

=== Resultado ===
<pre>
[rrc@Pridd PythonClase]$ mysql -u PythonClase -pPy800se
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 27
Server version: 10.0.22-MariaDB Mageia MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use PythonClase
Database changed
MariaDB [PythonClase]> select * from TablaDePrueba;
+----+--------------+
| id | CampoDePueba |
+----+--------------+
| 1 | Valor 1 |
| 2 | Valor 2 |
+----+--------------+
1 row in set (0.00 sec)

MariaDB [PythonClase]>

</pre>

Curso de Programación en Python/MySQL-4 - Historial de revisiones

Rrc en 21:57 12 mar 2016