Welcome Guest, Not a member yet? Register   Sign In
[SOLVED] How to change db connection in CI
#4

(This post was last modified: 01-31-2018, 12:01 AM by plonknimbuzz.)

(01-30-2018, 06:14 AM)Narf Wrote:
(01-30-2018, 02:26 AM)plonknimbuzz Wrote: this is valid sql server query but not in mysql, because the right query in mysql is: INSERT INTO `table` (`id`, `name`) VALUES ('1', 'john')

That's not entirely true.

Double quotes are the correct identifier escape character per the SQL standards and MySQL does support that via the ANSI_QUOTES SQL mode.

Did you mean this?

[Image: hJ5T100.png]

thanks narf, this is new knowledge for me.
Reply


Messages In This Thread
RE: [SOLVED] How to change db connection in CI - by plonknimbuzz - 01-30-2018, 11:57 PM



Theme © iAndrew 2016 - Forum software by © MyBB