If you want to analyze the columns structures of a MySQL table and want to view the actual data in your table with certain suggestion then you can get help from PROCEDURE ANALYSE(). For example, if any data present in your table and plays a big role in any decision making then this is very […]
Search: “data”
We found 1,491 results for your search.
KnockoutJS – Declarative Bindings
To connect data to UI declarative bindings are used. As bindings and Observables both are different, using normal javascript object you can bind view. Declarative Bindings consists of two values i.e. name and value: Full name: <input data-bind=”value: fullName, valueUpdate: ‘afterkeydown’” /> Here when each key is pressed value will be updated.
Replace NULL values
You can show the null values which represent the concept of missing or inapplicable information, with other values for better data representation. Suppose we have a table as below: Name Country John India Jane Australia Tim [NULL] So if you query from the database the null result will show the blank result. You can replace […]
Construction projects can be complicated, with many moving parts, teams, and deadlines to manage. Making sure the finished product is high-quality is essential. But finding and fixing problems during construction, especially in large projects, isn’t easy. That’s where Construction Defect Management Software comes in. It helps teams find and fix problems. What Is Construction Defect […]
Components of KnockoutJS
Components are way of organizing the UI code for structure wise and promote code re-usability for a large application. Components can be registered using the ko.components.register() API. ko.components.register(‘componentname’, { viewModel: {…}, template: {….) }); <!DOCTYPE html> <head> <title>Components of KnockoutJS</title> <script src=”https://cdnjs.cloudflare.com/ajax/libs/knockout/3.2.0/knockout-min.js”></script> </head> <body> <h4>Example 1: without parameters</h4> <div data-bind=’component: “example-editor”‘></div> <h4>Example 2: passing parameters</h4> […]
Since 59% of the global population is looking for products and services online, it is imperative that your company has a strong online presence to stand ahead of competitors. Customized web applications offer greater security, scalability, and features that are basically designed to meet the demands of individual businesses. Custom creation, as opposed to off-the-shelf […]
MySQL copy table
It is very useful to copy table data from a old existing table to a new table when you need to back up data and replicating the production data for testing. To copy data from one table to another table, you can use CREATE TABLE and SELECT statements as follows. Simple example of copy table: […]
AngularJS Scopes
AngularJS scopes is a special object which joins controller with views. $scope object access model data in controller as it is the first argument to controller. $scope is specifically for controller so it can inherit its parent controller also. Basically, scope is an object which refers to the application model i.e. an execution context for […]
Create Trigger in MySQL
Using CREATE TRIGGER statement you can create a trigger. You have to put the trigger name after the trigger statement. Let’s see an example of Create Trigger: For example we have two tables i.e. users and userhistory. users:userIDfirstNamelastName userhistory:userIDlast_update Read Also: INSERT … ON DUPLICATE KEY UPDATE Now we will create a trigger before update […]
KnockoutJS – Observables
3 concepts in which KnockoutJS is build upon is:– Through observables dom elements and ViewModel exchange information– Bindings between UI and ViewModel– Templating web applications To make it observable declare as:this.property = ko.observable(‘value’); Let’s try below Observables example: <!DOCTYPE html> <head> <title>KnockoutJS – Observables</title> <script type=”text/javascript” src=”http://ajax.aspnetcdn.com/ajax/knockout/knockout-3.1.0.js”></script> </head> <body> <!– This is input box, used […]
