mysql Examples and Free Source Code

Inserting columns with a case expression...

mysql sql insert case

Compare a date column versus a number of days from the current date using CodeIgniter's query bu...

php mysql date codeigniter query-builder

Saving a date earlier than 1970 in y-m-d format results in a date in the 21st century in my MySQL da...

php mysql date-formatting

SELECT rows WHERE current day is BETWEEN two date column values using CodeIgniter's query builde...

php mysql codeigniter query-builder days

How can I execute 2 MySQL queries with mysql_query()?...

php mysql multi-query

SELECT COUNT of records in a second table per record in a first table using CodeIgniter query builde...

php mysql codeigniter activerecord query-builder

MySQL database trying to update info but not appearing on website...

php mysql symfony

How to access query result data to build subsequent queries in a loop using CodeIgniter...

php mysql codeigniter codeigniter-2

How to get different error message using elesif...

php mysql codeigniter if-statement

How to comma-JOIN multiple tables with CodeIgniter's query builder...

php mysql codeigniter join query-builder

SELECT rows WHERE column contains the search string or column is a substring of the search string...

mysql sql-like

mysql not equal operator not working...

sql mysql equality

Too many connections Nodejs + mysql2/promise...

mysql node.js typescript mysql2 node-mysql2

"Error starting ApplicationContext" when executing spring application...

java mysql spring

How to fetch results from two tables using single query...

mysql sql

AWS: can't connect to RDS database from my machine...

mysql database amazon-web-services amazon-rds

MySQL - How to grant read only permissions to a user?...

mysql sql security permissions readonly

MySQL: Sum if rows are equal...

sql mysql group-by sum

How to fetch paginated results with a MySQL SELECT query...

mysql pagination limit offset

How to SELECT the first N rows in one query then the rest of the rows in another query?...

mysql limit

Select first 10 distinct rows in mysql...

mysql limit

How to SELECT the first 10 records in MySQL, but order of the records descendingly...

php mysql sql-order-by limit

How to connect mySQL database using C++...

c++mysql

mysql: select last 10 rows from DESC LIMIT...

php mysql pagination limit

SELECT N rows with the largest column value, but then sort with smaller column values first...

mysql sql-order-by limit

Does MySQL prevent full table sorting when given ORDER BY and LIMIT?...

mysql query-optimization sql-order-by limit execution

Apply different ORDER BY after query has ORDER BY and LIMIT applied...

mysql join sql-order-by limit

SELECT rows with ORDER BY and LIMIT, then change the ORDER BY rule...

mysql sql-order-by limit

Single MySQL SELECT query to fetch N rows with datetime next to occur and M rows most recently past...

mysql limit union-all

Apply ORDER BY to parent rows relating to rows from another table with the highest COUNT() after GRO...

mysql join group-by count sql-order-by