Top "Mysql" questions

MySQL - Cannot add or update a child row: a foreign key constraint fails

This seems to be a common error, but for the life of me I can't figure this out. I have …

mysql foreign-keys mysql-error-1452

How to store Query Result in variable using mysql

SET @v1 := SELECT COUNT(*) FROM user_rating; SELECT @v1 When I execute this query with set variable this error is …

mysql database variables set

Are table names in MySQL case sensitive?

Are table names in MySQL case sensitive? On my Windows development machine the code I have is able to query …

mysql case-sensitive mysql5

how to run command "mysqladmin flush-hosts" on Amazon RDS database Server instance?

I got a database server failure, says host is blocked because of many connection errors. It ask me to unblock …

mysql amazon-rds

SELECT list is not in GROUP BY clause and contains nonaggregated column

Receiving the following error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'world.country.…

mysql sql aggregate mysql-error-1055

Cannot connect to MySQL 4.1+ using old authentication

I'm trying to connect to a mySQL database at http://bluesql.net, but when I try to connect, it gives …

php mysql authentication connection

Laravel: Get Object From Collection By Attribute

In Laravel, if I perform a query: $foods = Food::where(...)->get(); ...then $foods is an Illuminate Collection of …

php mysql laravel

What column type/length should I use for storing a Bcrypt hashed password in a Database?

I want to store a hashed password (using BCrypt) in a database. What would be a good type for this, …

mysql hash types storage bcrypt

error code 1292 incorrect date value mysql

I have a table `CREATE TABLE IF NOT EXISTS `PROGETTO`.`ALBERGO` ( `ID` INT(11) NOT NULL COMMENT 'identificativo dell\' albergo' , `…

mysql mysql-workbench mysql-error-1292

MySQL - How to parse a string value to DATETIME format inside an INSERT statement?

I have a MySQL database, with a column that is date type DATETIME. I am getting a string value for …

mysql datetime insert