mysqldump with --where clause is not working?

mysqldump -t -u root -p mytestdb mytable --where=datetime LIKE '2014-09%' This is what I am doing and it returns...

Fatal error: Uncaught Error: Call to undefined function mysql_connect()?

I am trying to do a simple connection with XAMPP and MySQL server, but whenever I try to enter data or connect to th...

php password_verify not working with database?

I am using php 5.4 with this backwards compatibility script: https://github.com/ircmaxell/password_compat/blob/maste...

Can a table have two foreign keys??

I have the following tables (Primary key in bold. Foreign key in Italic) Customer table ID---Name---Balance---Acc...

What is the difference between SERIAL and AUTO_INCREMENT in mysql?

I have come across two ways to increment the ids in mysql automatically. One is SERIAL and other is AUTOINCREMENT. ...

Group by with union mysql select query?

(SELECT COUNT(motorbike.`owner_id`) as count,owner.`name`,transport.`type` FROM transport,owner,motorbike WHERE tran...

Using ALTER to drop a column if it exists in MySQL?

How can ALTER be used to drop a column in a MySQL table if that column exists? I know I can use ALTER TABLE my_tab...

Unable to get spring boot to automatically create database schema?

I'm unable to get spring boot to automatically load my database schema when I start it up. Here is my application.p...

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'db'?

I want to begin writing queries in MySQL. show grants shows: +--------------------------------------+ | Grants for...

How to encrypt a specific column in a MySQL table??

I am experimenting with creating a simple message system (PHP) page that uses a MySQL table to store the entries. Th...

MySQL Error 1215: Cannot add foreign key constraint?

I am trying to forward engineer my new schema onto my db server, but I can't figure out why I am getting this error....

Select from multiple tables without a join??

What is the easiest way to select data from two tables and rather than join them, have them appear as separate rows....

SQL many to many select?

category_product --------------- id_category id_product product --------------- id_product id_manufacturer manufac...

How to update multiple columns in mysql using php?

Here i am trying to update update multiple column values in mysql table using php. $product_id = mysqli_real_escape...

How to make join queries using Sequelize on Node.js?

I am using sequelize ORM; everything is great and clean, but I had a problem when I use it with join queries. I have...