Welcome Guest, Not a member yet? Register   Sign In
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...
4,382 Views
5 Replies
11-29-2018, 08:36 AM
kbs170
    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...
4,382 Views
5 Replies
11-29-2018, 06:22 AM
kbs170
    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...
4,382 Views
5 Replies
11-29-2018, 05:29 AM
kbs170
    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
3,910 Views
2 Replies
10-25-2018, 12:35 PM
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...
3,910 Views
2 Replies
10-24-2018, 03:18 PM
kbs170

Theme © iAndrew 2016 - Forum software by © MyBB