mysql

Just a quick note here today that if you need some example MySQL database tables, you can use these. I created them for some experiments I ran last night. They show the MySQL create table, primary key, and foreign key syntax:

MySQL DATE syntax FAQ: How do I set a MySQL DATE field to default to "now", i.e., the current time?

MySQL default date now - Solution

Unfortunately you can't default a MySQL DATE field to "now", but you can get the "now" behavior with a MySQL TIMESTAMP field. The basic MySQL syntax to create a MySQL TIMESTAMP now field is:

last_changed timestamp not null default now(),

where "last_changed" is the name of my field, timestamp is the type of field, it can't be null, and the date/time default is now.

MySQL backup FAQ: How do I back up a MySQL database?

I can't speak about backing up MySQL databases that are modified twenty-four hours a day seven days a week, but on all the MySQL databases I currently work with, there are always times when I can guarantee that there won't be any SQL INSERTs, DELETEs, or UPDATEs occurring, so I find it's really easy to perform a MySQL backup using the mysqldump utility program. Here's how it works.

MySQL "create database" FAQ: Can you share an example of how to create a MySQL database, including (a) creating the MySQL database and (b) a new MySQL database user, with all appropriate MySQL GRANT permissions for that user?

I've written about the process of How to add/create a MySQL user before, but I just ran across the Drupal installation documentation, which also has a nice description for how to create a MySQL database (for use with Drupal), so I thought I'd include some of their documentation here, along with some notes from my own recent Drupal and MySQL installation.

1) Create a new MySQL database

The first part of the Drupal installation document refers to creating a MySQL database:

MySQL users FAQ: How do I show MySQL users (How do I show user accounts I've created in a MySQL database)?

To show/list the users in a MySQL database, first log into your MySQL server as an administrative user, then run this MySQL query: