information_schema.columns reports a character_set_name of 'utf8' and a
collation_name of 'utf8_general_ci'
On Wed, Jun 3, 2015 at 3:14 PM, Emil Oppeln-Bronikowski e...@fuse.pl
wrote:
Is this a bug? If it's a feature, what could we do instead to get
around
this issue?
Is your column set
|
++-+---+
1 row in set (0.06 sec)
Is this a bug? If it's a feature, what could we do instead to get around
this issue?
Thanks,
Robert Voliva
.
Regards,
- Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui man...@tuenti.com wrote:
2013/2/13 Robert Citek robert.ci...@gmail.com
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek robert.ci...@gmail.com
wrote:
Any other possibilities? Do other scenarios become likely if there
are two or more tables
Yes. Except for a handful of static MyISAM tables. But the tables
that are experiencing the issues are all InnoDB and large (a dozen or
so fields, but lots of records.)
Regards,
- Robert
On Thu, Feb 14, 2013 at 5:59 PM, Singer Wang w...@singerwang.com wrote:
Are you using all InnoDB?
S
.
Regards,
- Robert
On Thu, Feb 14, 2013 at 6:13 PM, Rick James rja...@yahoo-inc.com wrote:
Recommend, for security reasons, you rectify that.
If you need some SUPER action, create a stored procedure with privileges
'creator', so the security hole is still mostly contained.
--
MySQL General Mailing
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek robert.ci...@gmail.com wrote:
Any other possibilities? Do other scenarios become likely if there
are two or more tables?
Of those, which are the most likely?
[from off-list responder]:
Other possibility: The replication is reading from master
robert
drop table IF EXISTS tblAgentCompanyMapper;
CREATE TABLE IF NOT EXISTS `energie_2`.`tblAgentCompanyMapper` (
`siaid` INT COMMENT 'id assigned in the excelsheet by SIA' ,
`company_id` INT NULL DEFAULT NULL UNIQUE COMMENT 'id automatically used by
energiecluster adresses' ,
`name
Yes! The illegal double error only happens if you do the select like you
did. The only error I was getting was the generic there's an error in your
sql.
Thank you!
Bob
From: Hank [mailto:hes...@gmail.com]
Sent: Monday, December 20, 2010 11:52 AM
To: Ramsey, Robert L
Cc: mysql
On Thu, Dec 9, 2010 at 9:10 AM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
On 12/8/2010 22:50, Robert Citek wrote:
Greetings to all,
Can I migrate slave databases between slave servers?
Imagine the following scenario: I have one master database server with
10 databases. I also
/replication-solutions.html
Regards,
- Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I have a query with three subselects, all referencing the same table. I'd like
to be able to combine them into one with aliases.
Here's what I have now:
select letter_codename,
(select greek from letter_otherlanguages where letter ='A') as greek,
(select french from letter_otherlanguages where
relevant, or are overblown, or whatever, i'd appreciate it.
again, i'm not taking sides, i just want to make sure the information
is as accurate as possible. thanks.
rday
--
Robert P. J. Day
to and some of the tables still
appear to be missing, there's not much i can do. or is there?
rday
--
Robert P. J. Day Waterloo, Ontario, CANADA
Top-notch, inexpensive online Linux
Say I have the following data:
+---+
| title
|
+---+
| ...And justice
a
monopoly, therefore there is no grounds to prevent the sell.
Again, SUN will sell it to Oracle unless someone gives SUN a better deal. It
will not matter how many I-hate-Oracle or Anti-sell-to-Oracle websites are
created. This business people, big business.
Robert Canary
OCDirect Electrical-Datacomm
Hi,
I have a table of events like this:
Evtuid
Evtname
Startdate
Stopdate
Repeats enum('true', 'false')
Monday enum('true', 'false')
Tuesday enum('true', 'false')
Wednesday enum('true', 'false')
Thursday enum('true', 'false')
Friday enum('true', 'false')
Satday enum('true', 'false')
Sunday
If you are very new, you may want to go through the tutorial at w3shools:
http://www.w3schools.com/SQl/default.asp
Regards,
- Robert
On Wed, Sep 30, 2009 at 11:45 AM, Carlos Williams carlosw...@gmail.com wrote:
I am no doubt very new to MySQL and have been studying the on line
manual however
It's not clear what exactly you are looking for. Two possible solutions:
1) use a union
2) use a join with another table containing partner and factor fields.
Can you give a short example of what the input looks like and what you
would like the output to look like?
Regards,
- Robert
On Thu
I have a stored procedure that inserts a record that I call from a
PreparedStatement. When I call #getGeneratedKeys it always returns a
null result set. Is that expected behavior?
Robert DiFalco | Chief Technology Officer (Products)
Direct: 503.276.7564
Mobile: 503.890.4994
Charlotte Caswell
, but it wouldn't have worked for me. The original site was
not mine and I didn't have permission to do so.
Thanks,
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Olaf Stein olaf.st...@nationwidechildrens.org writes:
I think he only has one DB, I guess that is a provider restriction...
True. I would create a separate db for each application if I could.
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL
.
Thanks in advance for any help or pointers to relevant documentation,
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to
reflect the name of the current db, right?
Thanks for your help. My partner will be rather happy to have her wiki
up.
rdc
--
Robert D. Crawford rd...@comcast.net
Laugh at your problems; everybody else does.
--
MySQL General Mailing List
For list
it as base of a bigger scenario (as part of a event/document
managementsystem based on zope/plone).
robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
me one.
this would not only spare me some time and errors designing it but I migth lern
some tricks of the trade.
thanks a lot
robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jason Pruim schrieb:
On Aug 12, 2008, at 2:30 AM, robert rottermann wrote:
Hi there,
I am about to create tools to maintain addresses (companies, persons,
groups)
As this is probably done allredy a million times over I would like to
ask if somebody could point me from where I migth download
tblProducts_has_tblSupplier which is linked to both tblSupplier and
tblProducts by foreign keys.
How do I guaranty integrity when deleting a product or supplier??
do i have to do that using triggers?
thanks for your insigth
robert
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS
Hi there,
is it possible to define an update trigger that calls a webservice (or just some
external method that would do it).
we have a web frontent, that does the indexing of data in its own catalog
(zope/plone).
so I would like to be able to push an update to the frontend.
thanks
robert
hi there,
I am usin mysql workbench to edit tables
now I wonder what codepage I shoud use.
what I want is to use utfo input and output.
now ther is utf8 - utf8_bin, utf8 - utf8_unicode_ci and about 7 million of
others.
which one do I use.
thanks very much
robert
--
MySQL General Mailing List
I'm running MySQL 5.0.22 on CentOS 5.1 (with all current patches
applied) and tried to define a table 'testcsv' using ENGINE = CSV. I
couldn't find a *.CSV file in the data directory. After looking it up in
MySQL Third Edition (by Paul DuBois) it turns out that I'm not running
the CSV engine. My
I've been told that an index always contains the primary key. So if I
have a LONG ID that is the primary key of table and create on index on
LONG VALUE, the index on LONG VALUE will actually work as a typical
compound index on ID,VALUE. My question is this, if I don't know that
about MySQL and
There is already a primary key index on ID.
-Original Message-
From: Wm Mussatto [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 10:50 AM
To: mysql@lists.mysql.com
Subject: Re: Indices in InnoDB/MySQL
On Tue, April 1, 2008 10:01, Robert DiFalco wrote:
I've been told
blurry when the PKEY is compound.
-Original Message-
From: Olexandr Melnyk [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2008 11:08 AM
To: mysql@lists.mysql.com
Subject: Indices in InnoDB/MySQL
On 4/1/08, Paul DuBois [EMAIL PROTECTED] wrote:
At 10:01 AM -0700 4/1/08, Robert DiFalco
Hi,
I'm having trouble wrapping my head around this problem. I have a list
of events for multiple computers. What I want to get is a summary of
the top 3 most common errors for each computer. So I get a result like
this:
Computername event numb_times
Comp1
A while back there was a general consensus that useCursorFetch (with
useServerPrepStmts) was somehow flakey?
Is this still the case? I had heard from someone that MySQL will not
even provide support for customers using these options in the JDBC
driver. Is that true?
TIA,
Robert
--
MySQL
'urulu.lang' doesn't exist
mysql
thanks
robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello!
I have three tables, mapping out a n:n relationship of authors and the
books they worked on:
table 1: authors (id, name)
table 2: authorships (author_id, book_id)
table 3: books (id, name, bestseller tinyint)
Here's two different queries I want to run:
1. Select each author, and how
, Robert L [EMAIL PROTECTED] wrote:
I'm looking for a best practices way of creating tables to store
both
one time and regularly repeating events. These are classes, so for
the
most part the have a regularly recurring time, but we do have some
one
off events. (...)
The only other way I could
Hi,
I'm looking for a best practices way of creating tables to store both
one time and regularly repeating events. These are classes, so for the
most part the have a regularly recurring time, but we do have some one
off events. For example, let's say the following:
Class-A Mon,Wed,Fri 8-9 from
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 18, 2007 10:00 AM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
I realize that wasn't the question, but it does seem like a lot of
trouble to get the equivalent of setAutoCommit(true
a commit (unless there was an exception but I'm not
analyzing that case).
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:36 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
Robert
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
they are functionally the
Sure, but that wasn't really the question.
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:56 PM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
If your transaction
`))
I would be very gratefull, if somebody could help me getting this straigth (
and point me to my missconseptions)
thanks
robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, not ID (integer) values. Any reason for
that?
yes! blunt stupidity!
(the insert was actually created programmatically, but I should have
seen it myself)
thanks
robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Could also be the DISTINCT processing depending on the number of dups
and the fields in the result set that must be sorted to perform the
distinct operation. Normally if there were a lot of dupes I would
suggest a sub-query but that is not a great option for MySQL.
-Original Message-
Any thoughts?
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Monday, June 18, 2007 10:10 AM
To: mysql@lists.mysql.com
Subject: INNER versus OUTER
I'm using the latest MySQL with InnoDB and something is happening I
don't understand. I am going to try this first
I'm using the latest MySQL with InnoDB and something is happening I
don't understand. I am going to try this first by paraphrasing my
queries since they are complex and have some proprietary info in them.
It seems that when a LEFT OUTER or an INNER join will produce the same
result and other
tuning and debugging.
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 2:35 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Need confirmation: Subselects are broken with regards to
index usage?
Hi Robert,
The way non-correlated
I think I'm discovering that sub-selects in MySQL are broken. Is that
true? It seems like you cannot have a sub-select without doing a table
scan -- even for a constant IN expression -- this because it gets
re-written as an EXISTS that executes for each row.
Is that true? Forcing an index
ON link.parentID=path.decendantId
WHERE (path.ancestorId = 1)
LIMIT 0,100;
Anyone have any ideas why this is the case?
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 24, 2007 1:11 PM
To: mysql@lists.mysql.com
Subject: Need confirmation: Subselects
Assign all dates to have a day of 01
Store in a date field, use DATE_FORMAT to just extract the MM and .
As you don't have the real day information it doesn't matter what day is used,
so long as it present in all months.
Hope this helps
Robert Gehrig
Webmaster at www.gdbarri.com
e-mail
a $4-million business printing out mailing labels
on a Win98SE machine. Why? Because it works perfectly for what they
want, why change it. They print out over 7 million mailing labels a
year. They did upgrade the printer.
--
robert
Stephen Cook wrote:
You should send that one to The Daily
Are there any hard and fast rules for this? If someone has already
compiled a list I'd love to see it.
For example:
* When a subselect will eliminate duplicates a join might introduce.
Change:
SELECT DISTINCT Acl.*
FROM Acl
JOIN Link ON Link.childID = Acl.ID
JOIN Paths ON
I'm looking for a tool that could parse a boat load of various queries
using complex joins and subqueries, analyze each, and print out the
optimal covering indices that could be used on each table for each
query. It would have to take into consideration stuff like a WHERE
expression that could not
PROTECTED]
Sent: Friday, November 03, 2006 1:40 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Analysis Tool
H. I actually think this would be somewhat difficult to write,
Robert. Parsing the queries would be complex enough given the different
ways one can construct SQL
I have some long VARCHAR fields that a user will sometimes sort on. Does
a prefix index in any way help with sorting or just for lookups? Will it
speed up a filesort? I couldn't find this information in How MySQL uses
indices.
R.
--
MySQL General Mailing List
For list archives:
Btw, this is using the InnoDB engine.
-Original Message-
From: Robert DiFalco
Sent: Tuesday, October 17, 2006 9:26 AM
To: mysql@lists.mysql.com
Subject: References on Optimizing File Sort
I have an unavoidable filesort in a very large query. Can someone point
me to references
I have an unavoidable filesort in a very large query. Can someone point
me to references for optimizing filesort? I'm assuming this is going to
be changes to my.ini or the hardware.
TIA,
R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
03, 2006 1:39 PM
To: Rick James
Cc: Robert DiFalco; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: Innodb Locks
There is a detailed write-up on how locking works in the manual:
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html
If you are not doing replication, you might
Schwartz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 1:39 PM
To: Rick James
Cc: Robert DiFalco; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Re: Innodb Locks
There is a detailed write-up on how locking works in the manual:
http://dev.mysql.com/doc/refman/5.0/en/innodb
Yup, innodb_locks_unsafe_for_binlog=1 fixes the problem and so does your
suggestion of using a JOIN instead of a subselect.
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 8:54 AM
To: Baron Schwartz; Rick James
Cc: mysql@lists.mysql.com
Then I guess I am not understanding why re-writing the statement as a
JOIN alleviates that need.
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:35 AM
To: Robert DiFalco
Cc: Rick James; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject
Right, as I understand it the query optimizer in 5.2 will simply rewrite
these sub selects as joins when possible.
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 11:45 AM
To: Robert DiFalco; 'Baron Schwartz'
Cc: 'Rick James'; mysql
Anyone here know enough about how the optimizer works to explain why it is use
the less optimal index in this case?
-Original Message-
From: Christian Hammers [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 2:54 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re
Any thoughts on this? Should SomeTable be locked when performing the
UPDATE on AnotherTable?
---
Is there a detailed source for when innodb creates row or table locks?
I have a situation where one thread is performing this in one
transaction:
UPDATE SomeTable SET WHERE
To: mysql@lists.mysql.com
Subject: Re: Innodb Locks
On 10/2/06, Robert DiFalco wrote:
Is there a detailed source for when innodb creates row or table locks?
The sourcecode.
I have a situation where one thread is performing this in one
transaction:
UPDATE SomeTable SET WHERE
Here's an odd one.
I have a table called Elements and another table called ElementNames.
The ElementNames table has a unique ID and a VARCHAR display name. The
Elements table has a ElementName.ID, a node ID, a rule ID and some other
stuff.
I have an index on the NameID, NodeID, and RuleID. I
that I do not have to reset the table_cache every time
the service is restarted?
Thank you all for your feedback!
Robert Coggins
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Scratch that, the only way to have the optimizer choose the correct
index is to remove all compound indices that start with NodeID or move
NodeID so that it is not the first column specified in the compound
index. Ugh. Any ideas?
-Original Message-
From: Robert DiFalco [mailto:[EMAIL
Thanks, I had seen that but I don't have a lot of flexibility for adding
database specific extensions on a query by query basis.
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 03, 2006 2:30 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject
in the mean time I am going to search for additional
ini files that may contain the offending variable value.
Thanks!
Robert Coggins
Dan Buettner wrote:
Robert, I recall a similar issue on Windows a couple of months ago.
The problem there was the presence of multiple ini files scattered
about
Well, I scoured the HDDs and I was unable to find additional my.ini
files. Any other thoughts!
Thanks again for your help!
Robert Coggins wrote:
Dan,
Thanks for the reply...
I wondered if this might be the case myself. However, I made a change
the the variable query_cache_size
Well, I scoured the HDDs and I was unable to find additional my.ini
files. Any other thoughts!
Thanks again for your help!
Robert Coggins wrote:
Dan,
Thanks for the reply...
I wondered if this might be the case myself. However, I made a change
the the variable query_cache_size
Is there a detailed source for when innodb creates row or table locks?
I have a situation where one thread is performing this in one
transaction:
UPDATE SomeTable SET WHERE SomeTable.id = N;
This is invoked after another thread has kicked off this long running
query in another
For us the querying of trees is more important than the speed of writing them.
So each time we add a child or change a parent or whatever, we trigger a stored
procedure that updates a paths table. Then our query for children is pretty
simple:
SELECT Node.*
FROM Node
JOIN
I have two tables that are related:
Parent
LONG id
LONG childCount
LONG maxChildAge
...
Child
LONG parentId
LONG age
...
There can be thousands of parents and millions of children, that is why
I have denormalized childCount and maxChildAge. The values are too
expensive to
: Tuesday, September 26, 2006 7:15 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Updating two fields from an aggregate query
Robert, you might give insert ... select ... on duplicate key update a
try:
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
something like
Something else you may or may not want to consider. You may want to have
both users and user-groups be principles. Something like the following:
Principle (ID, NAME, PERMS)
User (P_ID, PASSWORD, ... )
UserGroup (P_ID, ... )
PrincipleLink (PID, CID) - Many to Many (parent, child)
Also
Does using LIMIT 1 with UPDATE provide a performance improvement when
the WHERE condition is on a unique index or primary key?
R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 29, 2006 9:06 AM
To: mysql@lists.mysql.com
Subject: Performance: LIMIT 1 with UPDATE
Does using LIMIT 1 with UPDATE provide a performance improvement when
the WHERE condition is on a unique index or primary key?
R.
--
MySQL
]
Sent: Tuesday, August 29, 2006 11:51 AM
To: Robert DiFalco; mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: Performance: LIMIT 1 with UPDATE
Maybe it is the tiny extra time to parse the unnecessary LIMIT 1?
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent
What connection pool code are you using? My guess is that the problem is
in your code somewhere. Either transactions are not being closed (i.e.
because of a connection pool flaw maybe?) or you have two threads trying
to update the same row at the same time (in which case this would be
expected
No takers?
-Original Message-
From: Robert DiFalco
Sent: Thursday, August 17, 2006 3:03 PM
To: Robert DiFalco; mysql@lists.mysql.com
Subject: RE: More query help for user-defined values
One simple solution is to denormalize a little and take the refTypeID
column out of StringValue
'
)
AND
EXISTS
(
SELECT null
FROM StringType ST
WHERE ST.ID = 1 AND ST.defaultVal LIKE 'bar'
)
)
)
-Original Message-
From: Robert DiFalco
Sent: Friday, August 18, 2006 12:37 PM
To: Robert DiFalco; 'mysql
To support user defined properties I have the following tables:
TABLE StringType
LONG ID PKEY
VARCHAR name
...
VARCHAR defaultValue
TABLE StringValue
LONG parentID
LONG typeID
VARCHAR val
Assume the correct indices are in place. Different string value types
.defaultVal LIKE 'foo' ) )
AND
( SV2.f_val LIKE 'bar' OR
( SV2.val IS NULL AND ST2.defaultVal LIKE 'bar' ) )
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 17, 2006 8:43 AM
To: mysql@lists.mysql.com
Subject: More query
Why would you want to do this? As data moves around within the table the
updates will be in error. Wouldn't it be easier to assign a unique key to each
row, search for the key or unique set of information and update the resulting
row?
Bob
-Original Message-
From: [EMAIL PROTECTED]
generally simplify this?
R.
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Friday, August 04, 2006 4:12 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: Query Help for Loosely Couple Properties
I think this only works if I know that Orange
, 2006 9:37 AM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from
table T whose COLOR property value is ORANGE.
The only
They are user defined properties.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 8:11 PM
To: Robert DiFalco
Cc: mysql@lists.mysql.com
Subject: Re: Query Help for Loosely Couple Properties
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco
I have a table that contains properties that can be associated with any
table whose primary key is a LONG. Lets say that there is just one kind
of property. The table looks something like this:
TABLE StringVal
REF_ID BIGINT// row to associate property with
TYPE_ID BIGINT
Considering there are a number of pieces that are involved in the connection
being ready why not create a small program that tries to connect and checks the
return value. If it fails sleep for 500ms to 1 sec and try again for up to
X-times before aborting altogether?
Bob
-Original
If you will excuse my ignorance. I have no immediate need for this, but have
often asked what the pros/cons there are writing a WEB based interface in PHP
vs. say Perl. Do you have any insight into that?
Thanks
Bob
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Thursday,
FWIW, IMO LOB handling is really where MySQL lags behind all other
enterprise database solutions. Firebird, DB2, Oracle, et al all are able
to stream LOB data to and from disk so that it does not all need to be
loaded in memory (multiple times for a single LOB). I would call this a
bug but others
Bad design that violates basic DB design checks. Redundant information will
become a major problem for you going forward. Unless you have hard and fast
performance issues they require it, just don't do it:-)
Create a single table that contains customer info and reference the information
using
Why not store them in separate columns? You could then have the domain
field be a foreign key into another table.
-Original Message-
From: Ferindo Middleton [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 2:14 PM
To: mysql@lists.mysql.com
Subject: how to extract common text string
No problem, just didn't want to jump the gun if it was a known issue or
if it were clear from the posted traces that I was doing something
wrong.
-Original Message-
From: Stewart Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 10:54 PM
To: Robert DiFalco
Cc: [EMAIL
Version 5.0.19.
We have no autogenerate keys. We perform a single insert and get a lock
timeout. The insert is done with a stored procedure with a single line.
The lockup happens VERY rarely and we have no idea how to reproduce it.
Here's the hostname.err data:
Alarm status:
Active
1 - 100 of 649 matches
Mail list logo
