Scripts posted recently tagged to mysql in Kelpi

1- 5 of 5.

Create database and grant privileges to use

to sql mysql by aitzol 

create database database_name;
grant all on database_name.* to 'user_name'@'host_name' [identified by 'user_password']

Modify a bunch of registers in a MySQL table

to modify update mysql sql by nando.quintana 

 UPDATE `pasarteas` SET `zintaren_kodea` = 'ELG-022' WHERE `zintaren_kodea` = 'BER-123'

Create a user in a MySQL Database

to user db mysql sql by nando.quintana 

# su - mysql
# mysql
CREATE DATABASE databasename;
GRANT ALL PRIVILEGES ON databasename.* TO "user"@"hostname" IDENTIFIED BY "password";
FLUSH PRIVILEGES;

Read items directly from a Koha mysql database

to koha mysql python by nando.quintana 

#!/usr/local/bin/python2.4
# -*- coding: utf-8 -*-
import MySQLdb
import os
import re

Connect to MySQL throught Free Pascal

to pascal freepascal mysql by lovelace 

PROGRAM test;
USES mysql;
CONST
DataBase : Pchar = 'db_prueba';
Query : Pchar = 'select count(*) from tb_prueba';
hits counter