#mysql
10 November 2007
Total 22 pages. You are browsing page 4/22.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:15 <****> (Adaptive Hash Indexes) : http://dev.mysql.com/doc/mysql/en/innodb-adaptive-hash.html
03:16 <****> is it possible to see what the list looks like indexed
03:16 <****> I understand what indexing does
03:16 <****> but I'd like to actually see its makeup
03:25 <****> I think I need a book on database theory more than a product manual
03:25 <****> any good suggestions?
03:25 <****> if you want a real book, get something like "introduction to database systems"
03:25 <****> its like 1000 pages, lots of stuff
03:26 <****> cool
03:26 <****> http://www.amazon.com/Introduction-Database-Systems-Eighth/dp/0321197844/ref=pd_bbs_sr_1/105-5385798-6915659?ie=UTF8&s=books&qid=1194661817&sr=8-1
03:26 <****> if you have a respectable borders near you, they might have it in the store, so you can browse it before buyng it
03:26 <****> 50 bucks =[
03:26 <****> 50?
03:26 <****> looks like $103 to me
03:27 <****> new and used
03:27 <****> ah
03:27 <****> this one is also good, http://www.amazon.com/Science-Database-Management-Paul-Helman/dp/0256134383/ref=sr_1_1/105-5385798-6915659?ie=UTF8&s=books&qid=1194661906&sr=1-1
03:27 <****> http://product.half.ebay.com/An-Introduction-to-Database-Systems_W0QQprZ2433744QQtgZinfo
03:27 <****> :)
03:27 <****> 25 dollah
03:28 <****> 45 cents
03:28 <****> http://product.half.ebay.com/An-Introduction-to-Database-Systems_W0QQprZ2234229QQtgZinfo
03:28 <****> 5 dollah
03:28 <****> Anyone able to tell me how I could add a delete statment to this query. http://hashphp.org/pastebin.php?format=plain&pid=35830. I've got 3 rows with the same value in one column. I'm basically trying to merge the rows.
03:28 <****> :)
03:31 <****> Narcsis: why are you inserting the totals in the same table as the data itself?
03:32 <****> well im just trying to replace the 3 rows with 1 row.
03:32 <****> it needs to be in the same table because there are many records that dont have duplicates
03:32 <****> Narcsis: an INSERT is hardly the best way to achieve that
03:32 <****> and there are many records with duplicates
03:32 <****> ok, what do you suggest
03:33 <****> well, two passes
03:34 <****> 1
03:34 <****> then delete from sales where SubID IN (select SubID from tmp_table)
03:35 <****> then finally, insert into sales select * from tmp_table
03:35 <****> ok, ill give it a shot. I was just trying to do it in one swoop.
03:36 <****> I am fairly certain it requires at least two passes
03:36 <****> i.e. my three passes could be improved on.
03:36 <****> Get Operand should contain 1 column(s) error on http://pastebin.com/m3290ac8b . I don't understand why. : (
03:36 <****> socksxj: what?
03:37 <****> wtf is limit 0, ``
03:37 <****> what phpmyadmin turned limit 0,1 into
03:37 <****> någon här som har bra koll på regexp?
03:37 <****> socksxj: your subquery should only return ONE field.
03:37 <****> oh sorry wrong window
03:37 <****> thumbs: ok, i'll see how it goes. Thanks for the tips.
03:38 <****> Narcsis: the trick is NOT to touch the unique rows.
03:38 <****> and ONLY computer the SUM() for the rows which have multiple duplicate rows.
03:39 <****> yea, that was a concern I was going to look at once I got it working in general. I did notice that the query was affecting all rows.
03:39 <****> ahh, thumbs, works now, thank you. jbalint, thank you too. I guess that was fairly obvious, I'm dumb. Thanks again.
03:39 <****> have fun
03:41 <****> !man replace
03:41 <****> (REPLACE Syntax) : http://dev.mysql.com/doc/mysql/en/replace.html
03:42 <****> !man dateadd
03:42 <****> Nothing found.
03:42 <****> theres no dateadd in mysql?
03:42 <****> !man date and time functions
03:42 <****> (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
03:43 <****> I need something that finds a string and replaces it with something
03:43 <****> I thought that was replace()
03:43 <****> !man string functions
03:43 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
03:44 <****> thats weird that the notation is different in the string function page to the replace() page
03:44 <****> you worry too much
03:44 <****> well the first one didn't make sense
03:45 <****> and the 2nd does
03:45 <****> so follow the second.
03:45 <****> yea...
03:45 <****> tators: There's a REPLACE statement and REPLACE function.
03:46 <****> tators: As you might guess, they have vastly different behavior / usage.
03:47 <****> ah
03:47 <****> no wonder
03:47 <****> so I'm doing a replace function... and I made it update set namesuffix = replace('"', '"', '');
03:47 <****> because for some reason every peice of data has quotes around it
03:48 <****> but I think the initial str is wrong in the ()
03:48 <****> I want to replace all the quotes with nothing
03:49 <****> you're not using the function properly.
03:49 <****> ok
03:49 <****> err update voter
03:49 <****> but how would I use the function properly then
03:49 <****> still wrong.
03:50 <****> ...
03:50 <****>);
03:51 <****> I got all that
03:51 <****> excluding the source field...
03:51 <****> which I said was wrong...
03:51 <****> hence the 'still wrong' comment.
03:51 <****> its not still wrong if I say what I did wrong
03:51 <****> ALTER IGNORE TABLE a ADD UNIQUE INDEX b(c) ORDER BY - why ORDER BY does not work for my MEMORY tables?
03:51 <****> it just not right...
03:51 <****> what is the source field
03:52 <****> tators: well all those years of administrating SQL servers really paid off, did they?
03:52 <****> tators: any field/column
03:52 <****> what?
03:53 <****> what what?
03:54 <****> update voter set namesuffix = ('namesuffix', '"','') doesn't work
03:54 <****> you're missing a very important keyword in there.
03:54 <****> the actual function name.
03:54 <****> oh yea
03:54 <****> good work
Total 22 pages. You are browsing page 4/22.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last