SQL

Structured Query Language

Andy's Oracle utilities

Submitted by DaisyLucy12 on
(01) display the printable and space ASCII characters and their codes (02) bump up sequences (03) display a calendar with this PL/SQL procedure (04) check the free space in your database (05) check for object dependencies (06) DBMS_JOB job scheduler INTERVAL examples (07) delete duplicates in a table with one SQL statement (08) describe all tables, views, and materialized views (09) PL/SQL does

How to Create a simple Registration Form in PHP/MySQLi and HTML

Submitted by Yorkiebar on
Introduction: This tutorial will cover creating a register form with PHP/MySQLi/HTML. Steps of Creation: Step 1: First, we need to create a database to hold the user accounts. This is done through MySQL/PHPMyAdmin. On your localhost/web host cPanel/Control Panel go to MySQL Databases and create a new one (for example; the name of your site - Mine will be "tutorial"). Next, go to PHPMyAdmin and

3 SQL Version of NorthWind Database

Submitted by nostradamus1566 on
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

Insert and Delete Record in Database Using PHP/MySQL

Submitted by rinvizle on
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.

MySQL Operators

Submitted by alpha_luna on

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.

MySQL Reserved Words

Submitted by alpha_luna on
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.

MySQL Language Syntax

Submitted by alpha_luna on

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.

MySQL Installation

Submitted by alpha_luna on

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/downloads.
Subscribe to SQL