Learning MySQL - JSON in MySQL 

Watched all 39 videos. This MAN is a legend!!!

Hi Steve. Just finished your course. It was awesome! Thank you.

Also nice to pick up some additional tips when your looking for a refresher. Great Video! Thank you.

Thank you! great teacher! I was having some problems on how to store arrays in MySQL this video save me a lot of time! Also, your way of explaining things is great! Already subscribed!

Bro your way of explaining things is way out of this world.

Steve, thank you so much for this course. Very informative. People like you run this world

Thank you for this! This was the best and easy explanation I found after checking many other videos on this topic.

One of the most helpful video ever! thanks a whole lot

This has been extremely helpful, thank you very much Steve!

Thank you so much for the wonderful series. You're such an incredible teacher, and it is so fun to learn!! Best

Your channel certainly deserves more subscribers

It's what I am exactly searching for loved your tutorial so much.. ❤️

Great tutorials, really helped me understand SQL better. I know it is late to say, but please add one video of the topic Transaction too.

Thanks pal, very useful video tutorial. Go ahead.

Thank you for the great course!

Superb presentation!

Thank you for this nice and useful tutorial. JSON is very powerful ! If I exagerate, we could have a whole table structure in only one JSON field !

great explanation. thank you.

This is so cool! Thank you very much for this! Great explanation clap clap

Thank you! Very helpful.

Great information

Thank you 👍 it's a great tutorial 🙏👍

Great tutorial

thank you - great job

its very useful 😍

Great! I am using json data type to extract many APIs to single table (single field). I don't get careful with data type of what I am extracting it. Using this approach, I be able to have a big productivity. I am using too in data system integration. I don't need to know about data, I only send a Json, of one system to other system, in batch way. Have a nice day!

Hi brother. I love you. Good video !

Thank you Steve, Finished the course, Amazing course. Feedback: I know it was about MySQL and not about databases, however since you explained from basics (assuming that viewers do not have much knowledge). It would be great if you can make a tutorial on DB design basics. Like foreign key, Integrity normalization and how to normalize. It can be 1 stop shop for databases. That being said, it was amazing. Thank you.

tanks a lot

thanks

Hi Steve. Looks very powerful. Do you have any videos of the examples you mentioned at the end?

your videos are great keep it up. may I ask you to make a transactions video, it'd be really helpful.

Thanks!

Could you please make video for JSON usage in triggers and converting JSON data to a table record

Nice video. Thanks! Good way of explanation. We're trying to refactor our project and we are now discussing the database structure. We're trying to research about json vs. the "normal" way of mysql (cols, 1:n, n:n, and so on). What the problem is, we do not know what way is better. Let's say you have a row with 30 cols as table with various datatypes. If we do the same thing with json - which one will be faster for our database? I think Performance is a big topic here. Can you say something to this? Like.. When does Json outplay Cols? Or when do Cols outplay Json? Or is it just the same effort for the database driver? I think JSON should be more performant, because you dont store NULL or empty columns. If you have a "normal" table it is possible that some rows have NULLs in there. That's an unnecessary way. That would be a big PRO for JSON. Is it good to mix up? Like if you have a user-table with your example. Would it be better if we set only the personal_data in JSON or the whole user-row? I know.. big questions. But I think you have the knowledge and experience to these questions ;) Greetings from Austria

I just saw your video and is very helpful. Can you share a link or have you posted any video about json in detail? I have read MySQL document before coming to your channel. It was tough to read. Thanks

Example for nested JSON. set @dir = curdate(); select @dir; select json_pretty(json_object("Name","Kangna","DOB",1990,"Language","Hindi","Country","International","Date",@dir ,"Hobbies",json_array("Swimming","Dancing"),"Misc",json_object("Cars","Merc","Zodiac","Scorpion")));

Great explanation, but my question is when to use json to store data over traditional way of inserting single value in the column ? Say if I have a bunch of medical data related to a patient (say 100 items) for example should i store those data in json object as it is very hard and seems inlogical to create a column for each property

