Thanks to antville.org
Wednesday, 22. December 2010
MySQL reserved words

all the following words are actually MySQL keywords and should not be used as table/ column names.

timestamp, date, localtime, primary, repeat, schema

There are times when you do not notice any issue with it but at a later stage, one has to face a lot of issues because of this.

... Comment

Online for 4921 days
Last modified: 2/9/16 4:46 PM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
February 2016
SunMonTueWedThuFriSat
123456
78910111213
14151617181920
21222324252627
2829
January
Recent updates
linguistics using Python These are
the 4 libraries apart from standard library nltk are useful...
by shantanuo (2/9/16 4:46 PM)
Aurora Amazon rates The cost
of Aurora hosting per hour. db.r3.large $0.290 (0.24 mysql) db.r3.xlarge...
by shantanuo (1/26/16 3:06 PM)
connect to AWS It is
possible to use password to connect to AWS 1) change...
by shantanuo (1/25/16 11:17 AM)
Install percona extra backup tool
innobackupex Steps to install innobackupex on Ubuntu: $ apt-key adv...
by shantanuo (9/28/15 8:24 AM)
Backup mysql data using innobackup
BACKUP innobackupex --user=USERNAME --password=PASSWORD --no-timestamp /data/backups/new_backup
by shantanuo (9/28/15 8:09 AM)
Tuning MySQL Getting the shell
script: wget https://launchpadlibrarian.net/78745738/tuning-primer.sh Running: sh tuning-primer.sh
by shantanuo (9/4/15 4:34 PM)
convert a rpm to deb
Here are simple steps to convert a rpm package to...
by shantanuo (9/1/15 3:28 PM)
upgrade ubuntu Upgrade from 14.04
to 15.04 is a 2 step journey. sudo nano /etc/update-manager/release-upgrades...
by shantanuo (8/10/15 1:10 PM)
Libre office on centOS Here
is how to install Libre office on centOS 64 bit...
by shantanuo (7/7/15 8:02 AM)
manage iso image file Here
is how you can open and copy files from an...
by shantanuo (7/7/15 6:57 AM)
predictive typing You can try
a software called typing booster on Fedora. It helps user...
by shantanuo (6/29/15 10:59 AM)
download Enterprise backup 1) Access
My Oracle Support. 2) Click on Patches & Updates navigation...
by shantanuo (2/9/15 11:19 AM)
disable innodb The MySQL server
can still be started without InnoDB in 5.6 using the...
by shantanuo (12/6/14 4:35 PM)
Yahoo Trip planner Yahoo has
shut down Trip planner and My Travel service that was...
by shantanuo (8/17/14 9:34 AM)
Type Marathi on Ubuntu Here
are the steps to install Marathi input method for Ubuntu....
by shantanuo (6/30/14 12:10 PM)
Tokudb and proxy on the
same server # Here are the 2 steps to start...
by shantanu oak (2/10/14 7:16 AM)
Why not blog or text
columns? BLOB/TEXT columns are stored in an external hidden table....
by shantanu oak (1/25/14 2:48 PM)
Creating a new repository Create
a new repository on the command line touch README.md git...
by shantanu oak (1/23/14 5:24 PM)
Percona xtrabackup commands / Tar-compatible
file innobackupex-1.5.1 --stream=tar ./ > backup.tar / Compress innobackupex-1.5.1 --stream=tar...
by shantanu oak (1/21/14 3:03 PM)
Create a Reverse SSH Tunnel
on Remote server: ssh -fN -R 7000:localhost:22 username@yourMachine-ipaddress Now do...
by shantanu oak (12/20/13 9:56 AM)
Innodb Monitor table Monitor table
is a way of communicating directly to the InnoDB storage...
by shantanu oak (12/15/13 5:59 AM)
Installing python as a single
file wget https://downloads.egenix.com/python/install-pyrun chmod 700 install-pyrun mkdir /mypython ./install-pyrun mypython/...
by shantanu oak (12/12/13 6:30 AM)
connect to remote windows server
You need to go to start - run and type...
by shantanuo (11/14/13 5:40 PM)
Adding swap The following example
will add 1 GB of swap file to your Linux...
by shantanuo (11/11/13 4:28 PM)
Starting mysql When you have
installed mysql from source, you will need to change the...
by shantanu oak (9/29/13 4:23 PM)

RSS feed

Made with Antville
Helma Object Publisher