Day 270 of writing every day.
After receiving a late night reply to my daily report yesterday, I decided to put the hint I received in the comment and use the snippet of command code that I was missing. Once I started the code with “use” I was able to insert data directly into a database I created in the command prompt with MariaDB active.
“Create database [insert database name]” is the starting command that merely sets up a named container that is the database; it stores data that is organized by tables. A newly created database is empty though and my practice then continues with “create table [insert table name] (column_name value_type, column_name value_type) for as long as I need to in order to create the table with however many columns of info it would hold.
Once the table is ready, then I can start inserting data into it by using “insert into table_name values (value for each column in order)” to get things going. The column name can be skipped if inserting data for all the columns, but will need to be specified in cases where only data is being added to certain columns.
I’ll keep this note short today.
Thanks for reading!
One Chance Works 