Categories
MySQL

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: […]

Categories
Feature Story Health

The Rise and Fall of Quaaludes: A Historical Perspective on a Controversial Drug

Introduction Quaaludes, short for methaqualone, is a sedative-hypnotic drug that gained notoriety in the 1960s and 1970s. Initially prescribed as a sleep aid and muscle relaxant, it soon became a popular recreational drug. This article explores the history, uses, and controversies surrounding Quaaludes, shedding light on a bygone era of pharmaceutical experimentation. The Birth of […]

Categories
Css3

Webfonts Explained

Unlike web safe fonts a webfont is a special font used on websites using the CSS @font-face declaration. A webfont has four flavors. A TrueType, WOFF, EOT and an SVG file. To target in different browsers each one is designed. You will require all four files when using webfonts for a website. You can get […]

Categories
MySQL

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 […]

Categories
Css3

Columns using CSS3

It is very difficult to pull off column-based layouts in CSS. But, now there is a way to this using the CSS rule – columns i.e. Columns using CSS3. Columns using CSS3 – HTML: <div class=”container”> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born […]

Categories
KnockoutJS

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 […]

Categories
KnockoutJS

KnockoutJS MVVM Application Framework

Now a days everyone use a single page application i.e. all necessary information are gathered into a single page and KnockoutJS is no exception of this which uses MVVM Application Framework. This is a client side framework which very easily bind html to domain data with MVVM pattern. MVVM is an architectural design pattern for […]

Categories
Corporate

How Many Hours Are International Students Allowed to Work in Canada?

Canada is also an ideal alternative for overseas students who want to get a good education and live in a cosmopolitan environment while working part-time. Students from India and other parts of the world must know and comprehend the rules and regulations governing working hours in order to maintain a balance between studies and finances. […]

Categories
AngularJS

AngularJS internationalization

For internationalization AngularJS uses three types of filters i.e. currency, date and numbers. We need to incorporate corresponding js depends on locale of the country. <script src=”https://code.angularjs.org/1.2.5/i18n/angular-locale_da-dk.js”></script>

Categories
MySQL

MySQL custom row number in a result set

You can add a sequential number as a custom row number of a row using SET clause and increment at next row. Suppose users table has columns name and age.When you want to show the result you want to add extra column serial_no. So using below query you can achieve custom row number: SET @serial_number = […]