ExtJS Associations: The Good, the Bad and the Ugly

As you may already know, with the release of ExtJS 4.0 came a heralded new feature of associated data models, briefly introduced in the Countdown to Ext JS 4 Blog Post. At first glance, associations seem absolutely spectacular: an easy means of retrieving relational data without all the messy callbacks and recursive searching that you may have experienced in the past. Truth be told, associations are pretty cool, however there are just a few quirks…

"ExtJS Associations: The Good, the Bad and the Ugly"

Power, Beauty, Soul – 100 Years of Aston Martin

Aston Martin known for it’s power, beauty, soul,  is one of the most iconic British brands, and not so iconic as in 2013 with the luxury sports car maker celebrating its centenary year. The last 12 months has seen the brand celebrate in its birthday in true British style, but how did it all start? Delving into a Rich History The company was founded in 1913 by Lionel Martin and Robert Bamford, and acquired its…

"Power, Beauty, Soul – 100 Years of Aston Martin"

Update Command in Mysql

Update command is used to update record in the table based upon some condition, if condition is missing then all record will get updated. Syntax : UPDATE tablename SET column1=value1,column2=value2 WHERE condition Eg: UPDATE user SET name=’abhishek’,age=’22′ WHERE salary>22000 above query will update the name to ‘abhishek’ and age to ’22′ whose salary is greater than 22000. Updating table based upon pattern matching. Suppose we want to add 2 years to age whose name has…

"Update Command in Mysql"

List of Mysql Mathematical Functions

Below is the complete list of Mysql Mathematical Functions Name Description ABS() Return the absolute value ACOS() Return the arc cosine ASIN() Return the arc sine ATAN2(), ATAN() Return the arc tangent of the two arguments ATAN() Return the arc tangent CEIL() Return the smallest integer value not less than the argument CEILING() Return the smallest integer value not less than the argument CONV() Convert numbers between different number bases COS() Return the cosine COT() Return…

"List of Mysql Mathematical Functions"

Mysql Introduction

Mysql is a RDMBS ie Relational Database Management System. It is the most popular RDMS used with php. Mysql uses various storage engine .Some of them are MyISAM,MEMORY,HEAP,MERGE,InnoDB etc .The defalut storage engine is MyISAM. Below are the some operations which are frequently used . Insert Syntax : insert into tablename(column1,columan2…..) values (values1,values2…….). alternate  syntax insert into tablename values (values1,values2…….). Eg :  Insert into user (name,age,sex) values (‘Manish’,’23′,’Male’) Here table name is user, the order…

"Mysql Introduction"