Top "Mysql" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

How do I create a sequence in MySQL?

I'm trying to create a sequence in MySQL (I'm very new to SQL as a whole). I'm using the following …

mysql sql sequence
Easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard), 10.7 (Lion), 10.8 (Mountain Lion)?

What is the easiest way to activate PHP and MySQL on Mac OS 10.6 (Snow Leopard), 10.7 (Lion), 10.8 (Mountain Lion)? I'd prefer …

php mysql macos osx-snow-leopard osx-lion
View stored procedure/function definition in MySQL

What is the MySQL command to view the definition of a stored procedure or function, similar to sp_helptext in …

mysql stored-procedures stored-functions
using where and inner join in mysql

I have three tables. locations ID | NAME | TYPE | 1 | add1 | stat | 2 | add2 | coun | 3 | add3 | coun | 4 | add4 | coun | 5 | add5 | stat | schools ID | …

mysql inner-join
Running AMP (apache mysql php) on Android

I currently work on an open source e-commerce platform (www.oscmax.com) and I am trying to work out if …

php mysql apache tablet
Having both a Created and Last Updated timestamp columns in MySQL 4.0

I have the following table schema; CREATE TABLE `db1`.`sms_queue` ( `Id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `Message` VARCHAR(160) …

mysql mysql-error-1293
Java: Insert multiple rows into MySQL with PreparedStatement

I want to insert multiple rows into a MySQL table at once using Java. The number of rows is dynamic. …

java mysql jdbc prepared-statement batch-insert
Storing JSON in database vs. having a new column for each key

I am implementing the following model for storing user related data in my table - I have 2 columns - uid (…

mysql sql sql-server database optimization
INSERT ... ON DUPLICATE KEY (do nothing)

I have a table with a unique key for two columns: CREATE TABLE `xpo`.`user_permanent_gift` ( `id` INT UNSIGNED …

mysql sql unique-key
How to set root password to null

How can I change the password for root user of MySQL to null -- meaning no password or '' -- …

mysql mysql-management