| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> usally, it's low.
<1> dm - mysql permissions are based on the IP of the client
<1> you may not have permissions remotely
<2> hi all
<0> it's on the same server
<3> dm, are you talking for the machine (this is all local btw) or does MySQL admin have some setting?
<2> does MySQL 4.0 have an issue with the "CHARSET" parameter?
<4> it doesnt know about it
<0> mysql has suprisingly, no settings. No p***words can be set, no new databases can be made. I am given 1 premade db and my regular login.
<0> From: "Sarber, William BMCS" <SarberW@cnrc.navy.mil> <- What is a BMCS?
<4> get a better isp
<1> !google BMCS
<5> BMCS: http://www.bmcs.demon.co.uk/
<0> I was thinking about trying another.
<1> heh, well, it's not that.
<0> I emailed a Navy recruiter, then she sent me and a list of other people a form letter asking for even more info, so I replied to everyone suggesting that it was a little stupid for the US government to allow it's employees to send messages to multiple people with TO rather then BCC. Then that woman emailed me back, apperently a super
<6> Is there any way I can insert a bunch of rows into a table and retrieve the auto-increment-id for each of them, with just one round trip?
<1> I don't think so
<1> you could lock the table and take the max() before and after, and ***ume their sequential
<6> Hm, not so nice.
<1> no, not so nice
<6> I wonder if a procedure could do the dirty work...
<6> If so it's a good excu^Wreason to upgrade to MySQL 5
<7> Hi :)
<7> I'm having some issue trying to wrap my head around something, I need to INSERT... SELECT in a way I'm not sure is possible. Essentially, I have items, which have 6 attributes eachs, I need to go from the table which holds the 6 attributes, and number them 1 through 6 for each item in another table, (their default order for templating)
<8> !man math functions
<5> (Mathematical Functions) : http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
<8> I guess it's probably /
<8> yeh
<8> returns a float though
<1> cast it
<9> hi ppl
<7> sjrussel, in SQL?
<9> how can i enable log queries in my.cnf?
<7> oh, I can use DIV
<1> for Darien... I don't think your insert/select is posible
<1> DIV?
<7> yes...
<8> ?
<7> DIV
<7> Integer division. Similar to FLOOR(), but is safe with BIGINT values.
<7> mysql> SELECT 5 DIV 2;
<7> -> 2
<7> from the manual
<1> nice
<7> or I can FLOOR() it :)
<1> as long as they're not BIGINT
<10> MalMen: log=file
<9> zeitoun i want that to see the querys at last 10 seconds
<9> how can i do that with no log files?
<10> MalMen: this will log all queries
<9> im not want log querys, i want see the number of...
<10> MalMen: I have absolutely no idea
<10> you can monitor the activity with mysql-administrator
<11> Does anyone have a method for substring replacement in a TEXT column?
<11> ie, changing all xxx to yyy in a text field?
<10> !m equant replace()
<5> equant: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<10> equant: update tablebla set fieldbla=replace(fieldbla, 'xxx', 'yyy');
<11> Thanks zeitoun
<11> I should have been able to find that.
<11> I looked at that page and I was ***uming it wouldn't be so easy. Must have just ignored the replace() function :)
<10> equant: your mistake was to "look at" instead of "read"
<10> ;)
<11> what is this read thing?
<11> Is there something I can look at that explains reading?
<10> !google reading
<5> reading: http://www.reading.ac.uk/
<10> looks like a good reference...
<10> but maybe not for reading docs
<0> Ok I'm up to: Duplicate entry '1' for key 1
<0> I need to modify a row of data, I am using INSERT INTO bins VALUES ('$address','$date','$comment','$latitude','$longitude','$location','$status','$by')
<12> is there any way to monitor progress on large updates?
<0> INSERT only seems to be for new entries, but I need to mofiy an entry
<4> !m dm update
<5> dm: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<1> bazman - select count(*) from the table , if it's not locked
<12> sjrussel: it's MyISAM, so yeah it's locked
<1> you could watch the MYD size
<12> sjrussel: it's an unindexed column
<1> MYD is data
<12> sjrussel: oh right. Read that as MYI
<1> oh, it's an update? I read INSERT
<1> nm then
<1> I don't think you can monitor updates
<12> Is it better to store missing data as an empty string or as NULL?
<7> hrm, UNION doesn't work quite like I imagined in INSERT.... SELECT
<6> bazman: NULL is for missing data
<7> its inserting all the first SELECT's, then the next SELECT, then the next
<7> instead of performing the UNION first
<12> The docs say sometimes it's better to store empty dates as the zero date rather than NULL because it takes less space to index
<12> thought the same might go for varchar
<12> If the particular column never has an empty string as data, nothing wrong with using empty string right?
<13> Davey|Work: have you tried -- insert into table (select ... union select...);
<7> TodoInTX, no, thinking about doing that now :)
<14> Todointx: about your earlier query concering "Lazy Bastard" nope. I worked in the hosting matrix stuff
<7> TodoInTX, it didn't like that
<13> Davey|Work: syntax error?
<7> yup
<15> can an ndb MGM node also be an ndbd node?
<7> hrm. Now what :
<7> :/
<7> can I re-insert the data over itself, using GROUP BY to get the PKs how I want them?
<13> Davey|Work: how are you doing the query now?
<16> I have a database of people who are ***igned to families (many people can be in each family). Is there a way to combine the data in one query so I can get all the family information and all the people in that family?
<13> I tried and example doing -- insert into table (select...) UNION (select...) -- which seemd to work.
<13> alphablue: basically the LazyScripts package intergrates with your browser to pull login info from CORE, then uses pexpect to ssh into the servers.
<17> mrturtle? eg select * from familys,members where familys.id=memberes.fam_id and familys.name="what you want" ?
<7> How do I delete the items which are <= (MAX(id) / 2)
<7> (I get a syntax error about invalid use of grouping functions when I use that)
<17> Davey|Work why do you need grouping there?..
<18> okay so I am going to group a bunch of records together but I need to have the sum of every record that is grouped into one, will the SUM(This_Field) work for that?
<7> Joe7, precedence (sp?)
<13> select @newmin := MAX(id) / 2 from orignal table; delete from table where id <= @newmin;
<16> joe7, yes, that's the basic idea. I'll give that a try.
<7> TodoInTX, that will work in MySQL 4.1 w/ MyISAM?
<16> thanks, btw
<13> it should
<7> hrm, that'd be cool
<19> what is the default mysql root p***word?
<19> hmm maybe blank, nevermind i typed the set p***word in correctly... thanks
<20> Hi there; if I have a database with two tables; one is called orders and one is called items, the first shows the info about the order and the second shows the items ordered. The items in the second table know which order they belong to via a column, so how can I select all of the items pertaining to a particular order (I hope that made sense) (ack)
<13> Davey|Work: actaually you probably want --- select @newmin := FLOOR(MAX(id) / 2) from table;
<16> Joe7, when I do that, I get multiple 'family' rows for each person. Is there a way to get all people in one family query?
<13> Davey|Work: just incase you have an odd number of rows.
<13> DogWater: sounds like a JOIN.
<14> todo: cool
<17> mrturtle: multiple family rows? pastebin a query/result pls
<21> Hi. I just created a DB : CREATE DATABASE blah;
<21> Then, I create a user with rights to the db: GRANT ALL on blah TO 'foo'@'localhost' IDENTIFIED BY 'bar';
<21> Then, I issue a "flush privileges".
<21> I even restarded mysqld.
<13> DogWater: select fields... from items join order on items.order_id = orders.id and orders.id = 'N';
<21> But I still get "Error 1044: Access denied for user: ..."
<20> TodoInTX: SELECT * from sessions where $email = '$email' I have that part, but I need to also select anything in session_objects which belongs to the sess_id where email = '$email'
<13> ok.. same sort of thing.
<21> I must be missing something...
<13> select sessions.*, session_objects from sessions join session_objects on sessions.id = session_objects.id where session.email = '$email';
<13> sorry... that should be -- join session_objects on sessions.id = session_objects.session_id
<16> http://pastebin.com/545265
<21> Hum. I need "GRANT ALL on blah.* TO"...
<21> Shame on me, it's written everywhere. Need not to work when sick I guess !
<21> Bye.
<20> TodoInTX: there isnt a session_objects in sessions its its own table
<20> TodoInTX: there is a parent_session column in the session_objects table that I am trying to use as a reference so i will know which items go with which order.
<22> hi
<22> When database records are transmitted from one database to another, is there a way to check to see if the record had arrived successfully?
<20> you can count the number of rows in both dbs?
<22> I meant a command response
Return to
#mysql
or
Go to some related
logs:
#css
how to change latin1_swedish to utf8
#oe
#bash
#css
Uncompressing Quake III Arena Demotrap linux
suse 10.1 yast msttcorefonts
#web
ubuntu asureus
#php
|
|