Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: Zapytanie sql...
Forum PHP.pl > Forum > Bazy danych > MySQL
assasin
8.04.2010, 16:25:58
Witam mam takie zapytanie:

INSERT INTO `quest_template` VALUES ('66634', 'tekst1, 'tekst2', 'tekst3', 'Tekst4.', 'Tekst4?', '0');


i tam są wartości kolejno dla danych komórek.. 

[SQL] pobierz, plaintext 
  1. `entry` int(11) UNSIGNED NOT NULL DEFAULT '0',
  2.   `Title` text,
  3.   `Details` text,
  4.   `Objectives` text,
  5.   `OfferRewardText` text,
  6.   `RequestItemsText` text,
  7.   `EndText` text,
[SQL] pobierz, plaintext




PostWysłany: Dzisiaj 17:03 Temat postu: Zapytanie SQL. Odpowiedz z cytatem Zmień/Usuń ten post Zgłoś Post

Witam mam takie zapytanie:

INSERT INTO `quest_template` VALUES ('66634', 'tekst1, 'tekst2', 'tekst3', 'Tekst4.', 'Tekst4?', '0');


i tam są wartości kolejno dla danych komórek..

Kod:
`entry` int(11) unsigned NOT NULL default '0',
`Title` text,
`Details` text,
`Objectives` text,
`OfferRewardText` text,
`RequestItemsText` text,
`EndText` text,


A ja mam tabele


DROP TABLE IF EXISTS `quest_template`;

[SQL] pobierz, plaintext 
  1. CREATE TABLE `quest_template` (
  2.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  3.   `Method` tinyint(3) UNSIGNED NOT NULL DEFAULT '2',
  4.   `ZoneOrSort` smallint(6) NOT NULL DEFAULT '0',
  5.   `SkillOrClass` smallint(6) NOT NULL DEFAULT '0',
  6.   `MinLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  7.   `QuestLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  8.   `Type` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  9.   `RequiredRaces` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  10.   `RequiredSkillValue` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  11.   `RepObjectiveFaction` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  12.   `RepObjectiveValue` mediumint(9) NOT NULL DEFAULT '0',
  13.   `RequiredMinRepFaction` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  14.   `RequiredMinRepValue` mediumint(9) NOT NULL DEFAULT '0',
  15.   `RequiredMaxRepFaction` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  16.   `RequiredMaxRepValue` mediumint(9) NOT NULL DEFAULT '0',
  17.   `SuggestedPlayers` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  18.   `LimitTime` int(10) UNSIGNED NOT NULL DEFAULT '0',
  19.   `QuestFlags` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  20.   `SpecialFlags` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  21.   `CharTitleId` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  22.   `PrevQuestId` mediumint(9) NOT NULL DEFAULT '0',
  23.   `NextQuestId` mediumint(9) NOT NULL DEFAULT '0',
  24.   `ExclusiveGroup` mediumint(9) NOT NULL DEFAULT '0',
  25.   `NextQuestInChain` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  26.   `SrcItemId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  27.   `SrcItemCount` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  28.   `SrcSpell` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  29.   `Title` text,
  30.   `Details` text,
  31.   `Objectives` text,
  32.   `OfferRewardText` text,
  33.   `RequestItemsText` text,
  34.   `EndText` text,
  35.   `ObjectiveText1` text,
  36.   `ObjectiveText2` text,
  37.   `ObjectiveText3` text,
  38.   `ObjectiveText4` text,
  39.   `ReqItemId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  40.   `ReqItemId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  41.   `ReqItemId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  42.   `ReqItemId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  43.   `ReqItemCount1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  44.   `ReqItemCount2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  45.   `ReqItemCount3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  46.   `ReqItemCount4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  47.   `ReqSourceId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  48.   `ReqSourceId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  49.   `ReqSourceId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  50.   `ReqSourceId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  51.   `ReqSourceCount1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  52.   `ReqSourceCount2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  53.   `ReqSourceCount3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  54.   `ReqSourceCount4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  55.   `ReqSourceRef1` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  56.   `ReqSourceRef2` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  57.   `ReqSourceRef3` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  58.   `ReqSourceRef4` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  59.   `ReqCreatureOrGOId1` mediumint(9) NOT NULL DEFAULT '0',
  60.   `ReqCreatureOrGOId2` mediumint(9) NOT NULL DEFAULT '0',
  61.   `ReqCreatureOrGOId3` mediumint(9) NOT NULL DEFAULT '0',
  62.   `ReqCreatureOrGOId4` mediumint(9) NOT NULL DEFAULT '0',
  63.   `ReqCreatureOrGOCount1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  64.   `ReqCreatureOrGOCount2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  65.   `ReqCreatureOrGOCount3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  66.   `ReqCreatureOrGOCount4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  67.   `ReqSpellCast1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  68.   `ReqSpellCast2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  69.   `ReqSpellCast3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  70.   `ReqSpellCast4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  71.   `RewChoiceItemId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  72.   `RewChoiceItemId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  73.   `RewChoiceItemId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  74.   `RewChoiceItemId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  75.   `RewChoiceItemId5` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  76.   `RewChoiceItemId6` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  77.   `RewChoiceItemCount1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  78.   `RewChoiceItemCount2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  79.   `RewChoiceItemCount3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  80.   `RewChoiceItemCount4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  81.   `RewChoiceItemCount5` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  82.   `RewChoiceItemCount6` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  83.   `RewItemId1` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  84.   `RewItemId2` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  85.   `RewItemId3` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  86.   `RewItemId4` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  87.   `RewItemCount1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  88.   `RewItemCount2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  89.   `RewItemCount3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  90.   `RewItemCount4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  91.   `RewRepFaction1` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  92.   `RewRepFaction2` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  93.   `RewRepFaction3` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  94.   `RewRepFaction4` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  95.   `RewRepFaction5` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
  96.   `RewRepValue1` mediumint(9) NOT NULL DEFAULT '0',
  97.   `RewRepValue2` mediumint(9) NOT NULL DEFAULT '0',
  98.   `RewRepValue3` mediumint(9) NOT NULL DEFAULT '0',
  99.   `RewRepValue4` mediumint(9) NOT NULL DEFAULT '0',
  100.   `RewRepValue5` mediumint(9) NOT NULL DEFAULT '0',
  101.   `RewHonorableKills` mediumint(9) UNSIGNED NOT NULL DEFAULT '0',
  102.   `RewOrReqMoney` int(11) NOT NULL DEFAULT '0',
  103.   `RewMoneyMaxLevel` int(10) UNSIGNED NOT NULL DEFAULT '0',
  104.   `RewSpell` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  105.   `RewSpellCast` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  106.   `RewMailTemplateId` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  107.   `RewMailDelaySecs` int(11) UNSIGNED NOT NULL DEFAULT '0',
  108.   `PointMapId` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  109.   `PointX` float NOT NULL DEFAULT '0',
  110.   `PointY` float NOT NULL DEFAULT '0',
  111.   `PointOpt` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  112.   `DetailsEmote1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  113.   `DetailsEmote2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  114.   `DetailsEmote3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  115.   `DetailsEmote4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  116.   `IncompleteEmote` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  117.   `CompleteEmote` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  118.   `OfferRewardEmote1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  119.   `OfferRewardEmote2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  120.   `OfferRewardEmote3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  121.   `OfferRewardEmote4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  122.   `StartScript` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  123.   `CompleteScript` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  124.   PRIMARY KEY (`entry`)
  125. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System'; 
[SQL] pobierz, plaintext


I jak przerobić moje zapytanie tak żeby po wysłaniu do bazy zaktualizowało wartości w tabeli o ID 66634..
erix
8.04.2010, 16:56:04
Temat: Jak poprawnie zada pytanie
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.