CodeIgniter Forums - Search Results

Search Results

Thread: CURRENT_TIMESTAMP: different mysql-behavior phpmyadmin vs. CI
Post: RE: CURRENT_TIMESTAMP: different mysql-behavior ph...

I found the mistake. There is a bundle of UPDATEs before that. All without modified=NOW() but - of course - mysql set "modified" automatically (because of ON UPDATE CURRENT_TIMESTAMP). Sorry, and tha...

Thread: CURRENT_TIMESTAMP: different mysql-behavior phpmyadmin vs. CI
Post: RE: CURRENT_TIMESTAMP: different mysql-behavior ph...

Pertti Wrote: (11-29-2018, 06:09 AM) -- If you are keeping your queries, you can do PHP Code: -- echo $this->db->last_query(); -- That should give you exact SQL query CI was trying to execute...

Thread: CURRENT_TIMESTAMP: different mysql-behavior phpmyadmin vs. CI
Post: CURRENT_TIMESTAMP: different mysql-behavior phpmya...

Hi, We have a problem with different behavior between executing mysql-query in phpmyadmin and Codeigniter. In the same UPDATE-Query we would like do both save an old timestamp (means: "move" to an ot...

Thread: MariaDB / mysql: JOIN (SELECT ... FROM ... WHERE) USING (...)
Post: RE: MariaDB / mysql: JOIN (SELECT ... FROM ... WHE...

Thank you very much! That works great! Best, kbs170

Thread: MariaDB / mysql: JOIN (SELECT ... FROM ... WHERE) USING (...)
Post: MariaDB / mysql: JOIN (SELECT ... FROM ... WHERE) ...

Hi, is there a function in Codeigniter to use "JOIN .. USING .." like $this->db->join_using()? I use Codeigniter 3.0.4 with mariaDB and need the following statement: Code: -- JOIN (SELECT ... FROM...