>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
React
Js. Basics
Webpack
ExtJS Framework
jQuery
React
TypeScript
CSS
InterviewTasks
PHP
HTML
DB
SQL
Projecting
MySQL
Postgres
Delphi & DBExpress
Delphi & FireDAC
VersionControl
Git
SVN
Algo
Algo.Java
C#
Other
DesignPatterns
ToLearn
Author
Other
IDE and other tools
IIS
Docker
Music
Reading Books
R.C.Martin Clean architecture, some remarks from reading
SQL.Tips
TechInterview
←
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
Java.Servlet.What authentication methods are available to a servlet?
Java.Servlet.What are the main features introduced in the Servlet 3 specification?
Java.Servlet.Should i close connection in my code if i use connection pool ?
Java.Servlet.If i created connection pool, when it should be destroyed ?
Java.Servlet.How can we organize a database connection, provide logging in a servlet?
Java.Servlet.How can we provide transport layer security for our web application?
Java.Servlet.What is an effective way to ensure that all servlets are accessible only to a user with a valid session?
Java.Servlet.How can we notify an object in a session that the session is invalid or expired?
Java.Servlet.What is session ?
Java.Servlet.What exactly encodeRedirectURL does ?
Java.Servlets.What is the purpose and difference between encodeURL() and encodeRedirectURL()?
Java.Servlet.What is URL Rewriting?
Java.Servlet.Can i delete Cookie ?
Java.Servlet.What are the methods for working with cookies provided in servlets?
Java.Servlet.What are cookies?
Java.Servlet.What are the different methods of session management in servlets?
Java.Servlets.What happens to symbols when i don’t encode them in URL, give example ?
Java.Servlets.What does URL encoding mean? How can it be implemented in Java?
Java.Servlet.Explain the SingleThreadModel interface.
Java.Servlet.Can PrintWriter and ServletOutputStream be used simultaneously in a servlet?
Categories
Aptana
Azure
C#
DataSnap
DBExpress
Delphi
Delphi и сети
Delphi. Язык программирования
ExtJS
FastReport
FireDAC
FireMonkey
GIT
ICS
IDE
IIS
Indy
InnoSetup
javascript
jQuery
JSON
LiveBindings
MSHTML
MySQL
PHP
REST
Ribbons
SMS
SQL инструкции
SVN
TRichView
UniGui
WebBroker
WinAPI
Windows
Алгоритмы
Без рубрики
Деревья
Ищу ответ
Компонентостроение
Мои компоненты
Начальный уровень
Обработка исключений
Парсинг
Потоки(Threads)
Регулярные выражения
Тестирование приложений