|
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:
|
77
|
283
|
790
|
|
Post:
|
257
|
941
|
2,690
|
|
|
MySQL Help Posting activity graph:
|
Top authors during last week:
user's latest post:
INNER JOIN w/ some data not...
Published (2009-11-07 21:19:00)
Quote: Originally Posted by daprezjer ... LEFT will always bring up the table to the right (oddly) of the = sign um, no equal signs are just that... equals the equal condition in an outer join simply determines how the rows are to be matched it is the table mentioned to the left of the LEFT OUTER JOIN keywords that is the one for which all the rows are returned note that you can do a join on conditions other than equality
user's latest post:
Problem with InnoDB, Foreign...
Published (2009-11-06 18:50:00)
Quote: Originally Posted by quiquedcode If I'm not wrong, shouldn't I use this instead? Code: ... ON DELETE SET NULL ON UPDATE CASCADE So, if a city's ID changes, it also changes on supplier table? Yes of course. But why not set it to ON UPDATE NO ACTION? Because why would you _ever_ want to change the id of a city?? And I would like to repeat my previous question a bit: Do you really need to allow NULL for cities and taxes for...
user's latest post:
INNER JOIN w/ some data not...
Published (2009-11-07 20:31:00)
You want an OUTER JOIN, not an INNER JOIN. There are two kinds of OUTER JOIN: LEFT OUTER JOIN and RIGHT OUTER JOIN and, in MySQL, the word OUTER (like the word INNER) is optional, so it's often dispensed with.
user's latest post:
Mutiple join showing result when...
Published (2009-11-05 13:30:00)
Can you test it on a copy of the table with just a couple of sample rows? Or post the same here, of course. Also, what do you get for the other "er" fields? Those should be null as well.
user's latest post:
Selecting items with no...
Published (2009-11-07 21:34:00)
Wow, thanks, works like a charm. You may have just gotten yourself a customer. Learning this stuff can be powerful (and I have way to many nested queries).
user's latest post:
Help with CASE Statements
Published (2009-11-02 05:27:00)
Not really, maybe those other procedures had at most one parameter? It probably has to do with how some class in VB is implemented.
user's latest post:
Mutiple join showing result when...
Published (2009-11-05 15:53:00)
Knew that was the problem all along I was just testing how quickly you guys could figure it out. Needless to say a little disappointed!
user's latest post:
Mysql database splitting over...
Published (2009-11-06 18:51:00)
ok read it.... tried it.... failed epically.... anyone want to help? lmao im using wamp and mysql 5.1.36 so alot of the stuff isnt the same and i couldnt figure it out for the life of me but im going to keep trying and if anyone knows how to set it up under wamp in the easiest possible step by step possible im no IT pro so im still learning and their tutorial on it totally killed me
user's latest post:
Page 2 - Alternative to...
Published (2009-10-30 16:37:00)
I reran my original query without a join to tblLossContacts and it ran in 3.65 seconds: Code: mysql> DESCRIBE SELECT tblLosses.LossID, tblClaims.ClaimID, (SELECT MIN(Description) FROM tblProperty WHERE ClaimID=tblClaims.ClaimID ORDER BY PropertyID) AS Description FROM tblLosses INNER JOIN tblClaims ON tblLosses.LossID=tblClaims.LossID INNER JOIN mapCompaniesToLosses ON tblLosses.LossID=mapCompaniesToLosses.LossID LEFT JOIN tblContacts...
user's latest post:
Problem with InnoDB, Foreign...
Published (2009-11-06 18:53:00)
You're right PS1: I was joking about Q.A. team, I work by myself lol PS2: I think you're right, I'll make city and tax required
|
|
|
|
Latest active threads on MySQL Help::
Started 2 days, 20 hours ago (2009-11-06 16:45:00)
by sr
The max_connections problem can be due to that connection pooling on your webserver is bad. It can very often leave stale connections.
You will have to check this with SHOW PROCESSLIST during operation and if you have a lot of rows where the Command = Sleep and the Time value is high then you have this problem.
What you can do get rid of these stale connections is to reduce ...
Started 1 day, 15 hours ago (2009-11-07 21:10:00)
by r937
it shouldn't make any difference, should it
but to be honest, i don't actually know
my advice is not to sweat it unless your database is the size of, oh, i dunno, facebook's
Started 1 day, 15 hours ago (2009-11-07 21:15:00)
by r937
Quote: Originally Posted by daprezjer Use a single query to select any rows that are not parents of other rows.
Code:
SELECT childless.ID
, childless.title
, childless.parentID
FROM services AS childless
LEFT OUTER
JOIN services AS child
ON child.parentID = childless.ID
WHERE child.ID IS NULL
vwalah...
Started 1 day, 16 hours ago (2009-11-07 20:31:00)
by cafelatte
You want an OUTER JOIN, not an INNER JOIN.
There are two kinds of OUTER JOIN: LEFT OUTER JOIN and RIGHT OUTER JOIN and, in MySQL, the word OUTER (like the word INNER) is optional, so it's often dispensed with.
Started 2 days, 19 hours ago (2009-11-06 18:00:00)
by requinix
Where's user_answer_id coming from?
Started 2 days, 15 hours ago (2009-11-06 21:34:00)
by r937
Quote: Originally Posted by davidoff69 cant think of anything unusual ive done oh really?
how about designing a crappy table?
i don't mean to be harsh but your tbl_client_data table table is not even in first normal form
redesign it, so that you're not joining to the same table umpteen times, and i'll bet your performance improves immensely
Started 3 days, 20 hours ago (2009-11-05 16:05:00)
by MrFujin
if each company have several tables with own data and company A has no relations to company B, then having a database for each customer could be an idea.
From your point of view it, it is easier to manage one database with one table for all customer, one table for all invoices etc..
But it also depend what kind of data you want to extract and how the customer interact with ...
Started 3 days, 17 hours ago (2009-11-05 19:57:00)
by r937
'null' is a 4- character string
NULL (or null if you prefer lowercase) is a special keyword that represents the absence of a value
see the difference?
Started 5 days, 4 hours ago (2009-11-04 08:56:00)
by sr
Well I'm not entirely sure how you mean.
Running several mysql several servers against the same datadirectory (the physical files) is not recommended.
And if you say "network drives" what are you referring to here? Some sort of NAS? If it is then you should also avoid it for performance reasons. Mounting a volume over a network is much slower than running it off an internal ...
Started 3 days, 18 hours ago (2009-11-05 18:09:00)
by sr
Quote: Originally Posted by crazy D
Tamil uni codes and other some English symbol not working in this
server please help me
Sorry, you will have to provide more information if we shall be able to help you.
|
|
Hot threads for last week on MySQL Help::
Started 5 days, 4 hours ago (2009-11-04 08:56:00)
by sr
Well I'm not entirely sure how you mean.
Running several mysql several servers against the same datadirectory (the physical files) is not recommended.
And if you say "network drives" what are you referring to here? Some sort of NAS? If it is then you should also avoid it for performance reasons. Mounting a volume over a network is much slower than running it off an internal ...
Started 4 days, 3 hours ago (2009-11-05 09:08:00)
by r937
Quote: Originally Posted by cranium ...to no avail.
If possible, I would appreciate an explanation on why what I am doing is wrong so I can better attack these sorts of things in the future. what you are doing is right
Code:
FROM establishment e
INNER
JOIN state s
ON s.id = e.stateID
LEFT OUTER
JOIN rating_establishment ...
Started 3 days, 17 hours ago (2009-11-05 19:57:00)
by r937
'null' is a 4- character string
NULL (or null if you prefer lowercase) is a special keyword that represents the absence of a value
see the difference?
Started 1 week, 1 day ago (2009-11-01 12:19:00)
by r937
Quote: Originally Posted by leeming this does not seem like the sensible way of doing this but it is
why would you not know the resource id for money??
Started 2 days, 19 hours ago (2009-11-06 18:00:00)
by requinix
Where's user_answer_id coming from?
Started 1 week ago (2009-11-01 15:31:00)
by r937
try it with COUNT instead of COUNT DISTINCT and see if that gives you a hint
Started 2 days, 15 hours ago (2009-11-06 21:34:00)
by r937
Quote: Originally Posted by davidoff69 cant think of anything unusual ive done oh really?
how about designing a crappy table?
i don't mean to be harsh but your tbl_client_data table table is not even in first normal form
redesign it, so that you're not joining to the same table umpteen times, and i'll bet your performance improves immensely
Started 1 week ago (2009-11-02 06:53:00)
by heibad
Started 6 days, 5 hours ago (2009-11-03 07:31:00)
by r937
Quote: Originally Posted by quintellarosa Supposing user #5, who speaks Portuguese (language_id 7), by retrieving a query, I would like to see these results:
Code:
WHERE language_id = 0 -- English is aways language_id 0
OR user_id = 0 -- User_id 0 will be used for official content
OR user_id = 5 -- user_id of person running the query...
Started 1 week ago (2009-11-02 11:24:00)
by r937
Code:
SELECT a.id
, a.name
, a.username
, a.email
, MAX(CASE WHEN b.field_id=20 THEN b.value END) AS 'Company'
, MAX(CASE WHEN b.field_id=13 THEN b.value END) AS 'Website'
, MAX(CASE WHEN b.field_id=19 THEN b.value END) AS ' Job Title'
, MAX(CASE WHEN b.field_id=9 THEN b.value END) AS 'Address'
, MAX(CASE WHEN b.field_...
|
|
Size: 1,583 bytes
