| |
| |
| |
|
Page: 1 2
Comments:
<0> if I execute this query from php: "INSERT INTO offers (title) VALUES('')". how can I find out wich row has been modifyed? or what index it got?
<1> I'm sure the manual of both MySQL and PHP will tell you
<1> you even have multiple ways of doing it
<1> although one would be more intuitive than the other in that context
<0> well, I could simply get the last element from a select where name=''
<1> no
<0> hmm... how else?
<1> that wouldn't account for a multi-user environement
<1> <1> I'm sure the manual of both MySQL and PHP will tell you
<0> well. then what kind of help do I get if I "Just ask!" in here
<0> I'm looking at the manual right now
<1> "(but know what you are asking about!) "
<0> I know
<0> I need to find out the index of the modifyed row
<1> not enough for it to be an interesting question.
<0> it is for me
<1> ... you should RTFM then
<0> whatever
<0> I think I don't have a choice with ppl like you around
<1> smart people?
<0> people that keep everything for themselfs
<0> regardless that at some point in theyr life they got info/stuff for free
<0> from other guys that had nothing to do with them
<0> for example the mysql documentation and mysql server itself
<2> muerte
<3> hi
<4> someone here ?
<5> no
<4> doh
<4> I need suggestions
<5> u suggest you ask an actul question
<4> I have an application that sharing a database, but I want to lock records when a user is working on data to prevent other user editing the same data
<4> because if someone editing a record and the other user dindt see the change yet it can edit it too and the result will be the last editing and the 1st user will ask what happened
<5> you think your the first person to encounter this issue?
<6> NullDragon: Simple solution, create a table with locks in it
<4> yeah but I dont want to lock all the table just some records ..
<6> as a user goes to edit a record, put a lock in the table, when they're done - remove it...
<7> i'm using the standard rpms off the mysql site now
<7> where's the base_dir location on a linux system?
<7> ./usr/bin ?
<8> somebody here who could help me ?
<9> hi all
<9> Is there a query I can run that will search for a string within a database, and remove that string where-ever it is in a database, regardless of what row or table it is in? Remember I want to remove the string from the row, and not the row itself
<10> hello everyone..
<10> I need to create a myisam table that will support more than 4gb.. any ideas on how to do this?
<11> K_F i got it fixed :P
<11> 23:51:14 up 2 days, 12:53, 2 users, load average: 0.23, 0.22, 0.19
<6> hehe... agriva needs a table larger then 4 gb... mine crash at 40
<12> Freman
<12> hi
<12> http://rafb.net/paste/results/ryE1kH21.html
<12> what is wrong?
<12> K_F
<12> hi
<12> how are you?
<12> K_F: http://forums.mysql.com/read.php?10,66307,66307#msg-66307
<1> http://www.kfwebs.net/news/?id=387&New+Semester <- Current Management Accounting
<1> ... sitting in a lecture
<1> way 2 there you need to start the server before using mysqladmin
<1> uhm, nvm
<12> acces deneied...
<1> try to move the "mysql" folder away from the data dir and run mysql_install_db again
<12> ok
<12> ) http://rafb.net/paste/results/5TTvey92.html
<1> eh
<1> you stop mysqld before moving the "mysql" folder right?
<12> not
<1> bah
<1> .... you should
<12> K_F win
<12> seee the way
<12> and worked...
<1> now we don't have to hear your whining for a little while :)
<12> ok
<12> K_F: http://rafb.net/paste/results/XQvzbI76.html
<1> and?
<12> only for post the solution, much thanks
<1> one shot or one bottle?
<1> I don't recommend the latter in one night..
<1> been there, done that
<12> 1 bootle :)
<1> are you using OpenPGP?
<12> no
<1> http://www.secure-my-email.com <- you should read up on it
<1> used for digital signatures and/or encryption
<1> exempli gratia email communication, code releases ..
<1> you've probably seen [signature] written when you download applications
<1> nice to be able to use it
<1> you probably have gpg installed on your linux computer already
<1> try to write "gpg --version"
<12> gpg (GnuPG) 1.2.1
<1> so easy to get started, don't even have to install the application
<1> although I prefer the 1.4.x series
<13> how can I get less verbose output from mysql client ? results are now in | 231 | 123 | 234| form
<13> I could do without the "|" make up.
<1> novation: http://www.kfwebs.net/links/6 for SQL
<14> is there n e way i can replace into a seleceted query?
<14> want to know the correct syntax in replacing?
<14> i've ran this query: SELECT * FROM 'table' WHERE 'field' BETWEEN 'val1' AND 'val2'
<14> but how do i replace into a field?
<14> once i've ran this query?
<14> help please
<1> CHIPZ: http://www.kfwebs.net/links/6 for SQL
<15> how can you check whether a one-field array of values (e.g. select foo.bar from foo) has any overlaps with another one-field array of values( e.g. select bar.bar from bar) ?
<16> Can someone help me with this query: SELECT p.*, s.email as store_email, s.name as store_name, s.city as store_city, s.v_code as store_v_code, pi.id as img_id FROM product p, product_images pi, store s WHERE p.status = 1 AND p.image_flag = 1 AND (p.cat_id in(100) or top_level_cat_id in(100)) AND p.id = pi.reference_id AND pi.type_id = 1 AND p.store_id = s.id LIMIT 0,3;
<16> the query is fine and quick when the cat_id and top_level_cat_id return result but when no result the query take 15 second
<16> why and what can I do^
<1> for one thing I prefer the ansi92 synta for joins
<1> makes for much cleaner reading
<16> are you talking about left joins, ....
<1> ?
<16> ansi92 synta for joins
<1> SELECT * FROM a INNER JOIN b ON a.id=b.blah;
<1> would be an example of using ansi92
<1> http://www.kfwebs.net/links/6 for SQL
<1> has nothing to do with inner/outer join or not, you might want to read the "introduction to structured query languages - part 2"
<16> if I simplify the query like this the same problem happen: select * from product where status = 1 and image_flag = 1 and (cat_id in(101) OR top_level_cat_id in(101)) LIMIT 0,3
<16> if the cat_id return noting the query take 15 second and when thequery return result it take 0,3 second
<16> 193645 record in product
<0> how do I see the query that I have to use in order to create a table that already exists in the database
<0> I remamber something with show create database dbname, or something like that
<0> but it's not working
<16> show tables
<16> ^
<16> ?
<0> show create table `tblname`
<0> it works
<0> tx
<16> you want to create a table with the record of an existing one?
<16> create table 'new_table_name' select * from 'existing_table_name';
<17> i changed the hostname of my root account, and for some reason i can't connect using from that machine, and now i can't connect from localhost, how can i change my hostname for the root account if I can't use it?
<16> in mysql database, select * from user and update the Hostname to the good one.
<17> i can't get into mysql
<17> i quit, then tried from the new host
<17> and now i can't do anything
<18> Servo, http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<16> what is the better sql query to replace this one: select * from product where status = 1 and image_flag = 1 and (cat_id in(101) OR top_level_cat_id in(101)) LIMIT 0,3
<18> Naimur, i think the time diff may be because as soon as you get 3 results the query stops but otherwise it continues.
<1> for one thing he lack an ORDER BY
<1> so LIMIT is prohibited per definition
<18> ah
<1> http://www.kfwebs.net/links/6 for SQL
<1> beebum: just configured http://stortingsvalg2009.com here
<1> "election 2009"
<1> up to 4 bloggers now :)
Return to
#mysql
or
Go to some related
logs:
galaxynet sturgis mirc
#linuxhelp
#skype
#AllNiteCafe
#linux
PHP SESSID
php keyword selected
WHAT IS THE CAPTAIN OF A CURLING FOURSOME CALLED ?
majormud source code
debian root enforced
|
|