Jump to content
  • 0

Составить запрос на заполнение строк языка


angelShlesser
 Share

Question

Имею таблицу saite1

8730900cf322356396a0c4d43a71c392.png

Добавить name_loc0, то есть заполнить.

66ff1a5deaa1c217c4749a910ee163dc.png

Дамп через phpmyadmin


-- phpMyAdmin SQL Dump
-- version 3.5.4
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Янв 10 2013 г., 03:10
-- Версия сервера: 5.5.27-28.1
-- Версия PHP: 5.3.3-7+squeeze14
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- База данных: `saite1`
--
-- ——————————————————--
--
-- Структура таблицы `saite1`
--
CREATE TABLE IF NOT EXISTS `saite1` (
`itemsetID` smallint(3) unsigned NOT NULL,
`name_loc0` varchar(255) NOT NULL,
PRIMARY KEY (`itemsetID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
--
-- Дамп данных таблицы `saite1`
--
INSERT INTO `saite1` (`itemsetID`, `name_loc0`) VALUES
(1, 'The Gladiator'),
(41, 'Dal''Rend''s Arms'),
(65, 'Spider''s Kiss'),
(81, 'The Postmaster'),
(121, 'Cadaverous Garb'),
(122, 'Necropile Raiment'),
(123, 'Bloodmail Regalia'),
(124, 'Deathbone Guardian'),
(141, 'Volcanic Armor'),
(142, 'Stormshroud Armor'),
(143, 'Devilsaur Armor'),
(144, 'Ironfeather Armor'),
(161, 'Defias Leather'),
(162, 'Embrace of the Viper'),
(163, 'Chain of the Scarlet Crusade'),
(181, 'Magister''s Regalia'),
(182, 'Vestments of the Devout'),
(183, 'Dreadmist Raiment'),
(184, 'Shadowcraft Armor'),
(185, 'Wildheart Raiment');

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. See more about our Guidelines and Privacy Policy