Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'h'
- dbSendQuery(con, "CREATE TABLE CITY_INFOS (CITY_NAME text, NORTH_CORD text, EAST_CORD text)")
- dbSendQuery(con, "INSERT INTO CITY_INFOS (CITY_NAME, NORTH_CORD, EAST_CORD)
- SELECT 'Frankfurt am Main', '50.110922' , '8.682127'
- UNION SELECT 'Moskau', '55.755826' , '37.6173'
- UNION SELECT 'München', '48.137108' , '11.575382'
- UNION SELECT 'Hamburg', '53.551085' , '9.993682'
- UNION SELECT 'Berlin', '52.520007' , '13.404954'
- UNION SELECT 'Zürich', '47.372394' , '8.542333'
- UNION SELECT 'St. Gallen', '47.425059' , '9.376588'
- UNION SELECT 'Limoges', '45.833619' , '1.261105'
- UNION SELECT 'Paris', '48.856614' , '2.3522219'
- UNION SELECT 'Brussels', '50.8503396' , '4.3517103'
- UNION SELECT 'Dingolfing', '48.6434808' , '12.4851983'
- UNION SELECT 'Oxford', '51.7520209' , '-1.2577263'
- UNION SELECT 'Bonn', '50.73743' , '7.0982068'")
- 'i'
- dbSendQuery(con, "DROP TABLE CITY_INFOS")
- dbSendQuery(con, "CREATE TABLE CITY_INFOS (CITY_NAME text, NORTH_CORD text, EAST_CORD text, FOREIGN KEY (CITY_NAME) REFERENCES TXW_PLANT(ORT01))")
- dbSendQuery(con, "INSERT INTO CITY_INFOS (CITY_NAME, NORTH_CORD, EAST_CORD)
- SELECT 'Frankfurt am Main', '50.110922' , '8.682127'
- UNION SELECT 'Moskau', '55.755826' , '37.6173'
- UNION SELECT 'München', '48.137108' , '11.575382'
- UNION SELECT 'Hamburg', '53.551085' , '9.993682'
- UNION SELECT 'Berlin', '52.520007' , '13.404954'
- UNION SELECT 'Zürich', '47.372394' , '8.542333'
- UNION SELECT 'St. Gallen', '47.425059' , '9.376588'
- UNION SELECT 'Limoges', '45.833619' , '1.261105'
- UNION SELECT 'Paris', '48.856614' , '2.3522219'
- UNION SELECT 'Brussels', '50.8503396' , '4.3517103'
- UNION SELECT 'Dingolfing', '48.6434808' , '12.4851983'
- UNION SELECT 'Oxford', '51.7520209' , '-1.2577263'
- UNION SELECT 'Bonn', '50.73743' , '7.0982068'")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement