Tag: MySQL database
PreambleSQLShell is a cross-platform command-line tool for SQL, similar to psql for PostgreSQL or MySQL command-line tool for MySQL.Why use it?If you already only use one command-line tool such...
PreambleIf you are a Linux sysadmin or developer, there comes a time when you need to manage an Oracle database that can work in your environment.In this case, it is important to understand...
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....
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....
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...
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...
PreambleWorking with the database is often the weakest point in the performance of many web applications. And you can often see how the same rake comes the developers in the design of the...
In this article, we will learn how to connect to a MySQL database from Java code and execute simple queries to retrieve and update data. In order to access the database, we will use the JDBC...
When switching from MS SQL to MySQL, apart from data migration, you must also transfer the application code, which is in the database.Earlier we discussed how to move MS SQL to a MySQL...
Before starting to create an SQL table, it is necessary to define the database model. Design an ER diagram in which to define the entities, attributes, and relationships. Basic...
If you mainly use open-source programs in your company, and there are several MS SQL server databases, you can consider moving to a MySQL database.Below are a few reasons why you might want...
MySQL is probably the best known relational database management system. As the "M" of the LAMP web development platform, this open-source solution is very popular worldwide.However, its...
MySQL DISTINCT statement is used to remove duplicates from the result set. The DISTINCT operator may be used only with SELECT operators. Syntax DISTINCT operator in MySQL SELECT DISTINCT FROM...
MySQL FROM statement is used to display tables and any associations required for querying in MySQL. Syntax of FROM statement in MySQL FROM table1 [ { INNER JOIN | LEFT [OUTER] JOIN | RIGHT...
MySQL statement SELECT LIMIT is used to extract records from one or more tables into MySQL and limit the number of records to be returned based on the limit value. Syntax of SELECT LIMIT in...
MySQL statement SELECT is used to extract records from one or more tables to MySQL. Simple syntax for SELECT statement in MySQL SELECT expressions FROM tables [WHERE conditions]; The full...