plz suggest me query syntex: insert,delete,search.

[bullockc83]

i want to know query syntex: insert,delete,search.
thanks for advance..

[jassaal123]

A query is broken up into terms and operators. There are two types of terms: Single Terms and Phrases.

A Single Term is a single word such as "test" or "hello".

A Phrase is a group of words surrounded by double quotes such as "hello dolly".

Multiple terms can be combined together with Boolean operators to form a more complex query (see below).

Note: The analyzer used to create the index will be used on the terms and phrases in the query string. So it is important to choose an analyzer that will not interfere with the terms used in the query string.

[Jagbani]

Create Table:-
Synatax
create table table_name
(
Id varchar(13),
name varchar(21),
School vatchat(23)
)
Insert Table:-
Synatax
insert table_name values(value1,value2,value3)
Search for the Table
Syantax
select * from table_name where Id='0001'
Delete the Table
Syntax
delete table table_name