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 4479 days
Last modified: 8/17/14 9:34 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
November 2014
SunMonTueWedThuFriSat
1
2345678
9101112131415
16171819202122
23242526272829
30
August
Recent updates
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)
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)
mysql analysis When there is an issue, We should gather some preliminary data to analyze...
by shantanuo (5/13/13 6:07 AM)
Git Alias Consider setting up a simple Git alias for common but complex Git command...
by shantanuo (4/21/13 7:16 AM)
mysql to postgresql It is incredibly easy to migrate from MySQL to PostgreSQL. Just migrate...
by shantanuo (4/20/13 1:56 PM)

RSS feed

Made with Antville
Helma Object Publisher