CONTENTS: About this Tutorial MySQL Administration Working with Tables MySQL Commands vs. Postgres Commands About this Tutorial I’ll be adding to this tutorial in the coming weeks. If you have ideas of things you’d really like to see here, email…

CONTENTS: About this Tutorial MySQL Administration Working with Tables MySQL Commands vs. Postgres Commands About this Tutorial I’ll be adding to this tutorial in the coming weeks. If you have ideas of things you’d really like to see here, email…

How to backup multiple mysql databases ? A very powerful shell script to backup your mysql databases totally free.. enjoy #!/bin/bash NOW=`date +"%Y-%m"`; BACKUPDIR="location/of/your/backup/dir/$NOW"; ### Server Setup ### #* MySQL login user name *# MUSER="user"; #* MySQL login PASSWORD name…

How do I change MySQL root password under Linux, Debian, centos, fedora, suse, mandrake, linux-mint, Ubuntu, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session? Setting up mysql password is one of the essential tasks. By default…

PostgreSQL database server installation and configuration in debian / ubuntu Introduction : PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many…

CREATE DATABASE CREATE DATABASE dbName; CREATE TABLE (with auto numbering integer id) CREATE TABLE tableName ( id serial PRIMARY KEY, name varchar(50) UNIQUE NOT NULL, dateCreated timestamp DEFAULT current_timestamp ); Add a primary key ALTER TABLE tableName ADD PRIMARY KEY…

Hi all, In this article you will know some very very basic commands about postgresql. When i started learning postgresql, I found bit strange when “show databases”, “show tables”, and “show columns” command did not work. I was using mysql…