Examples of programming questions in mysql

Whats the best way to store a time duration in a MySQL larger than the TIME range?
Calling stored procedure with Out parameter using PDO
MySQL - Query combine rows with same id and keep all entry for that id but as one record
Java, how to change current database to another?
What is difference between storing data in a blob, vs. storing a pointer to a file?
Arabic language in php/mysql appears "????" question marks in html
remove dash of UUID generated directly on MySQL
php mysql Group By to get latest record, not first record
syntax error in create trigger, what's wrong?
cakephp Table for model was not found in datasource default
MySQL infile ignore header row
Grab where CURDATE() and the day before with MySQL
PHP with MySQL is slow
Return all mySQL Records for Current Year
Convert Time String to Decimal Hours PHP
How I can Insert Data in the MySQL Database?
Count distinct values in MySQL without folding NULL values
When storing a MySQL connection string in App.config, what value should the providerName property be set to?
PHP MySQL Order by multiple columns
group_concat performance issue in MySQL
MySQL: Convert Unencrypted Password Column to MD5 Hash
PHP : Using a variable to hold a table name, and using that variable in queries
How to remove bad characters that are not suitable for utf8 encoding in MySQL?
PHP/MYSQL Join multiple tables
MySQL LEFT JOIN using MAX & GROUP BY on joined table?
Dynamic table names in stored procedure function
How to round a time to the nearest 15 minute segment
How to write query with time between now and midnight of today in MySQL?
Relational database design multiple user types
SQL update multiple rows with same value
Updating Views in MySQL
Select only unique row/record in mysql
Dynamic MySQL partitioning based on UnixTime
Drop unnamed Foreign Key in MySql
mysql double-quoted table names
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails
Expression mysql NOW() in Doctrine QueryBuilder
Mysql append column value
MySQL stored procedure that accepts string with multiple parameters
How do I put an 'if clause' in an SQL string?
Getting mysql result from the last 30 days
phpmyadmin opens MySQL table lists very slowly
MySQL : sum of every day
Selecting table data with PDO statements
Dropping procedure which already exists?
How to use comparison operator in case statement in MySQL?
How should i store newlines in a MySQL database?
windows batch file for mysqldump command
Is there a way to change wait_timeout and max_allowed_packet through PHP?
How do I reference a foreign key to serial datatype
MySQL SELECT unique column where other column is max
MySQL WHERE NOT IN extremely slow
Get last inserted auto increment id in mysql
does a primary key speed up an index?
SQL injection is not working correctly
MYSQL Select on two values one column
Two column as a primary keys in mysql?
how remove the backslash ("\") in the json response using php?
Php/Mysql date saved as '0000-00-00'
MySQL: insert values from another table into one column
mysql infile convert string to time format
Checking if a date is within 7 days of the current time
Group rows by 7 days interval starting from a certain date
How to do "while fetch assoc" in CodeIgniter?
Errcode 13 , SELECT INTO OUTFILE issue
syntax error on DECLARE CURSOR FOR
Temporary Tables Not Working in PHPMyAdmin
MySQL BETWEEN without endpoints
Get rows from the beginning of the current hour
What is the most efficient way to search in date ranges in MySQL?
How to prevent MySQL sleep injections?
MySQL query with two joins
Designing an E-Commerce Database - MySQL
How to export part of a table as SQL in Adminer?
Can I run a loop in MySQL without using a procedure/function?
MySQL Auto Increment Columns on TRANSACTION, COMMIT, and ROLLBACK
How can I automatically convert MySQL DDL to Oracle DDL?
Do I need to add an index on a mySQL table if the ID column is the primary key?
LEFT OUTER JOIN query not returning expected rows
SQL Get Other Rows From Aggregate Function
How should I establish and manage database connections in a multi-module Python app?
MySQL data export changes times
order sql tree hierarchy
Should mysqli update queries return a result?
Make hibernate backquote all table / column names
MySQL SELECT everything into one big string (columns and rows)
mysqldump version Error while exporting data from MySQL
MySql UPDATE with SUM in same table
MYSQL - Delete Query with Join
Saving an image in MySQL from Java
Adding characters in values in an existing column
How to Import shape file into MySQL
No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider
How to create user/group associations in MySQL
How to set database timezone for a AWS RDS instance
MySQL REPLACE in an auto incremented row
Dump File MySQL 5.6.10
php/mySQL on XAMPP: password for phpMyAdmin and mysql_connect different?
How to extract hour for MySQL FROM_UNIXTIME() results?
MySQL "binary" vs "char character set binary
MySQL - cannot add foreign key
How to create Triggers to add the change events into Audit Log tables
Get the max length allowed in column, mysql
SQL: Binary to IP Address
C# Get insert id with Auto Increment
MySQL Join Multiple Rows as Columns
Quickest way to Insert mass data Into Mysql database
Stored procedures in Ruby on Rails
MYSQL - Select only if row in LEFT JOIN is not present
MySQL fetch time optimization
Why is peewee including the 'id' column into the mysql select query?
Return the count of rows grouped by week MySQL
LOAD DATA INFILE on remote machine
MySql - order by monthname
Doctrine 2 and Many-to-many link table with an extra field
MySQL select yesterday's date
tomcat7 - jdbc datasource - This is very likely to create a memory leak
concurrent READ and WRITE on MySQL Table
'OPTION SQL_SELECT_LIMIT=DEFAULT'
IF... ELSE in WHERE clause MySQL
MYSQL: How to convert a string into a month (Number)
how to get mysql table size in GB
Rename Root @ local host username mySQL
Prepared Statement syntax for ON DUPLICATE KEY UPDATE (number of params error)
MySQL Every derived table must have its own alias
MySQL gives fluctuating row count when I query schema?
Doctrine2 LEFT JOIN with 2 conditions
MySQL CURSOR ERROR 1193: Unknown system variable
JDBC vs Web Service for Android
MySQL SELECT with fields less and greater than values
Mysql create table with multiple foreign key on delete set null
Maximum execution time of 30 seconds exceeded
MySQL, what does @@ mean?
Getting minute difference between two timestamps in mysql using TIMESTAMPDIFF
C++ / mysql Connector - undefined reference to get_driver_instance - already tried the easy stuff
Is it Possible to Enforce Data Checking in MySQL using Regular expression
is it good to store decimal value as varchar in mysql?
Count total without duplicate using MySQL and PHP
MySQL: Long table vs wide table
AND field NOT IN(NULL) returns an empty set
Call to undefined function session_register()
mysql get month from timestamp not working
Combine two MYSQL table with same column Name
php pdo get only one value from mysql; value that equals to variable
How to log query and its execution time of each query which runs on a db?
Rails 3.2 + MySQL: Error: Field 'created_at' doesn't have a default value: INSERT INTO
How to use LIKE query in Ruby on Rails
Why is AES_DECRYPT returning null?
Drop All Tables Except One in MySql
pdo prepared statements with wildcards
MySQL : strange LENGTH() behaviour on utf8 string
Why is MySQL showing index_merge on this query?
How can I correct MySQL Load Error
SQL count how many times a value appears in multiple columns?
MySQL SELECT COUNT > 0 as boolean value
java.sql.SQLException: Already closed
To get MYSQL query execution time in Query
MySQL MyISAM how to perform a read without locking a table?
MySQL ONLY IN() equivalent clause
How to fix `unknown variable 'sql-mode=ANSI'`?
Max size of UNIQUE index in MySQL
How to transpose mysql table rows into columns
auto increment primary leaving gaps in counting
MySQL: Creating table with two foreign keys fails with "Duplicate key name" error
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in
Javascript function post and call php script
How to insert an hebrew value into a mysql db in php
Deciding on foreign key while implementing one to one relationship in MySQL
What does mysqld_safe do in my.cnf?
Alternative of NOT IN On MySQL
Get row with highest or lowest value from a GROUP BY
Amazon EC2 MySQL Failed to Start
wildcard for single digit mysql
How to fetch a single result from mysql using code igniter?
MySQL ORDER BY Date field which is not in date format
How to subtract one to the month of a date format in mysql?
How to have Unique IDs across two or more tables in MySQL?
negate regex pattern in mysql
Inner join with like clause
PHP to output single and double quotes as a value for an input element
LOAD DATA from CSV file where doublequote was used as the escape character
Select only unique values from a column in codeigniter
Mysql query case with range, and case with currency
Laravel/Eloquent - 15 Second Interval between timestamp
C# Too many connections in MySQL
Mysql nested while loop in a Stored Procedure
MySQL SELECT + add a character after value
Delete all rows except first N from a table having single column
Database Structure for Web Messaging System
How do I pass more than one parameter in Hibernate createSQLQuery()?
Is it bad to omit semicolon in MySQL queries?
Mysql: Swap data for different rows
mysql slow count in join query
Can't gzip my mysqldump on the command line windows
MySQL trigger with join
How to populate database only once before @Test methods in spring test?
Session Variable in Select Statement
Session Variables: How much data is too much?
Merge Multiple .sql Table Dump Files Into A Single File
Mysql_install_db cannot find file
MySQL Command not Found [MAMP]
Insert query with an inner join
sequelize.js - You need to install mysql package manually
mysql view super slow
MySQL SSL Remote Connection Error: Unable to get Private Key
Best way to get unix timestamp for current UTC time in MySQL
Is there a TTL for MySQL as there is in MongoDB?
SQL Query Stuck in Statistics State
Mysql 5.6 headaches on Mac OSX
Disable autocommit in SQL Developer when using MySQL
MySQL - SHOW COLUMNS from Multiple Tables
Count all values from column values in MySQL using PHP
MYSQL Select MAX Date inside a join statement
How to use Table output from stored MYSQL Procedure
How to perform action on OK of JOptionPane.showMessageDialog
Bash script to insert values in MySQL
SQL Error: 1191 - Can't find FULLTEXT index matching the column list
JDBC url for MySQL configuration to use utf8 character encoding
Inserting a Column to preexisting table in phpmyadmin
BLOB data returned in MySQL using AES_DECRYPT with ORDER clause
How to join MySQL tables using a nullable column?
How to sort time ( In AM / PM ) in SQL?
Allowed memory size of 134217728 bytes exhausted (tried to allocate 4294967296 bytes)
Query SUM for two fields in two different tables
MySQL compare unix timestamps
Whole word matching with dot characters in MySQL
Right join query not working
New version of PHPMyAdmin has stopped me being able to edit data
How to find duplicate email within a mysql table
ASP.NET use SqlConnection connect MySQL
Inserting records into a MySQL table using Java
Using "TYPE = InnoDB" in MySQL throws exception
Get Time from mysql and echo it in any format we want - php
How to delete a certain row from mysql table with same column values?
Replace spaces with dash and copy into new column
Database Structure involving dynamic fields
MySQL 'LIKE' query with spaces
Joining different tables based on column value
finding products that customers bought together
MySQL Database Connection With Visual Studio 2013 Preview
SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
MySQL user defined functions
mysql: why does left join not use an index?
Will MySQL reuse deleted ID's when Auto Increment is applied
How can I use mysqli_fetch_array() twice?
Ubuntu can't stop mysqld
mysql case sensitive in utf8_general_ci
check date between two dates or NULL in sql
Store Images in MySQL Database
How to create a notification chrome extension?