SQLme Files

********************************************************************

SQLme DataBase Management System V.1.2 
SQLme is A Little DataBase Managment System
Proff F. Amiri DataBase Systems Project
 Created By NIMIX3 (Nima Akhlaghi)
Under GNU V.3 License
Copyright 2013 Open Source Projects & GNU v.3
Download Free From : www.ProForums.ir | www.NIMIX3.com

********************************************************************

SQLme Console Supports The Following Syntax Below :

Note !  Words in brackets shows that which data should input there
                and Words Out of brackets shows the SQLme Supported Keywords .
             SQLme Supports both UpperCase & LowerCase of Syntax or Table names .
             Feel Free When Enter Correct Syntax ( But Avoid To Enter spaces where syntax not support )
             Any spaces between Syntax Keyword were resolve by Engine ( but in some cases in keywords data you
               should follow the SQLme Syntax to avoid occuring errors .

At The First You Need To INCLUDE (embed)  the  "SQLme.Class.php" File into your App File.
Then You Sould Use   SQLme_connect("dbname");   to connect your own DataBase.
After That don't Try To Use SQLme Functions  Just Use   SQLme_Query("dbname",{SQLmeCODE})   to make query in your database.
At last You Should close the DataBase by disconnecting from it , for that use   SQLme_disconnect()  and disconnect from last open database.

--------------------------------------------------------------------

1. SELECT  [Attribs name { multiple data that separate with comma } ]  FROM  [Table name]  Where  [Attrib name](< or > or = or ~ or <= or >=)[a value]  ORDERBY  [Attrib name]

Example :  SELECT  *  FROM  Table1  WHERE  name~nima  ORDERBY  name
Example :  Select  name,family  From  table1  Orderby  name
Example :  Select  g,name  From  table1  Where  g>100

NOTE !  After Select Syntax Keyword You can enter multiple data separate with comma ,
              SQLme Not Support  AND / OR / NOT / ... Syntax yet  :|
              SQLme Support multiple data input separate with comma where we says that , not everywhere !

--------------------------------------------------------------------

2. INSERT INTO  [Table name]  VALUES  [ Record Data { multiple data that separate with comma } ]

Example :  INSERT INTO  table1  VALUES  nima,22,Isfahan,123
Example :  Insert Into  table2  Values  a,b,c,d
Example :  Insert Into  table3  Values  john

NOTE !  The number of data that enter as VALUES  should be  the  same with Attribs number.  
              SQLme Not Support  AND / OR / NOT / ... Syntax yet  :|
              SQLme Support multiple data input separate with comma where we says that , not everywhere !

--------------------------------------------------------------------

3. DROP TABLE  [Table name]

Example :  DROP TABLE  table1
Example :  Drop Table  table1

NOTE !  The Table you want to DROP should Exist in DataBase.
              SQLme Not Support  AND / OR / NOT / ... Syntax yet  :|

--------------------------------------------------------------------

4. REPORT TABLE  [Table name]

Example :  REPORT TABLE  table1
Example :  Report Table  table1

NOTE !  The Table you want to REPORT should Exist in DataBase.
              SQLme Not Support  AND / OR / NOT / ... Syntax yet  :|

--------------------------------------------------------------------

5. DELETE FROM  [Table name]  INDEX [Index of Table Record]

Example :  DELETE FROM  table1  INDEX 2
Example :  Delete From  table1  Index 2

NOTE !  The Table you want to DELETE from it and correct record INDEX should Exist in DataBase.
              SQLme Not Support  AND / OR / NOT / ... Syntax yet  :|

--------------------------------------------------------------------

6. CREATE DATABASE  [Database name]

Example :  CREATE DATABASE  myDB1
Example :  Create Database  myDB1

NOTE !  The DataBase you want to CREATE should be unique or not exist in Database or not created before. 

--------------------------------------------------------------------

7. CREATE TABLE  [Table name]   [Attribs name { multiple data that separate with comma }]

Example : CREATE TABLE  myTable  st#,name,family
Example :  Create Table  myTable  st#,name,family

NOTE !  The Table  you want to CREATE should be unique or not exist in Database or not created before. 
               If you want to replace this new Table with old one you should DROP that old one and CREATE this new one.
--------------------------------------------------------------------

*** In Next Version We Try To ADD some Synatx and Security layers like ACCESS LEVEL and User Groups