Latest Posts in Database

Browse latst posts in Database Category

Published 31 Jan, 2022
Storing Images in Database : Base64 vs Blob

Even tiniest of applications today require a number of images. If you're a developer, you must have wondered whether is it advisable to store images in a database or not? In this post we'll look into it.

Published 03 Feb, 2022
How to schedule a stored procedure in MySQL

How to schedule a stored procedure in MySQL

Published 04 Feb, 2022
Composite Primary Keys & Should You Even Use it?

Composite primary keys are special meaning they is not just one key that uniquely identifies a record. There are many such scenario and composite primary keys play a vital role.

Published 23 Feb, 2022
How to recompile all stored procedures and table valued functions in SQL Server database?

How to recompile all stored procedures and table valued functions in SQL Server database?

Published 23 Feb, 2022
How to list all constraints of a table in PostgreSQL?

How to list all constraints of a table in PostgreSQL?

Published 23 Feb, 2022
How to get a group where the count is zero?

How to get a group where the count is zero?

Published 23 Feb, 2022
How to run recurring tasks on Postgresql without an external cron-like tool?

How to run recurring tasks on Postgresql without an external cron-like tool?

Published 31 Jan, 2022
How to dump mysql table structure without data with a SQL query?

How to dump mysql table structure without data with a SQL query?

Published 03 Feb, 2022
How To Increase The Number of MySQL Connections?

MySQL database server supports multiple connections at once. Did you know you can even increase or reduce the number of connections manually.

Published 23 Feb, 2022
How to write a query that counts rows by date?

How to write a query that counts rows by date?

Published 31 Jan, 2022
MySQL InnoDB foreign key between different databases

MySQL InnoDB foreign key between different databases

Published 23 Feb, 2022
MySQL - How to check for a value in all columns

MySQL - How to check for a value in all columns

Published 03 Feb, 2022
Is it Even Possible To Version Control Your MySQL Database?

I was wondering whether I can version control my database and by database I mean the schema part and so a little research brought me the information I was looking for.

Published 03 Feb, 2022
How to store an array into mysql?

How to store an array into mysql?

Published 22 Apr, 2022
MySQL - How to cast an integer to a boolean in a MySQL SELECT clause?

Try using the IF function: SELECT IF(`gu`.`StoppingUnitEventME`=`ese`.`MonitoringElement`, TRUE, FALSE) FROM ... or SELECT IF(`gu`.`StoppingUnitEventME`=`ese`.`MonitoringElement`, 1, 0) FROM ......

Published 03 Feb, 2022
How To Update 10 Million+ Rows in a MySQL Table The Fastest Way

Even the fastest of SQL queries slow down during heavy I/O operations in databases. Doing things efficiently is important as even the tiniest of modifications may make a huge difference.

Published 04 Feb, 2022
How To Add Comments In MySQL Queries?

MySQL is a special purpose programming language. There are well lot of features built into it, you can write complex procedures and do amazing things with data.

Published 03 Feb, 2022
MySQL ORDER BY rand(), name ASC

MySQL ORDER BY rand(), name ASC

Published 03 Feb, 2022
What effects does using a binary collation have?

What effects does using a binary collation have?

Published 03 Feb, 2022
Changing Table Engine in MySQL

Changing Table Engine in MySQL