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 4627 days
Last modified: 2/9/15 11:19 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
April 2015
SunMonTueWedThuFriSat
1234
567891011
12131415161718
19202122232425
2627282930
February
Recent updates
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)
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)

RSS feed

Made with Antville
Helma Object Publisher