Dakular's profile打哭了的拨烙锅PhotosBlogLists Tools Help

Blog


    5/19/2006

    一个空格引发的血案

    MySQL也不是省油的灯,气的我吐血。当建立一个和库名相同的表时,必须加个空格,如下:
     
    Description:
    See how-to-repeat. It's a bug as x(a INT) works fine in 4.0.16.

    How to repeat:
    mysql> create database x;
    mysql> use x;
    mysql> create table x(a int);
    ERROR 1064 (42000): You have an error in your SQL syntax.  Check the manual that
    corresponds to your MySQL server version for the right syntax to use near 'x(a
    int)' at line 1
    mysql> create table x (a int);
    Query OK, 0 rows affected (0.00 sec)

     

    Comments (3)

    Please wait...
    Sorry, the comment you entered is too long. Please shorten it.
    You didn't enter anything. Please try again.
    Sorry, we can't add your comment right now. Please try again later.
    To add a comment, you need permission from your parent. Ask for permission
    Your parent has turned off comments.
    Sorry, we can't delete your comment right now. Please try again later.
    You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
    Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
    Complete the security check below to finish leaving your comment.
    The characters you type in the security check must match the characters in the picture or audio.

    To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in


    Don't have a Windows Live ID? Sign up

    Picture of Anonymous
    boubo wrote:
    welcome to my home
    May 24
    Picture of Anonymous
    boubo wrote:
    welcome to my home
    May 24
    玉玲 赵wrote:
    祝你好运!~
    May 23

    Trackbacks

    The trackback URL for this entry is:
    http://dakular.spaces.live.com/blog/cns!8668FFEC49BC51CE!368.trak
    Weblogs that reference this entry
    • None