MySQL Database Tutorial - 27 - How to Insert Multiple Rows

Question: can't we just combine two tables with a JOIN statement?

How to use FOR statement?

550th like😁😁😁😁😁😁😁

THANK! LIKE IF YOU ARE IN THE FUTURE!

Hey you are awesome

very useful trick :-), thanks

i want to know how to insert a data in two relation tables using textbox( window form) in c#

Ok then what about inserting a row in between to sequential ids? I would like to renumber the last ids, in other words bump them up. For example I have ids 1,2,3 and want to add a row in between 1 and 2? How would that be possible?

Awesome!!

Love you Bucky!!

thanks Bucky,
how do i use the 'WHERE' clause in the insert, select statement

i need to insert sub columns .. how ??

how do you merge it then ? 😃

This might sound silly, but an Oracle mentor of mine advised me that to properly avoid at the comma problem, you should always BEGIN with the comma on each new line. Good habits can prevent many errors.

How to insert a row into row #1? I mean not append a row at last.

Thanks again Bucky for great tutorials!

what happens if the faketable has the same id number with the items?

I want to bid for beef chops!

nada

I've had lots of good reasons to insert data via selecting from another table. It is not a "bad practice". Having unnecessarily duplicate data is bad but that is a concern separate from using this technique.

Example: There is a client with 2 apps with 2 separate databases. 1 is ancient and gigantic and contains 15 years worth of info from 6 businesses. Employees update that database via a desktop program that only runs in windows 95 and its original developers are all dead. The other database is small and fast and properly normalized and powers both a website and mobile app that sells a tiny fraction of things from 1 of the businesses. Rather than have employees add items via the desktop app and then repeat that work to add the items to the smaller website, we select the data from the older database and by using aliases in our SELECT statements we create result sets that exactly match the table structures in the newer database and we copy only the relevant data into the new site.

"send me a million dollars" lol

Technically NULL means unknown, which is different from an empty string.

nice,It's easy to understand.I want to konw where can i watch your video of C++

Question for SQL specialists : Why can't i use function NVL to replace null by random number?

anti vegetarian episode -_-

jelly pockets and sack of ham

i would like to buy a babyfoot.

Come on,baby no emmy no emmy

it was not set as autoincrement, but it was a primiary key nonetheless, so it must have been not null

they still have to be uniqe, you can type INSERT INTO items(id,name) SELECT id+106,name FROM customers Now ids will be uniqe. How's your career after 11months? Are you working with SQL maybe? :D

Bucky<3 You save lives! Thank you so much :)

LoL this was upload on my birthday last year XD

You can just leave the id (first field) empty while entering values, since I guess it is an autoincrement field.

thank u

Agreed but this is good for school shit.

Thanks very knowledgeable

So i a few words,im not gonna make lot of money by just being a database admin,and i need several months to be tested?

I dont understand your comment at all.....

If i work in a company as a database administrator,am i gonna make good amount of money by doing that...?? what kind of stuff companies make ya do if ur a database admin?

Expensive baby seat!

WHATS WITH THE sql rule THAT ONE ROW MUST HAVE A UNIQUE VALUE(key), BUT IF YOU COPY id FROM ANOTHER TABLE YOU WILL HAVE THE SAME ID FOR MULTIPLES ITEMS ?????

* sneakily doesn't send him a million dollars*