The default port for MySQL server is 3306.
Monthly Archives: June 2014
MySQL Features
The following list shows the most important properties of MySQL.
- Clients and Tools
- Localization
- Connectivity
- Scalability and Limits
- Security
- Data Types
- Client/Server Architecture
- Stored procedures
- Views
- SubSELECTs
- SQL compatibility
- Triggers
- Unicode
- User interface
- Full-text search
- Replication
- Transactions
- Foreign key constraints
- GIS functions
- Programming languages
- ODBC
- Platform independence
- Speed
- Relational Database System
ACID
In computer science, ACID (Atomicity, Consistency, Isolation, Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.
Difference Between jQuery and jQuery U
jQuery is the core library. jQueryUI is built on top of it. If you use jQueryUI, you must also include jQuery.
jQuery UI
jQuery UI is a curated set of user interface interactions, effects, widgets, and themes built on top of the jQuery JavaScript Library that can be used to build interactive web applications.
jQuery Difference Between .stop(true,true) And .finish()
The .finish() method is similar to .stop(true, true) in that it clears the queue and the current animation jumps to its end value. It differs, however, in that .finish() also causes the CSS property of all queued animations to jump to their end values, as well.
jQuery .finish() Method
The .finish() method stops all queued animations and places the element(s) in their final state. This method was introduced in jQuery 1.9.
jQuery Migrate Plugin
With release of 1.9 version of jQuery, many deprecated methods were discarded and they are no longer available. But there are many sites in production which are still using these deprecated features and it’s not possible to replace them overnight. So jQuery team provided with jQuery Migrate plugin that makes code written prior to 1.9 work with it.
So to use old/deprecated features, all you need to do is to provide reference of jQuery Migrate Plugin.
jQuery Source Maps
In case of jQuery, Source Map is nothing but mapping of minified version of jQuery against the un-minified version. Source map allows to debug minified version of jQuery library. Source map feature was release with jQuery 1.9.
jQuery Deferred And Promise Object
Deferred and promise are part of jQuery since version 1.5 and they help in handling asynchronous functions like Ajax.