PostgreSQL | Create a connection to a local postgres database in pgAdmin |||

| By Webner

Steps to create a connection to a local postgres database in pgAdmin ||| : 1. Make sure PostgresSql and its components should be installed in ubuntu system. 2. Check what databases are available in postgresSql through terminal 3. Login to

MYSQL | #1293 – Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP

| By Webner

Suppose we want to have columns created_date and last_modified_time with default timestamp in any table in MySQL/Phpmyadmin. Let us take an example of Students table. Create table Students using following query : CREATE TABLE students( id INT AUTO_INCREMENT PRIMARY KEY

CakePHP | How to implement Internationalization in CakePHP 3.X

| By Webner

To implement Internationalization, CakePHP will pick all your strings which start with “__(“ double underscore ) and generate a default file for you. For Example: one of the strings defined in our project is as below: echo __ ( ‘ Gift