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 4355 days
Last modified: 6/30/14 12:10 PM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
July 2014
SunMonTueWedThuFriSat
12345
6789101112
13141516171819
20212223242526
2728293031
June
Recent updates
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)
import data faster Following my.cnf parameter is highly recommended on high configuration machine. This will...
by shantanuo (4/14/13 3:21 PM)

RSS feed

Made with Antville
Helma Object Publisher