Posts with the tag SQL
Here is how change the root password of MySQL on Ubuntu or Debian:
/etc/init.d/mysql stop mysqld_safe --skip-grant-tables echo "use mysql; update user set password=PASSWORD('newpass') where User='root'; flush privileges;" | mysql -u root -p ## this doesn't work in 'skip-grant-tables' mode: #echo "SET PASSWORD FOR 'root' = PASSWORD('newpass');" |...
search using SQL
SELECT * from bash_history where command LIKE '%modprobe%'
% is the wildcard character in SQL!
The SQLAlchemy SQL Toolkit and Object Relational Mapper is a comprehensive set of tools for working with databases and Python. It has several distinct areas of functionality which can be used individually or combined together. Its major API components, all public-facing, are illustrated below:
+-----------------------------------------------------------+ | ...
Omitted SQL Language Features
you cannot choose table names from the keywords list!!!
enforce foreign keys
SQLite Foreign Key Trigger Generator: http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator
SQLite with Python
Admin tools / GUIs
Open Source, cross platform!
SQLite Database Browser
sudo apt-get install sqlitebrowser
ATTENTION! Do not follow this advice! It is of no use, now that I found the converter for Tags ↔ Categories: Categories to Tags Converter Importer!!!
Sometimes you give posts a tag but realize later it should rather be a category.
What you can do to convert a certain tag –...
When I programatically added most of the blog posts in this blog, I forgot to adjust the date and time of each post to its actual age. So I decided to set it via SQL directly in the database.
First I worked out a
SELECT query to filter all the entries...