How to get the value of the latest auto-incremented value on a mysql table with concurrent connections
When building a web application it can seem a bit tricky to get the value of the id (primary key) of the latest row inserted in a mysql table.
It is not that complicated.
The function LAST_INSERT_ID() can help you finding that. This function will return the latest auto-incremented value. No need to specify the table, it just takes the latest one.
SELECT LAST_INSERT_ID() ;
The next question is: what happens when I have many concurrent sessions on the same server? Will I get the latest inserted id from another user?
Login and re-login and re-re-login in phpmyadmin is a huge pain.
Here is the way to extend sessions duration.
Open the file config.inc.php in /usr/share/phpmyadmin or in /etc/phpmyadmin
Add the following line:
And in php.ini, modify the following line:
session.gc_maxlifetime = 86400
You now have 24h sessions.
MAC addresses are assigned at the bootup of a virtual machine. But there is a way to assign a fix hardware address to a vmware network interface by editing the virtual machine with Vi.
Simply connect with SSH to your ESXi and go to /vnfs/datastore1 or anywhere you put your vm.
If your virtual machine is called vm1, go to /vmfs/datastore1/vm1
Open the file vm1.vmx using Vi.
Around the end of the file there will be the configuration of the network interfaces.
You should see things like:
Indians seem to be very proud of Qutub Minar. It is a nice sight to visit, no too crowded even on a Saturday afternoon.
As usual when it is available I decided to hire an audio guide. Audio guides will give you only advantages.
First no pseudo fake official guide is going to annoy you and try to get your money in exchange of dodgy historical facts…
Second the information you receive is probably accurate. It probably doesn’t work in every country but I think I can trust India for not trying to change History.
The Lotus Temple is a multi-faith praying temple. It is also known as the Bahá’í House of Worship. Apparently these Bahá’í Houses are sharing some characteristics. They should be roughly rounded and have 9 sides. I looked a bit inside and it was obvious that everything was build around the number 9.
Anyone is welcome to enter the Lotus temple and stay as long as they want. You are welcome to pray for whoever you want and speak to whatever god you want and for as long as you want.
This complex was interesting and peaceful like many other sights in Delhi. A throw stone away from the hustle and bustle of the streets of Delhi but very quiet inside. Some people are repairing some parts of the site. Their kids are playing with them as it is Saturday and they are not at school.