| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> I'll be happy to represent you
<1> So, anyway, I plan on using a CHAR(1) for deletion status. But all the same, the manual says that a CHAR(0) NOT NULL column can take '' and NULL. That is not right, right?
<2> *** shabbs is Lionel Hutz
<3> dvos, why CHAR
<0> doesn't seem right, no
<3> use tinyint
<4> hello, why don't I have a /etc/my.cnf file after I installed MySQL-server-5.0.18-0.glibc23.i386.rpm and MySQL-Max-5.0.18-0.glibc23.i386.rpm (rpm -vhU mySQL-server-5.0.18-0.glibc23.i386.rpm MySQL-Max-5.0.18-0.glibc23.i386.rpm) ??
<0> should be CHAR(0) NULL as you said
<1> Okay, just checking.
<1> Thanks.
<0> KoRnouille: could be /etc/mysql/my.cnf
<3> !m shannon date time formats
<5> shannon: Nothing found
<3> !m shannon date time
<5> shannon: (Date and Time Types) : http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html
<1> How do I tell MySQL to fix it?
<1> (the company, I mean)
<2> ./mysql --fix-it-dammit=1
<0> report it as a documentation bug, or yell at someone here
<4> shabbs: nop: updatedb ; locate my.cnf # won't give anything...
<0> KoRnouille: then it's possible that you have to copy it from the samples/examples provided
<1> HEY! SOMEONE! THE DOCS AIN'T RIGHT!
<2> dvoss, they're pretty responsive to documentation issues. I submitted some problems a couple of years ago and the changes were in the next documentation revision about a month later
<2> er, last year I guess
<4> what's InnoDB exactly ? Does it have anything to do with NDB cluster ?
<3> a database engine, and no
<6> DELETE FROM pieces JOIN program_bits ON pieces.program_bits_id=program_bits.id WHERE pieces.id = '2' AND program_bits.recital_id='691'
<6> anyone see anything wrong with that?
<4> sjrussel: thanks
<0> rob^^^: not without the error message
<6> 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 'JOIN program_bits ON pieces.program_bits_id=program_bits.id WHER
<7> hey guys, i commented out skip-networking in my.conf for mysql and uncommented bind (because i needed to) and now mysql wont start... i get: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
<0> rob^^^: don't think you can use JOIN with delete
<1> infi, um, there doesn't seem to be a category for documentation bugs.
<2> http://bugs.mysql.com/, last item in category, underneath MySQL Server
<6> shabbs: ok, I did with with delete x from x,y WHERE x.foo_id=y.id AND blah
<8> is there any way to forbid whitespace only strings in a varchar or text field?
<9> your app
<0> with a trigger
<10> hi all
<10> i have a table and i wanted to know how to make an existing table column a primary key without doing the whole table over.
<0> !m paco___ alter table
<5> paco___: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<11> paco___: all values must be unique and not null
<10> i am trying to use this table to authenticate users with p***words. does the user column HAVE to be a primary key, or doesn't it matter?
<0> no, they don't have to be a primary key
<0> you could have an auto_increment primary key which would identify each user by a unique number
<10> shabbs, well, for now, all i have is one universal user name and p***word
<0> paco___: you can still make the username unique, but not a primary key. it's usually a lot better to refer to rows with a numeric ID than text (internally to the app)
<10> i am using php's mysql_numrows function to match what the user typed in and compare that to the p***word.
<0> numrows? doesn't that just return the number of rows matched?
Return to
#mysql
or
Go to some related
logs:
#perl
#suse
needs kernel < yum update
#css
caducho
ubuntu as user root+wrong password
ubuntu aterm antialiased
Change computer name FC5
N800 support Java
etc keepwork
|
|