| |
| |
| |
|
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> iirc it's 32 hex digits separated with 2x "-"
<1> osfameron: ok cool thanks :-)
<2> hi all
<2> I have a strange problem after installing mysql 4.0.26 on freebsd 4.7
<2> when trying to start mysqld, i get the error: 060330 14:34:42 /usr/local/libexec/mysqld: unknown variable 'secure-auth=1'
<2> I've tried the binary packages provided on mysql.org and compiled from source through fbsd ports
<2> in both cases I get the same error
<2> no record of it in teh forums or in google
<2> any ideas?
<2> mysql 4.1 is installed on the same system, but in a different directory
<3> Hi all, just would like a to clarify an issue: the difference between utf8_bin and utf8_unicode_ci is only the collation, right ?
<3> ie the data is going to be stored in the same way, it's just comparisons between that data which will be different? is taht correct or am I making wrong ***umptions ?
<4> ouch .. just went through the example mysql5 cert questions on datatypes
<4> damn did i screw up :/
<5> !tell me about certs
<6> But I don't know a thing about that.
<5> !man certifications
<6> Nothing found.
<5> fine.
<7> lsmith: yeah, those are fun
<8> how do I select from two queries in the same table? I got one accounts and one info table.. there are the same id's in borth tables.
<4> s/queries/columns?
<4> err ..
<4> no i just dont get it
<9> d_l0rd: with a join
<9> !man join
<6> (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<9> hrm, there's probably something more tutorial-ish out there
<8> yeah, found join in the manual. does it connect the rows by the primary key or just in the order that they come?
<9> You tell it how
<8> ok, back to reading :)
<8> Is it better to join two tables in one query than to make two queries?
<8> from a memmory/cpu consuming point of view.
<10> d_l0rd: One query is almost always better than two.
<7> not always
<7> but usually
<7> ;-)
<8> ok
<8> found som loops with queries in them... heh..join seems to be a better solution :)
<10> hey domas. :)
<10> d_l0rd: In that case, most definitely
<11> how can i select by descending date easily?
<12> order by...
<13> is there someway of having an "enum" in sql? for example something like: create table verdict( arrest_id int, verdict int, 0=trial innocent, 1=nulle pros innocent, 2=guilty confession, 3=guilty bench trial, 4=guilty jury trial)
<5> aside from the ENUM column type, you mean?
<13> infi ok that is what I am looking for :) thanks, I will google it now :)
<11> ty
<5> !m clarks enum
<6> clarks: (The ENUM Type) : http://dev.mysql.com/doc/mysql/en/ENUM.html
<14> 9 i woz framed your honor
<5> 8 do-not-fly list
<4> wtf SHOW COLUMNS FROM mytest FROM test;
<7> ;-)
<15> hey, does anyone know why slave status would report some astronomical seconds_behind one second and 0 literally the next?
<16> anyone know why "references" doesnt work in table/coulmn creation when using innodb?
<8> hmm.. I seem to get like 20 rows when I do a left join with three tables.. but there is only two matching rows in each table. Did I just do some typical newbie error?
<4> key word
<13> archivist: :) that is what they all say
<4> think foreign key
<13> thanks, cya latter
<16> anyone know why "references" doesnt work in table/coulmn creation when using innodb?
<16> silly mysql, complex data relations are for kids!
<17> i tryed to change p***word root with mysqladmin -u root p***word newp***wd "table mysql.user doesnt exist "
<7> winmutt: it works.
<9> rub: That's worrying. Does it exist?
<16> domas: not in 4.1
<17> yeah
<16> create table x (fk integer not null references mybutt(fk)) engine=innodb;
<16> that will execute but not create the fk
<16> you have first create an index and then declare the fk
<16> silly mysql
<17> could someone help me ?
<17> table mysql.user doesnt exist
<18> rub: is this a fresh install ?
<7> winmutt: are you sure innodb is enabled on your server?
<7> winmutt: show variables like 'have_innodb';
<17> i download mysql 5.0
<8> when I do a join I have an argument that is (t3.id='3') cause I ony want one type of rows. But I dont have a line for ever record so it only gives me the rows that has this table. I wan this column to be kinda optional :)
<17> automatically installed it for me
<19> winmutt: it's probably mysql's fault. it's very silly
<7> winmutt: is mybutt table innodb?
<18> rub: run 'mysql_install_db' as root
<17> ok thanks
<18> and try again
<17> where is it, i can not find it
<17> zeitoun
<17> i have installed mysql version windows
<7> winmutt: FKs were working in 3.23
<7> winmutt: so 4.1 is not that old :)
<19> domas: nonsense, mysql is a silly database
<7> Deu***: really?
<7> why?
<19> because he said so
<7> :-)
<7> hey, I say that like 20 times per day
<7> but it doesn't become truth! :)
<19> :-)
<17> zeitoun
<17> i can not find mysql_install_db , i have installed mysql under windows, thats matter ?
<18> rub: yes it does. You don't have to do that on windows: http://dev.mysql.com/doc/refman/5.0/en/windows-post-installation.html
<18> my advice was for **nix... sorry should have asked.
<18> rub: meanwhile, the error message you gave suggest something went wrong when you installed...
<17> it doesnt ask me for nothing i only click next & next , simple installation
<20> did you configure the server?
<17> no
<20> well that's why then
<17> i only run with mysqld
<21> hey, is there a way to order the results in my query by the character length of one of the cells of each row?
<17> then how to configure it ?
<20> there is a 'configure server instance' thing that got installed
<8> wohoo join rules! (at the moment)
<20> Hory`: order by length(field1)
<21> great, thanks shabbs
<17> shabbs dont undertand you
<20> rub: after you installed it should've popped up a form that said "Configure the server or exit" which if you didn't configure, would not have asked you for a p***word or any of the other parameters. There is a 'server configurator' program that you can run under windows, it should be under start menu->mysql->mysql server x.x->Server instance config wizard
<22> I can't believe you know that... so disappointed.
<20> I have a windows version installed :(
<17> ok it is done
<17> host is not allowed to connect to mysql server, some books tell me about remote host, grant permission, but i really dont know , why this error ?
<20> !m rub grant syntax
<6> rub: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<23> anybody use mysql-workbench? I can't get it to add a relationship between two tables. I select the Relationship Tool, click table1, click table2, and then ... nothing. Is there more to it?
<24> gah
<25> SELECT * from raticketdb.ticket where code ='9168-XAUC72' --> this is a correct query, syntax-wise, right?
<24> can't find a word for the cl*** that deals with Surcharges and Discounts
<20> adjustments?
<22> rolemodel, tias
<26> Where can I find mysql hackers to hire for a short-term mission (1 day)?
<25> will ?
<22> rolemodel, Try it and see
<8> hmm join doesnt rule at all took 18 secs to get 10 lines...
<8> :)
<22> cyrilb, Do we get to dress up in black and sneak around foreign countries?
<22> d_l0rd, It's your query. Use EXPLAIN on it
<22> !m d_l0rd explain
<6> d_l0rd: (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<26> will: remote work is ok
<22> Do I get night vision goggles?
<26> will: and I really don't care about the dress code as soon as the job is done
<22> Do I get a gun?
<27> nvgoogles, great! ;-)
<20> google should display things in 'infrared' if the client's clock is between 9pm and 5 am
<17> sql my question was about undertand the error "host '' is not allowed to connect to my sql server " no about revoke or grant , i really need one guide to explain me this
<22> shabbs, It would only be supported in Firefox... :(
<20> will: that's ok, ie users don't need night vision
<22> Their eyes are bloodshot anyways.
<25> will bah, bad conversaion from latin to utf 8 :p
<22> rub, Because you don't have any users in your DB that is allowed to connect. You need to GRANT them the rights to connect.
<22> rolemodel, Are you making fun of my latin?
Return to
#mysql
or
Go to some related
logs:
turning off IPv6 ifconfig fc5
ubuntu kernel 2.4.32 depmod
#perl
#suse
#php
unlegible websites
tek-ops
ubuntu restart xserver
friendshipness quotes
moodle hopto
|
|