Thank you Quentin! After I managed to export my dissertation dataset as a CSV file from SPSS I have been using your tutorials to run queries on my data on MyPHP. They are to the point and really helpful and i will definitely recommend.
I was getting an error because of the space. As soon as I hit "Play" here, I paused it, went back, removed the space, came back and it worked, even so I went on watching because why not and sure enough, right after a minute you mentioned the space after "COUNT" lol little things that make you pull your hair out smh
Ugh I can't figure out why I can't do SUMs or AVG... I've tried many variations, including: SELECT SUM('supplier_number_of_products') FROM 'supplier' Don't judge me on the name of column, but the column name and table is correct. The column 'supplier_number_of_products' is set as SMALLINT(4) in the structure, so I can't figure out why this aint' working... Anyone? :-(
So hard to find good MySQL tutorials on RUclips. Glad to say I don’t have that problem anymore! I am now subscribed.
Your lessons are amazing, I actually played with wildcard in the example. Good job!!
Thank you Quentin! After I managed to export my dissertation dataset as a CSV file from SPSS I have been using your tutorials to run queries on my data on MyPHP. They are to the point and really helpful and i will definitely recommend.
Great video! Most MySQL tutorials are over twenty minutes. Nice to find a simple one.
Thanks... really saved me🙏
I'm glad to hear that.
You solved my problem. Thank you.
Great news!
You are the best one! Thanks for the lesson!
this is sooo amazing and helpful. thank you
You say to not mess up the BRACKETS after COUNT...but those are PARENTHESIS!
Haha just kidding. Good videos. Thank you!
Thankyou sir👍👍👍
Pleasure!
Thank You&Good job
thanks buddy
subscribed
Thank you.
How about summing up query that has the same entry name in the table?a lot of the same entry name that i need to sum up the specific column.
may i know how do i display the result? tq
Dear sir. I want to sum four table quantity column additions and one table quantity column substraction php? How they done it?
How do I add a column which is sum of other two columns
how to auto increment value on its own in a single row? example i have 1 then i want to make it 2 like 1+1 = 2
how to use join bro
How to make udf for count
Hi I want to do fiction SUM with numbers with commas but the results add the first two numbers like 1,000 +1,000 will give a 2 pls help.
I was getting an error because of the space. As soon as I hit "Play" here, I paused it, went back, removed the space, came back and it worked, even so I went on watching because why not and sure enough, right after a minute you mentioned the space after "COUNT" lol little things that make you pull your hair out smh
So, how can I get that sum value in C# programming?
Cheers!
how can we save arthmetic operations between two columns in next column of same table in sql...any guides ?
Try reading up on inner joins as column_name
it sinks well
Hi i need Hélp please
Does anyone know how to use the count function to count the number of blue lightsabers for example? as opposed to counting the total product names?
Late answer but if you didnt find an answer for that just do.
SELECT COUNT(`Items`) FROM Shop WHERE Items = 'Blue_Lightsaber'
FIZZ main btw 💤
Didn't see any problem when I used count not COUNT.
Ugh I can't figure out why I can't do SUMs or AVG...
I've tried many variations, including:
SELECT SUM('supplier_number_of_products') FROM 'supplier'
Don't judge me on the name of column, but the column name and table is correct. The column 'supplier_number_of_products' is set as SMALLINT(4) in the structure, so I can't figure out why this aint' working...
Anyone? :-(
does this work: SELECT SUM('supplier_number_of_products') FROM `supplier`
using ` ` instead of ' ' for supplier
0:22