Legends, Tables and AMG - SLS .
Sankara is a leader who was ahead of his time and age. I believe he was one of the few African leaders who genuinely wanted the best for his people, country and continent. His rise to power though questionable was what was required for Burkina Faso. He is in my hall of fame besides Gadaffi and Mandela. Anyway how’s the New Year? it’s good to virtually see you in 2023. This is a year of quality over quantity. I pray you achieve your goals for the year. I did a full round trip around Kenya and it’s been amazing. We are blessed with amazing people from the Escarpments of Iten and Highlands of Kabarent Popularly known as ‘KBT’. Its like every Kenyan Town has an acronym. Comment your town’s initials below so that we get to know each town’s shortform name. We have beautiful Senaries and Culture. Kenya is just pulchritudinous.
I want to bring your awareness to Tables. My team being ontop of the table I had to write how tables make our lives easier and better. You can think of a table as a basket carrying all your fruits. The fruits in this case are your data in a database. In simple terms Tables are object that contain all your data. They consist of Columns and Rows. A column is a list of values, usually belonging to a particular field, displayed vertically in a table. A row is an individual entry that exist on a database table. With these two it is possible to store any data you want in the table of your choice. These are the Building blocks of any table.
My cousin- Max introduce me to Top Gear back in 2014. I really enjoyed the show being a big fan of vehicles. I happened to stumble upon an old video of the back then classic Show. It was an episode that featured the Mercedece SLS AMG. A Beautiful car by all standards and a serious racing car. A car that will go into our vintage books as a cocktail of brilliance, elegance and a hint of monstrosity. If you get to reach 2050 you’ll be able to attend a Concours d’Elegance show and admire the damn thing. It’s really a master class of perfection. Jeremy, a host of the show test drives both the petrol and the battery powered vehicle.
At the time the Electric SLS was the first electric super car. The car produces 739 Hps while the petrol engine produces 622Hps. Fun fact- they added a noise feature in the car that produces driving noise because the car is soundless. The car is half a tonne heavier than the 6.2L V8 and has 864 batteries in it. On full charge the SLS gives you arrange of upto 249kms. The only drawback to this beautiful machine is the charge time which takes upto nearly 20hours. Here is a link to the video.
Creating a table in SQL is straight forward.
The basic Syntax of creating a table is;
CREATE TABLE arsenalteam(
Name Char,
Age Int,
Country Char,
…..
columnN datatype,
);
The CREATE TABLE keyword tells the database what you want to do and in this instance it is to create a table with a name, the name in the above table is arsenalteam. After the table name we define the columns and the data type it holds in our above table we have (Name as Char, Age as Int and Country as Char) .
In the table we get the opportunity to define contraints that we want in table. In every table though the primary key is a must as it is an indicator of the column or columns that contain values that uniquely identify each row in a table. Apart from the primary key we have the foreign and unique Keys. All these constraints have their unique purpose in the table. We will discuss more on the Data type and constraints in the next articles.
We can also perform one more action on the table and that is to delete.
DROP TABLE statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table. The syntax for this is;
DROP TABLE arsenalteam;
It simple and easy to follow.
****** SIPS TEA *******
SQL is sweet.
The designers of AMG SLS put in the time and effort to build a beautiful fast car. In my book of design, speed, class and elegance this Mercedes ranks in the Top 10.
Enjoy your weekend and God bless.
Ooh and Don’t forget about our chess matches 7am Everyday except Sunday.
Key
Hp — Horse Power.
