| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> (see, I use a question mark)
<1> _______ is populated with conditional statements
<1> to select from my variable statements
<0> How about you give me the query you are using?
<0> me/us/...
<1> it's different based on the post
<1> so
<1> for example
<0> Yes, an example would be just fine.
<1> SELECT * FROM hav_loc_eng WHERE country=1
<1> which
<1> works fine
<0> And from that, what do you want, username?
<1> one of the columns is userid
<1> which i can pull fine
<1> the primary key of my table users is userid
<1> and is ***igned to a username
<1> in the reporting
<1> I want a username ***igned
<1> with the reporting
<0> Read up on joins.
<0> !tell us about joins
<2> will asked me to tell you this: Very basic join information: http://hashmysql.org/index.php?title=Introduction_to_Joins - For more indepth info: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf
<3> anyone can help me about mysql under chroot?
<3> I have this problem
<3> /usr/sbin/chroot /chroot/mysql /opt/mysql-5.0.18/bin/mysqld_safe
<3> /usr/sbin/chroot: cannot run command `/opt/mysql-5.0.18/bin/mysqld_safe': No such file or directory
<3> ldd /opt/mysql-5.0.18/bin/mysqld_safe not a dynamic executable
<3> I have compiled mysql with -all-static, so I don't understand nothing :(
<4> hey guys, is there a better way to shutdown mysql than using /etc/rc.d/init.d/mysql stop or by killall -9 mysqld?
<5> Is there a way to get the "questions per second average" from the command line or via a query?
<6> ya
<6> mysqladmin status;
<6> that will show you queries per second
<7> will: sorry, didn't see your reply
<7> you reckon mysqldump?
<7> how do i do just 2 tables to dump then
<8> question
<7> np, sorted
<8> cheers
<6> mysqldump [options] db_name [tables]
<8> got a query for returning search results. Doesn't seem to return results when you search for some terms that do have products by that name
<8> checkit -> http://pastebin.com/566078
<8> it's a mess of a query really... I was trying to make a query that would search through columns product,description & title and to do some sort of Relevancy based ranking on the results
<3> hi again, using mysql 5 under chroot I have this error
<3> 060222 02:37:23 mysqld started
<3> 060222 2:37:23 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
<3> cat /chroot/mysql/etc/p***wd
<3> mysql:x:105:106:MySQL Server,,,:/opt/mysql/var:/bin/false
<3> but I habe this user under chroot p***wd file, any idea how to fix it?
<3> have
<8> awesomeeeeeeeeeee
<8> got a mean support system going here
<8> everyones just firing away questions & answers like crazy
<9> Is there anyway to setup mysql to let individual users have any db name they want? So two users could have db blah at the same time
<5> Use a db name prefix
<9> but then accessing it they would have to use prefix_blah
<5> it's what people deal with from all webhosts pretty muc
<9> there is no way to make it so when user X accesses database Y, it really looks up database X_Y
<10> What's the largest string a column with the type 'TEXT' canhold?
<11> i can't decide for a webserver running freebsd, multiple domains to be fitted on there, is the mysql of today the 4x series or is 5.0 stable enough, it's really hard to tell what people use out there
<12> HI again
<12> I can't start mysql under chroot, I have this error on logs
<12> 060222 2:44:51 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
<12> any idea how to fix it?
<11> josuah: does the user mysql exist ? Is user mysql able to read the files ?
<12> worjs perfect without chroot, and under chroot I have this
<12> cat /chroot/mysql/etc/p***wd /chroot/mysql/etc/group
<12> mysql:x:105:106:MySQL Server,,,:/opt/mysql/var:/bin/false
<12> mysql:x:106:
<10> What is a good length to specify as a index length for a column that is of type 'TEXT'?
<12> -rw-r--r-- 1 root root 58 Feb 22 02:28 p***wd -rw-r--r-- 1 root root 499 Dec 9 04:23 hosts
<12> console_ninja any idea :( =
<12> ?
<11> josuah: dunno then
<12> /usr/sbin/chroot /chroot/mysql /opt/mysql/bin/mysqld_safe -u 105
<12> chown: `mysql': invalid user
<12> :(
<8> support team too quick slow down
<0> [aJ], What is the significant prefix portion? Usually, you would use a FULLTEXT index on a TEXT since you usually search for text within the TEXT field, not what it starts with.
<10> will text
<0> Huh?
<0> !fooP
<13> :(
<8> anyone wanna have a look at my cool query?
<8> it's leet ..
<10> Will: sorry misread what you said
<10> will: I've got this query CREATE UNIQUE INDEX translation_en_iso_8859_15_translation_id_index ON translation_en_iso_8859_15 (translation_id) which works fine in PostgreSQL but when I run it in MySQL I get an error about not specifying a lenght
<8> i'll drop it down anyway ~ see what you think. It seems to return false - blank results sometimes :/ - http://pastebin.com/566078
<14> How come whenever my server running MySQL crashes, ie blackout or something, I can't restart MySQL?
<8> cause usually it's still running
<8> you on windows?
<14> My server is running Slackware
<14> you mean reboot it?
<14> and just let it sit?
<14> :\
<8> yeah
<8> restart it
<8> sometimes is just wacks up but is still running
<8> from what i've found, when that happens and I try to relaunch apache or mysql service it doesn't load cause the Port is Used so the service terminates when i try to run it..
<8> so you gotta actually make sure ya kill the process then try fire it up
<8> anyway
<14> akumanz, yeah, cause I've got lots of important entries in there (blog) and I hope MySQL doesn't corrupt 'em or something.
<8> shouldn.t
<8> anyone have a chance to look at my query :/ http://pastebin.com/566078
<14> akumanz, okay, I've restarted. Apparently mysql is not running
<14> ps -ef | grep mysql doesn't show anything
<14> akumanz, now what?
<14> :\
<8> try restarting the service?
<14> mysqld_safe --user=mysql &
<14> ?
<8> not familiar with linux. but uh just try starting the service again however you do it
<15> is there a way to check the existance of a temporary table?
<15> how can i check for the existance of a table in a database, if i need to create them for holding temporary records?
<16> yay spam
<16> Therion: entertain us.
<8> try creating a table with that name dogmeat..
<14> akumanz, uh
<14> it dies
<14> with an error
<14> 060221 18:47:45 mysqld started
<14> InnoDB: Warning: we did not need to do crash recovery, but log scan
<14> InnoDB: progressed past the checkpoint lsn 0 44831 up to lsn 0 44864
<14> 060221 18:47:45 InnoDB: Started; log sequence number 0 44831
<14> 060221 18:47:45 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.$
<14> oops
<14> pastebin time
<15> akumanz: it is better if there is a SQL test for the existance of a table
<14> akumanz: http://rafb.net/paste/results/0L2jbr61.html
<14> anyone help?
<8> ah crap sorry at work cya
<14> aww man
<17> when using a 'left join', is there any way I can specify the default values for empty? Instead of null? I'm having a hell of a time trying to get my datasets to accept DBNull
<10> I've got the query "CREATE UNIQUE INDEX translation_en_iso_8859_15_translation_id_index ON translation_en_iso_8859_15 (translation_id)" the column translation_id is TEXT. This query doesn't work on on MySQL because it doesn't have a lenght after the translation_id is there a way to get it to work w/o changing the query to "CREATE UNIQUE INDEX translation_en_iso_8859_15_translation_id_index ON translation_en_iso_8859_15 (translation_id
<18> Xedecimal: SELECT COALESCE(t2.fieldx,0), ... ;
<17> damn you
<17> I just got around it
<17> with the nulls, thinking it wasn't possible
<17> sorry, it's good to know though
<19> Does anyone know if mysql consumes less or more memory than postgresql?
<10> pingu: good question
<20> pingu: I can configure MySQL to use 16MB or 32GB.
<17> probably depends on context
<19> Aah :D
<19> Thanks.
<10> What should I use for the length in this query? 64, 128? the column is a text column btw "CREATE UNIQUE INDEX translation_en_iso_8859_15_translation_id_index ON translation_en_iso_8859_15 (translation_id(???????))"
<8> holla
Return to
#mysql
or
Go to some related
logs:
visibility-inlines CXXFLAGS
#python
#perl
#physics
killingyourfather
gentoo modprobe error i810 invalid module format
#php
world list gentoo
padlock emblem linux
#perl
|
|