Ipctrd (A Computer Learning Blogs)

Types of Phones:- CDMA (Code Division Multiple Access) — A network that digitizes communication using a specific frequency; it behaves much like GSM, but the two are not compatible. Before traveling internationally, be sure to find out which is used to make sure your phone will work when you reach your destination. GSM (Global System for Mobile Communications) — A digital cellular network which behaves much like CDMA, but the two are not compatible. GSM is commonly used in Europe. 3G phones — "Third-generation" devices. Third generation technology makes it possible for cell phones to accommodate broadband wireless data in addition to traditional cell phone functionality (e.g. e-mail download and Internet access). There are other Internet technologies that perform similarly but are not called "3G" specifically. Features Accessories — Manufacturers offer a number of accessories that can make phones even more convenient to use, such as hands-free options (hea...

MYSQL TRUNCATE statement removes the complete data without removing its structure. The TRUNCATE TABLE statement is used when you want to delete the complete data from a table without removing the table structure. Syntax: TRUNCATE TABLE  table_name; Example: This example specifies how to truncate a table. In this example, we truncate the table "cus_tbl". TRUNCATE TABLE  cus_tbl; See the table: SELECT* FROM cus_tbl; MySQL DROP Table MYSQL DROP table statement removes the complete data with structure. Syntax: DROP TABLE  table_name; Example: This example specifies how to drop a table. In this example, we are dropping the table "cus_tbl". DROP TABLE  cus_tbl; MySQL TRUNCATE Table vs DROP Table:- You can also use DROP TABLE command to delete complete table but it will remove complete table data and structure both. You need to re-create the table again if you have to store some data. But in the case of TRUNCATE TABLE, it removes only table data not st...