|
More site info...
MySQL Help | Forum profile
|
|
Forum profile page for MySQL Help on http://www.devshed.com.
This report page is the aggregated overview from a single forum: MySQL Help, located on the Message Board at http://www.devshed.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 Help" on the Message Board at http://www.devshed.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 Help:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
86
|
293
|
787
|
|
Post:
|
307
|
1,042
|
2,764
|
|
|
MySQL Help Posting activity graph:
|
Top authors during last week:
user's latest post:
Exclude Similar Data from Tables...
Published (2009-11-25 11:51:00)
sorry, the only dedupe software i have any experience with was on an ibm mainframe in the 1980s that's why i gave you the google link you gots to research them and evaluate them yourself p.s. the reason i suggested a human being is because dedupe software isn't perfect
user's latest post:
Challenging query
Published (2009-11-26 03:44:00)
Fantastic. Another pyramid scheme. Just what the world needs.
user's latest post:
Migrating
Published (2009-11-25 08:25:00)
Start with checking that you are setting the content-type in your html page. You should have a row something like: Code: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> In your html head block.
user's latest post:
Exclude Similar Data from Tables...
Published (2009-11-26 05:01:00)
We did sth. similar once: - we took the adress to google and retrieved it's geo position - we implemented a rating system for surname soundex, first name soundex and geo position Whenever there was a new record, we gave - one point, whenever there was another record with the same geo position - another for an identical sounding surname at the same geo position - and one more, if there was an identical sounding first name as well Every...
user's latest post:
Optimizing mysql performance
Published (2009-11-23 19:21:00)
yes the my.ini file is the part i am editing. i have got it down to about 9/8ms now from the original 17 but that was due to sorting out my mysql queries. i was posted my quesries would you guys be able to see if you can merge any together and optimize them as im not expert with mysql
user's latest post:
TEXT versus VARCHAR
Published (2009-11-24 00:38:00)
Thanks for the reply. I have a number of TEXT fields and I was wondering if I may run in the same problems as this person if i converted them into VARCHAR: http://forum.percona.com/index.php/m/4603/ Will TEXT convert into VARCHAR using the ALTER TABLE command coinsidering that the the external text will then have to become inline? or must I create a new table and dump the old old data in there? How about converting from TEXT to VARCHAR, is...
user's latest post:
2 update for 2 table
Published (2009-11-18 05:56:00)
Quote: Originally Posted by r937 there is a good reason i wanted you to try the SELECT first please, keep trying a SELECT to retrieve the titles from both tables i solved problem using following query PHP Code: UPDATE thread INNER JOIN post ON thread . firstpostid = post . postid SET thread . title = post . title
|
|
|
|
Latest active threads on MySQL Help::
Started 1 day, 23 hours ago (2009-11-26 03:44:00)
by cafelatte
Fantastic. Another pyramid scheme. Just what the world needs.
Started 2 days, 16 hours ago (2009-11-25 10:53:00)
by r937
Quote: Originally Posted by Joomla_India We need that, there should be something on the backend suggestion: a human being
Started 3 days, 7 hours ago (2009-11-24 20:27:00)
by r937
you forgot the obvious simple solution...
Code:
CREATE TABLE t_products
( idProduct INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT
, some_other_field VARCHAR(99)
, some_other_field VARCHAR(99)
, country VARCHAR(99)
, colour VARCHAR(99)
, team VARCHAR(99)
);
SELECT *
FROM t_products
WHERE country = 'Austria'
AND colour = 'Red'
AND team = ...
Started 4 days, 11 hours ago (2009-11-23 16:24:00)
by nathan2oo9
Sorry to add a bit more description to what the actual problem is doing. It is giving me an error on line 51 which is the line
[code]
$dbQuery="SELECT numRentals FROM cars WHERE numRentals=" . $_POST["$make"] and ["$model"];
[code]
thanks
Started 3 days, 16 hours ago (2009-11-24 11:25:00)
by jghake
Hello! I am fairly new to MySQL but I believe I have a fairly simple command to write.
I need to get a record with a "HARDWARE_ID" and " IPADDRESS" from the "networks" table, determine from the "IPADDRESS" (10.10.*.*) on the third octet which site they are with and save that into the "Location" record for the same "HARDWARE_ID" in the "accountinfo" table.
I have been able to ...
Started 2 days, 18 hours ago (2009-11-25 09:19:00)
by cafelatte
Quote: Originally Posted by Ghezzo
But when I enter "email VARCHAR(60)" it only says 'NULL' in the email field in the DB.
Can you be a bit more specific?
Started 2 days, 20 hours ago (2009-11-25 06:47:00)
by sr
Quote: Originally Posted by regdude Hi!
I migrated from a older mysql server (linux) to a newer mysql server (linux), but I have a problem with the charset.
This is odd because everything in the PHPMyAdmin shows good, but in the webpages it doesn't.
Why is that?
Have you changed both the MySQL server and the Webserver or only the mysql server?
Started 3 days, 8 hours ago (2009-11-24 18:54:00)
by r937
Quote: Originally Posted by behnampmdg3 Hey guys, what does <> mean in a query? it means less than or greater than
in other words, not equal
Started 2 days, 19 hours ago (2009-11-25 08:41:00)
by JClasen
This'll only damage existing data, if the tables declared charset does not match the charset your data is in. Otherwhise ALTER TABLE ... CONVERT TO CHARACTER SET should work as intended.
Regards, Jens
Started 3 days, 15 hours ago (2009-11-24 11:58:00)
by sr
And by the word "registry" you mean what exactly?
The mysql query-log is otherwise along the lines of what you are asking, since it stores connection, time and query.
|
|
Hot threads for last week on MySQL Help::
Started 6 days, 16 hours ago (2009-11-21 11:08:00)
by r937
Quote: Originally Posted by jacques123 So user Ben can choose any store but if he does not select his own store the results from DB will be empty. so... why bother forcing him to choose a store?
just show him his own store, forget the dropdown
Started 4 days, 11 hours ago (2009-11-23 16:24:00)
by nathan2oo9
Sorry to add a bit more description to what the actual problem is doing. It is giving me an error on line 51 which is the line
[code]
$dbQuery="SELECT numRentals FROM cars WHERE numRentals=" . $_POST["$make"] and ["$model"];
[code]
thanks
Started 3 days, 8 hours ago (2009-11-24 18:54:00)
by r937
Quote: Originally Posted by behnampmdg3 Hey guys, what does <> mean in a query? it means less than or greater than
in other words, not equal
Started 2 days, 18 hours ago (2009-11-25 09:19:00)
by cafelatte
Quote: Originally Posted by Ghezzo
But when I enter "email VARCHAR(60)" it only says 'NULL' in the email field in the DB.
Can you be a bit more specific?
Started 4 days, 1 hour ago (2009-11-24 01:53:00)
by henrybill
Started 2 days, 20 hours ago (2009-11-25 06:47:00)
by sr
Quote: Originally Posted by regdude Hi!
I migrated from a older mysql server (linux) to a newer mysql server (linux), but I have a problem with the charset.
This is odd because everything in the PHPMyAdmin shows good, but in the webpages it doesn't.
Why is that?
Have you changed both the MySQL server and the Webserver or only the mysql server?
Started 2 days, 16 hours ago (2009-11-25 10:53:00)
by r937
Quote: Originally Posted by Joomla_India We need that, there should be something on the backend suggestion: a human being
Started 1 week ago (2009-11-20 11:00:00)
by ran_dizolph
Started 4 days, 17 hours ago (2009-11-23 10:13:00)
by sr
Quote: Originally Posted by big JME
ok guys thats everything i could possibly think you would need to know. i need mega low read and write times as my server has to have a very fast response time. currently running around 30 mysql queries im able to get a 17ms response time but i need this to go to about 3ms or slightly higher towards 8ms
Where did you get ...
Started 6 days, 9 hours ago (2009-11-21 17:53:00)
by Guelphdad
|
|
Size: 117 bytes
