CIMOT – SQL v.1_0

TUTORIAL

 

PREVIOUS <       > NEXT

 

5. CLIENT SIDE QUERY

 

5.1. TABLES MANAGER 

 

5.1.1. HOW TO CREATE TABLES

 

To create tables use Create Table Tabbed Pane in Table Manager Tabbed Panes. In the first text field insert your desired Table Name and in the second text field insert your desired Field Name followed with Field Type and then click Create Table button

 

 

You may also create as many as Field in the Table, just separate each Field with coma(,) after the last Field Type.

 

Below is original MySQL syntax to create Table:

 

mysql> create table marlboro (medium varchar(9));

 

or

 

mysql> create table marlboro (medium varchar(9), light int(9));

 

In CIMOT-SQL v.1_0 we only need to insert each value in the text fields:

 

	marlboro

 

first text field

 

	medium varchar(9)

 

second text field                                                                                   or

 

	medium varchar(9),light varchar(9)

 

second text field

 

 

5.1.2. HOW TO SHOW TABLES

 

To show available tables that are available in the database simply use the Show Tables Tabbed Pane in Tables Manager Tabbed Panes, and click Show Tables button.

 

 

 

The original MySQL syntax to Show Tables is:

 

mysql> show tables;

 

 

5.1.3. HOW TO DESCRIBE TABLES

 

To see what Fields available inside a Tables use Describe Table Tabbed Pane in Tables Manager Tabbed Panes, insert desired Table Name to described then click Describe Table button.

 

 

The original MySQL syntax to Describe Table is:

 

mysql> describe marlboro;

 

In CIMOT-SQL v.1_0 we only need to insert the text field with the desired Table Name to be describe:

 

	marlboro

 

 

 

 

 

5.1.4. HOW TO CHANGE FIELDS NAME IN TABLES

 

To Change Field Name in the Tables use Change Field Tabbed Pane in Tables Manager Tabbed Panes, insert the Table Name in first text field, insert the current Field Name we want to change in the second text field, insert the new Field Name and the new Field Type in the third text field, and then click Change Field button.

 

 

The original MySQL syntax to Change Field Name is:

 

mysql> alter table marlboro change medium superlight varchar(9) ;

 

In CIMOT-SQL v.1_0 we only need to insert the text field with proper value:

	marlboro

 

first text field

 

 

	medium

 

second text field

 

 

	superlight varchar(9)

 

third text field

 

 

 

5.1.5. HOW TO CHANGE FIELDS TYPE IN TABLES

 

To Change Field Type use Change Field Type Tabbed Pane in Tables Manager Tabbed Panes. Insert the Table Name in the first text field, insert the current Field Name which we want to change it Type in the second text field , insert the new Field Type in the third text field.

 

 

The original MySQL syntax to Change Field Type is:

 

mysql> alter table marlboro modify superlight int(9) ;

 

In CIMOT-SQL v.1_0 we only need to insert the each text field with proper value:

	marlboro

 

first text field

 

	superlight

 

second text field

 

	int(9)

 

third text field

 

 

5.1.6. HOW TO ADD FIELDS IN TABLES

 

To Add New Field in the Table use Add Field Tabbed Pane in Tables Manager Tabbed Panes. Insert the Table Name in the first text field, insert the new Field Name and the Field Type in the second text field, then click Add Field button

 

 

The original MySQL syntax to Add Field is:

 

mysql> alter table marlboro add lightmenthol vachar(9) ;

 

In CIMOT-SQL v.1_0 we only need to insert the each text field with proper value:

	marlboro

 

first text field

 

	lightmenthol

 

second text field

 

	varchar(9)

 

third text field

 

 

 

5.1.7. HOW TO DELETE FIELDS IN TABLES

 

To Delete Field in the Table use Drop Field Tabbed Pane in Tables Manager Tabbed Panes. Insert the Table Name in the first text field, insert the current Field Name we want to deleted in the second text field, then click Drop Field button.

 

 

The original MySQL syntax to Delete Field is:

 

mysql> alter table marlboro add lightmentol vachar(9) ;

 

In CIMOT-SQL v.1_0 we only need to insert the each text field with proper value:

	marlboro

 

first text field

 

	lightmenthol

 

second text field

 

 

 

5.1.8. HOW TO CHANGE TABLES NAME

 

To Change Table Name use Change Table Name Tabbed Pane in Tables Manager Tabbed Panes. Insert the current Table Name we want to change in the first text field, insert the new Table Name in the second text field, then click Change Table Name button.

 

 

The original MySQL syntax to Change Table Name is:

 

mysql> alter table marlboro rename luckystrike ;

 

In CIMOT-SQL v.1_0 we only need to insert the each text field with proper value:

	marlboro

 

first text field

 

	luckystrike

 

second text field

 

 

 

5.1.9. HOW TO DELETE TABLES FROM DATABASES

 

To Delete Table from the database use Drop Table Tabbed Pane in Tables Manager Tabbed Panes. Insert the current Table Name we want to delete in the text field, then click Drop Table button.

 

 

The original MySQL syntax to Delete Table is:

 

mysql> drop table luckystrike ;

 

In CIMOT-SQL v.1_0 we only need to insert the text field with the name of Table Name we want to delete.

	luckystrike

 

 

 

 

 

 

 

 

5.2. FIELDS MANAGER

 

 

5.2.1. HOW TO ADD FIELDS VALUES IN TABLES

 

There are 2 different ways to add Field Values in a Table , the first choice is if we want to add Field Values without mentioning specifically which Field that we want give specific value, and the result is the first Value will be input into the first Field in the Table, the second Value will be input into the second Field in the Table and so on. To use the first choice use the Insert Into Table #1 Tabbed Pane in Fields Manager Tabbed Panes. Insert the Table Name in the first text field, insert the Field Value in the second text field, then click Insert Into Table button.

 

 

