al details abound in the manual:
http://dev.mysql.com/doc/refman/5.6/en/backup-types.html
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For lis
Hi Neil,
On 10/30/2013 9:55 AM, Neil Tompkins wrote:
Shawn
What I need is that if I pass say 10 parameters/variables to a query, I
only want to update the column/field if the value passed is NOT NULL.
On Wed, Oct 30, 2013 at 3:41 AM, Shawn Green wrote:
Hi,
On 10/29/2013 9:52 PM, h
Hi,
On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
2013/10/29 11:35 -0400, Shawn Green >>>>
My favorite technique is the COALESCE function for this on a column-by-column
basis
SET FieldName1 = Now(), FieldName2 = COALESCE(:MyVariable, FieldName2)
<<<<<<<<
b
that "might" need to be updated if the variable
passed for each field is NOT NULL.
Therefore, I felt this needs to be done at database level in the stored
procedure. How can I accomplish this.
Thanks
Neil
On Mon, Oct 28, 2013 at 6:17 PM, Shawn Green mailto:shawn.l.gr...@oracle.com>&
D @MyVariable IS NOT NULL
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ducts on AIX improve, we may reassess this
decision in the future.
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://
different purposes. Some metadata (even if it is outside the database
itself) is required to establish context.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General M
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but
= 19166
) b
on b.MaxDateTime = a.date_time
WHERE recipe_id = 19166;
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.
otelRegion h ON h.HotelID = c.CityID
SET City.RegionID = h.RegionID
WHERE ...
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mys
e client
(mysql.exe) works just fine for you. What is the other tool are you
attempting to use as a MySQL client that has been giving you problems?
There are at least two connection libraries you can launch from Python
that allow you to connect to MySQL. Which one is yours?
Regards,
--
Shawn
tion server
should be on 5.5 or 5.6 by now or migrating soon. It is also a fairly
safe bet that if you are still operating a 3.23 instance of MySQL that
it is also time to upgrade your hardware.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware a
ed to
the publicity channels for any official announcements if or when they
are made.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://l
nvironment to reduce the cost of computation on
each copy (or portion) of your data. However, this is a topic best
handled in a separate thread.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
ormula on their own.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
s you are
interested in. Visually parse that row (it's contained in its own set of
() parentheses) to find the 'old' values you seek.
Sorry that it's such a manual process but you didn't want to restore so
you get to pretend to be the database server :)
Yours,
--
Shawn
you had,
it should be 'undo1' not just '1'
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_undo_tablespaces
So, that simple '1' file also seems unusual to me.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardw
tive='Y' AND MATCH(name) AGAINST('AB&C*' IN
BOOLEAN
MODE)
and I'm not getting any results. And there IS a org AB&C,
Inc.
My assumption is the ampersand sign as a part of the
keyword.
Any idea?
Read this:
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.
isk (reads), send data to the disk
(writes), and occasionally tell the operating system that it must flush
its buffers to disk to ensure durability (fsync).
Why are you so interested in these numbers?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Sof
u can always bring those
questions back to the list.
http://dev.mysql.com/doc/internals/en/client-server-protocol.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL Gene
Hello Daevid,
On 6/11/2013 7:17 PM, Daevid Vincent wrote:
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, June 11, 2013 2:16 PM
To: mysql@lists.mysql.com
Subject: Re: How do I select all rows of table that have some rows in
another table (AND
EXISTS inside a single statement but I think the
execution time would have been miserable. I also think that that
approach also would not have allowed us to evaluate a partial match
(like 5 out of 7 target genres), only complete matches would have been
returned.
I am still very interested in se
t;right" answer.
There are something like 5 different "datetime" concepts. MySQL covers 2 of
them.
DATETIME is a picture of _your_ clock.
TIMESTAMP is an instant in the _universe_.
For these, and others, think of a recurring event on a calendar, a sporting
event, an app
to TIMESTAMP columns and many other variations
like how to see if a datetime is within a 2 day span instead of one.
It's a major ball of wax to rewrite these queries in the optimizer just
to avoid one extra line of SQL code per comparison. To us "Keep It
Simple, Stupid!" (KISS) s
previously.
For example:
date_col = CAST(datetime_col AS DATE)
###
That seems pretty clear to me as not a bug.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing Li
://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html
Also, why are you using a pre-release (milestone) version of 5.6 when
the full release (GA) versions of 5.6 are available?
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracl
Windows.
You may not, or ever, choose to use Windows as a base platform but many
people do and do superbly with their choice of OS.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL
ate every query (and their
results) that derived from that table. For large caches, that can bring
the server to a cold halt until the purge complete.
Try disabling it entirely and see how that affects performance or make
it much smaller.
--
Shawn Green
MySQL Principal Technical Support Engin
he
MySQL CLI client.
Drop back to a system prompt and try again.
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
quot;which" command to clarify where that is on your system.
which mysql_tzinfo_to_sql
Then use the path it identifies when executing the utility.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountvill
a trivial
number of rows to compare against, that can reduce overall performance
because the results of your subquery would need to be scanned for each
row of the outer table in the main query it was joining to. Based on the
WHERE clause, all rows from the outer table may not be in the 'j
x27; privilege or the 'with create option' option
on their accounts. In my position I see many servers operating where
every user (including applications) are operating with root privileges.
This is as bad for databases as it is for operating systems.
Yours,
--
Shawn Green
MySQL Princi
other table.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
your MySQL isn't
being randomly killed by your OS for exhausting its RAM.
If those are both a bust, enable the General Query Log and see if any
other weird commands you don't recognize are being sent to your database.
http://dev.mysql.com/doc/refman/5.6/en/server-logs.html
--
Shawn
your queries to only use the explicit "JOIN ... ON
..." syntax for all of your joins to avoid these problems in the future.
http://dev.mysql.com/doc/refman/5.5/en/join.html
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engi
://dev.mysql.com/doc/refman/5.5/en/grant-table-structure.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
presented in the subset. If I looked for 2 terms and I ended up
with hits=2, then I know that those ID values matched on both terms.
You can expand on this pattern to also do partial (M of N search terms)
or best-fit determinations.
I hope this was the kind of help you were looking for.
Reg
more details:
http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html
http://dev.mysql.com/doc/refman/5.5/en/examples.html
http://dev.mysql.com/doc/refman/5.5/en/select.html
http://dev.mysql.com/doc/refman/5.5/en/join.html
And, as always, you can ask the list.
Best wishes,
--
Shawn Green
MySQL Princip
ess joins more like the specifications in the SQL standards, we
demoted the precedence of the comma operator with 5.0.12. These changes
also affected the behavior of the USING and NATURAL JOIN operators.
http://dev.mysql.com/doc/refman/5.5/en/join.html
Regards,
--
Shawn Green
MySQL Principal Tech
When you have MySQL do the
purging, the .index file will be automatically updated.
For more details about the binary log, please read:
http://dev.mysql.com/doc/refman/5.5/en/binary-log.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software,
T
...
, MAX(IF(iconstandardrel.icon = 3,1,0)) AS 'god_vaerdi.eps'
...
GROUP BY main.code;
That will combine (aggregate) your rows together.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountvill
ysql.com/doc/refman/5.1/en/mysqldump.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
e on
http://dev.mysql.com/downloads/cluster/
You need to upgrade to receive this fix. Let us know if that works.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing Lis
for the
current connection. Only actions taken by the current connection can
change this value.
http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software
position can be skipped if you are not trying to do a hot (or warm)
backup.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysq
ries, not those constructed by a third party. If the problem exists
in our packages, do tell us about it. If the problem is not reproducible
using official MySQL products, then please report it to the appropriate
channel for the product you are using.
MySQL Bugs -
http://bugs.mysql.com/
Thanks!
5.6
http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html
In particular, the password complexity threshold can be configured using
the new Password Validation plugin:
http://dev.mysql.com/doc/refman/5.6/en/validate-password-plugin.html
Yours,
--
Shawn Green
MySQL Principal Technical Suppor
es from a server with the same --server-id setting unless you
specifically set --replicate-same-server-id=1 .
Regards
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mail
tiple-servers.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
l.com/doc/refman/4.1/en/charset-conversion.html
The example uses BLOB but BINARY will also work.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For
excellent starting point for you to use to build the menu tree. From
there, it should be easy to extend this to link your leaf nodes to any
information records you may want.
Let us know if we can give any additional insights or suggestions.
--
Shawn Green
MySQL Principal Technical Support Engineer
the
rows that match your condition.
When you execute the query manually, you are getting the benefits of
peformance as you would have for ALGORITHM=MERGE in the VIEW. However
since you are not getting those benefits, it looks like you are in an
ALGORITHM=TEMPTABLE situation.
http://dev.mysql.co
TER JOIN,
LEFT JOIN or RIGHT JOIN operations will produce
If the executed JOIN Statement does not produce expected results STOP and
correct the JOIN clause BEFORE incorporating more functionality
Obfuscation and confusion can hopelessly sidetrack any intelligent analysis
Well put!
--
Shawn Green
MyS
ex will fail to locate any rows that contain that value.
My preference is to use the two-table approach as I can index both the
descriptive data (on the parent table) and all of the values that appear
in the list (on the child table) to make retrieval both accurate and
very fast.
Regards,
hat is smaller
than --binlog-cache-size limit
b) have a mixed-mode transaction.
If this is a valid concern for your usage pattern set
--binlog-cache-size to a smaller value.
http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_binlog_cache_size
--
Shawn Green
MySQL
, we created a separate cache specifically for the
non-transacted events to reduce our replication overhead. Only those
statements will be transmitted in the event of a ROLLBACK.
http://dev.mysql.com/doc/refman/5.5/en/server-status-variables.html#statvar_Binlog_cache_disk_use
Regards,
--
Shawn
ld like to
be shared in a general forum like this list.
Also, there is a more technical discussion on the internal mechanics of
MySQL already in place. The proper place to ask for more details would
be the Internals mailing list.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracl
ter from Slave to Master so that the Master can
wait for at least one Slave to have written to its relay log.
* Percona Cluster, Galera, etc., add more complexity to the replication traffic.
...
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Soft
-win.
Go simple, not bigger. Divide and conquer is what I believe is your best
approach.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list arch
level of hardware
redundancy. Sometimes they require multiple layers in multiple locations.
Several of those features of MySQL also help with meeting some
high-availability goals.
Are you willing to discuss your specific desired availability thresholds
in public?
--
Shawn Green
MySQL Princip
to see that bug. In order to see that bug,
you need to log into My Oracle Support (MOS) and do a KM search on the
number 14248833. However, that system has many more restrictions on it
than bugs.mysql.com does. I am not at all sure you will have access to
the details you seek.
Regards,
--
Sh
also add more columns to this table or create other summary
tables using combinations of time or price or any other dimensions you
want to use to slice and dice your data. This is the core principal to
designing a data warehouse for online analytical processing (OLAP).
Yours,
--
Shawn Green
MySQ
al information about how indexes are used and abused during
queries is located in the Optimization chapter in the manual:
http://dev.mysql.com/doc/refman/5.1/en/optimization.html
I suggest you start here and work your way out:
http://dev.mysql.com/doc/refman/5.1/en/optimization-indexes.html
Best wishes,
On 7/1/2012 12:11 AM, Hank wrote:
Check the manual:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-25.html
Shawn Green
Thank you, but that warning note was not there when I first posted
this message in here. I'm not sure when the warning note appeared,
but I'd guess it was within t
og or update site that might explain why they retracted 5.5.25?
thanks,
-Hank
Check the manual:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-25.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blount
(duration) as totalhours from tmpHours group by
employeeid;
If you want to breakdown your final report by other values (by date, by
week, by shift, etc) then you need to compute those and add them to the
tmpHours table when you create it.
Regards,
--
Shawn Green
MySQL Principal Technical Support
://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_myisam_sort_buffer_size
You will need to experiment with how large the maximum value will be
permitted for your platform.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Togethe
resources
http://www.oracle.com/us/support/contact-068555.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
e. However, the esset (sharp S) is
just one example of the alternative spelling letters that were affected
by the collation change. Thorn, the AE ligand, and many others fall into
that same category.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Ha
On 6/15/2012 1:00 PM, Rick James wrote:
You are very close to a standalone test case. Please create such. Then post
it on bugs.mysql.com .
-Original Message-
From: GF [mailto:gan...@gmail.com]
Sent: Friday, June 15, 2012 12:45 AM
To: Rick James
Cc: Shawn Green; mysql@lists.mysql.com
hould be able to cleanse the incoming data (remove
duplicates, adjust any weird fields) and merge it with your existing
data to maintain the relational and logical integrity of your tables.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software,
.1.x releases.
Yes, collations are used for equality and inequality comparisons, too,
not just sorting. That's why having alternate spellings ,like the words
"strasse" and "straβe", will collide within a PK in 5.1 where they will
not for 5.0 or 5.5 (with the appropriate c
depends on many factors that we cannot determine
for you.
Warmest wishes,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mys
uld really understand basic,
top-down master-slave replication before attempting to create a
replication ring.
Active-Active (dual master) configuration is even more complicated and
is suited only for specific application purposes. This is definitely an
advanced technique and requires careful pl
Key relationships, update your key values (the USER_ID fields), then
re-create your Foreign Key relationships.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing
nd what types of failures you are encountering
(including any error messages you are receiving). This usually allows
anyone trying to help you to respond in a more focused and less general
way.
Warmest regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware
ents any two threads from cross-locking at the same time.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
//dev.mysql.com/doc/refman/5.1/en/mysqld-multi.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
in 5.6. Please check out our newer
versions to see if we have solved or improved any particular scalability
problems you may be having.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Log. To enable this, use the --log-slow-slave-statements option.
http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL Gener
.
There is nothing visibly wrong with your replication configuration at
this point. The problem most likely revolves around your table definitions.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Bloun
000=25000 (250 million) full-row comparisons in order
to process this DELETE event.
The lesson here: Always assign a PRIMARY KEY to your tables if you are
going to use MIXED or ROW values for --binlog-format
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Ha
not at all surprised that the population of people
on this list who has either written code for or used MySQL Proxy in
production situations may be very small or none.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to W
nding events in the relay logs of the
lost node that have not yet been relayed to the downstream node.
I may not have every answer, but I have seen nearly every kind of
failure. Everyone else is encouraged to add their views to the discussion.
--
Shawn Green
MySQL Principal Technical Suppor
take up
less space and will be more functional that multiple single-column indexes.
e) Test, test, and retest - Until you can push your system to the
choking point in the lab, you will have no idea of how much traffic it
will be able to handle in the field.
Good luck!
--
Shawn Green
MySQL
overed in the changelog to version 5.5.3 and the
specific bug reports linked from within it.
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-3.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office:
eping @localhost separate from @, we allow you
(the DBA) to deny privileged access to any other user that cannot login
directly from the host machine.
Hopefully, this clarifies why your localhost account was unable to login.
Additional reading:
http://dev.mysql.com/doc/refman/5.5/en/connect
efficiency
of how we evaluated the original query which is why your row numbering
system no longer works as you expected it to.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountvi
ld it be best to just dump/drop/re-import the tables/databases ?
Many Thanks,
- bobb
The simple solution is to rename your tables to
a) use shorter names
and b) not use any illegal characters
Are those odd characters and long names really a requirement to your
design or are they there just f
credentials.
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_user
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http
tion instructions for Macs and other non-Windows systems in the
manual?
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-installation.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
t (always assume someone else may
steal the room, for example) and those may need to be resolved through a
different process.
* Keep the business logic in your application, leave the data integrity
rules to the database.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle US
so that each of your child rows can be assigned their proper parent id
values.
http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
te their installation, there is the script.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
must trust you, the DBA, to do that properly.
http://dev.mysql.com/doc/refman/5.5/en/replication-sbr-rbr.html
http://dev.mysql.com/doc/refman/5.5/en/replication-rbr-safe-unsafe.html
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineer
ourage you to engage with Cluster sales or
any reputable consultant to get an evaluation and their recommendation,
too. (disclaimer: I am not a cluster guru). I also encourage you to seek
multiple recommendations. Many different solutions to the same problems
you describe have been created by
be an option they can use.
So the default remains at 0 until the support for it becomes much more
common among Linux user accounts.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
transaction isolation in InnoDB, the less isolation you
require, the more likely you are to generate a shared lock vs an
exclusive lock.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, T
WHERE db1.field1 IS NULL;
How many rows do you get back from that?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
ot;last
update on 18 Feb 2011" 1 -00-00 00:00:00 0 0 0 0
Please let me know the efficient & easiest way to remove it.
Thanks
The manual is your friend, please don't be afraid to use it. I believe
the function you are looking for is REPLACE().
http://dev.mysql.com/doc/ref
1 - 100 of 323 matches
Mail list logo