Skip to main content

Posts

Showing posts from June, 2013

sql inda all country in database

CREATE TABLE country ( id int NOT NULL , country_code varchar(5) NOT NULL default '', country_name varchar(100) NOT NULL default '', ) -- INSERT INTO country VALUES (1, 'US', 'United States'); INSERT INTO country VALUES (2, 'CA', 'Canada'); INSERT INTO country VALUES (3, 'AF', 'Afghanistan'); INSERT INTO country VALUES (4, 'AL', 'Albania'); INSERT INTO country VALUES (5, 'DZ', 'Algeria'); INSERT INTO country VALUES (6, 'DS', 'American Samoa'); INSERT INTO country VALUES (7, 'AD', 'Andorra'); INSERT INTO country VALUES (8, 'AO', 'Angola'); INSERT INTO country VALUES (9, 'AI', 'Anguilla'); INSERT INTO country VALUES (10, 'AQ', 'Antarctica'); INSERT INTO country VALUES (11, 'AG', 'Antigua and/or Barbuda'); INSERT INTO country VALUES (12, 'AR', 'Argentina'); INSERT INTO country VALUES