Notification
A second ago
Browse latst posts in Database Category
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.
How to schedule a stored procedure in MySQL
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.
How to recompile all stored procedures and table valued functions in SQL Server database?
How to list all constraints of a table in PostgreSQL?
How to get a group where the count is zero?
How to run recurring tasks on Postgresql without an external cron-like tool?
How to dump mysql table structure without data with a SQL query?
MySQL database server supports multiple connections at once. Did you know you can even increase or reduce the number of connections manually.
How to write a query that counts rows by date?
MySQL InnoDB foreign key between different databases
MySQL - How to check for a value in all columns
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.
How to store an array into mysql?
Try using the IF function: SELECT IF(`gu`.`StoppingUnitEventME`=`ese`.`MonitoringElement`, TRUE, FALSE) FROM ... or SELECT IF(`gu`.`StoppingUnitEventME`=`ese`.`MonitoringElement`, 1, 0) FROM ......
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.
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.
MySQL ORDER BY rand(), name ASC
What effects does using a binary collation have?
Changing Table Engine in MySQL