Thoughts on technology, infrastructure, and AI
Viewing posts tagged mysql Clear filter
pip install pgcli mycli These are replacements for the standard mysql and postgresql command line clients. This is appealing because it provides a (somewhat) consistent end user experience to these da...
Just learned how to use variables in mysql - the variables are bound to the specific client session - and are destroyed on disconnect. SET @varname = value SELECT max(value) from table into @varname S...
Starting from Mysql 5.0.2, mysql now supports triggers - which can be quite handy. I'm using them to automatically create new (derived) table records when a user submits data to my web app. Syntax is...
I finally had a chance to sit down and learn the syntax of creating mysql users and assigning specific permissions. This allows me to have different users for different web services - eg. cron jobs, w...