Create a small SQL COMMAND Script

Closed Posted Apr 17, 2014 Paid on delivery
Closed Paid on delivery

Looking for someone to create a small script in php that will easily echo out SQL command lines simply by entering columns & table names.

I would like to cover all the basic commands as possible such as:

Basic SQL Commands

SQL SELECT

SQL DISTINCT

SQL WHERE

SQL AND OR

SQL IN

SQL BETWEEN

SQL Wildcard

SQL LIKE

SQL ORDER BY

SQL GROUP BY

SQL HAVING

SQL ALIAS

SQL AS

SQL SELECT UNIQUE

SQL INSERT INTO

SQL INSERT INTO SELECT

SQL UPDATE

SQL DELETE FROM

The basic structure of the script should look similar to the lines below:

SELECT [ALL | DISTINCT] (column1),[(column2)]

FROM table1 [,<table2>]

[WHERE]

[GROUP BY] (column-list)

[HAVING] (conditions)

[ORDER BY (column-list) [ASC | DESC]]

All values in the [ ] are optional;

If there are any questions please ask.

PHP

Project ID: #5821155

About the project

16 proposals Remote project Active May 24, 2014

16 freelancers are bidding on average $43 for this job

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

$206 USD in 1 day
(468 Reviews)
7.5
PHPsoldier

Dear Sir, I can create you a query builder where user will be able to select table and fields. Regards....

$100 USD in 5 days
(53 Reviews)
5.8
caneadysl

Hi Requirement is clear. Can deliver this as it is. I am a master of sql more than 11 years. PM me for getting touch.

$35 USD in 1 day
(42 Reviews)
5.5
elboukharimu

Aucune proposition n'a encore été fournie.

$30 USD in 1 day
(6 Reviews)
4.0
soulmind22

A proposal has not yet been provided

$35 USD in 3 days
(3 Reviews)
3.0
yasirijaz

You want a gui interface for database For example you enter a table name it will give you a complete command of sql

$40 USD in 2 days
(1 Review)
0.6
marcelandrade

Ainda não foi fornecida uma proposta

$25 USD in 10 days
(0 Reviews)
0.0
blonk

Hello, I Have been experienced with PHP and MySQL since i was in college, it was 4 years ago and i am being continue to working as a web developer until now. I will finish the job in a day or less. as a new Freelan More

$25 USD in 1 day
(0 Reviews)
0.0
mukilanbarath

We will be happy to finish your demands. We have knowldege about php,html,javascript . and also the basics of jsp and servlet. We also do backend works with mysql and have good knowledge about rdms working. Our ini More

$20 USD in 1 day
(0 Reviews)
0.0