1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75:
| procedure TForm1.btBeendenClick(Sender: TObject); begin application.terminate; end;
procedure TForm1.btDatenbankClick(Sender: TObject); var query : string; ErrorCode : integer; begin hDaten := tDaten.create; mysql_create_db( hDaten.Descriptor, hDaten.zDB ); btTabellen.Visible := true; hDaten.free; end;
procedure TForm1.btTabellenClick(Sender: TObject); var query : string; query1 : string; query2 : string; query3 : string; query4 : string; query5 : string; query6 : string; query7 : string; query8 : string; query9 : string; query10 : string; query11 : string; query12 : string; query13 : string; query14 : string; query15 : string; query16 : string; query17 : string; query18 : string; queryEx : string; ErrorCode : Integer; begin hDaten := tDaten.create; mysql_select_db(hDaten.Descriptor, hDaten.zDB); query := 'CREATE TABLE mannschaften(id bigint( 10 ) NOT NULL AUTO_INCREMENT, name VARCHAR( 50 ) NOT NULL, '+'bild VARCHAR( 100 ) NOT NULL, nation CHAR( 3 ) NOT NULL, PRIMARY KEY (id))'; mysql_real_query(hDaten.Descriptor, PChar(query), length(query)); query := 'CREATE TABLE spieler(id bigint(10) NOT NULL AUTO_INCREMENT, vorname varchar(50), nachname varchar(50) NOT NULL, bild varchar(100) NOT NULL,'; queryEx := ' dob varchar(15) NOT NULL, groesse int(3) NOT NULL, nation char(3) NOT NULL, verein bigint(10), wert bigint(10), PRIMARY KEY(id))'; mysql_real_query(hDaten.Descriptor, PChar(query+queryEx), length(query+queryEx)); query := 'CREATE TABLE nationen(id int(3) NOT NULL auto_increment,land varchar(30) NOT NULL default '', bild varchar(100) NOT NULL default '', PRIMARY KEY (id))'; mysql_real_query(hDaten.Descriptor, PChar(query), length(query));
query :='INSERT INTO nationen( id, land , bild ) VALUES (1, Afghanistan , AFG ), (2, Ägypten , ET ), (3, Albanien , AL ), (4, Algerien , DZ ), (5, Andorra , AND ), (6, Angola , ANG ), (7, Äquatorial-Guinea , GQ ), (8, Argentinien , RA )'; query1 :=', (9, Aserbaidschan , AZ ), (10, Äthiopien , ETH ), (11, Australien , AUS ), (12, Bahamas , BS ), (13, Bahrain , BRN ),(14, Bangladesch , BD ),(15, Barbados , BDS ),(16, Belgien , B ),(17, Belize , BH ),(18, Benin , DY )'; query2 :=',(20, Bolivien , BOL ),(21, Bosnien-Herzegowina , BIH ),(22, Botswana , RB ),(23, Brasilien , BR ),(24, Brunei , BRU ),(25, Bulgarien , BG ),(26, Burkina Faso , BF ),(27, Burundi , RU ),(28, Chile , RCH ),(29, China , RC )'; query3 :=',(31, Dänemark , DK ),(32, Dem. Rep. Kongo , CD ),(33, Deutschland , D ),(34, Dominica , WD ),(35, Dominikanische Rep. , DOM ),(36, Ecuador , EC ),(37, El Salvador , ES ),(38, Elfenbeinküste , CI ),(39, England , England )'; query4 :=',(41, Estland , EST ),(42, Färöer , FR ),(43, Fidschi , FJI ),(44, Finnland , FIN ),(45, Frankreich , F ),(46, Gabun , G ),(47, Gambia , WAG ),(48, Georgien , GE ),(49, Ghana , GH ),(50, Gibraltar , GBZ ),(51, Grenada , WG )'; query5 :=',(52, Griechenland , GR ),(53, Guatemala , GCA ),(54, Guinea , RG ),(55, Guinea-Bissau , GN ),(56, Guyana , GUY ),(57, Haiti , RH ),(58, Honduras , HN ),(59, Hongkong , HK ),(60, Indien , IND ),(61, Indonesien , RI ),(62, Irak , IRQ )'; query6 :=',(63, Iran , IR ),(64, Irland , IRL ),(65, Island , IS ),(66, Israel , IL ),(67, Italien , I ),(68, Jamaika , JA ),(69, Japan , J ),(70, Jemen , YAR ),(71, Jordanien , JOR ),(72, Kambodscha , K ),(73, Kamerun , CAM )'; query7 :=',(75, Kap Verde , CV ),(76, Kasachstan , KZ ),(77, Katar , Q ),(78, Kenia , EAK ),(79, Kirgisistan , KS ),(80, Kiribati , KIR ),(81, Kolumbien , CO ),(82, Kongo , RCB ),(83, Kroatien , HR ),(19, Bhutan , BHT ),(30, Costa Rica , CR )'; query8 :=',(84, Kuba , C ),(85, Kuwait , KWT ),(86, Laos , LAO ),(87, Lesotho , LS ),(88, Lettland , LV ),(89, Libanon , RL ),(90, Liberia , LB ),(91, Libyen , LAR ),(92, Liechtenstein , FL ),(93, Litauen , LT ),(40, Eritrea , ER )'; query9 :=',(94, Luxemburg , L ),(95, Madagaskar , RM ),(96, Malawi , MW ),(97, Malaysia , MAL ),(98, Malediven , MV ),(99, Mali , RMM ),(100, Malta , M ),(101, Marokko , MA ),(102, Marshall-Inseln , MH ),(103, Mauretanien , RIM )'; query10 :=',(104, Mauritius , MS ),(105, Mazedonien , MK ),(106, Mexiko , MEX ),(107, Moldawien , MD ),(108, Monaco , MC ),(109, Mongolei , MGL ),(110, Mosambik , MOC ),(111, Myanmar , MYA ),(112, Namibia , NAM ),(113, Nepal , NEP )'; query11 :=',(74, Kanada , CDN ),(123, Österreich , A ),(124, Pakistan , PK ),(125, Panama , PA ),(136, Samoa , WS ),(137, San Marino , RSM ),(138, Santa Lucia , WL ),(147, Sierra Leone , WAL ),(148, Simbabwe , ZW ),(149, Singapur , SGP )'; query12 :=',(150, Slowakei , SK )`,(161, Syrien , SYR ),(162, Tadschikistan , TJ ),(163, Tansania , EAT ),(164, Thailand , THA ),(176, Uruguay , ROU ),(177, USA , USA ),(178, Usbekistan , ZU ),(179, Vanuatu , VU ),(180, Venezuela , YV )'; query13 :=',(114, Neuseeland , NZ ),(115, Nicaragua , NIC ),(116, Niederlande , NL ),(117, Niederländische Antillen , NA ),(118, Niger , RN ),(119, Nigeria , WAN ),(120, Nordirland , Nordirland ),(121, Norwegen , N ),(122, Oman , OM )'; query14 :=',(126, Papua-Neuguinea , PNG ),(127, Paraguay , PY ),(128, Peru , PE ),(129, Philippinen , RP ),(130, Polen , PL ),(131, Portugal , P ),(132, Ruanda , RWA ),(133, Rumänien , RO ),(134, Russland , RUS ),(135, Sambia , Z )'; query15 :=',(139, Sao Tome und Principe , STP ),(140, Saudi-Arabien , KSA ),(141, Schottland , Schottland ),(142, Schweden , S ),(143, Schweiz , CH ),(144, Senegal , SN ),(145, Serbien & Montenegro , YU ),(146, Seychellen , SY )'; query16 :=',(151, Slowenien , SLO ),(152, Somalia , SP ),(153, Spanien , E ),(154, Sri Lanka , CL ),(155, St. Vincent , WV ),(156, Südafrika , ZA ),(157, Sudan , SUD ),(158, Süd-Korea , ROK ),(159, Surinam , SME ),(160, Swasiland , SD )'; query17 :=',(165, Togo , RT ),(166, Trinidad , TT ),(167, Tschad , TCH ),(168, Tschechien , CZ ),(169, Tunesien , TN ),(170, Türkei , TR ),(171, Turkmenistan , TM ),(172, Tuvalu , TUV ),(173, Uganda , EAU ),(174, Ukraine , UA )'; query18 :=',(175, Ungarn , H ),(181, Vereinigte Arab , UAE ),(182, Vietnam , VN ),(183, Wales , Wales ),(184, Weißrussland , BY ),(185, Zentralafrikanische Rep. , RCA ),(186, Zypern , CY ),(0, Unbekannt , Unbekannt )';
mysql_real_query(hDaten.Descriptor, PChar(query + query1 + query2 + query3 + query4 + query5 + query6 + query7 + query8 + query9 + query10 + query11 + query12 + query13 + query14 + query15 + query16 + query17 + query18), length(query + query1 + query2 + query3 + query4 + query5 + query6 + query7 + query8 + query9 + query10 + query11 + query12 + query13 + query14 + query15 + query16 + query17 + query18)); hDaten.free; end; |