PHP Classes

Support INSERT SET notation

Recommend this page to a friend!

      Light PHP SQL Parser Class  >  All threads  >  Support INSERT SET notation  >  (Un) Subscribe thread alerts  
Subject:Support INSERT SET notation
Summary:Add support for MySQL INSERT SET notation
Messages:4
Author:André Dias
Date:2018-05-29 12:06:22
 

  1. Support INSERT SET notation   Reply   Report abuse  
Picture of André Dias André Dias - 2018-05-29 12:06:22
Thanks for making this class. In MySQL at least it is possible to insert rows using syntax like:

INSERT INTO table_name SET table_field='123', table_field2='456';

If you have interest you could expand your class to support such constructs.

  2. Re: Support INSERT SET notation   Reply   Report abuse  
Picture of Marco Cesarato Marco Cesarato - 2018-05-29 12:34:04 - In reply to message 1 from André Dias
Hi André. Thank you for your report i will implement this syntax very soon.

  3. Re: Support INSERT SET notation   Reply   Report abuse  
Picture of Marco Cesarato Marco Cesarato - 2018-05-29 12:44:03 - In reply to message 1 from André Dias
Hi André!
In the version 0.1.82 now is implemented this syntax.
Let me a feedback for be sure.
Thank you.

  4. Re: Support INSERT SET notation   Reply   Report abuse  
Picture of André Dias André Dias - 2018-05-29 13:11:35 - In reply to message 3 from Marco Cesarato
Thanks, it is working fine ;-)