fenway
-
Posts
16,168 -
Joined
-
Last visited
-
Days Won
4
Everything posted by fenway
-
4GB is a reasonable maximum to assume... but I wouldn't worry about it.
-
What do you have so far?
-
Since I'm not familiar with that script, you'll need to isolate the problem further.
-
I have no idea what the mysql issue is.
-
No, not really.
-
Can you provide some sample output?
-
If you're using mysql 5, there a CSV engine type.
-
IT needs to be somewhere in one of the many paths... it's better to specify this path on the command-line.
-
Has little to do with godaddy... assuming your dump was valid, and you didn't switch version across hosts, we'll need error messages.
-
Howto select A.* where A.id not in B.id, and A.email not in B
fenway replied to swinstead's topic in MySQL Help
Sounds like what you need to do is get a list of customer IDs regardless of "origin" in a derived table, and then join that to orders. -
UTF-8 sounds like a good idea.
-
my website is extremely slow, potential database problem ?
fenway replied to tmyonline's topic in MySQL Help
The refman has the appropriate settings. -
List visitors between two dates. But also ouput "empty" dates in same query.
fenway replied to gladideg's topic in MySQL Help
You'll need to use an integers table to generate a recordset that include one row for every date you want. -
How is the output from that query different than what you would expect?
-
Perhaps I don't understand where you're stuck.
-
Solved how?
-
I don't follow.
-
Sorry, what is it that you're trying to achieve?
-
What's the actual query? Show us some table structures, and by the looks of it, some SP code.
-
Dynamically retrieving all the data from a mySQL database
fenway replied to iplaywithfire's topic in MySQL Help
That's a lot of code -- i see 2 select statements; what's the problem. -
What does "in linux" mean? Look at the my.conf file.
-
And you're locking why?
-
MySQL also has DATE_FORMAT()
-
You sound very confused.... mysql has no idea about javascript. Get a JSON object from the DB, and then pretend the DB doesn't exist.
-
What's wrong with a simple (secure) script?