Top "Mysql" questions

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

Can I store images in MySQL

Possible Duplicates: Images in MySQL Storing images in MySQL I'm trying to develop a website where users upload their images …

php mysql image
Fixing "Lock wait timeout exceeded; try restarting transaction" for a 'stuck" Mysql table?

From a script I sent a query like this thousands of times to my local database: update some_table set …

mysql transactions
How can I search (case-insensitive) in a column using LIKE wildcard?

I looked around some and didn't find what I was after so here goes. SELECT * FROM trees WHERE trees.`title` …

mysql sql sql-like case-insensitive
Using env variable in Spring Boot's application.properties

We are working on a Spring Boot web app and the database we are using is MySql; the setup we …

java mysql spring spring-mvc openshift
How to make MySQL table primary key auto increment with some prefix

I have table like this table id Varchar(45) NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30) NOT NULL, I want …

mysql auto-increment
1052: Column 'id' in field list is ambiguous

I have 2 tables. tbl_names and tbl_section which has both the id field in them. How do I go …

mysql sql database join mysql-error-1052
MySQL OPTIMIZE all tables?

MySQL has an OPTIMIZE TABLE command which can be used to reclaim unused space in a MySQL install. Is there …

mysql sql
Location of my.cnf file on macOS

I'm trying to follow along this tutorial to enable remote access to MySQL. The problem is, where should my.cnf …

mysql database macos
MySQL order by before group by

There are plenty of similar questions to be found on here but I don't think that any answer the question …

mysql group-by sql-order-by
mysql Foreign key constraint is incorrectly formed error

I have two tables, table1 is the parent table with a column ID and table2 with a column IDFromTable1 (not …

mysql sql heidisql