SQL

Submitted by: 
In this tutorial, we will convert sql to excel using PHP. This code will read all data from an SQL table then add it into an excel file using a class called "xlsxwriter.class.php". You can download the class using this link from Github Things to do You have to download and install XAMPP or any local server that run PHP scripts. In my case I used XAMPP as my local server, here's the download link...
Submitted by: 
This tutorial tackles on how to get the average of one column in mysql database using PHP. There are instance that we wanted to get the average of one column for reporting purposes like average sales, expenses etc. Normally, we get the sum of the column then we divide it by number of rows but actually there is a sql function that determines the average of one column.
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: 
A tutorial that tackles about SQL Subquery. Subquery is a query within another SQL query. Subqueries can be used with the 4 SQL methods which are SELECT, INSERT, UPDATE and DELETE.
Submitted by: 
The use of limit limits the number of results of your MySQL Query and is usually at the last part of your SQL. This is most applicable if for example, you want to get the top selling product, you just need to order the result then limit it by 1. This tutorial will teach you how to use this limit. Note: Bootstrap CSS and script used in this tutorial are hosted, therefore, you need internet...
Submitted by: 
This is a Simple Login webpage with attractive template. Create an database Database Name : site Remember Small 's' Create a table name login and then input the username and password into the value inside table. Note, For security purpose When inserting the password value use function "MD5" THE ABOVE STEP IS COMPULSORY Then run and use this code in your project. Thanks & abracadabra
Submitted by: 
In this tutorial we will try to send a data from Python to SQLite database. Python is a widely used advance-level programming language for a general technique to the developer. Beginners find Python a clean syntax and indentation structure based, and it is easy to learn because of its less semi colon problem. So let do the coding. Getting started: First you will have to download & install the...
Submitted by: 
<strong>Artbeat</strong> is online shopping website which displays art products. Website Contains shopping cart and category wise gallery. It also provides admin login with the add product and delete product compatibility. Provides user login and password management. Admin reports are not included in this version. <strong><ol> <li>Technologies</li> </ol>...
Submitted by: 
Welcome --------------- Hi Guys! I am Chinthaka Deshapriya from Sri Lanka. I am going to give some valuable source code for beginners of dynamic web developers. Installation ---------------- 01. Extract all content into your host. 02. Create New Database Name "maindb" 03. Import Database from your content in DB folder. Fine! It will work well. Good Luck!
Submitted by: 
In this tutorial, I will teach you how to create a database in SQL Server using the Microsoft SQL Server 2008 and Connect this database in the Visual Studio 2010. So, now let's start this tutorial! 1. Open the SQL Server Management Studio for the first step on creating a database. 2. Right Click on the Database Folder and then click New Database. 3. Create a database name, input a name on it...

Pages