Thanks so much, this helped especially with making relationships through the code and demonstrating how to turn it into an ERD.
@MattMacarty
2 жыл бұрын
Glad it helped
@HarryScutt
Жыл бұрын
You rescued my uni project thank you so much
@MattMacarty
Жыл бұрын
Glad it helped
@VeiseLeeQuilloy
9 ай бұрын
Perfect explanation, well concise
@MattMacarty
9 ай бұрын
Thanks. Glad it helped
@kamalkushwah2659
5 ай бұрын
Thank you so much for this type of detailed video you save me...
@MattMacarty
5 ай бұрын
Glad it helped
@montrafons
2 жыл бұрын
Thanks for the explanation, it is very easy to understand. I have a question, when the SQL query has been done and the relationship between the tables has been formed in the form of an EER Diagram, it's the relationship "One to Many", is it automatic from the workbench or can we change it for this relationship? Then is there any impact on the relationship between tables in Schemas, if we change from "One to Many "to" One to One " in the EER Diagrams section? Thanks
@MattMacarty
2 жыл бұрын
The database engine tries to determine the relationship when you add the foreign key constraint. You can edit and reimplement, but typically we don't see 1:1 relationships that often. They are usually between two primary keys.
@montrafons
2 жыл бұрын
@@MattMacarty Okay buddy, in what cases do we need 2 primary keys? Suppose that one table already has primary keys, then add primary keys from another table
@koraxtu5989
2 жыл бұрын
Thanks for this vid, it was very helpful!
@MattMacarty
2 жыл бұрын
Glad it helped
@faizanwar_
2 жыл бұрын
Nailed it ...that's the way to do it👍👍
@MattMacarty
2 жыл бұрын
Glad it helped
@SidAhmedHachoud
2 жыл бұрын
Thank you so much, this was literally life-saving!
@MattMacarty
2 жыл бұрын
Glad it helped!
@TiiLiiXx
Жыл бұрын
Thank you, it helped me
@MattMacarty
Жыл бұрын
Glad it helped
@Adekorede
2 жыл бұрын
Thank you so much Matt
@MattMacarty
2 жыл бұрын
My pleasure. Glad it helped.
@dellyemaya9184
2 жыл бұрын
Thanks again. You are the best!
@MattMacarty
2 жыл бұрын
Glad it helped
@Adrianacmp
2 жыл бұрын
You literally saved me! I've been watching videos for about 3hs and had not found any help! Thanks to you I could almost complete my first data base. The only thing left is to set some 'domains' (like a list of options that must be available when introducing new data in a field. is there any chance you could make a video about it? I'd really appreciate it! Anyways, thanks a lot for this video. You really know how to explain yourself and make it look so easy!
@MattMacarty
2 жыл бұрын
Let me see what I can do, but there is a datatype in MySQL called ENUM, that does what you want. I talk about it briefly in this video: kzitem.info/news/bejne/l26Os6CFcpiUnHY starting at 14:30
@Adrianacmp
2 жыл бұрын
@@MattMacarty Thanks a lot man! I'll check it
@ironrival9651
2 жыл бұрын
Wow this is a very good tutorial. Thanks a lot.😃
@MattMacarty
2 жыл бұрын
Thanks. Glad it helped
@miguelangelayalaleiva4939
2 жыл бұрын
Me fue de gran ayuda. tank you
@MattMacarty
2 жыл бұрын
Gad it helped
@NaseemaBegum-r6t
Жыл бұрын
can you please describe if there are contents in the table which you have created will the contents also move to another table after foreign constrain is done and what is the use of this, kindly help
@MattMacarty
Жыл бұрын
No the content will not move from one table to another. You are creating a relationship with the foreign key so that you can't add or delete data from tables improperly.
@NaseemaBegum-r6t
Жыл бұрын
@@MattMacarty thankyou for the response may I know if I need to copy the data from one table to another table is it possible
@sweatermanny94
2 жыл бұрын
Very useful but what about creating constraints for specific fields? For example: the field qauntity in the cart table must be more or equal to zero. Any idea on how to create those in workbench?
@MattMacarty
2 жыл бұрын
Yes you can put a UNSIGNED constraint on numerical data so : (Quantity TINYINT DEFAULT 1 UNSIGNED), this would limit input to 0 -127 and set a default value of 1
@anthonyfallon6070
Жыл бұрын
I don’t know what this means, can you maybe give an example how this would be used?
@neux64
2 жыл бұрын
"you can't make primary/foreign keys using text attibutes" This was it, I was wondering why the latest version of MySQL/phpmyadmin was telling me I couldn't do it. I thought it was a bug since both of my datatypes were the same, but they were both TEXT type, so that's why. Thanks!
@MattMacarty
2 жыл бұрын
Glad it helped. MySQL won't let you use varchar either.
@michaelowens2747
2 жыл бұрын
Really helpful
@MattMacarty
2 жыл бұрын
Glad it helped
@ate-trainingplcprogramming4837
Жыл бұрын
Vielen Dank . IT means in German thanks 10000x
@MattMacarty
Жыл бұрын
Glad it helped
@iAmGratchet_
Жыл бұрын
Is it possible to add mulitple values in a column?
@MattMacarty
Жыл бұрын
Yes but this violates first normal form. What did you have in mind?
@45_dzikrimufidtsaqif33
Жыл бұрын
How to do if the table connection we want is in a different schema sir?
@MattMacarty
Жыл бұрын
probably the easiest thing to do is copy the table into your schema
@pranavarora724
Жыл бұрын
thanks man
@MattMacarty
Жыл бұрын
Glad it helped
@appajik858
2 жыл бұрын
thank u so much
@MattMacarty
2 жыл бұрын
Glad it helped
@frog706
2 жыл бұрын
Brilliant video, first one that was actually useful.
@MattMacarty
2 жыл бұрын
THANKS. Glad it helped.
@Justin-mx5ye
2 жыл бұрын
Really insightful video. Thanks for the upload. Any chance you can upload something on complex monte carlo simulations in Python? I'd like to learn more about portfolio management from this perspective.
@MattMacarty
2 жыл бұрын
I have this one: kzitem.info/news/bejne/omaAlop3gax6q5g What were you thinking?
@Justin-mx5ye
2 жыл бұрын
@@MattMacarty I thought this was a helpful video. I am interested in learning more about fundamental research of the stock market using python. For example, I have used monte carlo simulations to simulate varying weights of equities to maximize a sharpe ratio. Any general portfolio management/python videos are always fascinating to me. I know you're probably busy, so thank you so much in advance.
@miguelangelayalaleiva4939
2 жыл бұрын
Gracias
@MattMacarty
2 жыл бұрын
De nada
@Huszan
Жыл бұрын
My referenced column contains only 'Specify Column...'
@MattMacarty
Жыл бұрын
You need to enter the primary for the table that is related
@danilorosado8868
Жыл бұрын
@@MattMacarty I still don't get it
@jakeevans598
9 ай бұрын
I have error: Duplicate foreign key constraint name
@MattMacarty
9 ай бұрын
sounds like you are trying to add the same foreign key constraint twice
@BrianGarside
5 ай бұрын
Helpful, but take too long to make a point like when creating a foreign key.
@MattMacarty
5 ай бұрын
OK
@EricNsi
5 ай бұрын
You sound like the dude from kzitem.info/rock/mrLCXSDScliR7q8AxxjvXg
Пікірлер: 68