How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dan O'Keefe wrote:
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
How about `tablename` ?
hth,
Stijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using backticks
`temp-08-08-28`
Cheers,
Ewen
On Thu, Aug 28, 2008 at 1:01 PM, Dan O'Keefe [EMAIL PROTECTED] wrote:
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
How do you escape a dash in a table name such as temp-08-08-28?
Best not to use them at all. If you must for some odd reason, use
backticks round the name.
PB
Dan O'Keefe wrote:
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
--
MySQL General Mailing List
On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila [EMAIL PROTECTED] wrote:
Hi, I've been trying to find information on how myisam handles locks. I
though myisam had locking only on writes and not on reads.
No, readers block writers. This true of any system that only has read
and write locks
SELECT this, that, theOther,
SUM(IF(SUBSTRING(myDate,1,10) = '20080101' AND SUBSTRING(myDate,1,10)
= '20080131'), 1, 0) AS `January`
FROM theTable
GROUP BY theOther
Throws this error...
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL
Try this:
SELECT this, that, theOther,
SUM(IF(SUBSTRING(myDate,1,10) = '20080101' AND SUBSTRING(myDate,1,10)
= '20080131', 1, 0)) AS `January`
FROM theTable
GROUP BY theOther
Problem was in parentheses
Dusan
Jay Blanchard napsal(a):
SELECT this, that, theOther,
SUM(IF(SUBSTRING(myDate,1,10)
I understand that reads are locked by writes but nowhere does of
mention that reads also block reads. Boy queries y posted to the list
are selects.
Jose E. Avila(tachu)
Yuku/Kickapps
Sent from mobile device.
On Aug 28, 2008, at 5:48 AM, Perrin Harkins [EMAIL PROTECTED] wrote:
On Wed, Aug
In the last episode (Aug 28), Jose Estuardo Avila said:
On Aug 28, 2008, at 5:48 AM, Perrin Harkins wrote:
On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila wrote:
Hi, I've been trying to find information on how myisam handles
locks. I though myisam had locking only on writes and not on
On Thu, Aug 28, 2008 at 10:59 AM, Jose Estuardo Avila
[EMAIL PROTECTED] wrote:
I understand that reads are locked by writes but nowhere does of mention
that reads also block reads.
How could they not? You can't simultaneously read and write the same
data -- the read would get half-written
My point is that on my process lists there are no writes being done at
that time only reads and actually only one read all other reads are
locked as well as writes. I've gone through every single one of the
queries in my processlist at any given time when more than 500 process
pile up and
On Thu, Aug 28, 2008 at 1:14 PM, Jose Estuardo Avila [EMAIL PROTECTED] wrote:
My point is that on my process lists there are no writes being done at that
time only reads and actually only one read all other reads are locked as
well as writes.
Sure, that's because the reads are in line behind
I've extracted text from approx 1600 pdf files using pdftotext.exe and
inserted it into a table.
Now I see there are form feed characters in the field, and I would suspect
other special characters, also.
I'm not having much luck trying to remove them.
Any pointers appreciated.
Thanks,
David
What's the recommended method for high-availability setups?
I've currently got a master-master replication setup that I'm testing
but it doesn't quite seem as complete a solution as I had pictured.
When a failed server comes back online you still have to manually add
it based off of the line
Hello,
It isn't without its pros and cons (just like any other HA solution), but you
might want to check out DRBD.
http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-drbd-heartbeat.html
-- Jimmy
Bryan Irvine wrote:
What's the recommended method for high-availability setups?
I've currently
I saw that. That's what initially got me thinking that I might need
to look elsewhere for a different HA solution.
The biggest thing is that the DB is for a hosting company. This
company could add databases for their clients upon a request and at
any point during the day. The current
I saw that. That's what initially got me thinking that I might need
to look elsewhere for a different HA solution.
The biggest thing is that the DB is for a hosting company. This
company could add databases for their clients upon a request and at
any point during the day. The current
In the last episode (Aug 28), Bryan Irvine said:
I saw that. That's what initially got me thinking that I might need
to look elsewhere for a different HA solution.
The biggest thing is that the DB is for a hosting company. This
company could add databases for their clients upon a request
agador-
did you look at replication implementations using master/slave configuration?
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-diffengines.html
HTH/
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any
At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote:
So how bad is this? The mentioned query will be the query which is used
the most in my application (yes, it is going to be a forum).
Should I break normalization and save the date of the root in each node row?
My recommendation is no.
20 matches
Mail list logo