| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> !m ***yKen fulltext
<1> ***yKen: (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<2> So that means I'll have to modify the current database?
<0> You'll need to add full text indexes, yes
<3> does anyone know if mysql 5.x allows for noncorrelated subqueries? i'd rather not upgrade right now if its not going to solve my problem
<4> i need to basically setup a mysql cluster, i have 2 live servers and 1 DB, both servers need to access the same DB and both need to see the changes from one another, are they're any good docs on this anybody can point me to/
<5> howdy
<5> is there a way to say something like: "order by field1 then by field2" ?
<5> as an example, consider we want to sort by date, then by owner, or something...
<0> mae^: you can likely rewrite your subquery as a derived table and join to it
<5> anyone?
<6> brianski, ORDER BY field1, field2
<6> Separate them by commas.
<2> invisio how do I add fulltext indexes?
<0> !m ***yKen create index
<5> Julian|Work - does that generalize? can you say like ORDER BY field1 ASC, field2 DESC ?
<1> ***yKen: (CREATE INDEX Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_INDEX.html
<6> brianski, yes you can.
<0> brianski: you have to pay extra for that
<6> brianski, yeah, pending payment received by inviso.
<6> So your queries may take 2-3 weeks to return.
<5> hehe check's in the mail
<5> thanks for the tip
<0> If it bounces, I'm coming after you
<3> inviso: hmm, interesting idea.. i'll try that
<0> mae^: heh, life before subqueries... Some of us are so old we had to do the same thing with temp tables ;)
<2> I created the FULLTEXT indexes for the proper columns, though I recieve this error: Can't find FULLTEXT index matching the column list
<0> ***yKen: the fulltext index needs to be created across *all the columns you will search on
<3> yeah, temp tables and crazy joins
<7> Why does the "rows" column under 'SHOW TABLE STATUS' show a different value than my 'SELECT COUNT(*) FROM table'?
<2> invisio: I created the fulltext index on the columns I'm searching....
<0> ***yKen: 1 for each or 1 total?
<2> 1 total -- You mean I have to do one for each?
<8> hello there, when I code, I would like to always check my database, what table/field names there are, etc. I'm actually looking for a program like phpmyadmin but just not browser-based. I tried Mysql Administrator but it was kinda too bloated. Anyone got some recommendations?
<0> no, just 1 fulltext index. A "composite" index if you will
<0> ndee: mysql administrator is the best gui tool I know of
<3> inviso: is there a way to do that with 1 query?
<9> hello, is there a way to p*** a set of strings to a stored proc to be used in a where in clause?
<2> Invisio: That's what I did....
<8> inviso: but it's kinda too big, I just wanna swap real quick between dreamweaver and that other program :)
<0> ***yKen: pastebin your query along with show indexes from tablename
<7> Anyone know?
<0> gremlins. Tiny vicious gremlins
<2> Invisio: http://pastebin.com/534675
<10> hi
<10> hmm okay this phpMyAdmin really is ****
<0> amen
<8> why?
<10> have 'engineers' in a database, went to add another BELOW another entry, but it stuck it right at the bottom, so I went to delete them...
<2> invisio: See any reason why
<10> checked their boxes, and went to delete - and it deleted the first instance it came across!
<10> which is not what I wanted
<0> ***yKen: how about your query?
<10> pfft to this
<2> invisio: select * from advertisers WHERE MATCH (name) AGAINST ('testing')
<0> ***yKen: I think you would need match(name, email, website_url, etc) against ('testing')
<10> anybody used 'FileMaker", its some kind of database
<10> ?
<7> FileMaker makes Baby Jesus cry.
<10> it's that good? :)
<7> I used to use it when I worked for an old webdev shack
<10> if it makes jesus cry then I'm sold :D
<7> they used it with L***o
<10> i have no idea what that is
<7> I don't even want to talk about L***o.
<0> yet there you go.. Weird world we live in
<7> L***o gives me the runs just thinking about it.
<10> but apparantly you can use ODBC to connect to mysql or whatever and use filemaker or excel to edit it...or so I read
<7> rad
<10> well I'm not certain how this works, but hmmm
<10> thinking of looking at filemaker
<7> Might as well wear pink
<7> and develop a lisp
<10> okay - then what would you do?
<7> what is your goal?
<10> to edit a database, seamlessly
<10> to be able to insert a new row
<10> above or below another
<2> Okay Thx, invisio, that seems to have worked.
<10> to quickly edit a database without ****ing around with phpMyAdmin or that **** arse query browserr
<10> acess was a lot less bother
<10> access
<2> invisio: So basically I create a 'group' of indexes depending on what I'd like to search at one time. (IE: Somenoe wants to search via location, I should create an fulltext index with 'zip, city, state' -- yes?)
<11> for IMMEDIATE sale 2 high performance laptops price 500 each includes shipping carry case and wireless router. message me if interested on aim at ogd443, msn at mcsltd@telusmail.net, or yahoo at mcsltd2. specs p4m 2.26, 1gb ram, 80gb hard drive sata, built in modem, ethernet, firewire, usb2.0, 802.11b/g wireless, 256mb nvidia geforce go 6800 pcie, 17.1" uwxga display.
<0> ***yKen: that's what I understand. I haven't used full text indexes to be honest
<0> ***kicker: take it somewhere else
<2> invisio: Well for not using fulltext indexes, you did a good job helping me, Thanks :-)
<0> ***yKen: np, enjoy
<2> ***kicker: High performance laptops have more than 256mb ram.
<2> I read wrong
<2> Okay
<2> Hit me.
<8> does "EXISTS" work in Mysql 4.0?
<6> I don't think ***kicker can hear you.
<12> !kickban ***kicker
<0> He might not be able to hear us, but we know where he lives :)
<13> hello all my databse connection returns error 1251 when I try to connect with my aplication, but in shell I conect in any machines, somebody knows what happens?
<14> grochap: check the exact errormsg not just that code
<13> arjenAU, mysql Error: 1251 (Client does not support authentication protocol requested by server; consider upgrading MySQL client)
<13> arjenAU, mysql 4.1 server both client :(
<14> grochap: that's irrelevant. you may still have a 4.0 pwd in the server, and have not enabled the old-p***words option. then you get this error.
<14> !m grochap upgrading 4.0 4.1
<1> grochap: (Upgrading from Version 4.0 to 4.1) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
<14> !m grochap old client
<1> grochap: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<13> arjenAU, I configure the server to accept old p***words :(
<13> arjenAU, tks. :) I will see the doc.
<14> grochap: never argue with reality. did you restart the server after changing that option?
<15> gr : http://dev.mysql.com/doc/refman/5.0/en/old-client.html
<13> arjenAU, thousand times
<15> grochap : http://dev.mysql.com/doc/refman/5.0/en/old-client.html
<14> grochap: ok feel free to continue battling reality ;-)
<15> easy
<13> arjenAU, makaveli I will see the doc, tks a lot guys
<13> arjenAU, makaveli ok , that's fine. tks again :)
<7> Well, now I'm wondering how accurate 'SHOW TABLE STATUS' really is, for other pieces of data, as wel.
<13> meet the debian-br-cdd http://cdd.debian-br-org :D
<13> bye
<16> anyone know of a basic php csv importer for mysql db
<17> )
<16> wtf
<18> is it possible to change a column to auto increment?
<19> hi
<20> adamc, I think
<19> if I'm to explain to someone who knows nothing much about computers about mysql and how it's safe with handling data. How would I go about it?
<18> why is there a change, alter, and modify column command?! do they all do the same thing?
<21> adamc: i don't think so...
<18> bah... so confusing... i wish they didn't do that
<19> can someone please answer my question?
<21> adamc: it's SQL for you
<22> murdoc: irc does not work that way
<19> ??
<21> murdoc: i would explain it...
<21> that data isn't safe in a mysql db :-P
<21> people can easily read the ascii from tables....
<22> unless the admin knows exactly what he/she is doing
<21> and sql tables can become corrupt and unreadable
<19> wat?!
<19> then why would people use it to hold p***words?
<21> they don't.
<19> people say it's the safest way for logins and stuff
<21> they use md5 and sha3 or was it sha2 to hash the p***words
<23> I think the lack of understanding is in your direction, murdoc
<19> yes I think so too infi
<21> which is it?
Return to
#mysql
or
Go to some related
logs:
yum install svn
filegrenade
#fluxbox
#iptables
#debian
MySQL-To-MSSQL 3.1 crack
#fedora
#lisp
#osdev
python-editor code-completion
|
|