Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
MySQL Database Tutorial – 17 – Functions
Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …
Original source
25 responses to “MySQL Database Tutorial – 17 – Functions”
how the table got attribute of UPPER NAME without using AS key word.(1:52).
The video was informative and easy to grasp. Here is another piece of information on MySQL Functions: http://www.raresapience.com/mysql-functions/
I hope you'll like it.
What difference does it makes by using "WHERE 1" (Duration: 5:26)
Love you BUCKY <3
now I see why they named the antivirus AVG
Here is code to find average and round off the values:-)
SELECT ROUND(AVG(cost)) FROM items
The cost of new gym socks is $2.34 yet it has 566 bids hahahaha
1 person didn't have a graphing calculator
[SQL]SELECT
CHARACTER_SETS.CHARACTER_SET_NAME,
CHARACTER_SETS.DEFAULT_COLLATE_NAME,
CHARACTER_SETS.DESCRIPTION,
CHARACTER_SETS.MAXLEN
FROM
CHARACTER_SETS
CONCAT(DESCRIPTION,MAXLEN)
AS New
[Err] 1064 – 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 '(DESCRIPTION,MAXLEN)
AS New' at line 8
whats wrong ??
Wow, that was a lot in one lesson. But I took notes and I'm pretty sure that I understand it all. On to the next. Kudos! Tnx Bucky 😀
WHat tutorials do you show how to build table and connect them and make primary keys and import files? Please let me know. thee are great.
RAND is random i guess also a function
mysql> SELECT DATEDIFF('2011-3-12', '2011-1-12'); this one returns number of days between two dates…used on e-bay when determining end of auction
YESS, and I'll add on that he's the best teacher
haha square root jokes… best jokes ever!!
are in these video tutorials lessons how to use the databases in you site'
thank u
list of Functions and more detailes ;-)… thankx Bucky Roberts
dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html
Tutorial 18 posted out of order? ok
Use SQL functions like AVG and DATE_FORMAT to get the data exactly the way you need it and feed it to your PHP rather than using your PHP to format the data 🙂
Bucky, if i become famous one day, I will say Bucky Roberts is the best programmer in the world
pretty sweet huh..
I already know MySQL, but Bucky's awesome tutorials teach me so much that I didn't know yet.
Awesome
Bucky, you describe a few of the built in functions in this video; will you end up making a video on user defined functions and procedures?