Home » Tag Archives: SQL Commands

Tag Archives: SQL Commands

Relational Operators in sql

Programmers are using number of relational operators for producing required results Commonly used ones are = Equalto < lessthan > greater than <= lessthan or equalto >= greater than or equal to <> IS NOT ! not ^ like -like operator

Read More »

How to see table stucture in SQL

table stucture in SQL SQL>desc <table name> Example: SQL>desc smarttips Name       Null                    Type Id              NOT NULL      NUMBER(2) Name                                   varchar(10)

Read More »

How to ALTER table in SQL

ALTER a table in SQL Use the following commands for add,change,drop table fields in SQL. SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name> ALTER TABLE  `test` ADD  `test INT NOT NULL ALTER TABLE  `test` DROP `name` ALTER TABLE  `test` CHANGE  `name`  `student_name` INT( 11 ) NOT NULL

Read More »