Thanks to
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 4696 days
Last modified: 6/29/15 10:59 AM
Youre not logged in ... Login
... Home
... Tags

July 2015
Recent updates
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 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 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)
avoid key prompt Here is
a simple tip that will avoid RSA key fingerprint authentication....
by shantanu oak (8/8/13 3:40 AM)
mysql troubleshooting The following information
is required to analyse any mysql issue 1. my.cnf configuration...
by shantanuo (7/29/13 2:28 PM)
Killing mysql Here are a
few ways to kill mysql process. mysqladmin shutdown kill -TERM...
by shantanuo (6/28/13 4:03 AM)
Improve InnoDB performance innodb_flush_method=O_DIRECT
innodb_file_per_table innodb-flush-log-at-trx-commit = 2 # number of cpus * number of...
by shantanuo (6/12/13 3:36 PM)
More about git ## getting
started git init git add index.html git commit -m"my first...
by shantanuo (6/9/13 2:48 PM)
Managing top While the output
of the top command displayed, press F, which will display...
by shantanuo (6/4/13 10:10 AM)
remove all files If you
have problems to delete many files in a folder using...
by shantanuo (5/17/13 1:12 PM)
correcting date A few packages
are dependent upon the server time. If the date is...
by shantanuo (5/14/13 12:37 PM)
Check for table corruption quick
and fast #!/bin/sh for dbname in `mysqlshow | awk '{print...
by shantanuo (5/13/13 4:39 PM)
Know more about your server
You can get information about the make, model and serial...
by shantanuo (5/13/13 1:03 PM)

RSS feed

Made with Antville
Helma Object Publisher