Skip to content

Instantly share code, notes, and snippets.

-- phpMyAdmin SQL Dump
-- version 3.3.5-rc1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Авг 25 2010 г., 01:45
-- Версия сервера: 5.4.3
-- Версия PHP: 5.2.13-pl0-gentoo
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
1.
UPDATE Products_menu
SET date_of_delivery = GETDATE()
WHERE date_of_delivery = NULL
2.
DELETE FROM Products_menu
WHERE measurement < 100 AND price > 70