You don't have to include "INSERT INTO employee VALUES" for subsequent rows. Using following way you can get rid of these redundant entries. INSERT INTO Employee VALUES (100, 'David', 'Wallace', '1967-11-17', 'M', 250000, NULL, 1), (101, 'Jan', 'Levinson', '1961-05-11', 'F', 110000, 100, 1), (102, 'Michael', 'Scott', '1964-03-15', 'M', 75000, 100, 1);
I'm so glad to have found you Mike. I've been watching all your videos for these last 2 weeks and I'm gradually starting to see the big picture. I've started with C# because I wanted to have some basis for Unity (regarding sound design) but as I went on thought your tutorials I felt like I could take it a little bit further and actually learn some other programming languages just for curiosity. From there I went onto PYTHON and JAVASCRIPT which in the case of this last one I had to go a little back in time to revisit and learn some concepts about implementing CSS and HTML. At this moment I'm in the middle of the SQL tutorials, but I just wanted to tell you man that you're a great teacher and that I'm learning a lot from you. Thank you soo much for your effort and dedication. You have a bright future ahead. All the best!
If you're having trouble finding the source code, click the link in the description and then notice that on the left, there is a list of all of the videos, which will contain their respective code.
i'm getting the error "Failed to add the foreign key constraint. Missing column 'employee_id' for constraint 'branch_ibfk_1' in the referenced table 'employee'"; when creating the table branch and giving the condition of mgr_id as foreign key. Can somebody help me resolve this error !!!!
I'm getting error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY(mgr_id) REFERENCES employee(emp_id) )' at line 6
For source code, click on source code link in the description --> Then in the list of tutorials on the left hand side of the page, click on "Creating Company Database" (same as the title of this RUclips video) --> and you will find the code under the embedded video.
Hey MIke when i am trying to exciute the code for Server: Msg 1785, Level 16, State 1, Line 1 Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Server: Msg 1750, Level 16, State 1, Line 1 Could not create constraint. See previous errors . Not sure how to fix this
@@stanleyjohn4670 No problem with adding values in Employee Table before creating Branch Table without adding a Foreign Key. Also, when you add a Foreign Key in Employee Table referencing Branch Table, it would definitely cause an error because Branch Table doesn't exist yet.
@@StRik3EagLe makes sense. Are you working as a DBA or anything related to SQL? I want to find some advanced SQL courses after this but can't get hold of any.
@@stanleyjohn4670 No, I was taking this course just for the heck of it. Try Udemy or Coursera if you're unable to find any advanced level courses on RUclips.
i have a similar assignment but no values are given, just telling us to come up with tables, is there any need for me to fake populate it with data? if yes, where do i get the data from?
Outside of training purposes, you don't have to do the ALTER TABLE employee ADD FOREIGN KEY(branch_id) right away. You can just enter the branch #'s first, do the ALTER TABLE later, and not have to do those UPDATE employee commands.
You should have include Dwight Schrute and Pam and Oscar and Kevin. Damn You also missed Toby(HR). 😁😁. I'm a huge fan of The office Sitcom which is more than enough for my motivation to learn mysql. Parkour Parkour. 🤘✊
At 5:43 ruclips.net/video/LzeVPZtJglE/видео.html While executing below syntax: ALTER TABLE employee ADD FOREIGN KEY(super_id) REFERENCES employee(emp_id) ON DELETE SET NULL; Error: Msg 1785, Level 16, State 0, Line 27 Introducing FOREIGN KEY constraint 'FK__employee__super___3D5E1FD2' on table 'employee' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Msg 1750, Level 16, State 1, Line 27 Could not create constraint or index. See previous errors. Could you please help me what went wrong?
Be careful Mike!! When you create the table "employee" following your source code, you create the birth date as "birth_day" instead of "birth_date" :)) Anyway, this course its so helpful!! Thank you so much!!
@@kushalshah4728 Go to the link, and look in the left side there will be a bunch of tabs naming each of the tutorials in the series, click onto the tab with the name "Creating Company Database", below that video you will find the code.
I give it to you my friend and tutor, you are the best. You have a unique way of making it all so simple and fun too. I have really learnt enough from this tutorial and I hope to follow on the others you did on different other programming languages. Thanks bro ...from Nigeria
@Mike Dane Are you still Here i could use some help as a beginner. I need Conversation Table, where we got Date of sent or date when message was received also What message is, and Who send it and who received it. So TIme and Date when Message is Received, Who received it and who send it Also should Save Sent messages and also Status of the message...
thank you so much .. it' was useful tutorial..and I'm sorry for bothering you but I have problem when I try to insert the data.. it gives me an error says(literal does not match format string)and I use oracle sql developer
hi mike, interesting tutorial and all.. why dont u show how a few different computers will connect to it? they cant use localhost like you do, cant they? can u make a tutorial on how to run a company database and let other users from different computers upload into it?
You don't have to include "INSERT INTO employee VALUES" for subsequent rows.
Using following way you can get rid of these redundant entries.
INSERT INTO Employee
VALUES
(100, 'David', 'Wallace', '1967-11-17', 'M', 250000, NULL, 1),
(101, 'Jan', 'Levinson', '1961-05-11', 'F', 110000, 100, 1),
(102, 'Michael', 'Scott', '1964-03-15', 'M', 75000, 100, 1);
Thanks! That saved me a lot of work :)
Thanks buddy!
Thanks, man.
I'm so glad to have found you Mike. I've been watching all your videos for these last 2 weeks and I'm gradually starting to see the big picture. I've started with C# because I wanted to have some basis for Unity (regarding sound design) but as I went on thought your tutorials I felt like I could take it a little bit further and actually learn some other programming languages just for curiosity. From there I went onto PYTHON and JAVASCRIPT which in the case of this last one I had to go a little back in time to revisit and learn some concepts about implementing CSS and HTML. At this moment I'm in the middle of the SQL tutorials, but I just wanted to tell you man that you're a great teacher and that I'm learning a lot from you. Thank you soo much for your effort and dedication. You have a bright future ahead. All the best!
He's soo so good. Am personally recommending him to anyone that wants to learn programming.
If you're having trouble finding the source code, click the link in the description and then notice that on the left, there is a list of all of the videos, which will contain their respective code.
i'm getting the error "Failed to add the foreign key constraint. Missing column 'employee_id' for constraint 'branch_ibfk_1' in the referenced table 'employee'"; when creating the table branch and giving the condition of mgr_id as foreign key. Can somebody help me resolve this error !!!!
where's the mentioned pdf?
Could you kindly share the PDF document for this database with me?
The Office references are awesome! Thanks for the great instructional!
I have to say a massive thank you to you, Mike!! Your tutorials are incredibly clear and helpful!! Thanks for offering these great videos for free!!!
I'm getting error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY(mgr_id) REFERENCES employee(emp_id) )' at line 6
i got the same erro message at this place!
For source code, click on source code link in the description --> Then in the list of tutorials on the left hand side of the page, click on "Creating Company Database" (same as the title of this RUclips video) --> and you will find the code under the embedded video.
Awesome Mike....
I do not see the code in description.Which tool do you use to draw ER diagram?
Hey MIke when i am trying to exciute the code for Server: Msg 1785, Level 16, State 1, Line 1 Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Server: Msg 1750, Level 16, State 1, Line 1 Could not create constraint. See previous errors
. Not sure how to fix this
at 10:00min Can you do
UPDATE Employee
SET branch_id = 1
WHERE branch_name = 'Corporate'; ??
no
Too bad this is MySQL... I need to learn MS SQL Server.
Mike, how about getting back? The world needs your tuts! Great work!
Thank you so much Mike! Your way of explaining things really click with me. Hope you make more and more precious tutorials.
Instead of going circular(due to Foreign Key Constraint) for Inserting Rows, we can Create all the Rows first and then add Foreign Keys.
What happens if we add in the branch_id number in the employee table before we create the branch table itself? Will it cause an error?
@@stanleyjohn4670 No problem with adding values in Employee Table before creating Branch Table without adding a Foreign Key.
Also, when you add a Foreign Key in Employee Table referencing Branch Table, it would definitely cause an error because Branch Table doesn't exist yet.
@@StRik3EagLe makes sense. Are you working as a DBA or anything related to SQL? I want to find some advanced SQL courses after this but can't get hold of any.
@@stanleyjohn4670 No, I was taking this course just for the heck of it.
Try Udemy or Coursera if you're unable to find any advanced level courses on RUclips.
Perhaps he does it circular as to show how values could be added even after foreign keys are made? Either way, your comment is good to know.
how about brand_supplier. I couldn't see you create it.
I had any troubles trying to create the campany database haha
i have a similar assignment but no values are given, just telling us to come up with tables, is there any need for me to fake populate it with data? if yes, where do i get the data from?
It's not better to first put values in branch and than use them typing values in Employee without updating?
same here
INSERT INTO employee VALUES(100, 'David', 'Wallace', '1967-11-17', 'M', 25000, NULL, NULL); I get literal does not match format string
Outside of training purposes, you don't have to do the ALTER TABLE employee
ADD FOREIGN KEY(branch_id) right away. You can just enter the branch #'s first, do the ALTER TABLE later, and not have to do those UPDATE employee commands.
You should have include Dwight Schrute and Pam and Oscar and Kevin. Damn You also missed Toby(HR). 😁😁. I'm a huge fan of The office Sitcom which is more than enough for my motivation to learn mysql. Parkour Parkour. 🤘✊
At 5:43 ruclips.net/video/LzeVPZtJglE/видео.html
While executing below syntax:
ALTER TABLE employee
ADD FOREIGN KEY(super_id)
REFERENCES employee(emp_id)
ON DELETE SET NULL;
Error:
Msg 1785, Level 16, State 0, Line 27
Introducing FOREIGN KEY constraint 'FK__employee__super___3D5E1FD2' on table 'employee' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 1, Line 27
Could not create constraint or index. See previous errors.
Could you please help me what went wrong?
Be careful Mike!! When you create the table "employee" following your source code, you create the birth date as "birth_day" instead of "birth_date" :))
Anyway, this course its so helpful!! Thank you so much!!
Hey ... Can u help me . I can't find the source code on the link mentioned
@@kushalshah4728 Go to the link, and look in the left side there will be a bunch of tabs naming each of the tutorials in the series, click onto the tab with the name "Creating Company Database", below that video you will find the code.
Hello Mike, all the good words had been written to you already ❤ so I'd only like to ask if any of your video covers stored procedures as well?
I give it to you my friend and tutor, you are the best.
You have a unique way of making it all so simple and fun too. I have really learnt enough from this tutorial and I hope to follow on the others you did on different other programming languages.
Thanks bro ...from Nigeria
Can't find the source code in your website. Please can u help....
Good Mann. your little efforts made beginner's life easy ... please keep it up.
You helped with my schoolwork! Thank you!
@Mike Dane Are you still Here i could use some help as a beginner. I need Conversation Table, where we got Date of sent or date when message was received also What message is, and Who send it and who received it. So TIme and Date when Message is Received, Who received it and who send it Also should Save Sent messages and also Status of the message...
It is Employee conversation of never mind company.
thank you so much .. it' was useful tutorial..and I'm sorry for bothering you but I have problem when I try to insert the data.. it gives me an error says(literal does not match format string)and I use oracle sql developer
hi mike, interesting tutorial and all.. why dont u show how a few different computers will connect to it? they cant use localhost like you do, cant they? can u make a tutorial on how to run a company database and let other users from different computers upload into it?
foreign keys have to be unique or priamry keys
Can you share this compony er diagram
please am having this alert saying i have duplicate data.....Whats the way forward? ...Please help me am stuck
you must be trying to create the same table twice or something drop it first
how would you get any tables or data out of the database via a web interface, or for use in an office environment via a shared network?
can we create the whole tables, insert all the values and then add primary and foreign keys in alter statements?
did you give this a try? How did it go? Thinking of doing same
inserting data into corporate i said , i get this alert that i have a duplicate primary key ie 100 , WHAT should i do to reverse this
PLEASE any help here
thankyou
Awesome mike thanks for the awesome video I really needed it :-D
great content. Thanks Mike
A real Code Professor ❤️🙏
When I use the DATE datatype, it doesn’t work, is this common
Amobi Ndubuisi T. Yes, but when i use DATE, it doesn’t highlight like it’s a command
good practice!!
So good tutorial
appreciate your effort!
Thank You
Thank you!
I CAN NOT SEE THE SOURCE CODE
CAN YOU DIRECT ME
I CLICKED THE LINK BUT STILL I CAN NOT SEE IT
Broke ur caps button? calm the fuck down son
so im looking into developing a database and would love to know which text editor you were using to create the database
POPSql
have installed mysql and dbeaver how can I create database?
I just typed CREATE DATABASE database_name; and then USE database_name;