Top "Mysql" questions

Deleting rows with MySQL LEFT JOIN

I have two tables, one for job deadlines, one for describe a job. Each job can take a status and …

mysql left-join delete-row sql-delete

DOUBLE vs DECIMAL in MySQL

OK, so I know there are tons of articles stating I shouldn't use DOUBLE to store money on a MySQL …

mysql double decimal

Loading .sql files from within PHP

I'm creating an installation script for an application that I'm developing and need to create databases dynamically from within PHP. …

php sql mysql import scripting

mysqli::query(): Couldn't fetch mysqli

Warning: mysqli::query(): Couldn't fetch mysqli in C:\Program Files (x86)\EasyPHP-DevServer-13.1VC9\data\localweb\my portable files\class_EventCalendar.…

php mysql mysqli

MySQL - sum column value(s) based on row from the same table

I'm trying to get 'Cash', 'Check' and 'Credit Card' totals in new columns based on ProductID from the same table. …

mysql select group-by left-join pivot

SQL: set existing column as Primary Key in MySQL

I have a database with 3 columns: id, name, somethingelse This table has no index set and i am getting "No …

mysql sql indexing primary-key

how to use a like with a join in sql?

I have 2 tables, say table A and table B and I want to perform a join, but the matching condition …

mysql sql join sql-like

Dump all tables in CSV format using 'mysqldump'

I need to dump all tables in MySQL in CSV format. Is there a command using mysqldump to just output …

mysql csv

How to change the foreign key referential action? (behavior)

I have set up a table that contains a column with a foreign key, set to ON DELETE CASCADE (delete …

mysql foreign-keys foreign-key-relationship

How do I UPDATE a row in a table or INSERT it if it doesn't exist?

I have the following table of counters: CREATE TABLE cache ( key text PRIMARY KEY, generation int ); I would like to …

mysql sql sqlite postgresql upsert