 [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. ___  [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:  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.  [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.  [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.  [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)
author | dbzfan4awhile |
---|---|
permlink | sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy |
category | sql-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"} |
created | 2018-01-03 20:59:33 |
last_update | 2018-01-03 20:59:33 |
depth | 0 |
children | 34 |
last_payout | 2018-01-10 20:59:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 3.740 HBD |
curator_payout_value | 0.304 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 9,854 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,868,242 |
net_rshares | 361,497,068,856 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
ausbitbank | 0 | 82,413,511,735 | 1% | ||
poeticsnake | 0 | 58,644,290,370 | 15% | ||
suprepachyderm | 0 | 9,931,566,432 | 100% | ||
develcuy | 0 | 6,198,998,396 | 25.1% | ||
dropahead | 0 | 7,986,410,941 | 25% | ||
dbzfan4awhile | 0 | 123,102,411,302 | 100% | ||
mandolincarls | 0 | 6,465,970,032 | 100% | ||
stormriderstudio | 0 | 3,156,426,040 | 25% | ||
crimsonclad | 0 | 15,078,062,673 | 8% | ||
thinknzombie | 0 | 2,333,931,780 | 1% | ||
discordiant | 0 | 3,365,219,324 | 8% | ||
msp-lovebot | 0 | 27,176,175,215 | 15% | ||
miraimage | 0 | 4,880,571,837 | 100% | ||
cesarx321 | 0 | 526,596,131 | 100% | ||
yudexisjaume | 0 | 1,048,970,174 | 100% | ||
sohan4745 | 0 | 438,127,960 | 100% | ||
killerkuasha | 0 | 650,844,089 | 100% | ||
phil-coding | 0 | 3,056,941,911 | 100% | ||
hakanyaman | 0 | 155,861,901 | 100% | ||
steemibu351 | 0 | 296,925,904 | 100% | ||
iqbaladan | 0 | 3,093,669,147 | 100% | ||
henryrider | 0 | 220,745,515 | 100% | ||
tenorbalonzo | 0 | 213,865,001 | 100% | ||
asagikulak | 0 | 175,318,445 | 100% | ||
cemalbaba | 0 | 165,263,865 | 100% | ||
hakanlama | 0 | 206,353,156 | 100% | ||
amf6 | 0 | 422,452,379 | 100% | ||
fonsetucker | 0 | 91,587,201 | 0.2% |
Your lessons are very instructive and understandable . thank you very much
author | asagikulak |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t221826635z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 22:17:18 |
last_update | 2018-01-03 22:17:18 |
depth | 1 |
children | 1 |
last_payout | 2018-01-10 22:17:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.382 HBD |
curator_payout_value | 0.125 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 74 |
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_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,881,326 |
net_rshares | 45,746,316,212 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 45,746,316,212 | 35% |
I'm happy that you're able to understand the lessons without difficulty.
author | dbzfan4awhile |
---|---|
permlink | re-asagikulak-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211432620z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:14:33 |
last_update | 2018-01-04 21:14:33 |
depth | 2 |
children | 0 |
last_payout | 2018-01-11 21:14:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 72 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,452 |
net_rshares | 0 |
I follow your lessons carefully . You are a wonderful teacher
author | cemalbaba |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t222001590z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 22:20:03 |
last_update | 2018-01-03 22:20:03 |
depth | 1 |
children | 2 |
last_payout | 2018-01-10 22:20:03 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.382 HBD |
curator_payout_value | 0.125 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 61 |
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_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,881,813 |
net_rshares | 45,746,316,212 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 45,746,316,212 | 35% |
I'm glad to be of service.
author | dbzfan4awhile |
---|---|
permlink | re-cemalbaba-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211550804z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:15:51 |
last_update | 2018-01-04 21:15:51 |
depth | 2 |
children | 0 |
last_payout | 2018-01-11 21:15:51 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 26 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,684 |
net_rshares | 0 |
Thanks for you all.
author | greenwhell79 |
---|---|
permlink | re-cemalbaba-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180105t022540185z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-05 02:25:48 |
last_update | 2018-01-05 02:25:48 |
depth | 2 |
children | 0 |
last_payout | 2018-01-12 02:25:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 19 |
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_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,169,283 |
net_rshares | 0 |
wow this is really cool :) 
author | faisal79 |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t012757208z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"image":["https://steemitimages.com/DQmNZWLzDQQKz6opVMSK8tHuGArhDJbeVNUuv6GSaR8FsyL/5894.jpg"],"app":"steemit/0.1"} |
created | 2018-01-04 01:28:00 |
last_update | 2018-01-04 01:28:00 |
depth | 1 |
children | 1 |
last_payout | 2018-01-11 01:28:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.416 HBD |
curator_payout_value | 0.113 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 122 |
author_reputation | 1,364,151,823,900 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,912,167 |
net_rshares | 47,697,962,718 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 47,091,796,101 | 35% | ||
faisal79 | 0 | 606,166,617 | 100% |
Thanks for the thumbs-up. Are you looking at learning SQL?
author | dbzfan4awhile |
---|---|
permlink | re-faisal79-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211244363z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:12:45 |
last_update | 2018-01-04 21:12:45 |
depth | 2 |
children | 0 |
last_payout | 2018-01-11 21:12:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 58 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,135 |
net_rshares | 0 |
I will definitely continue to follow you
author | hakanlama |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t221512091z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 22:14:09 |
last_update | 2018-01-03 22:14:09 |
depth | 1 |
children | 1 |
last_payout | 2018-01-10 22:14:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.388 HBD |
curator_payout_value | 0.125 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 40 |
author_reputation | 3,207,402,816,463 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,880,825 |
net_rshares | 46,419,056,156 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 46,419,056,156 | 35% |
I hope I can continue to teach you good things in an accessible way.
author | dbzfan4awhile |
---|---|
permlink | re-hakanlama-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211406909z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:14:09 |
last_update | 2018-01-04 21:14:09 |
depth | 2 |
children | 0 |
last_payout | 2018-01-11 21:14:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 68 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,371 |
net_rshares | 0 |
I have a lot to learn from you. thanks
author | hakanyaman |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t221112085z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 22:10:09 |
last_update | 2018-01-03 22:10:09 |
depth | 1 |
children | 1 |
last_payout | 2018-01-10 22:10:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.400 HBD |
curator_payout_value | 0.119 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 38 |
author_reputation | 622,701,372,785 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,880,118 |
net_rshares | 46,679,329,608 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 45,073,576,268 | 35% | ||
hakanyaman | 0 | 211,421,097 | 100% | ||
asagikulak | 0 | 200,695,863 | 100% | ||
cemalbaba | 0 | 180,828,730 | 100% | ||
hakanlama | 0 | 351,331,714 | 100% | ||
efsun2007 | 0 | 661,475,936 | 100% |
There are plenty of lessons available that I've written already (if you haven't read them already) to help you out.
author | dbzfan4awhile |
---|---|
permlink | re-hakanyaman-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211711482z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:17:12 |
last_update | 2018-01-04 21:17:12 |
depth | 2 |
children | 0 |
last_payout | 2018-01-11 21:17:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 115 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,909 |
net_rshares | 0 |
learn some new from you, thanks for sharing...
author | henryrider |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t214915555z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:49:24 |
last_update | 2018-01-03 21:49:24 |
depth | 1 |
children | 6 |
last_payout | 2018-01-10 21:49:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.424 HBD |
curator_payout_value | 0.029 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 46 |
author_reputation | 188,778,571,789 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,876,647 |
net_rshares | 41,034,899,498 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 41,034,899,498 | 35% |
I'm glad I could help you in your knowledge journey.
author | dbzfan4awhile |
---|---|
permlink | re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t215816896z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:58:18 |
last_update | 2018-01-03 21:58:18 |
depth | 2 |
children | 2 |
last_payout | 2018-01-10 21:58:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 52 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,878,127 |
net_rshares | 0 |
Ok it's good idea thanks for you ok
author | greenwhell79 |
---|---|
permlink | re-dbzfan4awhile-re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180105t022428018z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-05 02:24:33 |
last_update | 2018-01-05 02:24:33 |
depth | 3 |
children | 1 |
last_payout | 2018-01-12 02:24:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.351 HBD |
curator_payout_value | 0.113 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 35 |
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_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,169,038 |
net_rshares | 46,428,866,894 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 46,428,866,894 | 35% |
Nice cool₩₩₩
author | greenwhell79 |
---|---|
permlink | re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t123454735z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 12:35:06 |
last_update | 2018-01-04 12:35:06 |
depth | 2 |
children | 2 |
last_payout | 2018-01-11 12:35:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.400 HBD |
curator_payout_value | 0.123 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 12 |
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_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,025,305 |
net_rshares | 47,545,726,411 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 46,419,056,156 | 35% | ||
greenwhell79 | 0 | 1,126,670,255 | 100% |
Thank you, hopefully you can get something good out of the lessons.
author | dbzfan4awhile |
---|---|
permlink | re-greenwhell79-re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211321837z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:13:24 |
last_update | 2018-01-04 21:13:24 |
depth | 3 |
children | 0 |
last_payout | 2018-01-11 21:13:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 67 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,239 |
net_rshares | 0 |
Thank you, hopefully you can get something good out of the lessons.
author | dbzfan4awhile |
---|---|
permlink | re-greenwhell79-re-henryrider-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180105t184004297z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-05 18:40:06 |
last_update | 2018-01-05 18:40:06 |
depth | 3 |
children | 0 |
last_payout | 2018-01-12 18:40:06 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 67 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,344,897 |
net_rshares | 0 |
So cool!! Nice view!!!thanks for sharing..
author | killerkuasha |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t210855509z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:08:57 |
last_update | 2018-01-03 21:08:57 |
depth | 1 |
children | 1 |
last_payout | 2018-01-10 21:08:57 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.364 HBD |
curator_payout_value | 0.101 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 42 |
author_reputation | 2,213,124,390,757 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,869,862 |
net_rshares | 41,707,602,768 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 41,707,602,768 | 35% |
You are quite welcome, hope it helps you gain some knowledge in the area.
author | dbzfan4awhile |
---|---|
permlink | re-killerkuasha-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t213542965z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:35:45 |
last_update | 2018-01-03 21:35:45 |
depth | 2 |
children | 0 |
last_payout | 2018-01-10 21:35:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 73 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,874,362 |
net_rshares | 0 |
### <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>
author | mandolincarls |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180107t064040139z |
category | sql-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"} |
created | 2018-01-07 06:40:39 |
last_update | 2018-01-07 06:40:39 |
depth | 1 |
children | 1 |
last_payout | 2018-01-14 06:40:39 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.100 HBD |
curator_payout_value | 0.026 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,673 |
author_reputation | 2,157,799,664,736 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,697,469 |
net_rshares | 13,126,925,585 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
develcuy | 0 | 6,198,998,396 | 25.1% | ||
dropahead | 0 | 6,927,927,189 | 25% |
#### 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>
author | cessarespinozaa |
---|---|
permlink | re-mandolincarls-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180108t195940831z |
category | sql-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"} |
created | 2018-01-08 20:00:24 |
last_update | 2018-01-08 20:43:18 |
depth | 2 |
children | 0 |
last_payout | 2018-01-15 20:00:24 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.138 HBD |
curator_payout_value | 0.029 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 736 |
author_reputation | 1,344,892,326,028 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 28,075,313 |
net_rshares | 16,024,693,264 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
develcuy | 0 | 6,198,998,396 | 25.1% | ||
dropahead | 0 | 6,927,927,189 | 25% | ||
cessarespinozaa | 0 | 2,897,767,679 | 100% |
Love to read it.
author | sohan4745 |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t215152501z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:51:54 |
last_update | 2018-01-03 21:51:54 |
depth | 1 |
children | 3 |
last_payout | 2018-01-10 21:51:54 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.424 HBD |
curator_payout_value | 0.023 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 16 |
author_reputation | 589,118,262,599 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,877,075 |
net_rshares | 40,362,196,227 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 40,362,196,227 | 35% |
Hopefully it makes sense and helps you understand it better.
author | dbzfan4awhile |
---|---|
permlink | re-sohan4745-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t215843613z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:58:45 |
last_update | 2018-01-03 21:58:45 |
depth | 2 |
children | 2 |
last_payout | 2018-01-10 21:58:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 60 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,878,207 |
net_rshares | 0 |
yes, it is so useful, you are doing a great work, i know this by youu..
author | sohan4745 |
---|---|
permlink | re-dbzfan4awhile-re-sohan4745-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t220040702z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 22:00:45 |
last_update | 2018-01-03 22:00:45 |
depth | 3 |
children | 1 |
last_payout | 2018-01-10 22:00:45 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.394 HBD |
curator_payout_value | 0.131 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 71 |
author_reputation | 589,118,262,599 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,878,523 |
net_rshares | 47,091,796,101 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 47,091,796,101 | 35% |
so informative video.have a nice day
author | steemibu351 |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t210358803z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:04:00 |
last_update | 2018-01-03 21:04:00 |
depth | 1 |
children | 1 |
last_payout | 2018-01-10 21:04:00 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.352 HBD |
curator_payout_value | 0.113 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 36 |
author_reputation | 1,020,146,854,773 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,869,022 |
net_rshares | 41,707,602,768 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 41,707,602,768 | 35% |
Thank you so much. I hope this helps.
author | dbzfan4awhile |
---|---|
permlink | re-steemibu351-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t213511952z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:35:12 |
last_update | 2018-01-03 21:35:12 |
depth | 2 |
children | 0 |
last_payout | 2018-01-10 21:35:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 37 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,874,283 |
net_rshares | 0 |
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 ;)
author | stormriderstudio |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t211925158z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"community":"busy","app":"busy/2.2.0"} |
created | 2018-01-03 21:19:27 |
last_update | 2018-01-03 21:19:27 |
depth | 1 |
children | 3 |
last_payout | 2018-01-10 21:19:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.358 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 633 |
author_reputation | 1,082,215,996,176 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,871,724 |
net_rshares | 42,380,306,039 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 42,380,306,039 | 35% |
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.
author | dbzfan4awhile |
---|---|
permlink | re-stormriderstudio-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t213431376z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 21:34:33 |
last_update | 2018-01-03 21:34:33 |
depth | 2 |
children | 2 |
last_payout | 2018-01-10 21:34:33 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 403 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,874,175 |
net_rshares | 0 |
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! :)
author | stormriderstudio |
---|---|
permlink | re-dbzfan4awhile-re-stormriderstudio-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t214117533z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"community":"busy","app":"busy/2.2.0"} |
created | 2018-01-03 21:41:18 |
last_update | 2018-01-03 21:41:18 |
depth | 3 |
children | 1 |
last_payout | 2018-01-10 21:41:18 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.590 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 997 |
author_reputation | 1,082,215,996,176 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,875,321 |
net_rshares | 70,633,843,398 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 70,633,843,398 | 60% |
The lesson you gave about SQL Beginner's Tutorial is pretty good
author | tenorbalonzo |
---|---|
permlink | re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180103t222310265z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-03 22:23:09 |
last_update | 2018-01-03 22:23:09 |
depth | 1 |
children | 1 |
last_payout | 2018-01-10 22:23:09 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.376 HBD |
curator_payout_value | 0.125 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 64 |
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_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 26,882,376 |
net_rshares | 45,073,576,268 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
dbzfan4awhile | 0 | 45,073,576,268 | 35% |
I'm glad to hear.
author | dbzfan4awhile |
---|---|
permlink | re-tenorbalonzo-re-dbzfan4awhile-sql-beginner-s-tutorial-what-if-the-world-is-not-null-and-in-the-galaxy-20180104t211625834z |
category | sql-forbeginners |
json_metadata | {"tags":["sql-forbeginners"],"app":"steemit/0.1"} |
created | 2018-01-04 21:16:27 |
last_update | 2018-01-04 21:16:27 |
depth | 2 |
children | 0 |
last_payout | 2018-01-11 21:16:27 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 17 |
author_reputation | 8,411,661,872,775 |
root_title | "SQL Beginner's Tutorial: What if the World IS NOT NULL? and IN the Galaxy?" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 27,119,790 |
net_rshares | 0 |