CIMOT – SQL v.1_0

TUTORIAL

 

> NEXT

 

TABLE OF CONTENT: 

1. INTRODUCING CIMOT-SQL v.1_0

2. MYSQL BASIC FUNDAMENTAL TUTORIAL

3. HOW TO CONNECT TO MYSQL SERVER USING CIMOT-SQL v.1_0

4. DATABASE ADMINISTRATOR SIDE QUERY

      4.1. HOST MANAGER

                  4.1.1. HOW TO CREATE NEW USERS

                  4.1.2. HOW TO GIVE PRIVILEGES ACCESS TO USERS

                  4.1.3. HOW TO CHANGE HOST TO USERS

                  4.1.4. HOW TO CHANGE USERS NAME

                  4.1.5. HOW TO CHANGE USERS PASSWORD

                  4.1.6. HOW TO CHANGE ACCESS PRIVILEGES TO USERS

                  4.1.7. HOW TO DELETE USERS

4.2. DATABASE MANAGER

4.2.1. HOW TO CREATE NEW DATABASES

4.2.2. HOW TO SHOW DATABASES

4.2.3. HOW TO USE DATABASES

4.2.4. HOW TO DELETE DATABASES

       5. CLIENT SIDE QUERY

            5.1. TABLES MANAGER

                        5.1.1. HOW TO CREATE TABLES

                        5.1.2. HOW TO SHOW TABLES

                        5.1.3. HOW TO DESCRIBE TABLES

                  5.1.4. HOW TO CHANGE FIELDS NAME IN TABLES

                  5.1.5. HOW TO CHANGE FIELDS TYPE IN TABLES

                  5.1.6. HOW TO ADD FIELDS IN TABLES

                  5.1.7. HOW TO DELETE FIELDS IN TABLES

                        5.1.8. HOW TO CHANGE TABLES NAME

                        5.1.9. HOW TO DELETE TABLES FROM DATABASES  

5.2. FIELDS MANAGER

5.2.1. HOW TO ADD FIELDS VALUES IN TABLES

5.2.2. HOW TO SHOW FIELDS VALUES IN TABLES

5.2.3. HOW TO UPDATE FIELDS VALUES IN TABLES

5.2.4. HOW TO DELETE FIELDS VALUES IN TABLES

6.  ADVANCE MYSQL USER PANEL

                  6.1 EXECUTE QUERY SYNTAX

                  6.2 EXECUTE UPDATE SYNTAX

 

> NEXT