| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> newpers_ you can't explain that way :)
<0> INDEX is powerfull in many ways
<1> :)
<0> if used alot, then you will have some bad design
<1> yeah, that made it sound dandy
<0> you don'tmake every single key an index and hope it will be faster :) there are many consequences :p
<1> updating is slower
<1> as more info has to be stored
<0> you can run the EXPLAIN the query to find more info about how that query is processing in little detail
<1> what's that
<1> !man EXPLAIN
<2> (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<1> interesting
<3> what's the text BLOB equivalent?
<3> !man GLOB
<2> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<3> !man BLOB
<2> (The BLOB and TEXT Types) : http://dev.mysql.com/doc/mysql/en/BLOB.html
<3> TEXT cool ;)
<4> if that table never have update (example log table) its mean good when having much index ? *am i correct here?*
<1> so... is it possible to have mysql automatically run a stored procedure after a certain date?
<5> is there a good simple tool to backup a mysql database remotely via http, without having ssh access to it? i.e. at a shared-hosting ISP?
<5> i'm looking for a PHP script, ultimately, that'll return a bzipped mysqldump
<5> oh, and my ISP's PHP settings do not allow me to execute programs, so just exec'ing mysqldump is out of the question
<5> *crickets*
<6> muhoo: nothing i know of
<6> depending on your db size as well mysqldump might not be the best option either
<6> script could timeout, etc
<6> if your host doesn't allow ssh in i'd suggest finding another host
<6> there's tons out there
<6> i'd say try to send a support request to have them dump that **** for you
<6> either that or if they let you connect to the mysql server do it with your own tools
<6> something like navicat
<6> other than that you're SoL
<7> i'm using perl dbi, is there a way to get the value of a auto incriment column after I insert a new record withouth running a seperate query?
<8> muhoo: mysqldump --host=remotehost ...
<9> good evening
<5> Xgc: no go. the mysql server is hidden... security feature
<5> it's on a private address accessible only to the apache/php instance.
<10> hi guys, could someone tell me if they notice something wrong with the following:
<10> SELECT DISTINCT link_category, cat_name, show_description, sort_order
<10> FROM `$wpdb->links`
<10> LEFT JOIN `$wpdb->linkcategories` ON (link_category = cat_id)
<10> WHERE list_limit <> 0
<10> ORDER BY $direction ", ARRAY_A);
<8> suedoh_: There's a pastebin you should have used for that sort of post.
<10> oh ok, im sorry
<8> suedoh_: The php fluff isn't proper SQL.
<10> which php fluff?
<8> suedoh_: Expand that if you want specific (more helpful) corrections.
<8> `$wpdb->links`
<8> ORDER BY $direction
<8> That sort of stuff.
<8> suedoh_: What is the behavior you don't like?
<10> thanks , you helped :)
<10> by the "Order" part
<8> Ok. You're welcome.
<10> i forgot a column name
<11> i am trying to get mysql-query-browser running but i get an error about libgtkmm-2.4.so.1 as i do not have gnome installed
<11> do i need to install gnome or can i just install that single library, and if so, where do i need to put the file ?
<11> i have linux 2.6.15.6 with kde 3.4.2 although i doubt that either is relevant
<11> :P
<12> gnome is not gtk
<11> that's what i thought
<12> gtk is a library
<11> yup
<12> just install it
<11> so i just need to install gtk2 and all should be well ?
<12> yes
<11> cool thanks :P
<13> could someone help me figure out what's wrong with my syntax on this query?
<13> (SELECT `id`, `system_id`, `hull_id`, `field_id`, `revision_date`, `revision_number`, `document_number`, `comments`, `color_id`, `user_id`, MAX(`date`) as `date` FROM `program_cost_management_data` WHERE `system_id` = 1 AND `field_id` = 1 GROUP BY `hull_id`) LEFT JOIN (SELECT `name` AS `hull_name`, `description` AS `description` FROM `hull`) ON (`program_cost_management_data`.`hull_id` = `hull`.`id`) ORDER BY `hull_id` ASC
<13> it says it's near the "INNER JOIN"
<13> er... "LEFT JOIN" ... sorry
<14> i'm trying to insert rows in a temp table with 2 columns, one column being x, and the other column being x's placement in a resultset as ordered by a date in the table x is being pulled from
<14> e.g. [x1, 1], [x2,2] as ordered by the date. i can always loop through it but that's too slow, i want to do it relationally
<14> Tenshi: shouldnt your group by be after your joins?
<14> and your where clause for that matter
<14> eh maybe not its tough to read it all bunched together like that, i guess that's a subquery
<0> hansbrix sorry I don't get your problem
<14> i want to store the order, numerically, in a temp table, of a column
<0> so as a view?
<0> or create temptable?
<14> so if i have table foo, with 2 columns, x and date: x is 'wee', date is 1/3/05, x is 'doh', date is 1/3/04
<14> then the temp table would contain 2 rows
<0> CREATE TEMPORARY TABLE mytable ..
<14> [foo, 1]
<14> er, [doh, 1] and [foo, 2]
<0> so whenever you have data within table foo
<14> i'm having a problem generating the second column in the temp table relationally
<0> hmm
<0> how are you creating your temp table
<14> declaring it then inserting the foo's in
<14> with a select
<0> what is your statement
<14> the statement works fine
<14> i just cant get the second row
<0> ar eyou refering the temp table more than once in the same query?
<14> i mean i can insert the date, but i dont want the date, i want a numeric substitute for the date as ordered by x
<14> no
<0> ok
<14> the problem is more sql logic than implementation
<15> set @num = 0; create temporary table temp as select x, (@num:=@num+1) as y from foo order by x;
<14> how do i get these seemingly magical numeric values to be inserted
<14> hmm
<16> hey folks
<15> hansbrix, would that^ work?
<16> whats the best way to map your data models before creating anything?
<17> How do I replace the contents of my pic_upload col with the contents of my pic_path col for every row in the table ?
<14> bobfield: i dont think so no
<14> but then i'm actually doing this in sql server, maybe mysql has that functionality
<0> babo.. update mytable set col1 = 'fdfdf'
<0> if you don't place a where clause it replaces everything ...
<14> i tried it and i get 'a select statement that ***igns a value to a variable must not be combined with data-retrieval operations'
<0> hansbrix can you show use your query...
<14> CAN you do that in mysql? that would be very handy
<17> _m00: but I want each row to correspond the a different value ... the above will set all my pic_upload to the same value right ?
<0> yes babo
<15> quik_, pen&paper? That's how I lay stuff out
<17> _m00: well then it's not what I'm looking for ...
<17> _m00: well then it's not what I'm looking for ..
<16> does anyone go further than pen and paper?
<17> _m00: oops
<0> babo - theoretically, if you want a different value. distinct values then you would need to update each one..
<0> quik_ - use a tool
<14> _m0O no its not mysql syntax so i probably shouldnt show the query, i'm more just looking for a logical approach
<17> _m00: no shortcuts ?
<0> quick - relational schemas
<16> for app flow.. like uml wacky stuff
<0> babo - depends ... for a path.. I don't thinks o..
<0> babo - unless your just adding a constant to the thing ...
<0> babo - to the path that is...
<17> _m00: no choice then but to update each one ?
<0> quik_ - yes.. Many tools allow you to do the relational mappings like uml...
<0> babo - are you just updating the path?
<17> _m00: no - the pics have been swapped with the path .... I deleted a table and then restored from backup. But the design of the table was slightly different.... so now my pics are in the path col
<0> oh
<0> babo - so you just want to change the column to a idfffent name?
<0> swap names?
<0> swap columns?
<18> swap body fluids?
<0> you can easily fix that ...
<17> _m00: hmmm ... that's probably a good idea ....
<17> _m00: thanks
<14> ah, i figured it out. by using a subselect, select x, select (count(*)+1) from foo f2 where f2.date < foo.date)
<0> why not use a join instead
<14> using that in the insert clause generates the numbers i'm looking for, i guess i was just being thick and not realizing that you could use subselects in an insert clause heh =/
<14> hmm
<14> that's probably a good idea
<14> since i'll be duplicating stuff in the where clause later on
<14> good call _m0O
Return to
#mysql
or
Go to some related
logs:
mplayer avisynth.dll fc5
#css
nvidia linux 9xxx release rumours
#perl
#fedora
error inserting fglrx fedora 6
Eyecue ping
#nvidia
#linux
hot to install rpm on ubuntu
|
|