Hi! what way to import 300GB sql file in mysql with speed

Could you provide a video where we search like a where in? so we search rows where they etc contain a hashtag which is stores as hashtag: ["hashtag1", "hashtag2", "hashtag3"]

Q: JSON vs another table for a relationship? This seems like a great use case for something like a user that has more than one phone number or email. Typically I would associate this with perhaps another table or add using a | to delimitate this in the field. So this seems like the best of all worlds almost like having mongo inside of mysql to a degree no? Are there any downsides to using JSON in mysql? that you can think of? Guess parsing this if it was complex? Thanks as always Steve!

Above video is the best explanation of json in MySQL. But I have a question here, how can we compare 2 json object by using MySQL? For example I have a json object {"id":123, "name":"Swagat"} and after that same object's name has been changed like this {"id":123, "name":"Ankit"} by comparing these 2 object i should get the updated value ? Is that possible ?

Thanks for the tutorial. However, i have a question. I am using the most recent version of mysql with an innodb table and neither -> or ->> work. It displays a syntax error. I don't understand what is happening.

Hello. How can I extract a data from a json document and move that data to the column of a table. From a Server I get information in Json format, but I only care about one piece of all that document in json. I would like to move that single data to a column of a created table.

hey Steve!, what about performance? My use case is storing POST requests as JSON for debugging. Is MySQL recommended for that, or you would rather go for a NoSQL database?

Can I use these json-extensions in SQL commands in PHP PDO?

How to add json array into MySQL using nodejs? I want to insert keys and values separately

JSON_EXTRACT(data, \"$.STUDENT_NAME\") IN ('JASMINE','SAM') this is not working? any ideas?

When I tried inserting a JSON field it saves as LONGTEXT. As of now with XAMPP we get mariaDB and not Mysql anymore. Please suggest how can I use Mysql or Insert JSON in MariaDB. Any help would be greatly appreciated. Thanks Steve.

May I know how to retrieve a key value pair inside a JSON? I meant like if the JSON data looks like this: { a:1, b: { c: 2, d: 3, e: { f: etc }}} How do we access those keys inside?

Great tutorial . I have a question . Can I have instead json objects , like this - { index: 0, name: 'john' }, { index: 1, name: 'bob' }, can I have a list of arrays ? something like this - ['john', 'Bob'] ?

I must've watched 50 videos this week and followed 10 tutorials on SQL, Fetch, JSON data - but not a single one shows you how to connect to the server. Somebody please help!!

Hi again, Steve. May I know why the -> isn't working for me? However, if I use the JSON_EXTRACT (see below), it works perfectly fine. // This works perfectly. SELECT * FROM table WHERE JSON_EXTRACT(column_name, "$.email") = "some@email.com" // But not this. This one gives me a syntax error. SELECT * FROM table WHERE column_name->>"$.email" = "some@email.com"; The column_name has data that looks like this: { "name": "name of person", "email": "some@email.com" }

"{something:{something:[this:that]}}": How can I write a SQL query in order to obtain "that" from this JSON array?

JSON_ARRAY({"name", "John Doe"}); possible?

Sir iam 8:31 using exact query in mysql but it is showing #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>>' SELECT modules, modules->>"$.role" AS role FROM `user_permission` This is my Query and my column doesn't taking JSON data type it always set it as longtext

Good video but how this json filter scan will work on 3 Billions records ?

but sir, how can I store form input data here?

But how to insert into a JSON object?

Hello dear Mr Steve, I created a program by Cordova, but I need digital signing to publish it, but I can not do it. Please help me, my project is done in Visual Code.

Hi, How are you? Please, help me!!! I am trying to do it, but it doesn't works for me. My consult: SELECT desktop_access->>"$.username" as name FROM v_components WHERE desktop_access->>"$.username" = "facu" My array for each object on column "deskto_access": [ {"username":"santi","x":500,"y":25}, {"username":"facu","x":500,"y":25} ] Error with "->>"

EAV is dead and JSON killed it.

A dislike from xml team...