create account

SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy? by dbzfan4awhile

View this thread on: hive.blogpeakd.comecency.com
· @dbzfan4awhile ·
$4.04
SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?
![](https://steemitimages.com/DQmTBV3SSA4aSPPieGL3GxrEwH5JSvpuXfTgsWiLyrQeiB1/image.png)
[Source](https://imgflip.com/i/222wd0)

Good Morning, Afternoon, Evening, Happy Holidays, Good Vacation, etc.

So here we are again, talking again about SQL Queries and Logic. It was brought to my attention by @bronevik (thank you for pointing that out to me, by the way) that my previous lesson may have jumped-the-gun as there are a couple of other SQL statements that should have been explained before it. I always like to see where I can do better with my teaching... heck, I'm only Human and sometimes I assume understanding where I should not.

So it is with pride that I make myself better and backtrack to teach the concepts and logic behind the 2 statements that @bronevik has pointed out to me.

___

![](https://steemitimages.com/DQmVu4cdtaqLpNkFptrPB31AhEBnkoiVDAVscjA9NLHrP1C/image.png)
[A Null Pointer... Programmer Humor that you might understand after this section](https://www.google.com/search?q=null&source=lnms&tbm=isch&sa=X&ved=0ahUKEwiiirTx1LzYAhXp6YMKHZPnDVwQ_AUIDSgE&biw=1280&bih=633#imgrc=WkfauAbiiK8PsM:)

_**The Basic Concept of NULL**_

It occurs to me that I probably have to step back first to explain to some what the term _NULL_ actually means. The _NULL_ keyword is, essentially, a way to say "There is NOTHING here." What this means is that there is absolutely no value. I know, this sounds like a pretty basic concept, but it goes deeper than what you might consider as nothing... it is not 0, it is not an empty text field, it is not an empty container. Basically there _is_ no container, it takes away even the concept of 0 or the empty text field. It's like a Time Traveler went into the past _after_ the Query ran and removed the field completely. There's no value, no whole, no negative space, no _anything_.

As is defined well in the Wikipedia post [Here](https://en.wikipedia.org/wiki/Null_(SQL)):

_"Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database. Introduced by the creator of the relational database model, E. F. Codd, SQL Null serves to fulfil the requirement that all true relational database management systems (RDBMS) support a representation of "missing information and inapplicable information". Codd also introduced the use of the lowercase Greek omega (ω) symbol to represent Null in database theory. In SQL, NULL is a reserved word used to identify this marker."_

The problem with _NULL_ values lies in the fact that most early programming languages, spreadsheets, or data manipulation tools cannot truly understand the _non-value_ that _NULL_ represents. Therefore, programmers and data analysts usually (it doesn't always happen, but it's a good "best practice" to consider) check against data types being _NULL_. Newer Programming Languages have been set up with a way to handle _NULL_ "values" in queries and data returns.

___

https://youtu.be/HkZeUa53Jyg
[Source](https://www.youtube.com/watch?v=gn6BDeKn-qc)

_**"You have Sunk my Battleship... IS NULL?**_

Even DEATH may be confused as to this one. If Bill & Ted were playing a game and had truly sunk DEATH's Battleship, would it be NULL? This is going to be funky (made up table names and fields):

_SELECT status FROM BogusGames WHERE player = 'DEATH' AND game = 'BattleShip' AND token = 'BattleShip' AND hit_count = '4' AND wins IS NOT NULL_

The above query would never return a row with the _wins_ field holding a _NULL_ value. This means that the field will always have some sort of value. _IS NOT NULL_ filters the query by telling the _DBMS (Database Management System)_ not to return any rows if the _wins_ field has not been set at all (and this does not mean the field is blank... it is not even blank).

Additionally, you could query with _IS NULL_ as the filter if you wanted to find out how many rows have the field actually set to _NULL_ specifically. This can be done to verify data and _UPDATE_ rows when the field value(s) contain(s) _NULL_ values.

_SELECT status FROM BogusGames WHERE player = 'DEATH' AND game = 'BattleShip' AND token = 'BattleShip' AND hit_count = '4'_

This query, on the other hand, could conceivably return a _NULL_ value if the _wins_ field has not been set at all for the returned results. Mind also that if the field is set to _allow NULLs_ then the person setting the data could intentionally leave it as a _NULL_ value.

https://youtu.be/Z3sLhnDJJn0
[Source](https://www.youtube.com/watch?v=3EkBuKQEkio)

___

_**The IN Crowd**_

This alternate method to using any _JOIN_ statements can be used to filter data based on a _subquery_ that defines a separate list of results. A _subquery_ is literally a subordinate query that is run first in order to find a set of values to filter based on. It's a great way to get into filtering queries with other database tables without having to _JOIN_ the Dark Side. An example is below:

![](https://steemitimages.com/DQmRHSuyoxxBfS2QGRFVjs9yZCQs6rr7kzxA2caJkp7j57T/image.png)

As you can see above, I ran 4 different queries to show data. I am using the SchoolChildren and BackPack tables to show how to get data from one table using a _sub-query_ from another table along with the _IN_ SQL statement. This will help you understand how this is used to limit the initial data.

You can see the initial 2 queries (_select * from SchoolChildren_ and _select * from BackPack_) at the top and the corresponding results are the 2 upper sets of results. Basically it says "return everything" from each of those queries. This is like my scientific Baselines... it returns everything so you can check the results of the other queries to verify the data if you feel the need.

The 3rd query is the bulk query utilizing the _IN_ statement to add a _sub-query_ to the mix in order to filter the base query by the results of the _sub-query_. The 4th query is just added to isolate the _sub-query_ so that you can see the results.

So... what happens when the larger query with the _sub-query_ is executed is that it, first, queries the _sub-query_ to find the filtered range of data. You can see the results of that query as the lowest set of results. Now it puts these result items in for the _WHERE_ clause, so it effectively reads like this afterwards:

_SELECT * FROM BackPack 
WHERE id IN ('1', '4', '5')_

*Note: this is a viable option as well, if you know the values to query against.

In essence, it says "find all the results that have an _id_ value of 1, 4, or 5 and show all corresponding fields from the BackPack table". It is a perfectly acceptable way to handle data and a great way to filter out unwanted material _before_ the larger mass of data is returned. Doing this will make the queries run faster and is one step to optimize queries for speed and efficiency.

![](https://steemitimages.com/DQmUq6iTAUjUQfTTBXJik4pZbpVd5MwJqe2RJDbNgwz9xMD/image.png)
[Dora's Backpack... could be what you're trying to find?](https://www.google.com/search?biw=1280&bih=633&tbm=isch&sa=1&ei=xUFNWoznKZ22jwSO6q7QBQ&q=backpack+dora&oq=backpack+dora&gs_l=psy-ab.3..0l8j0i5i30k1l2.10181.13326.0.13581.7.6.1.0.0.0.101.493.5j1.6.0....0...1c.1.64.psy-ab..0.7.502....0.JBd-4EcpHFs#imgrc=zJCJodOYQOPXSM:)

One note about using _sub-queries_ is that you are only allowed to return a single field's values to compare to the field just before the _IN_ statement (in this example, it compares the _id_ results from the SchoolChildren table with the _backpack_id_ field in the BackPack table).

Before getting overly complicated and compiling difficulty, I just want to take a step back and look at the big picture.

![](https://steemitimages.com/DQmcud7AGWTzzkr6V7F5iiWLPjrPbWwbwCBWCXDeq5EtSjK/image.png)
[I think I have an idea!](https://www.google.com/search?biw=1280&bih=633&tbm=isch&sa=1&ei=1EFNWuTyDqHLjwSu9bzoAQ&q=big+picture&oq=big+picture&gs_l=psy-ab.3..0l10.71724.72905.0.73160.11.8.0.3.3.0.97.602.8.8.0....0...1c.1.64.psy-ab..0.11.612...0i67k1.0.aoAf5A-boTw#imgdii=LpcqI1CmhbXQpM:&imgrc=Txh7Cjnjll-arM:)

Yep, that was a rather large picture. I liked it.

___

Thanks to everyone for making my Tutorials at least a minor success. I appreciate all the views and votes of confidence. 

If you want me to focus on anything in particular or go back to anything, just leave a comment and inquire into it. We're still just scratching the surface.

![](https://steemitimages.com/DQmZx1n2vmjcC9irVnfzSLJCRRQhvK8QXv4otf3uebKCZoJ/image.png)
[We'll look deeper](https://www.google.com/search?biw=1280&bih=633&tbm=isch&sa=1&ei=skNNWrCcJpfijwTKsI7gAQ&q=spy+with+magnifying+glass&oq=spy+with+magnifying+glass&gs_l=psy-ab.3..0j0i5i30k1.5843.7274.0.7768.3.3.0.0.0.0.125.267.2j1.3.0....0...1c.1.64.psy-ab..0.3.266...0i7i30k1j0i7i5i30k1.0.0gyFCpdBUZ8#imgrc=3r9wEroworK3LM:)

___

If you need refreshers or need to go back to read some of my earlier posts in this Series before continuing onward, please feel free to do so now. Here is a list of links to those Posts:

[SQL Beginner's Tutorial: Relational Databases & SQL](https://steemit.com/steemiteduction/@dbzfan4awhile/sql-beginner-s-tutorial-relational-databases-and-sql)
[SQL Beginner's Tutorial: Writing your First Queries](https://steemit.com/sql-forbeginners/@dbzfan4awhile/sql-beginner-s-tutorial-writing-your-first-queries)
[SQL Beginner's Tutorial: SELECT Data to Use in the Game](https://steemit.com/utopian-io/@dbzfan4awhile/sql-beginner-s-tutorial-select-data-to-use-in-the-game)
[SQL Beginner's Tutorial: Manipulate Data for Use in the Game](https://steemit.com/utopian-io/@dbzfan4awhile/sql-beginner-s-tutorial-manipulate-data-for-use-in-the-game)
[SQL Beginner's Tutorial: JOIN Me and Together We Will Rule the Universe](https://steemit.com/sql-forbeginners/@dbzfan4awhile/sql-beginner-s-tutorial-join-me-and-together-we-will-rule-the-universe)
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , ,
properties (23)
authordbzfan4awhile
permlinksql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners","database","tutorial","technology","gaming"],"users":["bronevik"],"image":["https://steemitimages.com/DQmTBV3SSA4aSPPieGL3GxrEwH5JSvpuXfTgsWiLyrQeiB1/image.png","https://steemitimages.com/DQmVu4cdtaqLpNkFptrPB31AhEBnkoiVDAVscjA9NLHrP1C/image.png","https://img.youtube.com/vi/HkZeUa53Jyg/0.jpg","https://img.youtube.com/vi/Z3sLhnDJJn0/0.jpg","https://steemitimages.com/DQmRHSuyoxxBfS2QGRFVjs9yZCQs6rr7kzxA2caJkp7j57T/image.png","https://steemitimages.com/DQmUq6iTAUjUQfTTBXJik4pZbpVd5MwJqe2RJDbNgwz9xMD/image.png","https://steemitimages.com/DQmcud7AGWTzzkr6V7F5iiWLPjrPbWwbwCBWCXDeq5EtSjK/image.png","https://steemitimages.com/DQmZx1n2vmjcC9irVnfzSLJCRRQhvK8QXv4otf3uebKCZoJ/image.png"],"links":["https://imgflip.com/i/222wd0","https://www.google.com/search?q=null&source=lnms&tbm=isch&sa=X&ved=0ahUKEwiiirTx1LzYAhXp6YMKHZPnDVwQ_AUIDSgE&biw=1280&bih=633#imgrc=WkfauAbiiK8PsM:","https://en.wikipedia.org/wiki/Null_(SQL)","https://youtu.be/HkZeUa53Jyg","https://www.youtube.com/watch?v=gn6BDeKn-qc","https://youtu.be/Z3sLhnDJJn0","https://www.youtube.com/watch?v=3EkBuKQEkio","https://www.google.com/search?biw=1280&bih=633&tbm=isch&sa=1&ei=xUFNWoznKZ22jwSO6q7QBQ&q=backpack+dora&oq=backpack+dora&gs_l=psy-ab.3..0l8j0i5i30k1l2.10181.13326.0.13581.7.6.1.0.0.0.101.493.5j1.6.0....0...1c.1.64.psy-ab..0.7.502....0.JBd-4EcpHFs#imgrc=zJCJodOYQOPXSM:","https://www.google.com/search?biw=1280&bih=633&tbm=isch&sa=1&ei=1EFNWuTyDqHLjwSu9bzoAQ&q=big+picture&oq=big+picture&gs_l=psy-ab.3..0l10.71724.72905.0.73160.11.8.0.3.3.0.97.602.8.8.0....0...1c.1.64.psy-ab..0.11.612...0i67k1.0.aoAf5A-boTw#imgdii=LpcqI1CmhbXQpM:&imgrc=Txh7Cjnjll-arM:","https://www.google.com/search?biw=1280&bih=633&tbm=isch&sa=1&ei=skNNWrCcJpfijwTKsI7gAQ&q=spy+with+magnifying+glass&oq=spy+with+magnifying+glass&gs_l=psy-ab.3..0j0i5i30k1.5843.7274.0.7768.3.3.0.0.0.0.125.267.2j1.3.0....0...1c.1.64.psy-ab..0.3.266...0i7i30k1j0i7i5i30k1.0.0gyFCpdBUZ8#imgrc=3r9wEroworK3LM:","https://steemit.com/steemiteduction/@dbzfan4awhile/sql-beginner-s-tutorial-relational-databases-and-sql","https://steemit.com/sql-forbeginners/@dbzfan4awhile/sql-beginner-s-tutorial-writing-your-first-queries","https://steemit.com/utopian-io/@dbzfan4awhile/sql-beginner-s-tutorial-select-data-to-use-in-the-game","https://steemit.com/utopian-io/@dbzfan4awhile/sql-beginner-s-tutorial-manipulate-data-for-use-in-the-game","https://steemit.com/sql-forbeginners/@dbzfan4awhile/sql-beginner-s-tutorial-join-me-and-together-we-will-rule-the-universe"],"app":"steemit/0.1","format":"markdown"}
created2018-01-03 20:59:33
last_update2018-01-03 20:59:33
depth0
children34
last_payout2018-01-10 20:59:33
cashout_time1969-12-31 23:59:59
total_payout_value3.740 HBD
curator_payout_value0.304 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length9,854
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,868,242
net_rshares361,497,068,856
author_curate_reward""
vote details (28)
@asagikulak ·
$0.51
Your lessons are very instructive and understandable . thank you very much
👍  
properties (23)
authorasagikulak
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t221826635z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 22:17:18
last_update2018-01-03 22:17:18
depth1
children1
last_payout2018-01-10 22:17:18
cashout_time1969-12-31 23:59:59
total_payout_value0.382 HBD
curator_payout_value0.125 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length74
author_reputation-794,514,244,818
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,881,326
net_rshares45,746,316,212
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
I'm happy that you're able to understand the lessons without difficulty.
properties (22)
authordbzfan4awhile
permlinkre-asagikulak-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211432620z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:14:33
last_update2018-01-04 21:14:33
depth2
children0
last_payout2018-01-11 21:14:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length72
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,452
net_rshares0
@cemalbaba ·
$0.51
I follow your lessons carefully . You are a wonderful teacher
👍  
properties (23)
authorcemalbaba
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t222001590z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 22:20:03
last_update2018-01-03 22:20:03
depth1
children2
last_payout2018-01-10 22:20:03
cashout_time1969-12-31 23:59:59
total_payout_value0.382 HBD
curator_payout_value0.125 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length61
author_reputation-2,606,265,980,164
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,881,813
net_rshares45,746,316,212
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
I'm glad to be of service.
properties (22)
authordbzfan4awhile
permlinkre-cemalbaba-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211550804z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:15:51
last_update2018-01-04 21:15:51
depth2
children0
last_payout2018-01-11 21:15:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length26
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,684
net_rshares0
@greenwhell79 ·
Thanks for you all.
properties (22)
authorgreenwhell79
permlinkre-cemalbaba-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180105t022540185z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-05 02:25:48
last_update2018-01-05 02:25:48
depth2
children0
last_payout2018-01-12 02:25:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length19
author_reputation-759,695,835
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,169,283
net_rshares0
@faisal79 ·
$0.53
wow this is really cool :)
![5894.jpg](https://steemitimages.com/DQmNZWLzDQQKz6opVMSK8tHuGArhDJbeVNUuv6GSaR8FsyL/5894.jpg)
👍  ,
properties (23)
authorfaisal79
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t012757208z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"image":["https://steemitimages.com/DQmNZWLzDQQKz6opVMSK8tHuGArhDJbeVNUuv6GSaR8FsyL/5894.jpg"],"app":"steemit/0.1"}
created2018-01-04 01:28:00
last_update2018-01-04 01:28:00
depth1
children1
last_payout2018-01-11 01:28:00
cashout_time1969-12-31 23:59:59
total_payout_value0.416 HBD
curator_payout_value0.113 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length122
author_reputation1,364,151,823,900
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,912,167
net_rshares47,697,962,718
author_curate_reward""
vote details (2)
@dbzfan4awhile ·
Thanks for the thumbs-up. Are you looking at learning SQL?
properties (22)
authordbzfan4awhile
permlinkre-faisal79-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211244363z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:12:45
last_update2018-01-04 21:12:45
depth2
children0
last_payout2018-01-11 21:12:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length58
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,135
net_rshares0
@hakanlama ·
$0.51
I will definitely continue to follow you
👍  
properties (23)
authorhakanlama
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t221512091z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 22:14:09
last_update2018-01-03 22:14:09
depth1
children1
last_payout2018-01-10 22:14:09
cashout_time1969-12-31 23:59:59
total_payout_value0.388 HBD
curator_payout_value0.125 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length40
author_reputation3,207,402,816,463
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,880,825
net_rshares46,419,056,156
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
I hope I can continue to teach you good things in an accessible way.
properties (22)
authordbzfan4awhile
permlinkre-hakanlama-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211406909z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:14:09
last_update2018-01-04 21:14:09
depth2
children0
last_payout2018-01-11 21:14:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length68
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,371
net_rshares0
@hakanyaman ·
$0.52
I have a lot to learn from you. thanks
👍  , , , , ,
properties (23)
authorhakanyaman
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t221112085z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 22:10:09
last_update2018-01-03 22:10:09
depth1
children1
last_payout2018-01-10 22:10:09
cashout_time1969-12-31 23:59:59
total_payout_value0.400 HBD
curator_payout_value0.119 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length38
author_reputation622,701,372,785
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,880,118
net_rshares46,679,329,608
author_curate_reward""
vote details (6)
@dbzfan4awhile ·
There are plenty of lessons available that I've written already (if you haven't read them already) to help you out.
properties (22)
authordbzfan4awhile
permlinkre-hakanyaman-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211711482z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:17:12
last_update2018-01-04 21:17:12
depth2
children0
last_payout2018-01-11 21:17:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length115
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,909
net_rshares0
@henryrider ·
$0.45
learn some new from you, thanks for sharing...
👍  
properties (23)
authorhenryrider
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t214915555z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:49:24
last_update2018-01-03 21:49:24
depth1
children6
last_payout2018-01-10 21:49:24
cashout_time1969-12-31 23:59:59
total_payout_value0.424 HBD
curator_payout_value0.029 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length46
author_reputation188,778,571,789
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,876,647
net_rshares41,034,899,498
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
I'm glad I could help you in your knowledge journey.
properties (22)
authordbzfan4awhile
permlinkre-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t215816896z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:58:18
last_update2018-01-03 21:58:18
depth2
children2
last_payout2018-01-10 21:58:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length52
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,878,127
net_rshares0
@greenwhell79 ·
$0.46
Ok it's good idea thanks for you ok
👍  
properties (23)
authorgreenwhell79
permlinkre-dbzfan4awhile-re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180105t022428018z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-05 02:24:33
last_update2018-01-05 02:24:33
depth3
children1
last_payout2018-01-12 02:24:33
cashout_time1969-12-31 23:59:59
total_payout_value0.351 HBD
curator_payout_value0.113 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length35
author_reputation-759,695,835
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,169,038
net_rshares46,428,866,894
author_curate_reward""
vote details (1)
@greenwhell79 ·
$0.52
Nice cool₩₩₩
👍  ,
properties (23)
authorgreenwhell79
permlinkre-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t123454735z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 12:35:06
last_update2018-01-04 12:35:06
depth2
children2
last_payout2018-01-11 12:35:06
cashout_time1969-12-31 23:59:59
total_payout_value0.400 HBD
curator_payout_value0.123 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length12
author_reputation-759,695,835
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,025,305
net_rshares47,545,726,411
author_curate_reward""
vote details (2)
@dbzfan4awhile ·
Thank you, hopefully you can get something good out of the lessons.
properties (22)
authordbzfan4awhile
permlinkre-greenwhell79-re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211321837z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:13:24
last_update2018-01-04 21:13:24
depth3
children0
last_payout2018-01-11 21:13:24
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length67
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,239
net_rshares0
@dbzfan4awhile ·
Thank you, hopefully you can get something good out of the lessons.
properties (22)
authordbzfan4awhile
permlinkre-greenwhell79-re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180105t184004297z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-05 18:40:06
last_update2018-01-05 18:40:06
depth3
children0
last_payout2018-01-12 18:40:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length67
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,344,897
net_rshares0
@killerkuasha ·
$0.47
So cool!! Nice view!!!thanks for sharing..
👍  
properties (23)
authorkillerkuasha
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t210855509z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:08:57
last_update2018-01-03 21:08:57
depth1
children1
last_payout2018-01-10 21:08:57
cashout_time1969-12-31 23:59:59
total_payout_value0.364 HBD
curator_payout_value0.101 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length42
author_reputation2,213,124,390,757
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,869,862
net_rshares41,707,602,768
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
You are quite welcome, hope it helps you gain some knowledge in the area.
properties (22)
authordbzfan4awhile
permlinkre-killerkuasha-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t213542965z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:35:45
last_update2018-01-03 21:35:45
depth2
children0
last_payout2018-01-10 21:35:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length73
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,874,362
net_rshares0
@mandolincarls ·
$0.13
### <center>Upvoted on behalf of the **dropahead Curation Team!**</center> 
<center>Thanks for following [the rules](https://steemit.com/introduceyourself/@dropahead/introduceyourself-xxvotesplus-dropahead-curation-trail-and-my-path-to-witness).</center>

###### DISCLAIMER: dropahead Curation Team *does not necessarily share opinions expressed in this article*, but find author's effort and/or contribution deserves better reward and visibility.

#### <center>Help us giving you bigger upvotes by:</center>
<h6><center>Upvote this comment!</center></h6> | <h6><center>Upvote the [latest dropahead Daily Report!](https://steemit.com/trending/xx-votesplus)</center></h6>
-------- | ---------
<h6><center>[Join the dropahead Curation Trail](https://v2.steemconnect.com/authorize/@dropahead) <br /> to maximize your curation rewards!</center></h6> | <h6><center>[Vote dropahead Witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=dropahead&approve=1) with SteemConnect</center></h6>
<h6><center>[Proxy vote dropahead Witness](https://v2.steemconnect.com/sign/account-witness-proxy?proxy=dropahead&approve=1) <br /> with SteemConnect</center></h6> | <h6><center>[Delegate/donate STEEM POWER](https://steemit.com/delegate/@zeartul/how-to-delegate-steem-power-the-easy-way-if-you-have-over-30-sp-you-can-delegate) to @dropahead</center></h6>

###### Do the above and we'll have more STEEM POWER to give YOU bigger rewards next time!

---
News from dropahead: [Bye bye 25+ and 50+! Welcome 20+ 40+ and 60+!](https://steemit.com/xx-votesplus/@dropahead/bye-bye-25-and-50-welcome-20-40-and-60)

<sup id="dct_data" dct:type="curation_comment" dct:lang="en"></sup>
👍  ,
properties (23)
authormandolincarls
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180107t064040139z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"users":["dropahead"],"links":["https://steemit.com/introduceyourself/@dropahead/introduceyourself-xxvotesplus-dropahead-curation-trail-and-my-path-to-witness","https://steemit.com/trending/xx-votesplus","https://v2.steemconnect.com/authorize/@dropahead","https://v2.steemconnect.com/sign/account-witness-vote?witness=dropahead&approve=1","https://v2.steemconnect.com/sign/account-witness-proxy?proxy=dropahead&approve=1","https://steemit.com/delegate/@zeartul/how-to-delegate-steem-power-the-easy-way-if-you-have-over-30-sp-you-can-delegate","https://steemit.com/xx-votesplus/@dropahead/bye-bye-25-and-50-welcome-20-40-and-60"],"app":"steemit/0.1"}
created2018-01-07 06:40:39
last_update2018-01-07 06:40:39
depth1
children1
last_payout2018-01-14 06:40:39
cashout_time1969-12-31 23:59:59
total_payout_value0.100 HBD
curator_payout_value0.026 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length1,673
author_reputation2,157,799,664,736
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,697,469
net_rshares13,126,925,585
author_curate_reward""
vote details (2)
@cessarespinozaa · (edited)
$0.17
#### Quality review by the [dropahead Curation Team](https://steemit.com/introduceyourself/@dropahead/introduceyourself-xxvotesplus-dropahead-curation-trail-and-my-path-to-witness)
According to our **quality standards**<sup>(1)</sup>, your publication has reached an **score of 100%**.


Congratulations for your excellent work!
---
<sub> (1) *dropahead Witness'* quality standards:</sub>

<sub>- Graphic relation to the text (Choice of images according to the text)<br />- Order and coherence<br />- Style and uniqueness (Personal touch, logic, complexity, what makes it interesting and easy to understand for the reader)<br />- Images source and their usage license</sub>

<sup id="dct_data" dct:type="qa_comment" dct:lang="en"></sup>
👍  , ,
properties (23)
authorcessarespinozaa
permlinkre-mandolincarls-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180108t195940831z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"links":["https://steemit.com/introduceyourself/@dropahead/introduceyourself-xxvotesplus-dropahead-curation-trail-and-my-path-to-witness"],"app":"steemit/0.1"}
created2018-01-08 20:00:24
last_update2018-01-08 20:43:18
depth2
children0
last_payout2018-01-15 20:00:24
cashout_time1969-12-31 23:59:59
total_payout_value0.138 HBD
curator_payout_value0.029 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length736
author_reputation1,344,892,326,028
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id28,075,313
net_rshares16,024,693,264
author_curate_reward""
vote details (3)
@sohan4745 ·
$0.45
Love to read it.
👍  
properties (23)
authorsohan4745
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t215152501z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:51:54
last_update2018-01-03 21:51:54
depth1
children3
last_payout2018-01-10 21:51:54
cashout_time1969-12-31 23:59:59
total_payout_value0.424 HBD
curator_payout_value0.023 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length16
author_reputation589,118,262,599
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,877,075
net_rshares40,362,196,227
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
Hopefully it makes sense and helps you understand it better.
properties (22)
authordbzfan4awhile
permlinkre-sohan4745-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t215843613z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:58:45
last_update2018-01-03 21:58:45
depth2
children2
last_payout2018-01-10 21:58:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length60
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,878,207
net_rshares0
@sohan4745 ·
$0.53
yes, it is so useful, you are doing a great work, i know this by youu..
👍  
properties (23)
authorsohan4745
permlinkre-dbzfan4awhile-re-sohan4745-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t220040702z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 22:00:45
last_update2018-01-03 22:00:45
depth3
children1
last_payout2018-01-10 22:00:45
cashout_time1969-12-31 23:59:59
total_payout_value0.394 HBD
curator_payout_value0.131 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length71
author_reputation589,118,262,599
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,878,523
net_rshares47,091,796,101
author_curate_reward""
vote details (1)
@steemibu351 ·
$0.47
so informative video.have a nice day
👍  
properties (23)
authorsteemibu351
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t210358803z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:04:00
last_update2018-01-03 21:04:00
depth1
children1
last_payout2018-01-10 21:04:00
cashout_time1969-12-31 23:59:59
total_payout_value0.352 HBD
curator_payout_value0.113 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length36
author_reputation1,020,146,854,773
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,869,022
net_rshares41,707,602,768
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
Thank you so much. I hope this helps.
properties (22)
authordbzfan4awhile
permlinkre-steemibu351-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t213511952z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:35:12
last_update2018-01-03 21:35:12
depth2
children0
last_payout2018-01-10 21:35:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length37
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,874,283
net_rshares0
@stormriderstudio ·
$0.36
Ah SQL, so simple and yet when you want to do that ONE thing, you have to take 47 detours and test it at every step. Admittedly that's because I'm usually building complex queries from PHP and all sorts of fun things can happen.

I'd be very interested in learning more about database/table optimisation and query optimisation - things like additional keys, foreign keys and optimal datatype sizes (for some reason I always pick binary-friendly data sizes like varchar fields at 128 or 256 characters with no idea whether it's actually helpful!).

Nice work :) Posts like this could bring Krillin back to life for the 4'000th time ;)
👍  
properties (23)
authorstormriderstudio
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t211925158z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"community":"busy","app":"busy/2.2.0"}
created2018-01-03 21:19:27
last_update2018-01-03 21:19:27
depth1
children3
last_payout2018-01-10 21:19:27
cashout_time1969-12-31 23:59:59
total_payout_value0.358 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length633
author_reputation1,082,215,996,176
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,871,724
net_rshares42,380,306,039
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
Wow, you are very familiar with SQL... you may be above my level of expertise, honestly. I like putting these Tutorials together because I think they are set up in a low-level way so that novices can begin to learn and understand it.

Optimization is king... I use Crystal Reports for Document generation at my job and if the query is too slow the report will not generate or will not generate properly.
properties (22)
authordbzfan4awhile
permlinkre-stormriderstudio-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t213431376z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 21:34:33
last_update2018-01-03 21:34:33
depth2
children2
last_payout2018-01-10 21:34:33
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length403
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,874,175
net_rshares0
@stormriderstudio ·
$0.59
Yea, I've been playing with MySQL since.... around 2000 I think. I tend to run everything through HeidiSQL which is a lovely interface once you get to find all the tips and tricks in there.

I read back to your guide on JOINS and it's very different in MySQL. Inner joins by default, with just left join or right join. Seems foreign keys are used differently too, in MySQL they are more of an optimisation tool and everything is handled though the ON keyword. A much more informal layout but probably where I'm coming across some issues with performance on a site I inherited (getting close to 1 million records which join to themselves and repeat data all over the place - nightmare!)

On my list for 2018 is more optimisation for MySQL as I'm going from releasing purely bespoke sites (generally "awkward" ecommerce needs, package builders and the like) to my first general release CMS/online shop package with theme support - finally a code-base I can come back to and work on in iterations! :)
👍  
properties (23)
authorstormriderstudio
permlinkre-dbzfan4awhile-re-stormriderstudio-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t214117533z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"community":"busy","app":"busy/2.2.0"}
created2018-01-03 21:41:18
last_update2018-01-03 21:41:18
depth3
children1
last_payout2018-01-10 21:41:18
cashout_time1969-12-31 23:59:59
total_payout_value0.590 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length997
author_reputation1,082,215,996,176
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,875,321
net_rshares70,633,843,398
author_curate_reward""
vote details (1)
@tenorbalonzo ·
$0.50
The lesson you gave about SQL Beginner's Tutorial is pretty good
👍  
properties (23)
authortenorbalonzo
permlinkre-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t222310265z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-03 22:23:09
last_update2018-01-03 22:23:09
depth1
children1
last_payout2018-01-10 22:23:09
cashout_time1969-12-31 23:59:59
total_payout_value0.376 HBD
curator_payout_value0.125 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length64
author_reputation-1,115,275,014,457
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id26,882,376
net_rshares45,073,576,268
author_curate_reward""
vote details (1)
@dbzfan4awhile ·
I'm glad to hear.
properties (22)
authordbzfan4awhile
permlinkre-tenorbalonzo-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211625834z
categorysql-forbeginners
json_metadata{"tags":["sql-forbeginners"],"app":"steemit/0.1"}
created2018-01-04 21:16:27
last_update2018-01-04 21:16:27
depth2
children0
last_payout2018-01-11 21:16:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length17
author_reputation8,411,661,872,775
root_title"SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id27,119,790
net_rshares0