Top "Mysql" questions

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

How to store arrays in MySQL?

I have two tables in MySQL. Table Person has the following columns: id | name | fruits The fruits column may hold …

mysql database-schema
LAST_INSERT_ID() MySQL

I have a MySQL question that I think must be quite easy. I need to return the LAST INSERTED ID …

mysql insert last-insert-id
SELECT INTO Variable in MySQL DECLARE causes syntax error?

I´d like to SELECT a single value into a variable. I´d tried to following: DECLARE myvar INT(4); -- …

mysql select mysql-workbench declare
How can I fix MySQL error #1064?

When issuing a command to MySQL, I'm getting error #1064 "syntax error". What does it mean? How can I fix it?

mysql parsing syntax syntax-error mysql-error-1064
Is it possible to GROUP BY multiple columns using MySQL?

Is it possible to GROUP BY more than one column in a MySQL SELECT query? For example: GROUP BY fV.…

mysql sql group-by
MySQL IF NOT NULL, then display 1, else display 0

I'm working with a little display complication here. I'm sure there's an IF/ELSE capability I'm just overlooking. I have 2 …

mysql if-statement
MySQL Removing Some Foreign keys

I have a table whose primary key is used in several other tables and has several foreign keys to other …

mysql foreign-keys constraints mysql-error-1025
mysql server port number

I've just made a database on mysql on my server. I want to connect to this via my website using …

php mysql database database-connection port-number
How to get database structure in MySQL via query

Is it possible to somehow get structure of MySQL database, or just some table with simple query? Or is there …

mysql
Skip certain tables with mysqldump

Is there a way to restrict certain tables from the mysqldump command? For example, I'd use the following syntax to …

sql mysql database mysqldump