alvin alexander
Nodes for the term “mysql”
MySQL “show users”: How to show/list the users in a MySQL database
Read more
A MySQL add user and grant example
Read more
A MySQL “create table” syntax example
Read more
MySQL: How do I list the tables in a MySQL database?
Read more
A MySQL database backup (mysqldump) shell script
Read more
How to find all MySQL database tables that have specific column names
Read more
How to perform a SQL query for fields that are null (or not null)
Read more
A Scala JDBC connection and SQL SELECT example
Read more
MySQL show status: How to show open database connections
Read more
A Java MySQL SELECT example
Read more
MySQL error: Expression of SELECT list is not in GROUP BY clause, nonaggregated column
Read more
Scala: A ScalikeJdbc example (including SQL SELECT and UPDATE statements)
Read more
MySQL create database example - How to create a MySQL database and user account for Drupal
Read more
MySQL restore: How to restore a MySQL database from a backup
Read more
How to convert from a Scala BigDecimal to Java BigDecimal
Read more
How to search for a string in all fields of every table in a MySQL database
Read more
Complete backup scripts for my websites (Drupal, MySQL)
Read more
MySQL backups: How to backup a MySQL database
Read more
A Java MySQL UPDATE example
Read more
A Java MySQL INSERT example (using PreparedStatement)
Read more
A Java MySQL INSERT example (using Statement)
Read more
A Java MySQL DELETE example
Read more
Java MySQL examples and tutorials
Read more
A simple Java JDBC example that shows SQL insert, update, delete, and select
Read more
Java JDBC connection string examples
Read more
MySQL FAQ: How do I show the fields or schema of a database table?
Read more
A MySQL Vacuum database tables script (auto_increment reset)
Read more
A MySQL foreign keys “drop table” and re-create table example
Read more
MySQL drop table and foreign keys tip - the FOREIGN_KEY_CHECKS variable
Read more
MySQL syntax examples - create table, primary key, foreign key
Read more
Example MySQL database design: A Nagios MySQL database design
Read more
A MySQL database table index example
Read more
How to list MySQL database table column names without the table formatting
Read more
PHP write stderr - Write to STDERR in a PHP script
Read more
MySQL Error 1293 - Incorrect table definition (TIMESTAMP)
Read more
The MySQL default port is ...
Read more
How to speed up JDBC PreparedStatement MySQL batch inserts
Read more
A MySQL stored procedure example
Read more
A Play Framework Anorm insert method that returns the database auto-insert ID
Read more
MySQL foreign key examples (How to define foreign keys in MySQL)
Read more
The MySQL SHOW INDEX command
Read more
MAMP - Mac OS X, Apache, MySQL, and PHP (and CakePHP too)
Read more
A Drupal PHP script to log database errors
Read more
MySQL: How to show the schema of a MySQL database table
Read more
How to change a Drupal 6 user password using mysql or phpmyadmin
Read more
How do I access a MySQL database with the MySQL command line client?
Read more
Database-driven version of United States dropdown data
Read more
How to save the output from a MySQL query to a file
Read more
Help, my Drupal 8 database is huge
Read more
How to default a MySQL date (timestamp) field to now
Read more
Java JDBC drivers and driver downloads
Read more
Initial MySQL root user account
Read more
MySQL auto increment - the MySQL auto_increment attribute
Read more
How to get the generated key from a MySQL auto_increment field after an INSERT
Read more
Spring JDBC - How to retrieve the auto-generated database key after an INSERT
Read more
A Spring MySQL BasicDataSource connection example
Read more
Java MySQL JDBC Driver class and URL example
Read more
MySQL: How to start a MySQL server and client on a non-standard port
Read more
MySQL example database: The Coffee Break Database from Sun’s JDBC tutorial
Read more
How to use a my.cnf configuration file with MAMP/MySQL
Read more
The MySQL Sakila sample database
Read more
The Play Framework, MySQL, currency, decimal fields, and BigDecimal types
Read more
mysqldump error: 1044: Access denied for user ... when using LOCK TABLES
Read more
cake bake MAMP MySQL socket connection refused error
Read more
The PHP MySQL mysql_connect() can't connect to local MySQL server through socket error
Read more
The PHP PDOException SQLSTATE MySQL can't connect socket error
Read more
Nagios web interface, coming soon
Read more
A Drupal categories block PHP script
Read more
A MySQL PHP update query example
Read more
PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
Read more
A PHP "select from where in" query example
Read more
Update MySQL timestamp on update
Read more
Solving the MySQL "can't create/write to file" error message
Read more
The Drupal Diaries, Day 10
Read more
EU has MySQL concerns regarding Oracle-Sun deal
Read more
Use the PHP addslashes function to fix SQL INSERT problems
Read more
Oracle purchase of Sun wins EU approval
Read more
Oracle's plans for Sun technologies: Java, MySQL, SPARC, Solaris, Sun Cloud, and OpenSSO
Read more
A PHP/MySQL script to query the Drupal comments table
Read more
Oracle wins approval from the U.S. for Sun purchase
Read more
mysqldump command - how to dump (backup) a MySQL database
Read more
JDBC Timestamp - How to select a Java Timestamp field from a database timestamp column
Read more
MySQL FAQ - how do I list all the databases in a MySQL database?
Read more
MySQL login FAQ - How do I log in to a MySQL database?
Read more
A Perl DBI DBH MySQL example
Read more
MySQL ERROR 1005 (HY000): Can't create table
Read more
Show MySQL foreign keys with the "show create table" command
Read more
How I fixed my JDBC MySQL transaction problem
Read more
The beginning of a MySQL database script
Read more
MySQL timestamp - how to default a timestamp field to "now"
Read more
MySQL: Default a field to the current date/time
Read more
An apology, and a good laugh
Read more
Getting PHP, MySQL, and Mac OS X to work together
Read more
Ruby MySQL DBI example
Read more
MySQL CSV import example
Read more