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
Tag: SQL Commands
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)
How to Delete table from databse
Drop table from database SQL>drop table <table name> Example: SQL> drop table smarttips Table dropped
How to Delete all data in the SQL table
Truncate the Table SQL>truncate table <table name> Example: SQL>truncate table smarttips;
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