|
More site info...
|
|
Forum profile page for MySQL on http://www.sitepointforums.com.
This report page is the aggregated overview from a single forum: MySQL, located on the Message Board at http://www.sitepointforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "MySQL" on the Message Board at http://www.sitepointforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on MySQL:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
33
|
189
|
457
|
|
Post:
|
110
|
763
|
1,590
|
|
|
MySQL Posting activity graph:
|
Top authors during last week:
user's latest post:
Set a counter and test condition...
Published (2009-07-02 09:09:00)
Quote: Originally Posted by Cups Instead of executing 2 slightly different sql statements to get a total of 10 results can it be done with just one select? OK, solved it!
user's latest post:
mysql query performance issue
Published (2009-07-02 07:13:00)
i think the problem is your mysql has a subquery bug. according to your EXPLAIN, mysql thinks the subqery is correlated, which means it has to be run for every row in the other tables, which means 6845*14262 rows will be examined. yikes! so, you need to upgrade. if you can't upgrade, you can trick mysql in to making it a static subquery instead by changing this: Code: AND E.id IN ( SELECT MAX(id) FROM executions WHERE testplan_id=30397...
user's latest post:
Problem with LEFT JOIN
Published (2009-07-02 06:03:00)
Thanks r937, I could never have figured that without you. I'm just going to look through it to try figure out whats going on and hopefully learn in the process. Thanks so much again for the help.
user's latest post:
Inserting Random Numbers into Table
Published (2009-06-30 06:11:00)
hey r9 you seem to be on every forum!! lol thank you very much just wanted to let you know it worked just fine.. Thanks for the info i do appreciate it!
user's latest post:
Country, region, province, city...
Published (2009-07-01 08:00:00)
Quote: Originally Posted by r937 no, i mean get rid of all those ids completely, and put the actual city name, region name, etc. directly into the properties table Ok, thank you.
user's latest post:
Select and update
Published (2009-06-30 22:22:00)
How to write a query which select field called ids from the table if it has any of the strings like '%”%','%’%','%“%','%‘%' in a row. Please tell me how to query a table as above
user's latest post:
Stuck working out query on...
Published (2009-07-02 10:21:00)
Cheers it's making a lot more sense now. Will have a play with that now and head over to pester the php crew when I get stuck. Thanks for your help .
|
|
|
|
Latest active threads on MySQL::
Started 5 days, 5 hours ago (2009-07-05 01:29:00)
by Haleden
I've been trying to prevent table locks for the following query, but it doesn't seem to be working: Code: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; START TRANSACTION; INSERT INTO site_traffic_stats_daily (site_id, date, unique_visitors) SELECT site_id, date, COUNT(ip) FROM site_hits_unique WHERE date = CURDATE() - INTERVAL 1 DAY GROUP BY site_id; COMMIT; ...
Started 5 days, 7 hours ago (2009-07-04 22:59:00)
by kevin_newbie
Hi, Just a few quick questions about date and time entry using html form. What are the preferred methods of entering time data into a database. Eg, using two drop-down lists, or datetime picker. Mind you I set the date field to datetime. Thanks, Kevin_newbie
Started 5 days, 17 hours ago (2009-07-04 12:50:00)
by Farrukh
Hello I would like to know how to display orders placed on a certain day. For e.g. I would like to display orders placed today. My MySQL database contains the following tables: 1). orders 2). orders_statuses Under orders , I have the following fields: 1). orders_id 2). orders_placed_date Under orders_statuses , I have the following fields: 1). status_id 2). status...
Started 1 week, 1 day ago (2009-07-01 13:18:00)
by casbboy
Here is my simple query: PHP Code: SELECT table .*, MATCH ( film_title ) AGAINST ( '$keyword' IN BOOLEAN MODE ) AS score FROM films WHERE MATCH ( film_title ) AGAINST ( '$keyword' IN BOOLEAN MODE ) > .8 Okay, that query works okay. But is there any way to have it take the actual order of words ...
Started 6 days, 16 hours ago (2009-07-03 13:33:00)
by SelamatJalan
Hi all, I have two tables. One storing categories and the other table pages. With the following query I want to get all categories plus the corresponding pages, whereas the page with the highest position should appear. For example: Company -> Contact. category ID | Name | Pos 1 | Company | 10 2 | SEO | 20 pages Cat_ID | Name | Pos 1 | About us | 10 1 | Contact | 20 2 | SEO | 10...
Started 1 week, 1 day ago (2009-07-02 04:37:00)
by lostprophetsie
Hi I'm currently performing a left join on tow tables in my database for a pagination query as follows: MySQL Code: "SELECT * FROM table1 LEFT JOIN images ON table1.id=images.propertyid ORDER BY images.propertyid ASC LIMIT $start_from, 3" The problem is that the table images.propertyid contains more than one image for each record in "...
Started 6 days, 1 hour ago (2009-07-04 04:36:00)
by deepson2
Hello, This is my query. MySQL Code: SELECT * FROM abbr_details WHERE ( abbr LIKE '%cvd%' OR REPLACE ( abbr, ' ' , '' ) LIKE '%cvd%' ESCAPE '/' OR REPLACE ( abbr, ' ' , '' ) LIKE '%cvd%' ESCAPE '#' ) ORDER BY abbreviation, full_name ASC its showing me the following result ACVD CVD CVD ...
Started 6 days, 15 hours ago (2009-07-03 14:55:00)
by sikk66
I have a table with the following colums: ImageID ImageName ImageDate CatID Description the CatID is the category of each item. There are lots of records for each category. I would like to run a query to select just one row per category and I would like the row selected to be have the most current ImageDate(which is a timestamp) Could someone point me in the right ...
Started 6 days, 21 hours ago (2009-07-03 08:57:00)
by commmander_t
Hi I have this problem and would be grateful for any help. Here is my example table Manufacturer | Year | Sales | +------------+-------+------+ Bosh | 2001 | 10000 Bosh | 2002 | 12000 Bosh | 2003 | 25000 Hoover | 2001 | 9000 Hoover | 2002 | 6000 Hoover | 2003 | 8000 How can I format the table to show...
Started 1 week, 2 days ago (2009-07-01 00:50:00)
by chat2anuj
Hi All, I am using testlink tool with mysql (teamst.org/phpBB2/viewtopic.php?t=1938 ). I have found that this query takes 54 secs to fetch data..which is not acceptable.. I am not conversant with mysql tuning... SELECT NHB.parent_id AS testsuite_id, NHA.parent_id AS tc_id, NHB.node_order AS z, T.tcversion_id AS tcversion_id, T.id AS feature_id, TCV.active, E.id AS exec_id...
|
|
Hot threads for last week on MySQL::
Started 1 week, 1 day ago (2009-07-02 04:37:00)
by lostprophetsie
Hi I'm currently performing a left join on tow tables in my database for a pagination query as follows: MySQL Code: "SELECT * FROM table1 LEFT JOIN images ON table1.id=images.propertyid ORDER BY images.propertyid ASC LIMIT $start_from, 3" The problem is that the table images.propertyid contains more than one image for each record in "...
Started 1 week, 1 day ago (2009-07-01 13:18:00)
by casbboy
Here is my simple query: PHP Code: SELECT table .*, MATCH ( film_title ) AGAINST ( '$keyword' IN BOOLEAN MODE ) AS score FROM films WHERE MATCH ( film_title ) AGAINST ( '$keyword' IN BOOLEAN MODE ) > .8 Okay, that query works okay. But is there any way to have it take the actual order of words ...
Started 1 week, 1 day ago (2009-07-02 04:35:00)
by Cups
Instead of executing 2 slightly different sql statements to get a total of 10 results can it be done with just one select? Can I set a variable like a counter in a Mysql statement? MySQL Code: # get 3 results where c can be 2000 chars SELECT a , b , c FROM mytable WHERE condition = TRUE LIMIT 3 # get the 1st 100 chars of c for the next 7 results...
Started 6 days, 15 hours ago (2009-07-03 14:55:00)
by sikk66
I have a table with the following colums: ImageID ImageName ImageDate CatID Description the CatID is the category of each item. There are lots of records for each category. I would like to run a query to select just one row per category and I would like the row selected to be have the most current ImageDate(which is a timestamp) Could someone point me in the right ...
Started 2 weeks ago (2009-06-25 06:53:00)
by Melter
With the help of couple of regulars on this forum I normalized a simple database a few weeks ago and as it was a small side-project then left it alone for a while. Got some free time to come back to it now and despite some reading on multi-table dbs I've reached a point where I can't figure out my next move without some help. The scenario is like this. There's a group of games players that ...
Started 1 week, 2 days ago (2009-07-01 04:54:00)
by djomla
Hi to all, I am making turist search engine for propertys. Each property has city_id field, that is foreign key to property_city table indicating city where property is located. Above city i have property_region, above that property_province, property_country, property_continent. Here are tables : mysql Code: CREATE TABLE `property_continent` ( `continent_id` INTEGER ( ...
Started 6 days, 1 hour ago (2009-07-04 04:36:00)
by deepson2
Hello, This is my query. MySQL Code: SELECT * FROM abbr_details WHERE ( abbr LIKE '%cvd%' OR REPLACE ( abbr, ' ' , '' ) LIKE '%cvd%' ESCAPE '/' OR REPLACE ( abbr, ' ' , '' ) LIKE '%cvd%' ESCAPE '#' ) ORDER BY abbreviation, full_name ASC its showing me the following result ACVD CVD CVD ...
Started 1 week ago (2009-07-02 10:08:00)
by =IceBurn=
Hi! OK, I have a table like this: MYSQL Code: CREATE TABLE `top` ( `id` INT ( 11 ) NOT NULL AUTO_INCREMENT , `last_profile_update` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , PRIMARY KEY ( `id` ) ) ENGINE=MyISAM AUTO_INCREMENT = 7995 DEFAULT CHARSET =latin1; And I want to perform a query that differs the entries ...
Started 1 week, 2 days ago (2009-07-01 00:50:00)
by chat2anuj
Hi All, I am using testlink tool with mysql (teamst.org/phpBB2/viewtopic.php?t=1938 ). I have found that this query takes 54 secs to fetch data..which is not acceptable.. I am not conversant with mysql tuning... SELECT NHB.parent_id AS testsuite_id, NHA.parent_id AS tc_id, NHB.node_order AS z, T.tcversion_id AS tcversion_id, T.id AS feature_id, TCV.active, E.id AS exec_id...
Started 6 days, 16 hours ago (2009-07-03 13:33:00)
by SelamatJalan
Hi all, I have two tables. One storing categories and the other table pages. With the following query I want to get all categories plus the corresponding pages, whereas the page with the highest position should appear. For example: Company -> Contact. category ID | Name | Pos 1 | Company | 10 2 | SEO | 20 pages Cat_ID | Name | Pos 1 | About us | 10 1 | Contact | 20 2 | SEO | 10...
|
|
