#mysql
09 October 2007
Total 22 pages. You are browsing page 22/22.
First :: Prev :: [...] [18] [19] [20] [21] [22] :: Next :: Last
22:32 <****> how do i change that then?
22:33 <****> use boolean
22:33 <****> http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
22:33 <****> boolean will fix that ?
22:33 <****> ye i know how
22:33 <****> 50% of the rows.
22:33 <****> thanks much
22:33 <****> ebergen: I can probably guess, but tell me why
22:34 <****> well im testing so i only have like 10 rows
22:34 <****> because it doesn't output any set variables
22:34 <****> heh yep
22:34 <****> you're gonna love RBL
22:36 <****> I need a query that returns one row for each different value of column a and the number of times that vlue occurs. basically a count and a distinct together.
22:37 <****> SELECT field, COUNT(*) FROM table GROUP BY field;
22:37 <****> yay all good thanks guys..
22:39 <****> I am doing count(r.ad_id) , but I need unique r.ad_id ...is there a way to do that ?
22:39 <****> can I do multiple group by's maybe ?
22:39 <****> are multiple aggregates possible ?
22:40 <****> count(distinct r.ad_id)
22:40 <****> cool
22:43 <****> there is something in this line that free text search needs. what is it? cause i dont want the id field but i do want my number field to be unique.
22:43 <****> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
22:44 <****> can i take out the auto_increment and move rest to number field?
22:44 <****> du i guess i can try
22:44 <****> fl
22:44 <****> test
23:03 <****> http://www.l4m3rz.com:8000/listen.m3u
23:05 <****> Unable to open 'http://www.l4m3rz.com:8000/listen'
23:05 <****> ah now it works
23:07 <****> What language is this ?
23:08 <****> It looks like Visual Basic
23:08 <****> Lithuania
23:08 <****> What language do they speak there :p
23:09 <****> It sounds like Visual Basic
23:10 <****> how do I reset the stats that show is the mysql command-line client from the "status" command? "flush status" didn't do it.
23:38 <****> hmm when I try and increase the "max_packet_allowed" variable via the switch (--max_packet_allowed=32MB), it doesnt return... Am I doing something wrong?
23:41 <****> Anyone?
23:41 <****> Hi all - I've got a MySQL database with two tables. In the Administrator, they both display as 1,110 GB (not true - they only have 11000 rows of data that are purely numbers - no blobs or anything). When I try to access the tables or even drop them, Mysql-nt crashes. Its innodb. suggestions? If I could drop the tables that would be a solution, but I can't
23:43 <****> Xolt, doesnt return what?
23:44 <****> Err, the database has way more than two tables in my case, but there are two tables exhibiting this behavior
23:45 <****> tibyke, sorry... Meant to say doesn't change the variable at all
23:45 <****> try my.cnf
23:46 <****> "[mysql] \n max_allowed_packet=32mb"
23:46 <****> ?
23:53 <****> if i have a table products and it contains a field brandname, and i also have a table test_products which also contains similar records, how can i set the value of each record in the test_products table according to whats in the prodcts table, so say for example products, has records of id=1 and id =2 and i want to do if brandname=nike then test_products.brandname = 1 for each coresponding id
23:58 <****> Hello is this a valid trigger, I want to update date_arrival if arrival is set to 0 else make it empty
23:59 <****> This used to work in MySQl 4.1:
23:59 <****> SELECT Tipo.Name, Tipo.TipoID as ID, Product.Name AS ProductName, Product.Description AS ProductDesc,Image FROM Tipo, Product
23:59 <****> JOIN Tipo_mm_Product ON Tipo_mm_Product.TipoID = Tipo.TipoID
23:59 <****> Error : Unknown column Tipo.TipoID in 'on clouse'
--- Log closed Wed Oct 10 00:00:05 2007
Total 22 pages. You are browsing page 22/22.
First :: Prev :: [...] [18] [19] [20] [21] [22] :: Next :: Last