The original MySQL syntax to Add Field Value for the first choice is:

 

we assume the Table Name is potatochips, and the Field Name and the Field Type are price int(9) , taste varchar(9).

 

mysql> insert into potatochips values ( 1;’crispy’);

 

In CIMOT-SQL v.1_0 we only need to insert the each text field with proper value:

 

	potatochips

 

first text field

 

	1,’crispy’

 

second text field

 

don’t forget to add ‘’ symbol to crispy because the second Field Type is varchar ( taste varchar(9)).

 

 

The second choice is if we want to Add specific Value into a specific Field Name in a Table, we can use the  Insert Into Table #2 Tabbed Pane in Field Manager Tabbed Panes, insert the Table Name in the first text field, insert the specific Field Name in the second text field, insert the Field Values in the third text field, then click Insert Into Table button.

 

 

The original MySQL syntax to Add Field Value for the second choice is:

 

we assume the Table Name is potatochips, and the Field Name and the Field Type are price int(9) , taste varchar(9), barcode int(15)

 

mysql> insert into potatochips (price,barcode) values (1,4756813264756);

 

In CIMOT-SQL v.1_0 we only need to insert the each text field with proper value:

 

	potatochips

 

first text field

 

	price,barcode

 

second text field

 

	1, 4756813264756

 

third text field

 

 

 

5.2.2. HOW TO SHOW FIELDS VALUES IN TABLES

 

There are several different ways to show Field Values in a Table, as in CIMOT-SQL.1_0 the choices available is using 3 different MySQL conditional keyword they are:

select field_name  from table_name;

select* from table_name where field_name = field_value;

select* from table_name or insert_your_additional_conditional_keyword_and_conditional_value;

 

Above 3 choices is based on your sorting of values in the table. To use the first choice we will use Select From Table #1 Tabbed Pane from Fields Manager Tabbed Panes. Insert the Field Name or Fields Name in the first text field, insert the Table Name in the second text field, then click Select Field From Table button

 

 

The original MySQL syntax to Show Fields Values for the first choice is:

 

mysql> select price from potatochips;

 

or

 

mysql> select price,taste,barcode from potatochips;

 

 

In CIMOT-SQL v.1_0 Show Fields Values for the first choice is:

 

	price

 

first text field

 

	potatochips

 

second text field

 

or

	price,taste,barcode

 

first text field

 

	potatochips

 

second text field

 

 

To use the second choice to show Fields Values, we use Select* From Table #2 Tabbed Pane in Fields Manager Tabbed Panes. Insert the Table Name in the first text field, insert the Field Name in the second text field, insert your available  Field Value in the third text field. Then click Select From-Where button

 

 

The original MySQL syntax to Show Fields Values using the second choice  is:

 

mysql> select* from potatochips where barcode= 4756813264756;

 

 

In CIMOT-SQL v.1_0 to Show Fields Values for the second choice is:

 

	potatochips

 

first text field

 

	barcode

 

second text field

 

	4756813264756

 

third text field

 

 

 

To use the third choice to show Fields Values, we use Select* Tabbed Pane in Fields Manager Tabbed Panes. In this choice you can sort the Field  Values in many different way, insert the conditional Keyword in the text field regarding the Field Value you wanted to show, then click Select* button.

 

 

Below is 3 example in using the third choice in original MySQL syntax:

 

 

mysql>select* from potatochips where barcode= 4756813264756 and taste=‘crispy’;

 

mysql>select* from potatochips where left(kode,1)=”T”;

 

mysql>select* from potatochips having left(kode,1)=”T”;

 

In CIMOT-SQL v.1_0 to above 3 examples will look like below:

 

	potatochips where barcode= 4756813264756 and taste=‘crispy’

 

 

 

 

	potatochips where left(kode,1)=”T”

 

 

 

	potatochips having left(kode,1)=”T”

 

 

 

 

 

 

5.2.3. HOW TO UPDATE FIELDS VALUES IN TABLES

 

The meaning of Update Fields Values is we change the current Fields Value with new one, to Update Field Value use the Update Field Value Tabbed Pane in Fields Manager Tabbed Panes, insert the Table Name in the first text field, insert the current Field Name in the second text field, insert the new Field Value for the current Field Name in the third text field, insert the index Field Name in the fourth text field, insert the index Field Value in the fifth text field. Then click Update Field button.

 

 

 

The original MySQL syntax to Update Fields Values is:

 

mysql> update potatochips set barcode= 123456789 where taste= 'crispy';

 

 

In CIMOT-SQL v.1_0 Show Fields Values for the first choice is:

 

	potatochips

 

first text field

 

	barcode

 

second text field

	123456789

 

 

third text field

	taste

 

fourth text field

 

	‘crispy’

 

fifth text field

 

 

 

 

 

5.2.4. HOW TO DELETE FIELDS VALUES IN TABLES

 

To Delete Field Values use the Delete From Field Tabbed Pane in Fields Manager Tabbed Panes, insert the Table Name in the first text field, insert the current Field Name in the second text field, insert the Field Value for the current Field Name in the third text field, then click Delete Value button.

 

          

 

The original MySQL syntax to Delete Fields Values is:

 

mysql> delete from potatochips where barcode= 123456789;

 

 

In CIMOT-SQL v.1_0 to Delete Field Value will be like this:

 

	potatochips

 

first text field

 

	barcode

 

second text field

	123456789

 

 

third text field

 

 

 

 

 

PREVIOUS <       > NEXT