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
wrote:
>
> Is this a bug? If it's a "feature", what could we do instead to get
>> around
>> this issue?
>>
>
> Is your column set
002,|
17 |15 |
++-+---+
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
both.
Regards,
- Robert
On Thu, Feb 14, 2013 at 6:13 PM, Rick James 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 Gener
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 wrote:
> Are you using all InnoDB?
>
> S
--
MySQ
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui wrote:
> 2013/2/13 Robert Citek
>>
>> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>> wrote:
>> > Any other possibilities? Do other scenarios become likely if there
>> > are two or more tables?
>&g
es.
Regards,
- Robert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek 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 not
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 adres
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: R
I am having the hardest time getting a select as statement right. Here is the
full query:
select
SUM(IF(image='EE0840D00E2ED8A317E5FA9899C48C19',1,0)) as
EE0840D00E2ED8A317E5FA9899C48C19,
SUM(IF(image='235C7987796D5B7CEBF56FBDA2BF7815',1,0)) as
235C7987796D5B7CEBF56FBDA2BF7815,
SUM(IF(image='9
On Thu, Dec 9, 2010 at 9:10 AM, Shawn Green (MySQL)
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
/doc/refman/5.0/en/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
ose entries are no
longer 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
--
======
i just want to verify
that, if that's all i have access 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 Wate
Say I have the following data:
+---+
| title
|
+---+
| ...And justice fo
e Oracle 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 Electrica
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 enum('
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 wrote:
> I am no doubt very new to MySQL and have been studying the on line
> manual however I find it
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
O
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
x27;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:htt
Olaf Stein 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 General Mailing List
For list archi
line 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 Maili
hanks 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
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]
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
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]
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.
tha
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
--
M
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 te
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/
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
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 crea
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 l
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
2): Table '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 man
_stamp),
> KEY day_of_week (day_of_week),
> KEY day_in_month (day_in_month),
> KEY day_in_month_R (day_in_month_R),
> KEY month_day (month_day),
> KEY month_day_R (month_day_R),
> KEY month (month),
> KEY year_day (year_day),
> KEY year_day_R (year_day_R),
> KEY week_number (week
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 fro
[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
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 transa
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 s
ing 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 Updat
REIGN KEY (buddyDBID) REFERENCES tblUser (userDBID) ON DELETE
> CASCADE;
>> When I execute the following statement:
>> INSERT INTO tblBuddies (userDBID,buddyDBID) VALUES ('test user', 'test
> user 2');
>
> You are inserting string values, not I
GN
KEY (`userDBID`) REFERENCES `tblUser`
(`userDBID`))
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]
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-
From
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
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 joins
some 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-corre
th 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: Subse
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 doesn't
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.c
uot;. I have seen 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
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 Link.parentID
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'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
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:http://
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 for
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: http://lists.m
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: 'Ric
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
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
Baron 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/i
y, 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-transaction-model.html
If you are not doing replication,
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
S
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 variabl
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 variabl
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
&
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
Su
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 Di
ct this so 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]
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 have
: 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
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 SomeTab
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 tran
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 Paths
: 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
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 t
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 consid
]
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:
-
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
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]
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 beha
P.ID = L.parentID AND SV.f_val LIKE 'bar'
)
AND
EXISTS
(
SELECT null
FROM StringType ST
WHERE ST.ID = 1 AND ST.defaultVal LIKE 'bar'
)
)
)
-Original Message-
From: Robert DiFalco
Sent:
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
LL AND ST1.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: m
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
ca
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] [mai
27; OR (NST.VAL = 'Fred' AND NSV.REF_ID IS NULL)
)
How do I 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 Coupl
e-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 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 w
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 Message-
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, J
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 w
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 F
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 f
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: [
1 - 100 of 679 matches
Mail list logo
