Skip to main content

Posts

Showing posts from January, 2016

Automatic Initialization and Updating for TIMESTAMP and DATETIME in MySQL 5.6.5 and up

As of MySQL 5.6.5, TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current timestamp). Before 5.6.5, this is true only for TIMESTAMP, and for at most one TIMESTAMP column per table.

To specify automatic properties, use the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP clauses in column definitions.

For example:
ALTERTABLE`i88`.`ca` CHANGE COLUMN `date``date` DATETIME DEFAULT CURRENT_TIMESTAMPONUPDATECURRENT_TIMESTAMP;
You also need to set the column not null to have the default value, or else it may just use null value.

The order of the clauses does not matter. If both are present in a column definition, either can occur first. Any of the synonyms for CURRENT_TIMESTAMP have the same meaning asCURRENT_TIMESTAMP. These are CURRENT_TIMESTAMP(), NOW(), LOCALTIME, LOCALTIME(), LOCALTIMESTAMP, and LOCALTIMESTAMP().

Use of DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP is specific to TIMESTAMP and D…

How to refresh Netbeans workspace

In Eclipse, you can refresh workspace by pressing F5.

Within NetBeans:

select "Source" > "Scan for External Changes"

or

Go To Tools->Options->Miscellaneous->Files and check Enable-auto-scanning of source.

How to activate your iOS iPhone or iPad's Night Mode feature

1.

Go to the Settings app and enter the General, Accessibility, Zoom menu. Tap the Show Controller switch so it goes green, and the Idle Visibility menu shows up below it.
2.
Now, tap the Zoom switch above so it goes green. The screen may zoom in and a dark circle with arrows will appear.

3.
Tap on the dark circle and a menu will pop up. First, move the slider all the way to the left so you don't get needless zoom. Then, tap Choose Filter, and select Low Light.

4.
Tap anywhere on the screen (but not on the zoom controller itself) to make the menu disappear. Then, find the Show Controller switch, and turn it off. Now you can use it in low light conditions without straining your eyes. But if it isn't for some reason, find the Full Screen Zoom option, and set it to Full Screen Zoom.

5.
To set a short cut for the steps, just go back to the Accessibility menu, and find the Accessibility Shortcut option at the bottom. Set it to Zoom, and you'll be able to toggle Low Light mode on and o…

Abstraction

Abstraction is when you translate the equations, the rules, and the underlying essences of the problem not only into a language that can be communicated to your friend standing with you in an elevator, but also into a form that can percolate down and dwell in your subconscious.

Abstraction is important because it is your subconscious that makes the miraculous leaps of inspiration, not your perspiration or your logic. And unlike you, your subconscious does not understand JavaScript code.

How to Edit videos on YouTube

YouTube Video Editor With the Video Editor, you can: Combine multiple videos and images you've uploaded to create a new videoTrim your clips to custom lengthsAdd music to your video from a library of approved tracksCustomize clips with special tools and effects You can get to the Editor at http://www.youtube.com/editor. Using these tools, you can put together clips to create new videos and publish them to YouTube with one click.

Use aliases to add email addresses to your Microsoft account

An alias is an additional email address for your Microsoft account. It uses the same inbox, contact list and account settings as the primary alias. You can sign in to your account with any alias – they all use the same password. You can send emails from an alias whether you’re using an email app such as Outlook or a device such as a phone.

An alias is also the best way to change your email address, but keep all your emails. Add an alias, then make the new alias primary. Then you can keep or remove the original alias. If you have a @hotmail.com, @live.com or @MSN.com email address and would like to add a new email address, the best way is to add an alias.

Java Micro Frameworks

Java Micro Frameworks, like Jodd, Spark (not Apache Spark) or Ninja Framework. Even lighter than Dropwizard or Spring Boot. 
This doesn't mean that you can't build microservices on Play Framework or other full on frameworks, just that some applications can now be built on ridiculously small frameworks. 

Others: such as JHipsterJavaliteRatpack, and Vert.x.

How to compete in the market

Product — Improve your product or service based on findings about what your customers really want and need. Focus on things like function, appearance and customer service or warranties.

