-
MyISAM的索引与数据分开存储
-
MyISAM的索引叶子存储指针,主键索引与普通索引无太大区别
-
InnoDB的聚集索引和数据行统一存储
-
InnoDB的聚集索引存储数据行本身,普通索引存储主键
Over the years there’s been a steadily increasing ecosystem of JavaScript components to choose from. The sheer amount of choices is fantastic, but this also infamously presents a difficulty when components are mixed-and-matched. And it doesn’t take too long for budding developers to find out that not all components are built to play nicely together.
To address these issues, the competing module specs AMD and CommonJS have appeared on the scene, allowing developers to write their code in an agreed-upon sandboxed and modularized way, so as not to “pollute the ecosystem”.
Asynchronous Module Definition (AMD) has gained traction on the frontend, with RequireJS being the most popular implementation.
Here’s module foo
with a single dependency on jquery
:
$.fn.extend({
// options: [{label: '', css: '', valueProperty: '', textProperty: '', selectedValue: '', childProperty: ''}, {...}]
linkedDropdownList: function(data, options) {
var _this = $(this);
var id = _this.attr('id') + '_linkedDDL';
var selectedObjects = [];
var elFields = [];
var elContainer = $('<div id="' + id + '"></div>');
_this.append(elContainer);
USE oauth;
CREATE TABLE oauth_client_details (
client_id VARCHAR(255) PRIMARY KEY,
client_name VARCHAR(255),
client_secret VARCHAR(255),
resource_ids VARCHAR(255),
scope VARCHAR(255),
authorized_grant_types VARCHAR(255),
<label> | |
<i class="icon-loading"></i> Loading | |
</label> |
Describe how to build best popular APIs
Under REST principles, a URL identifies a resource. The following URL design patterns are considered REST best practices:
- URLs should include nouns, not verbs.
- Use plural nouns only for consistency (no singular nouns).
- Use HTTP methods (HTTP/1.1) to operate on these resources:
Describe how to use ajax to download files.
<button type="button" id="GetFile">Get File!</button>
$('#GetFile').on('click', function () {
$.ajax({
url: 'https://s3-us-west-2.amazonaws.com/s.cdpn.io/172905/test.pdf',
Records complex knowledge about JavaScript programming language.
new Promise( /* executor */ function(resolve, reject) { ... } );
Records complex knowledge about MySQL