Thoughts on technology, infrastructure, and AI
Viewing posts tagged mysql Clear filter
4 posts found
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...