SQL Server Blog
PreambleWe will show you how to install PostgreSQL on Debian 9. PostgreSQL is an object-relational database management system written in C.It is a free and open-source system, whose main...
PreambleMost Linux distributions come with MySQL.If you want to use MySQL, my recommendation is that you download the latest version of MySQL and install it yourself. Later you can update it to...
PreambleYou will show you how to list all databases in MySQL. MySQL is an open-source relational database management system commonly used with web applications such as WordPress, Magento, etc....
PreambleWhen administering PostgreSQL database servers, one of the most common tasks you will probably perform is enumerating databases and their tables. PostgreSQL comes with an interactive...
PreambleSometimes you need to select random entries from a table, for example: Highlight a few random blog posts and display them in the sidebar.Choose a random quote to display the Quote of...
PreambleYou can use the LEN function () to find the length of a string value in SQL Server, for example, LEN (emp_name) will give you the length stored in the emp_name string. Remember that...
PreambleThe MySQL development team is pleased to announce the release of a new 8.0 version to support MySQL Shell AdminAPI – 8.0.20!After the previous exciting release, which introduced...
PreamblePostgreSQL, often referred to simply as Postgres, is a universal open-source object and relational database management system.Knowing which version of the PostgreSQL server is installed...
PreambleMySQL is an open-source relational database server tool for Linux operating systems. It is widely used in modern web technologies and is part of the popular “LAMP” software...
PreamblePostgreSQL or Postgres is a universal object-relational database management system with open source code and many additional functions that allow you to create fault-tolerant...
PreambleIn this article, you will learn how to query today’s date data in MySQL using the built-in date functions.Getting today's date in MySQL using built-in date functionsSometimes you may...
PreambleMySQL provides you with a useful function called auto increment. You can assign the AUTO_INCREMENT attribute to the table column to create a unique identifier for the new row....
PreambleIt is easy to select the highest or lowest entry in the database table using the MAX or MIN function. However, it is a bit difficult to select the n highest record. For example, to get...
PreambleIn this article, you will learn how to emulate the row_number() function in MySQL. We will show you how to add a sequential integer to each line or group of lines in the result set.Note...
Publicly available web applications are interesting for hackers as resources or earning tools. The range of application of information obtained as a result of hacking is wide: paid access to a...
MySQL is an open-source database management system (DBMS) from Oracle. It was developed and optimized specifically for web applications. MySQL is an integral part of such web services as...