Previously, we covered creating tables in SQL. To create a column in a table, use the ALTER TABLE statement, along with the ADD and then define a column name followed by the data type: ALTER TABLE nameoftable ADD nameofcolumn datatype To delete a column in a table:: ALTER TABLE nameoftable DROP COLUMN nameofcolumn To change the type of data stored in a column, use MODIFY: ALTER TABLE nameoftable MODIFY COLUMN nameofcolumn datatype In this article, we’ll use the same “Customers” table from our first articles to add and edit columns: ID Site Contact Address City Zip Country 1 Krypted Charles Edge my house Minneapolis 55418 US 2 Apple Tim Cook…
-
-
Link Data In Multiple Tables Using The SQL JOIN Clause
A SQL JOIN clause combines rows from tables, based on a field shared between them (often a joining or ID field). There are four types of JOINs: INNER JOIN: Show rows when there’s a match in BOTH tables LEFT JOIN: Show rows in the left table with the rows that match up from the right table RIGHT JOIN: Show rows in the right table with rows that match up in the left table FULL JOIN: Show rows with a match in at least one table In this article, we’ll use the same “Customers” table from our first articles: ID Site Contact Address City Zip Country 1 Krypted Charles Edge my house…
-
Your First SQL Statement
Databases and Tables A SQL database is an organized collection of data. Or at least that’s what they taught me in college. In real life, it’s only as organized as the people putting data into the database. Databases contain schemas, tables, stored procedures, reports, views and other objects. Most databases will contain multiple tables. Tables contain rows that have data in them. I like to think of a database kinda’ like an Excel spreadsheet. Each tab on a spreadsheet is similar to a table; each row is similar to a row in a database and each column in the spreadsheet is somewhat similar to a column, or attribute. The headers…
-
FitBit Flex vs FitBit One: Ten Reasons the One Wins
I loved my FitBit Flex. I thought it was the best thing ever. It tracked how much I walked, was a silent alarm to wake me up, tracked my sleep patterns, estimated the number of calories I burned and gave my daughter something to do while bored standing beside me (who doesn’t love to tap on things to make LEDs light up). Then one day, I got an alert on my phone that there was a firmware update for the Flex. I tapped to update, watched it start and then poof, the FitBit went into a Cylon state where the LEDs just flashed from side to side until the battery…