Top "Mysql" questions

MySQL SELECT WHERE datetime matches day (and not necessarily time)

I have a table which contains a datetime column. I wish to return all records of a given day regardless …

mysql date select

Your password does not satisfy the current policy requirements

I want to create a new user in mysql with syntax: create user 'demo'@'localhost' identified by 'password'; But it …

mysql passwords

MySQL: Can't create table (errno: 150)

I am trying to import a .sql file and its failing on creating tables. Here's the query that fails: CREATE …

mysql sql phpmyadmin mysql-error-150

MySQL convert date string to Unix timestamp

How do I convert the following format to unix timestamp? Apr 15 2012 12:00AM The format I get from DB seems to …

mysql datetime timestamp unix-timestamp

Laravel-5 'LIKE' equivalent (Eloquent)

I'm using the below code to pull some results from the database with Laravel 5. BookingDates::where('email', Input::get('email'))…

php mysql laravel-5

How can I check MySQL engine type for a specific table?

My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which …

mysql innodb myisam

How to properly create composite primary keys - MYSQL

Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate …

mysql primary-key myisam composite-key composite-primary-key

Get record counts for all tables in MySQL database

Is there a way to get the count of rows in all tables in a MySQL database without running a …

mysql sql rowcount

How do you connect to multiple MySQL databases on a single webpage?

I have information spread out across a few databases and want to put all the information onto one webpage using …

php mysql

Differences between MySQL and SQL Server

I'm an ASP.NET developer who has used Microsoft SQL Server for all my database needs (both at work and …

mysql sql-server tsql