Today I see an mysql error in my apache log that I never faced before. default decode:true ">InternalError: (1205, u'Lock wait timeout exceeded; try restarting transaction') (10 additional frame(s) were not displayed) After lot of research I found solution. We can set variable innodb_lock_wait_timeout=100 for lock time to 100 sec. http://quickadsense.com/ --> none; margin:0px 0 […] Read more
phpMyAdmin is a free, open source web-based database management tool written using PHP programming language. It allows the database administrators to manage single or multiple database servers either from a local or remote system using a web browser. phpMyAdmin used to create, delete, rename, edit databases, tables, fields, and also used to directly execute any […] Read more
A stored function is a special kind stored program that returns a single value. You use stored functions to encapsulate common formulas or business rules that are reusable among SQL statements or stored programs. Different from a stored procedure, you can use a stored function in SQL statements wherever an expression is used. This helps […] Read more
A database table contains multiple columns with specific data types such as numeric or string. MySQL provides more data types other than just numeric or string. Each data type in MySQL can be determined by the following characteristics: The kind of values it represents. The space that takes up and whether the values is a […] Read more
A stored procedure is a subroutine available to connected relational database system applications. A stored procedure is a set of Structured Query Language (SQL) statements with an assigned name, which are stored in a relational database management system as a group, so it can be reused and shared by multiple programs. A stored procedure can […] Read more
