Tables löschen

  • Hallo Community,

    habe eine Frage wie löscht man richtig die LOCK und UNLOCK TABLES?

    Beispiel:

    SQL
    LOCK TABLES `biz` WRITE;
    /*!40000 ALTER TABLE `biz` DISABLE KEYS */;
    INSERT INTO `biz` VALUES ('BAUMARKT',2413.4,-1422.23,23.9782,'no-one',0,486460),('BOMBSHOPBAHNHOFLS',1841.9,-1859.24,13.3828,'no-one',5625,289600),('BOMBSHOPKRANKENHAUSLS',1103.23,-1191.25,18.245,'no-one',6225,199500),('CLUCKINGBELL',1801.06,-1918.57,13.3933,'no-one',0,747450),('CS:BAYSIDE',-2191.92,2410.87,4.9583,'no-one',0,1215500),('CS:COUTT',2136.23,-1152.93,23.9922,'no-one',0,895500),('CS:OTTO',-1650.79,1209.37,7.25,'no-one',0,1756500),('CS:PLANES',1954.16,-2177.66,13.5469,'no-one',0,1263550),('CS:TELEVISION',756.281,-1358.1,13.5142,'no-one',0,1100530),('CS:WANG',-1962.6,291.48,35.4739,'no-one',0,1356500),('DONUT',1041.46,-1338.11,13.7266,'no-one',0,489344),('PNSBEACH',491.583,-1733.29,11.279,'no-one',0,475500),('PNSBRIDGE',-2420.61,1029.94,50.3906,'no-one',0,354600),('PNSDILLIMORE',716.761,-464.51,16.3437,'no-one',0,272500),('PNSNORD',1019.87,-1032.57,31.8517,'no-one',100,540000),('PNSPIZZA',2073.91,-1827.82,13.5469,'no-one',0,475500),('PNSWANGCARS',-1908.95,276.172,41.0469,'no-one',0,462500),('TANKEALHAMBRA',1929.48,-1776.38,13.5469,'no-one',0,475600),('TANKEANGELPINE',-2232.36,-2557.95,31.9219,'no-one',0,167420),('TANKEDILLIMORE',661.064,-573.458,16.3359,'no-one',0,216400),('TANKELSEINGANG',-79.0579,-1169.64,2.15335,'no-one',0,275000),('TANKEMONTGOMERY',1374.26,468.705,20.1999,'no-one',0,195700),('TANKENORD',1013.11,-929.455,42.3281,'no-one',25,354000),('TANKERASTSTAETTE',2918.54,-646.437,11.0205,'no-one',0,295750),('TANKESFBRIDGE',-2419.75,969.865,45.2969,'no-one',0,322500),('TANKESFPD',-1675.57,431.513,7.17969,'no-one',0,316400),('TANKEWHETSTONE',-1614.39,-2727.65,48.6889,'no-one',0,152504),('WELLSTACKEDPIZZA',2102.72,-1809.48,13.5547,'no-one',0,658655);
    /*!40000 ALTER TABLE `biz` ENABLE KEYS */;
    UNLOCK TABLES;

    so löscht man Jetzt die ganze LCOK TABLES Zeile sprich: LOCK TABLES `biz` WRITE;
    Oder anders?

    Projektaufbau:

    |||||||||||||||||||||||||||||||||||||||||||||||||| 40% Fortschritt

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!