27;.
> Perhaps the client should indicate the socket or ip/port that was
> actually used in the welcome message.
>
> Thanks.
>
> Regards,
> Rich
>
I couldn't find it with a quick trip through the docs but I seem to
remember th
Todd,
Users are identified by more than just their login name. Users are a
combination of login AND a "host" specifier. When you do
SELECT * from user where user = 'user1';
a) how many entries are there
b) what is in the host column for those entries.
For example if the
e area is NULL or area='';
b.5) Are you trying to ADD a column or manage an existing one. Your
post was not very clear
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has t
he results to
SHOW GRANTS FOR 'root';
and you should see why your remote logins aren't able to do anything
you wanted them to do.
http://dev.mysql.com/doc/refman/5.0/en/show-grants.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
__
() aggregate function. That way you count only how many different
values exist in the list, not how many items are in the list.
Count | IP Address| First Seen| Last Seen | Days
SELECT
COUNT(src_ip) AS CNT
, INET_NTOA(src_ip)
, MIN(timestamp) first
, MAX(timestamp) last
,
; >
> > Martijn Tonies
> > Database Workbench - development tool for MySQL, and more!
> > Upscene Productions
> > http://www.upscene.com
> > My thoughts:
> > http://blog.upscene.com/martijn/
> > Database development questions? Check the forum!
> > http
numeric AND text a the same time. Practically, if you
quote your numbers, the autoconversion should kick in and you should be
comparing numbers to numbers again.
Please read for more details:
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
http://dev.mysql.com/doc/refman/5.0/en/number-synt
of a partnumber then it needs to show up in the
> list more than once.
>
> - Thanks again
>
> >>> Shawn Green <[EMAIL PROTECTED]> 4/12/06 12:15:56 PM >>>
>
>
> --- Ed Reed < [EMAIL PROTECTED] > wrote:
>
> > Thanks for the response
ry you are trying to write.
Please describe in words what you are looking for and I (or someone
else on the list) will be able to respond with an appropriate query.
Shawn Green
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protectio
STINCT conf_id
FROM conf_ip
WHERE ip = 'some_ip_value';
SELECT c.id, c.conf
FROM confs c
LEFT JOIN tmpMatches m
ON m.conf_id = c.id
WHERE m.conf_id IS NULL;
DROP TEMPORARY TABLE tmpMatches;
What we do is generate a list of all of the conf's that do have the
target IP and s
. The only way to get
to the groupwize maximum (in this case the record with the latest date
from a group of records sharing the same ID) is by using one of the
techniques listed here (temp table, subquery, concat hack):
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
.com/doc/refman/4.1/en/example-maximum-column-group-row.html
>
I am so glad the fine manual was useful for you. I think that everyone
should review the techniques discussed not just in the article you
quoted but also in the articles around it.
Shawn Green
Database Administrator
__
le) that can be sent in
response to a web browser's request for information (which can be
initiated by the user clicking on a link). And you wanted to know how
to format that link so that it becomes clickable.
Am I close?
Shawn Green
Database Administrator
--- Scott Purcell <[EMAIL PROTECTED]> wrote:
> I occasionally run into issues where I would like to ensure that the
> values across two or three columns are not duplicated. At work we use
> Oracle, and I see that they add constraints when creating the
> columns. I
> am running mysql 5.0 and was
sorry :( I clicked "send" too early
--- Shawn Green <[EMAIL PROTECTED]> wrote:
>
>
> --- Scott Purcell <[EMAIL PROTECTED]> wrote:
>
> > I occasionally run into issues where I would like to ensure that
> the
> > values across two or t
ser only needs one record to exist in your system. Each
relationship between each pair of users takes either one (asymmetrical
friendship) or two (symmetrical friendship) relationship records. If
all of the fields in this relationship table are numeric, then every
row of data will be the exact same
myriad of problems that your setup
can create. Your data will always be up-to-date and you won't have to
worry about file caching, table caching, index caching, file locking,
read/write contentions or any of those other problems.
Please try shifting your table definitions on Server1 from direct
TABLE command to re-organize your existing
table to eliminate the current deletion gaps.
Those are the two ideas off the top of my head.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
__
Do You Yahoo!?
Tired of spam? Yahoo
interesting, but outside the scope of this list and not
> immediately relevant to the system I'm working on.
>
>
> Douglas Sims
> [EMAIL PROTECTED]
>
>
I have also heard of this style of design called "chonological
database". Doing this Google returned s
>
>
> Anyone?
>
>
>
> Thanks,
>
> Scott
>
>
>
>
It's there: http://dev.mysql.com/doc/refman/4.1/en/describe.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
__
Do Y
be a crash, it might also be the server
> having
> shut down in an orderly fashion while the client is still connected.
>
> HTH,
> Joerg
>
> --
> Joerg Bruehe, Senior Production Engineer
> MySQL AB, www.mysql.com
>
>
IIRC, this message can also occur whenever
iendships). The relationship with Echo is asymmetrical.
A query to pick out only those relationships that are symmetrical would
look like:
SELECT p1.name, p2.name
FROM person p1
INNER JOIN friends f1
on f1.from_person_id = p1.id
INNER JOIN friends f2
on f2.to_p
ter whether "expression" is
> > complicated, it needs to be
> > computed only once, but "column_value" should just
> > be the column name
> > and not a function / expression using it.
> >
> > So what you need is
> > select count(*) from EVENT_
nversions all belong on one side of the comparison. Your fields
should not be part of a conversion or function if you ever hope to use
an index during the lookup phase.
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
Shawn Green
Database Administrator
Unimin Corporation -
an error in your SQL syntax; check the manual that
> corresponds to
> your MySQL server version for the right syntax to use near 'END' at
> line 1
> (0 ms taken)
>
> Error Code : 1064
> You have an error in your SQL syntax; check the manual that
> corresponds to
>
ment as from other thread.) No ; after the END or END IF
statements
http://dev.mysql.com/doc/refman/5.0/en/begin-end.html
http://dev.mysql.com/doc/refman/5.0/en/flow-control-constructs.html
> delimiter ;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual
>
rmal request. There are
probably better ways to solve your issue than by creating "fake" or
"virtual" data.
As was posted before, what is the real reason you want to auto-generate
separate rows of data? If we understood your REAL problem (not your
request, we understand that) we
stored separated?
>
If the data in the reports is truly static, then you GAIN performance
by only making your server compute it once. Storing the results of
statistical analysis is a commonly used practice when it comes to data
warehousing and OLAP system design. In your case, it especially ma
eference as expressed at a
> specific point in time?
>
> Thanks as ever for any suggestions.
>
> Russell.
>
Yet another variety of the FAQ -
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
In this case, what you are trying to
, multi-column update:
UPDATE old_table o
INNER JOIN bulk_changes b
ON o.pkid = b.pkid
SET o.Col_1 = b.Col_1, o.Col_2 = b.Col_2, o.Col_3 = b.Col_3,
o.updatetime = CURDATE();
Details are here:
http://dev.mysql.com/doc/refman/4.1/en/update.html
I hope that helps,
Shawn Green
Da
w, assuming that there are several records within the same second
(very possible depending on your traffic) and that you want to limit
the database to exactly 10 rows (see previous query), then this
should work for you:
DELETE FROM yourtablename
WHERE datecolumn < @lastDate
or (datecolum
ciplines_users AS du
ON d.id = du.discipline_id
GROUP BY d.id, d.name
The reason I inverted the FROM and LEFT JOIN was so that if you had a
discipline with 0 users, you can now see a zero. In your original
orientation, a relationship had to exist or its discipline wouldn't have
been coun
is
is the general shape of the command you will want to use.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ment even
though the condition is true.
please tell me why.
thank you
How do you know your condition is true?
Could this be part of a transaction that is rolled-back instead of
committed?
There are too many unknowns about your situation to make a clear
judgement on this particular problem.
-
d you try an OR conditional in your WHERE clause similar to
OR ranking = 2
?
Actually, you probably want a more complex WHERE clause similar to:
WHERE ( and ) or ( expressions as appropriate.
Yours,
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville,
o get leave out of the WHERE clause any
non-null comparisons for values. Anytime you avoid a dependent subquery
your query should also be much faster.
You can also use an INNER JOIN for all of these as you don't need to
update any non-matching rows in `A` with 2*NULL.
--
Shawn Green,
an/5.0/en/join.html
scan down about midway and look for
Join Processing Changes in MySQL 5.0.12
Beginning with MySQL 5.0.12, natural joins and joins with USING,
including outer join variants, are processed according to the SQL:2003
standard.
~~~~
Yours,
--
Shawn Green, MySQL Se
t is using to connect to
the MySQL server. That will release the connection and allow the server
to reallocate those resources to handling the commands for the live (and
not idle) connections.
For additional reasons for these errors, please peruse:
http://dev.mysql.com/doc/refman/5.0/en/communic
of duplicate key problems.
Double check your replication coordinates.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ng out as the 5.4 matures.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
problems (MS SQL, ASP, MySQL stored
procedures, etc)
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
-13'
It will not work because the WHERE clause will filter from the results
any rows from A where b.datecol is not > '2009-06-13' which would
include those rows from A that had no matching row from B (effectively
turning the LEFT join into an INNER join). Try it both
index on (blocksize,physmessage_id) would allow that
query to avoid any direct reads of the data table as all of the
information for the query would have come from the index itself
(regardless of database engine).
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountv
engine.
http://dev.mysql.com/doc/refman/5.1/en/federated-storage-engine.html
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
essing time.
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html
The overall problem is still that the on-disk structure of the 5.0
tables has changed and that you still need to per
int.
I suggest you modify how your data is stored by implementing the
techniques of normalization. I think it will help get you started.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://list
enough to allow your current
transactions to complete.
Yours,
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
ou can collect. I think a nice place to start will be here:
http://dev.mysql.com/doc/refman/5.0/en/optimization.html
Warmest regards,
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
ation that the application (or user) expected to find a
function in that database but did not.
Do you have any details about the database `suppor_db2` itself or what
the user might have been doing at the time they got the message that you
would like to share?
--
Shawn Green, MySQL Senior Su
g the PREPARED
STATEMENT commands using the data from your other table.
http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives:
WHERE clause are applied before any
GROUPing happens.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ave tried and enough explanation that we can figure out what you are
trying to accomplish. Normally this will get you correct and accurate
responses very quickly.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For
item
for your results? When there is a duplication like this, you must be
specific as MySQL can do many things but the ability to read the minds
of its DBA's is not one of them.
Respecfully,
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
ist and is required in order
to contain the metadata and other InnoDB elements.
To see how much of your tablespace is available for new data, check the
SHOW TABLE STATUS report.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Ma
same
box as your web server or are they located in separate machines?
At that point, we may be able to make a reasonable guess about your
situation.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives:
://dev.mysql.com/doc/refman/5.1/en/federated-description.html
http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html
http://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.html
http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-engine.html
--
Shawn Green, MySQL Senior Support
to exist in that
table. That means that all of those missing rows (the non-matches) just
got tossed out of your potential results.
This general pattern
SELECT ...
FROM A
LEFT JOIN B
ON A.id = B.id
AND B.column = value
WHERE B.(any normally non-null column) is NULL
is the generic way to
e
of the cases that we have an optimized and generalized execution plan to
handle well. The separate conditions, like I wrote in my example, is an
optimized situation and has a much better likelihood of using an index
during its evaluation.
I would think that an index on both columns woul
using labeling
one as "home_team" and other as "away_team".
I think that once you get a grip on how to use aliases, all of this
multiple-table stuff will start to become much easier.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountvill
s because you aren't using = but are using - . Switch your query to
"... ON t.ProdID = p.ID"
and see if that works any better.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: htt
u can query on ... FROM myparent LEFT JOIN mytable ... and if there
were no matches on the matching column then mytable would have all NULL
values for its columns. Is that something you can work with?
http://dev.mysql.com/doc/refman/5.1/en/join.html
--
Shawn Green, MySQL Senior Support Engin
table other than a direct file copy.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
f you split it into two REF tables,
one that points only to TABLE1 rows and one that points only to TABLE2
rows. That kind of separation of purpose is also known as "normalization".
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL G
(
select...
FROM athletes
INNER JOIN matches
ON ... matches.member2
) UNION (
select...
FROM athletes
INNER JOIN matches
ON ... matches.partner2
)
in order to use the indexes for the JOINS.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL G
those divs to sit side-by-side within a parent div is an
exercise left to the student.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
state
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
uery, the optimizer will still need to scan the results of each
subquery for every line of the outer query.
Try rewriting this as a joinl
SELECT eod.*
from endOfDayData eod
INNER JOIN names n
on n.symbol = eod.symbol
and n.market like 'NYMEX'
and names.name like 'natural gas {%&
SQL client
* a UUID value
* a hashed value of a combination of pseudo-random values (IP address,
time, someone's name, a random number, etc.) .
* some sequential number you track in another table.
All you really need is a number statistically improbable to repeat
between any two of you
gards,
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
? Version 5.1.37 is 29
releases *later* than 5.1.6 .
Those versions prior to 5.1.6 (the ones that would not have this
feature) would be 5.1.0, 5.1.1, 5.1.2, 5.1.3, 5.1.4, and 5.1.5 .
Sorry for the confusion.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office
ms (crashes and corruptions) if you
continue to use an index created with a different ft_min_word_len than
the server currently has.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysq
storage devices
* The use of DRBD
...
Full treatment of all of those factors is beyond the level of assistance
I am permitted to supply in these forums. However if you care to ask a
specific question or two I may be able to bend the rules a little.
--
Shawn Green, MySQL Senior Support Engineer
t platform. I encourage you to try it out and let us know what
you think.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
, Tomcat, MySQL
...
Are there other stacks on MS that you have heard of or are using?
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
function?
This is just one less way to confuse your design.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
cause the physical act of logically (internally) representing all of
those columns across all of those row permutations in memory can become
a burden to process.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For li
.1/en/server-options.html#option_mysqld_shared-memory
This works similar to a named pipe and if you want to enable both (pipes
and shares) at the same time, you need to provide different names. The
TCP/IP ports are independent and also available.
--
Shawn Green, MySQL Senior Support Engineer
Sun
-servers.html
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
x27;s one from our manual:
http://dev.mysql.com/doc/refman/5.1/en/counting-rows.html
(in your case, you are using MIN() instead of COUNT() )
The full list of GROUP BY Functions are here:
http://dev.mysql.com/doc/refman/5.1/en/group-by-functions-and-modifiers.html
--
Shawn Green, MySQL Senior Su
to me that your administrative skills may not yet be
ready for this particular challenge. May I recommend that you switch
back to the much easier to maintain master-slave replication
configuration? If not that, at least use your masters in an
active/passive mode, not active/active.
Warmest re
t you can
adjust the --long-query-time to throttle the contents of the log.
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_long_query_time
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc
om/doc/refman/5.1/en/privileges-provided.html#priv_usage
Additional explanation of how MySQL security works is located in the
following sections of Chapter 5 of the manual:
http://dev.mysql.com/doc/refman/5.1/en/security.html
http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html
http://de
nally keep the slave at least 5,10, 15, or 60 minutes behind the
master. This gives you a window of opportunity to intercept these
commands in the replication stream before they have a chance to take
effect.
This is not a script that MySQL has written so I cannot link you to any
versions of
'
ORDER BY n24 desc ***
limit 10;
DROP TEMPORARY TABLE rankme;
*** NOTE: without the ORDER BY clause, you are not guaranteed to get
your rows back in any particular order. As you want the top 10 listings
sorted by n24 for the country 'UA', you still need the ORDER BY to
I know it's bad form to reply to yourself but I spotted something I
could clarify
Shawn Green wrote:
...
One way to do this is to materialize the results of the ORDER BY into a
temporary table with an auto_increment column defined on it. Then just
do a query against the temporary table
ur descriptions, that should fix your duplication problems.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
could create a privileged routine called
change_phone_number() that could do that without giving the application
(or another user) the rights to manipulate that table directly.
Does this help?
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
-
act the actual vendor for your software to get any
possible support for this program.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
ments, yet.
http://dev.mysql.com/doc/refman/5.1/en/stored-program-restrictions.html
SQL prepared statements (PREPARE, EXECUTE, DEALLOCATE PREPARE) can be
used in stored procedures, but not stored functions or triggers.
Hope that helps!
--
Shawn Green
MySQL Principle Technical Suppor
s on which information are you looking
for and in what format you want to see it. Got any details you want to
share?
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
et, then there is no
password. Leave off the -p option and see if it allows you to set it
that way.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
nd" of problem you will create for
yourself, these are all things that have created problems for others in
the past.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysq
, you could have shutdown your MySQL
instance, too.
If not, then the in-memory and on-disk images of your tables are out of
sync. You may be copying away data that will appear corrupted after
restoration.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountvi
ts
output is already 5.1 compatible.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ata values should appear, not
for SQL keywords, identifiers, and so forth.
###
see also:
http://dev.mysql.com/doc/refman/5.1/en/execute.html
2) resolve your variables as you build your SQL string so that they no
longer refer to a variable but become literal values within the query
you are const
it OS.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s
in the SHOW INNODB STATUS report.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Victor Subervi wrote:
On Tue, May 18, 2010 at 1:09 PM, Shawn Green <mailto:shawn.l.gr...@oracle.com>> wrote:
Johan De Meersman wrote:
For additional details about failed FK attempts, check the error
details in the SHOW INNODB STATUS report.
I get this:
100518 10:26
Victor Subervi wrote:
On Tue, May 18, 2010 at 2:23 PM, Shawn Green wrote:
Shawn Green wrote:
I may be confused but how can the ID of the Passengers table be both the ID
of the Flight they are taking and their Customer ID at the same time?
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign
Victor Subervi wrote:
On Wed, May 19, 2010 at 10:59 AM, Shawn Green wrote:
Shawn Green wrote:
AH! that's your mistake. You think that creating the FK will also create
the column. That does not happen. You have to define the table completely
before you can associate the columns on this
1 - 100 of 323 matches
Mail list logo
