20 articles Uncategorized

SQLite CREATE Table

The SQLite CREATE TABLE statement is used to create a new table in any of the given database. Creating a basic table involves naming the table and defining its columns and each column’s data type.   Syntax: Basic syntax of CREATE TABLE statement is as follows: CREATE TABLE database_name.table_name ( column1 datatype PRIMARY KEY (one…

SQL JOIN

SQL INNERJOIN Before using MySQL INNER JOIN clause, you have to specify the following criteria: First, you have to specify the main table that appears in the FROM clause. Second, you need to specify the table that you want to join with the main table, which appears in the INNER JOIN clause. Theoretically, you can…

MySql Truncate Table

MySQL TRUNCATE TABLE The MySQL TRUNCATE TABLE statement allows you to delete all data in a table. Therefore it is like a DELETE statement without a WHERE clause. However in some cases, the MySQL TRUNCATE TABLE statement is more efficient than the DELETE statement. Syntax TRUNCATE TABLE table_name use the TRUNCATE TABLE statement to see…

File Uploading With Php

This Assignment Using for inserting or uploading file or image into Folder and server.Before Creating Php file you must have knowledge about file upload concept. Here we are Describing the File Uploading Concepts- 1. Read About file[],is_uploaded_file() method, move_uploaded_file() methods. 2.Create new folder where you want to upload files or image. 3.Read About PHP SERVER…