Price — Set a price based on popular profit margins, competitors' prices, financing options or the price a customer is willing to pay.

Placement — Decide where to set up and how to distribute a product. Compare the characteristics of different locations and the value of points of sale (retail, wholesale, online).

Promotion — Figure out how to best reach particular market segments (teens, families, students, professionals, etc.) in areas of advertising and publicity, social media, and branding.

Phablet from Motorola - Moto X Style

Moto X Style - Customizable and affordableOS: Android Lollipop | Screen size: 5.7-inch | Resolution: 1440 x 2560 | Memory: 3GB | Storage: 16/32/64GB | Battery: 3000mAh | Rear camera: 21MP | Front camera: 5MP

Happy money for happy life

It's known well that if you do something with passion you'll always reach success. It's interesting how it can be while doing the favorite thing earning enough money for your life. Engaging in favorite business is always a happy thing for anybody.

What is the difference between Google Cloud BigTable and Google Datastore

The main differences are:BigTable seems to be designed for HBase compatibility, whereas Datastore is more geared towards Python/Java/Go web app developers (originally App Engine) BigTable is 'a bit more IaaS' than Datastore in that it's not 'just there' but requires a cluster to be configured.BigTable supports only one index - the 'row key' (the entity key in Datastore)This means queries are on the Key, unlike Datastore's indexed propertiesBigTable supports atomicity only on a single row - there are no transactionsMutations and deletions appear not to be atomic in BigTable, whereas Datastore provides eventual and strong consistency, depending on the read/query methodThe billing model is very different:Datastore charges for read/write operations, storage and bandwidthBigTable charges for 'nodes', storage and bandwidth

The importance of email marketing

Learning to be a good email marketer isn't just for selling more of your products, it's also for encouraging people to become an active part of your community, to share the same passion for that which you love so dearly. That is why you should learn how to build email campaigns.
Email marketing is an important part of your business because not only does it let you follow up with your customers, but you can also automate the process so you only have to set it up once. In your email marketing software, simply set up an autoresponder that goes out some time after your customer interacts with you.

Business First, Technology Second

IT is a component of business. IT is to serve for business, not vise versa. It helps to see IT projects from the business side of things. It can help you find solutions faster. Skills of understanding the link between technology and its impact on the business are increasing in demand.

How to move Blogger / blogspot to WordPress

Moving posts from Blogspot to WordPress is easy. One has to export the posts from Blogspot and save the XML file. WordPress has included a converter which can be used to imports posts from Blogspot / Blogger.

After Exporting it save the XML file and then go WordPress and then go to Dashboard->Tootls->Import

Select Blogger and it will ask to install the plugin

After which just activate the Plugin

Give the XML file which we downloaded from the Blogspot. Now the blogspot / blogger posts will be converted to WordPress.

Your online account could be shut down without warning

If you're working on Tumblr, Twitter, Facebook, Google+, or any other social platform, it is like building castles on sand.  If the site receives a complaint that you've used copyrighted material, it can shut down your account, erasing everything you've ever posted. There are many incidents where people have had online accounts shut down without warning. You could lose several years of work and material.
If you're using any of these platforms and they are important to you, be aware of the risk. And be aware that enforcement of their rules can be arbitrary and selective. Investing in platforms you can't control involves risks.

If you do decide to focus on the platforms you don't control, make backups of everything you post. Someday you may thank yourself.

How to monetize your traffic

Any audience can be monetized. Once you have people's eyeballs, you can make money. Most passive income streams fall into the following categories:  If your niche is something entertainment related, then ads are usually the way to go. For this you need sheer numbers in order to make anything profitable. E.g.Google AdsenseAffiliate (such as Amazon) - if your audience would be interested in products, then tell them to go buy the products they'd already be interested in and make a small commission. If you're doing something compelling that no one else can do, then charge a fee for it. You can handle payment through PayPal or Stripe. If you are offering "secret information" then charge a monthly fee for being a part of your cult.

HOW T O BUILD SOMETHING THAT'S COOL

Find two things or more things you are passionate about and combine them. For example, web development or accounting will be one of them. Make something unique that provides value to people in the form of utility or entertainment.