| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<1> darkdrgn3k: there
<2> Kemurii: thanks
<3> in mysql type "show create table"
<4> !man ALTER TABLE
<0> (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<2> What's the syntax error in this line? INSERT INTO `smf_smileys` VALUES (14,':-\\','undecided.gif','Undecided',0,13,0);
<5> arex\: better question is "what's the error you get"
<1> arex\: that table has 7 columns?
<2> litheum: "syntax error"
<5> arex\: bull****. there's more
<5> what's the full error message
<1> that would have made an other error, me bad
<2> yes Kemurii
<1> arex\: is that PHP or MySQL saying that
<2> MySQL
<2> (via mysql-front)
<1> EEK!!!!
<4> arex\: did you try: INSERT INTO `smf_smileys` (column1,column2,..) VALUES (14,...);
<4> ?
<2> is it something with ':-\\' ?
<2> escaping etc
<5> insert into table1 values (':-\\');
<5> Query OK, 1 row affected (0.00 sec)
<3> try change :.\\ with :---
<2> thanks all :
<2> :)
<3> :->
<6> mysql> insert into foo values (':-\\');
<6> Query OK, 1 row affected (0.00 sec)
<3> mmh no matter with \\
<7> MYISAM FOREIGN KEY CONSTRAINTS FOR THE WINNNNNNN
<8> SELECT knife, fork, spoon FROM table WHERE fork = 'left' AND knife='right' AND spoon='right' GROUP BY mealcourse UNION SELECT food FROM plate WHERE course = 'appetizer';
<9> which table type is the best?
<8> would that not depend on the application?
<9> MarthaStewart: is there a list of reasons to pick differnt tables?
<9> or somethin
<8> http://www.developer.com/db/article.php/2235521
<9> nice
<9> thanx
<7> #1068 - Multiple primary key defined WHAT THE ****. ANY OTHER DBMS YOU CAN HAVE MORE THAN ONE PK
<7> _ANY_
<10> mogbit: you can have more than one column, but you can only have one primary key
<10> hence PRIMARY
<11> though you can have more than one primary school
<11> or primary colour
<10> *shrug* still it remains, one primary key that can have more than one column
<7> ever heard of a COMPOSITE/COMPOUND KEY
<10> mogbit: that's what the **** I'm talking about dip****, multiple columns
<12> yes. mysql supports them.
<7> bs
<12> RTFM, it's there
<10> ***
<12> I guess it's the retard olympics today.
<12> been like that in all my channels, jeeze
<10> must be one of those days
<1> lol
<1> which DMBS can have >1 PK on table?
<10> he was referring to compound/composite keys
<10> which apperantly he doesn't know the definition of
<1> yeah, I know
<13> Kemurii: probably dbms which are filled with bugs, mssql, oracle and such ****ty dbms :)
<1> ohmyohmy
<10> I highly doubt any of them support more than one pk
<1> (no phun indented)
<14> Waning Gibbous 59% of Full
<14> no, that's not it... odd.
<13> my favorite of mssql bugs (which still exists in sql2005) is when you select with a group where col=1 and it will give you rows which has col=0 :D
<14> March 8 is just freak day, I guess.
<10> uhh
<10> it's march 7th :D
<14> not where I'm at ;)
<10> except in australia and points east of GMT + 6
<1> International woman day and you call it freak day??? you are brave :)
<14> Wed Mar 8 02:34:49 JST 2006
<10> japan eh?
<14> yeh
<10> wtf are you doing in japan? :D
<14> trying to get this fscking Scheme implementation to compile :b
<1> getting ... hordes of schoolgirls
<15> Oooh, scheme! :)
<14> well, it will be if SCM didn't die mid-install :b
<10> hooray for hordes of schoolgirls
<15> lol
<16> can anyone help as to why I cannot update my database table french content to correspond to to english? I just inported the sql file but did not update the content variables...
<10> Roger: does it give an error on import?
<16> shabbs: it said it was successful, but still not resolving to english content.
<1> Roger: don't understand what you mean 'to correspond'? do you use and ID field? auto_increment or something?
<10> are you looking at the correct tables?
<16> shabbs: yes, when I browse for the sql file it was set as auto_increment
<14> SCM: P***ed all tests! <- whee!
<10> ok that makes no sense
<10> your file can't be set to auto_increment, a field in your table can be
<16> autodetect
<1> Roger: so, could it be that it is shifted? the French content starts at 1 and the english at 199 or something like that?
<10> ok
<16> Kemurii: let me take a look
<9> i tried making a constraint:
<9> ALTER TABLE client add CONSTRAINT brokerclient FOREIGN KEY (broker) REFERENCES broker(username) ON DELETE SET NULL ON UPDATE CASCADE
<9> i got error
<9> #1005 - Can't create table './barrons_case/#sql-13a1_207cd.frm' (errno: 150)
<9> what does it mean?
<1> !perror 150
<0> MySQL error: 150 = Foreign key constraint is incorrectly formed
<9> baaaa... what i do wrong
<1> darkdrgn3k: broker is a table? username a field? key on username?
<9> broker is a field in the table client
<1> darkdrgn3k: Innodb?
<9> username is a field in table broker
<9> yes
<9> broker InnoDB 16.0 KB
<10> is client innodb?
<10> though that wouldn't matter, I think it would still accept it
<9> client InnoDB 16.0 KB
<1> should accept
<10> you have indexes on both broker and username?
<9> lol that would help woudlnt it
<10> probably :)
<9> username is a pk so its index i ***umed automatically
<1> mark my 'key on username?' question :P
<10> if it's a pk then it should have an index
<10> index == key
<1> not really, well, yeah :P
<9> well i added an index to broker
<9> still same thing
<16> Kemurii: I got a table called configuration with french content in the fields for configuration_title and configuration_description variables. I have another database that was created an ran a sql query to export the english equivalent for it. I then went back into the french table for configuration and browse and imported the english sql file but did not replace the french content with the english...does that make any sense?
<17> hi
<9> broker INDEX 0 broker
<10> darkdrgn3k: are they the same field type?
<9> yep
<9> char30
<9> you add the constraint to the FORENKEY table right
<10> uhh
<10> no, it goes on the table you're altering
<9> i mean
<18> what was the command which does nearly the same as `DELETE FROM table' but resets the auto_increment column?
<9> you alter the table that has the FK in ir right?
<19> what would be the equivalent of SHOW VIEWS; ?
<20> what is the best way to "rotate" a log
<20> query log
<16> Kemurii: could it be that the french special characters are not letting the updates happen?
<1> darkdrgn3k: what myself version?
<1> mysql!
<1> MySQL!!! version
<19> how do i get a list of all stored views?
<1> Roger: nope
<10> darkdrgn3k: can you pastebin your show create table for both tables and the query you're trying to run?
<9> ok
<21> phpwner: use the information_schema database
Return to
#mysql
or
Go to some related
logs:
#php
#lisp
gentoo error: possibly undefined macro: AM_PROG_LIBTOOL
fedora mod_file
MAC Unable to find gd.h
#web
ALC658 kernel
gentoo drivespace
picassa.deb
postfix delivery temporaly suspended
|
|