In MySQL you can add an event to a database that runs in a interval to automate database tasks. You can wait for intervals and check the table to see the changes. By default, the event scheduler thread is not enabled in the database. You need to enable this: SET GLOBAL event_scheduler = ON; Or […]
Search: “data”
We found 1,473 results for your search.
Store IP Addresses as UNSIGNED INT
Want to store IP addresses in database and still using VARCHAR(15)? You can actually store IP addresses as integer values because using INT you go down to 4 bytes of space and have a fixed size field. As the range of a IP Addresses are 32 bit unsigned integer you can use your column as […]
MySQL export table to CSV
MySQL provides an easy way to export table result set into a CSV file. Suppose we have a query like: SELECT name, email, age FROM users WHERE status = ‘Active’; So if we need to export this data into a csv file then using below query we can do: SELECT name, email, age FROM users […]
Use NOT NULL if required
First of all think whether you require a NULL field or not.If having an empty string value can make any sense then use it otherwise use NULL value for a specific reason. So, Put NOT NULL if required. NULL columns require additional space in the row and add complexity to your statement. Avoid it for […]
PROCEDURE ANALYSE()
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 […]
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 […]