In this second part of the MySQL Beginner Series Basics, I will explore various uses of the
ALTER TABLE syntax. Part 1 covered the
CREATE command, establishing a database, table, and user. This blog post will build from there, so be sure to visit that post to get up to speed.
In this blog post, I will cover example uses of the
\copy meta-command, for client-side work with the PostgreSQL database server. This command allows users who do not have Superuser privileges, to perform
Ever needed or wanted to save particular query results for later? Perhaps you need to really study something for better understanding. Scrutinize a dataset with a hawk’s eye while having a coffee? Or just list out all of the tables in the database you are working in? The
\o meta-command is your new best friend.
Triple P threat to all data files!!! Hahahaha… Now that I have myself collected and together, in this blog post I will utilize Python, Psycopg2, and PostgreSQL for a bulk upload, importing data from a
CSV file to a database table. (more…)