delphi tokyo.
Server: localhost via TCP/IP
Server type: MariaDB
Server version: 10.1.21-MariaDB - mariadb.org binary distribution
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
table collation utf8mb4_general_ci
Code: Select all
Myquery2.SQL.Clear;
Myquery2.SQL.Add('UPDATE users SET TempCommand = ' + QuotedStr('') + ' where UserID=' + QuotedStr(UserID));
Myquery2.SQL.Add('UPDATE address SET address_state = ' + QuotedStr(Title) + ' where UserID=' + QuotedStr(UserID));
Myquery2.Prepared := True;
Myquery2.Execute;
but when use this command in direct phpmyadmin work.#42000You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UPDATE address SET address_state = 'الامارات' where UserID='90434024'' at line 2 > EMyError