>Digital-flame

In 1983 Computing was anyones' game

Skip to content

Home
Langs
- Delphi
  - Basics
  - Delphi.Masterpiece
  - UniGui
  - FireDAC
  - FireMonkey
  - Indy
  - DataSnap
  - FastReport
- C#
  - Syntax&Basics
  - ADO.NET
  - Entity
  - Algo
  - MVC
  - C#. TelegramCommands
- Java
- JS
  - Js. Basics
  - Webpack
  - ExtJS Framework
  - jQuery
  - React
  - TypeScript
  - CSS
  - InterviewTasks
- PHP
- HTML
DB
VersionControl
- Git
- SVN
Algo
- C#
- Other
DesignPatterns
ToLearn
Author
Other
- IDE and other tools
- IIS
Docker
Music

← MySQL. Удаление записей с истекшим сроком давности

Delphi. Гениальная борьба с WideMemo →

MySQL. Update Records with foreign key

Posted on 14.03.2017 by Stanislav_Panteleev

Delphi/Pascal

SET foreign_key_checks = 0;
UPDATE `unishopmilk_db`.`goods` SET `sortIndex`=:sortIndex WHERE `id`=:id;
SET foreign_key_checks = 1;

1

2

3

SET foreign_key_checks = 0;

UPDATE `unishopmilk_db`.`goods` SET `sortIndex`=:sortIndex WHERE `id`=:id;

SET foreign_key_checks = 1;

This entry was posted in MySQL. Bookmark the permalink.

← MySQL. Удаление записей с истекшим сроком давности

Delphi. Гениальная борьба с WideMemo →

Search for:
MY PROJECTS
Recent Posts
Categories

Proudly powered by WordPress.