#mysql
01 October 2007
Total 23 pages. You are browsing page 1/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Mon Oct 01 00:00:38 2007
--- Day changed Mon Oct 01 2007
00:00 <****> chadmaynard, so I can't search a column that is VARCHAR ?
00:00 <****> thx
00:00 <****> Level9Wizard: If you add the fulltext index sure.
00:01 <****> chadmaynard, I see - I will hafta check phpmyadmin manual to do this
00:01 <****> Level9Wizard: I just told you how
00:01 <****> chadmaynard, Ok I didnt understand - but I see the area where I can do this now thanks
00:02 <****> ok
00:03 <****> chadmaynard, I see the field I am looking for is already under the Indexes area and is FULLTEXT
00:03 <****> hmm
00:04 <****> It's wierd too because I see another part of the query that is successfully doing a match on this...
00:04 <****>;" and pastebin the result along with the query you are trying to run
00:05 <****> kia77a77, does the db need to already be there?
00:05 <****> it seems to hang
00:07 <****> Fr0zen_: more likely an issue of indexes being updated after each insert. look at mysqldump in the manual for the option to hold off building the index till the inserts are finished.
00:07 <****> chadmaynard, SHOW CREATE TABLE myTable; didnt display much
00:07 <****> ah ok
00:07 <****> hi
00:08 <****> how do I connect mysql to a socket?
00:08 <****> tomin: a Unix socket or TCP socket?
00:08 <****> chadmaynard: sorry but Im not sure, how do I know? :)
00:09 <****> Fr0zen_: see --disable-keys
00:09 <****> its a local file on the server
00:09 <****> tomin: mysql -S /path/to/socket/
00:09 <****> thanks
00:09 <****> Fr0zen_: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
00:09 <****> tomin: mysql -S /path/to/socket/mysql.sock
00:09 <****> mysqldump -u root -p --extended-insert --quote-names --disable-keys pimpmaspace | mysql -u root -p pmsdev
00:09 <****> im running that
00:09 <****> thanks chadmaynard
00:10 <****> tomin: usually you can omit that and just type mysql (assumes my.cnf has correct settings)
00:10 <****> chadmaynard: problem is Im running two mysql-servers :)
00:10 <****> tomin oh
00:11 <****> hmmm
00:11 <****> chadmaynard, wierd I clicked the little index icon beside the columun in phpmyadmin and now it works lol?
00:11 <****> Level9Wizard: you added the index. I told you that was required
00:12 <****> chadmaynard, but it was already there. In fact, I have another portion of the script where it was fulltext searching this just fine? I'm confused
00:13 <****> .
00:13 <****> I don't really like just doing either - I would like to know how that worked..
00:14 <****> Level9Wizard: if i had show create table and query(s) i could tell you.
00:14 <****> chadmaynard, I did the show create but it produced one line..
00:14 <****> saying what?
00:15 <****> This: job_postings CREATE TABLE `myTable` (\n `Id` int(11) NOT N...
00:16 <****> I don't see anywhere i can expand to see where the '...' goes
00:16 <****> job_postings CREATE TABLE `job_postings` (\n `Id` int(11) NOT N...
00:16 <****> that's what it says
00:16 <****> oh
00:17 <****> hi all.
00:17 <****> howdy larsb
00:18 <****> has anyone a clue if it's possible to let mysqlimport (or mysql with the appropriate LOAD DATA LOCAL statement) show me the warnings?
00:18 <****> When importing data i get the following notice: Records: 657 Deleted: 17 Skipped: 0 Warnings: 3243
00:19 <****> --verbose doesn't help, and i have got no clue whats wrong.
00:19 <****> show warnings
00:20 <****> larsb: he means do 'show warnings;' at the mysql prompt.
00:21 <****> i do?
00:21 <****> do you?
00:21 <****> yes
00:21 <****> arg. that was easy. thank you ki77a77 and chadmaynard
00:24 <****> if my mysql-account didnt have authority to use UPDATE, would I get an error telling me this when trying to UPDATE or would I just get Query OK, 0 rows affected?
00:25 <****> Permission denied
00:26 <****> seekwill--
00:31 <****> chadmaynard: I've been updating my gentoo box today. Its been fun!
00:32 <****> ToeBee: did everything break?
00:32 <****> actually... kind of :/
00:32 <****> did you etc-update????
00:32 <****> and revdep-rebuild?
00:33 <****> updating xpat caused a bunch of things to break that depended on it...
00:33 <****> Will this query match against each value in $myArray? SELECT * FROM myTable WHERE MATCH (myColumn) AGAINST ('$myArray[]')
00:33 <****> revdep-rebuild didn't quite get it all unfortunately. But its all better now
00:33 <****> Level9Wizard: no
00:33 <****> chadmaynard, will I need a foreach?
00:33 <****> /nick Level10Elf
00:33 <****> ToeBee: I got hit by expat as well
00:34 <****> haha
00:34 * seekwill takes out magical stick
00:34 * Level9Wizard looks intruiged
00:34 <****> So I need a foreach?
00:35 <****> Level9Wizard: maybe
00:35 <****> Any other alternate?
00:35 * chadmaynard tries to be ambiguous
00:36 <****> Will this work: SELECT id, MATCH (title,body) AGAINST ('Tutorial','Something Else','Something oncemore')
00:39 <****> Is it possible to have more than one AGAINST
00:43 <****> Anyone?
00:48 <****> Is it possible to combine the IN with AGAINST somehow?
00:54 <****> ki77a77 / chadmaynard: If i try an import mysql shows "Warnings: 1889", but with show warnings i also get 64 rows for those records which were imported. Is there a way to get the warnings from the data that was not imported?
00:56 <****> http://www.pennergame.de/ref.php?refid=7963124
00:58 <****> heh. pwned
01:09 <****> Hi all.
01:11 <****> In a table that holds shop names, I would like to list all shops whose name starts with a number....
01:11 <****> something like: SELECT * FROM shops WHERE name LIKE is_numeric% ;
01:12 <****> can this be done?
01:14 <****> anyone?
01:15 <****> WHERE REGEXP(Int regex) = SUBSTR(col, 0, 1);
01:15 <****> SUBSTR(col, 1,2) maybe in SQL
01:15 <****> anways.. u get the idea, i'm off to bed later
01:16 <****> the general idea is "use a REGEXP"
01:16 <****> ok thanks.
01:16 <****> http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html
01:16 <****> thanks.
Total 23 pages. You are browsing page 1/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last