SQL

Structured Query Language

Submitted by: 
A great way to learn database programming is to have a good sample database with lots of tables and appropriate relationships between them to work with. Queries can then be composed from within a variety of programming platforms, such as Java, PHP, Visual Basic 6, Visual Basic.Net, Visual C#, etc. NorthWind is a free sample database that Microsoft included with every version of Access going all...
Submitted by: 
This tutorial will teach you on how to import tables from .sql file into your MySQL database. SQL files are files that contains intructions about structures of MySQL Database. Most tutorials in the web esp. this site include .sql file as the database of a tutorial.
Submitted by: 
In this tutorial we will create a simple Insert and Delete Record in Database Using PHP/MySQL . This simple tutorial creates or insert a new data from our webpage to our database. You can also delete the data you inserted. The purpose of this simple tutorial is to show the live updates of every data you inserted and deleted. The application is programmed using Bootstrap Framework, PHP, and MySQL...
Submitted by: 
Good Day!!! In this tutorial, we are going to learn about the MySQL Operators and this is the continuation of MySQL Tutorials. My last work was all about the MySQL Reserved Words . In this Chapter, we will know all kinds of Operators in MySQL. Operator Precedence Operators which are shown below, in a line together will they have the same precedence. The precedence in operators, has a rules and...
Submitted by: 
Good Day!!!! In this chapter of my tutorial, we will discuss all the Reserved Words in MySQL. SQL is a language that made up of keywords - special words that we used in performing SQL operations. We're not supposed used these keywords when naming a databases , tables , columns and any other database objects . Thus, these all keywords are considered reserved. Reserved Words These are the following...
Submitted by: 
Good Day!!! In this tutorial, we are going to learn about the MySQL Language Syntax and this is the continuation of MySQL Tutorials. My last work was all about the Installation of MySQL . In this Chapter, we will know how most actions on a database are performed using the SQL statements. SQL Statements This is the free-form language for SQL, statements are the following: Uppecase or Lowercase...
Submitted by: 
Good Morning!!! To make some follow-up with my tutorial, MySQL Intro, Today, I decided to make another tutorial on how the Installation of MySQL . In this Chapter, explains installation procedure of MySQL. Download Installation Package For the installation of MySQL, they have an installation package and can be downloaded directly from the MySQL Downloads page, which can be found at www.mysql.com/...
Submitted by: 
In this tutorial I am going to teach you one of the most important MySQL techniques that you must use in your software development. Today huge amount of business use MySQL as their data base. Imagine if their database corrupted what would be happen ?, If your server crashed what word you do ? So we must use database backup technique to overcome those issues. Now I am going to explain you one of...
Submitted by: 
Modern day software application has millions of concurrent users. Development of efficiently serviceable application needs huge amount of effort, usage of lot of tools and techniques. Software developers always try to improve performance of the application by improving design, cording and database development. When we consider database development query optimization and evaluation techniques are...
Submitted by: 
Introduction: This tutorial is going to be covering the basic syntax of SQL queries in MySQL and MySQLi. MySQL and MySQLi...? MySQLi is an updated version of the original MySQL language. Both versions use almost exactly the same syntax although MySQLi should be used as it is more secure, updated and reliable. Query Syntax: To create a MySQL(i) query, you combine different MySQL(i) keywords...

Pages