Blogroll
Search
Blogroll
Categories
Forums
Category Archives: Blog Development
Quicken 2020 synching issues resolved
20200411 Update: The fix appears to be: ensure the Wells Fargo Account name is exactly same in Quicken — also case sensitive (put in all caps). Also, I’m correlating an improvement by editing the account in Quicken to not automatically … Continue reading
Querying the database – looking up stuff
Note: This is the part where I might do most of my entries — searching for stuff within the database. Not quite running reports — that’s later. Select (variable name) from (table name) — returns all records For example: Select … Continue reading
Create southwind database and table
CREATE DATABASE southwind; /*creates a new database and names it*/ SHOW DATABASES; /*displays all databases*/ USE southwind; /*tells mysql which database you want to work with*/ SELECT DATABASE; /*tells you which database has been selected*/ SHOW TABLES; /*displays any tables … Continue reading