to be the same between releases of the MySQL Server.
Is there any other solution to emulate row counter, which works with the
above query under 5.1 and 5.5 mysql version?
You need to materialize your sorted results before applying your row
counter. You can use an automatic temp table or a manual
with a really long name
- and some invalid char.frm' (errno: 2)
Any ideas or suggestions ?
I'd prefer to keep with the ubuntu version of mysql if possible. Would also
like to minimize the size of the downtime window.
Would it be best to just dump/drop/re-import the tables/databases ?
Many Thanks
MSSQL. Possible? How?
Heeh. If you're talking about an SQL dump into a textfile, that should be
doable - you might have to mess with some datatypes or so, but not
impossible.
If this is a binary dump, you're going to have to import it into an MS SQL
server, and proceed from there. MySQL connector
On 2/4/2012 19:57, Larry Martell wrote:
Just installed mysql on centos 6.2. When I try to start it with service I get:
#service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Nothing at all is written to the error log.
But if I
Higgenbothom to teach both
Calculus 212 and Probability 278 at 10:00 AM on Monday, Wednesday, and
Friday.
The problem isn't actually writing mysql to select the conflicts. The
problem is when and how to run the code. I could put it in a trigger but
say someone assigns Dr. Higgy to teach Calc 212 at 10 AM MWF
(or something similar based on some unique
combination of identifiers in your original data instead of just 'name'
) 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
Hello Ryan,
On 12/18/2011 15:36, Ryan Dewhurst wrote:
Hi,
Does anyone know why what's done in 'mysql_secure_installation' [0]
isnot part of the default mysql installation?
[0] http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html
Thank you,Ryan Dewhurst
P.S. I also asked
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, Engineered to Work
than me.
(This will also give me a learning opportunity to see what to do)
_*Client Question: *_
Well let me describe the issue.
1.I require to load records into a MySQL database table - no problem so
far ;-)
2.The table represents stock that will be being searched and
transacted (i.e. sold
.
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
--
MySQL General Mailing
On 11/17/2011 01:41, 王科选 wrote:
hi,
From this url:
http://dev.mysql.com/doc/refman/5.5/en/innodb-deadlocks.html , mysql
says If you are using locking reads (|SELECT ... FOR UPDATE|
http://dev.mysql.com/doc/refman/5.5/en/select.htmlor|SELECT ... LOCK
IN SHARE MODE|), try using a lower isolation
Hi Mike,
On 11/8/2011 20:46, Mike Seda wrote:
All,
Can anyone out there explain the result of the third statement provided
below:
mysql select count(distinct field1) from db1.table1;
++
| count(distinct field1) |
++
| 1063
On 11/3/2011 02:29, Adarsh Sharma wrote:
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with . I want to remove them.
Below is the snapshot :
*ID /URL Country Publication / Description ...and so
On 10/19/2011 20:03, Dotan Cohen wrote:
...
Thank you Shawn. I very much appreciate your help, and I also
appreciate your employer's initiative to have such a position
monitoring the mailing list. Is that an Oracle-created position, or
did it exist at Sun as well?
MySQL has always encouraged
it for a table, there is trouble:
mysql select * from memberp;
ERROR 1250 (42000): Table 'nam' from one of the SELECTs cannot be used in field
list
If I leave this, GROUP_CONCAT(DISTINCT GivenName ORDER BY Rank) AS, out, there is no
trouble. If I leave out any of the other like phrases
Hello Dotan,
On 10/19/2011 09:57, Dotan Cohen wrote:
mysql select * from beers;
++---++
| ID | name | colour |
++---++
| 1 | carlsburg | 2 |
| 2 | tuburg| 1 |
| 3 | tuburg| 9 |
++---++
3 rows in set
a right outer join and a
left outer join, and how they differ from a regular outer join. But
don't answer that, I'll google it and post back for the fine archives.
What you are describing is a FULL OUTER JOIN. This is not supported,
yet, in MySQL. We only support INNER, NATURAL, LEFT, and RIGHT
On 10/19/2011 13:29, Michael Dykman wrote:
While we have him online, I think we could all take a moment and be grateful
for the contributions of Shawn Green.
When I see the Oracle-bashing on this list, I am often reminded that we
still have a hard-core MySQL developer who has survived the ride
On 10/13/2011 14:41, Grega Leskovšek wrote:
What is the usage of connect keyword? I've tried to google what is the
difference between CONNECT and USE but got no explanation. It seems
everybody use USE, but am not clear why is the CONNECT used?
mysql CONNECT test1pizza
Connection id:9
from Oracle.
I work in MySQL Support and other than the tools that we were given to
work with, very little should have changed in our attitude, our
knowledge, or our level of professionalism (that I am aware of). Perhaps
there are thinks that the other support providers are doing better
Hello Javad,
On 9/2/2011 05:51, javad bakhshi wrote:
Hi again,
Thanks for the tips. My problem is:
I have a Function in Mysql that has some arguments in the signature as
follows:
CREATE FUNCTION Myfunction( type TINYINT, sec SMALLINT, vid INTEGER,
way TINYINT, quid INTEGER, day TINYINT
this.
In order to get every event in the range of c-f, here is what you need
for a WHERE clause
WHERE start = (ending time) and end = (starting time)
Try that and let us know the results.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered
On 8/27/2011 11:18, wrote:
2011/08/26 13:58 -0700, javad bakhshi
Thanks guys for the help. but my problem seems to stand unsolved.
Right, no arrays. Nothing is left but table. I used a temporary table, but note
that MySQL also does not let table be returned, or passed in. The table-name
. Then close them.
Allowing more connections to be made at one time can only push your
system harder. Each connection requires some resources to check its
status. There must be buffers for sending and receiving data. Also, if
there are any connection-specific MySQL objects created on a connection
On 8/15/2011 09:06, wrote:
2011/08/10 08:16 +0200, Johan De Meersman
Yes, the MySQL binary log can be read (and thus, re-executed) by the
mysqlbinlog utility.
Yes, but what is the best means of picking up the changes from the instance where there were
changes to the instance that is a copy
content is also available here:
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html
It may be an easier address to reach.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
the smaller table first.
--
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
want to base your time comparison on, and
someone will show you an example.
--
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
On 7/22/2011 18:48, Tim Thorburn wrote:
On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote:
On 7/21/2011 22:45, Tim Thorburn wrote:
Hello,
For those keeping score, this will be the second time in the past few
months I've come upon this problem. To recap, this is happening on a
development laptop
On 7/21/2011 22:45, Tim Thorburn wrote:
Hello,
For those keeping score, this will be the second time in the past few
months I've come upon this problem. To recap, this is happening on a
development laptop running Win7 64-bit Ultimate and MySQL 5.5.13. This
morning, all was working well
On 7/22/2011 17:02, Shawn Green (MySQL) wrote:
... quick correction ...
* ...the account 'root' for a new installation is*
created without a password. ...
I originally said 'is not'. Sorry for the confusion
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc
mentioned, those are version-sensitive comments. In order for
a MySQL server to not ignore the comment, it must be a version equal to
or greater than the value tagged in the comment.
For example, stored procedures did not exist before version 5.0.3 . So
all of the stored procedure
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?unsub=arch...@jab.org
`),
KEY `NameFirst` (`NameFirst`),
KEY `NameLast` (`NameLast`)
This extremely simple join is still massively slow.
Jim
On Mar 10, 2011, at 10:00 AM, Shawn Green (MySQL) wrote:
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing
On 3/10/2011 12:10, mos wrote:
I want to bounce some ideas off of MySQL developers that use it for web
development. Maybe I'm a little paranoid, but when dealing with the
Internet, I want to make my web app as secure as possible. I'm hoping
some of you can offer me some ideas in this respect.
I
' for query execution. That means that MySQL became
more complaint with the SQL standard but it also means that using a
comma-join instead of an explicit ANSI join can result in a Cartesian
product more frequently.
Try my style and compare how it works. If both styles are similarly
slow, collect
/replication-options-master.html#sysvar_auto_increment_increment
--
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
Hello Hari,
You already posted the best answer we could provide :)
On 2/22/2011 13:00, hari jayaram wrote:
Hi I am getting a Foreign key error .
...
I have attached the create table syntax for both the parent and child tables
and the innodb status below. ...
mysql show innodb status
or three sample rows for each table I could understand
your distinction?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
The Customer Support Center Will Retire February 11, 2011
Find out what
of using an INDEX on the dtcolumn column by wrapping it inside a function.
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
.
--
Shawn Green
MySQL Principal 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
for the section talking about clean backups.
--
Shawn Green
MySQL Principal 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
On 1/21/2011 14:21, Kendall Gifford wrote:
Hello everyone, I've got a database on an old Fedora Core 4 server running
MySQL 4 (mysql-server.x86_64 4.1.12-2.FC4.1). The database in question has
just two (InnoDB) tables:
messages (approx 2.5 million records)
recipients (approx 6.5 million records
Hello Delan,
On 1/19/2011 21:54, Delan Azabani wrote:
Hi all,
I'm using MySQL with C in a CGI application. I hope this is the right
list to ask for help.
If I have this simplified code:
MYSQL_RES *res;
MYSQL_ROW row;
mysql_query(mysql, some select query);
res = mysql_use_result(mysql);
while
On 1/15/2011 02:07, Jørn Dahl-Stamnes wrote:
On Saturday 15 January 2011 00:28, Johnny Withers wrote:
The result of your query without the join
probably exceeded your tmp_table_size variable. When this
occurs, MySQL quit writing the temp table to disk thus producing an
incorrect table file. (I
Hi listers
I have a mysql web application. in this application it would be fine to
be able to track the database entries i have visited, because often
later on i grat my head: which entry did i see this already in?
So i would need a way to find out which entries in which table i have
visited
On 1/12/2011 10:26, mysql wrote:
Hi listers
I have a mysql web application. in this application it would be fine to
be able to track the database entries i have visited, because often
later on i grat my head: which entry did i see this already in?
So i would need a way to find out which entries
On 1/10/2011 18:51, Ryan Liu wrote:
Hi,
In MySQL, is that possible to generate a data set join with it on fly (without
create an temporary table)?
e.g. for a report used by a graphic tool, it requires data in all dates, even it
is null. Can I
select vacationT.* left join ( all dates d
On 1/4/2011 23:23, James Dekker wrote:
Peter,
Thanks for the response!
Unfortunately, that worked but a new error arose:
check the manual that corresponds to your MySQL server version for the right
syntax to use near 'ID = (select max(CONVERT(id_field, signed)) from
my_table_t)' at line 1
On 1/5/2011 13:31, James Dekker wrote:
Because some sequence tables contain one to many cardinality and MySQL tables
can only have one auto_increment column...
Is there a way to do what I am trying to do (obtain max sequence id, set it to
its corresponding table, and then increment by one
On 1/4/2011 14:47, Rafael Valenzuela wrote:
Hi everyone:
I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking
in for google and documentation of mysql and nothing.
there any way to close connections with any command of mysql, i've
modification the timeout
to an identical table on
another server? In Oracle, we used to be able to set up connection profiles
and move data between servers with SQL, but I'm guessing that's not easy to
do with MySQL. I'd prefer not to use mysql command line client commands to
save the data as an OS file and then import
it probably
wouldn't.
It will not. MySQL does not grow or edit its index files
incrementally, it computes a fresh on-disk index image for every change.
Right now, you are doing a complete index rebuild for every row you add.
If you add up the total work you are saving (index 121000 rows, index
Hi Jerry,
On 12/17/2010 09:34, Jerry Schwartz wrote:
-Original Message-
From: Jo�o C�ndido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Friday, December 17, 2010 6:11 AM
To: mysql@lists.mysql.com
Subject: Re: Access to MySQL
What about this?
date_format(now(), %Y/%m/%d)
[JS
On 12/16/2010 03:53, Tim Thorburn wrote:
On 12/16/2010 3:42 AM, Tim Thorburn wrote:
I should mention this is Windows 7 Ultimate 64-bit. After rebooting I
installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once
MySQL was installed, I downloaded and installed the current version
On 12/13/2010 21:32, Andy wrote:
Greetings everyone.
I am in a situation where I need to do parallel inserts into MySQL database
from inside my Perl program. Basically, I have several million records to
insert into the database, and hence I would rather do them in parallel than
doing them one
to ensure that they are both catching up to the master.
--
Shawn Green
MySQL Principal 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
should be dumped using the
new version and reloaded.
... snip ...
Any ideas?
The easiest way to migrate between major versions is to dump logical
contents of the system data tables (the entire MySQL database)
separately from the rest of the data. It changes very slowly so
?
Mark
SELECT MIN(column) FROM table WHERE column0 ?
--
Shawn Green
MySQL Principal 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
. There is always the
possibility that someone never had a score above zero. This should
handle it.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On 11/16/2010 15:14, Sydney Puente wrote:
Hello,
How can I export a mysql 5.0.45 db to Oracle? mysql is going to stau but I need
to pass the data to oracle, just so the data can be transfered.
I have carried out a mysql dump. This seems fine.create table etc. about 20 MB
in total.
Any ideas
On 11/8/2010 10:47 PM, wroxdb wrote:
Hello,
I have a query below:
mysql select * from ip_test where 3061579775 between startNum and endNum;
+++-+--+--++
| startNum | endNum | country | province | city | isp
/refman/5.1/en/group-by-modifiers.html
--
Shawn Green
MySQL Principal 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
the old value, dont panic!
exit mysql client and enter again.
It also makes a difference which version of SHOW VARIABLES you are
using: SHOW GLOBAL VARIABLES or SHOW SESSION VARIABLES
Changes to global settings only apply to NEW sessions. Existing sessions
can modify their personal settings without
match are available.
select * from my_table where sex_id = 1 or country_id = 120 or education_id
I mean if in my table there are some records with sex_id = 1 or country_id =
120 then I got 2 (2 match) then I can say 66% percent match.
Thank you,
This is where having a name-value pair in your MySQL
Hellpo Krishna,
On 10/19/2010 8:40 AM, Krishna Chandra Prajapati wrote:
Hi Pradhan,
Obviously, it should fail. Since you have deleted the root user which is
used by mysqldump for making connection to mysql server for taking backup
Not true. The utility mysqldump is just a client like any
On 10/13/2010 9:18 AM, kranthi wrote:
Hi
Please be send sample incremental backup script (bash Shell script
Easy to understand)
Thanks Regards,
Kranthikiran
I think you missed the points of the previous replies.
MySQL does not do incremental backups the the same way
CHARSET=utf8
COLLATE=utf8_unicode_ci
I'm confused, I thought primary keys were always unique ?
Cheers
Neil
I see no reason why this won't work. Show us some duplicate data and I
may be able to explain how to fix your definition.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle
--
Shawn Green
MySQL Principal 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
level or two of time-based summary tables.
--
Shawn Green
MySQL Principal 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
of the day, you take
the previous 24 entries from stats_hour and compute a stats_day entry.
Each level up aggregates the data from the level below.
Does that give you an idea about how other people may have solved a
similar problem?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle
On 10/4/2010 12:32 PM, Tompkins Neil wrote:
Account Number : uk600724
Dear Sir/Madam,
The MySQL database version which you have supplied to us is version 5.0.77.
However, it would appear that we require version to be at least 5.1.43.
How can we get our MySQL db upgraded to this version
Green
MySQL Principal 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
On 9/24/2010 4:11 AM, Ma Xiaoming wrote:
Dear all,
I have installed the MySQL version 5.1.50 with complete installation. After
the installation process is finished and the configuration is done, when I
run 'mysqladmin' with option 'version' in prompt, I got the following error
message
Hello Hank,
On 9/18/2010 9:35 PM, Hank wrote:
I have the following pseudo code running on mysql 4.x:
set @cnt:=0;
insert ignore into dest_table
select t1.field1, t1.field2, t1.field3, t2.field1,
t1.field3, t2.ts, @cnt:=...@cnt+1
from table1 as t1 left join table2 as t2 using
that if there are 3 rows found in `c` that match a total of 10
rows in `a` that each, in turn, matches 1 row in `b`, then the total number of
qualifying would be 10 + 10 - 20.
That should also be the number of rows changed.
Somehow the numbers reported by MySQL don't seem to match up in my real case,
even
them as a
load test.
Do you have any techniques you can share?
--
Shawn Green
MySQL Principal 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
On 9/10/2010 10:01 AM, george larson wrote:
Uwe Brauer wrote:
...
The only one I know of, for my environment, is /etc/my.cnf. I believe
that it can be located elsewhere but you could just use 'find' to find
it. I've broken my dev. MySQL many, many times and that's the only file
I know about
On 9/9/2010 3:57 AM, Tompkins Neil wrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: [MySQL] mysql@lists.mysql.com
Hi
I've the following query
Hi listers
mysql show global variables like version;
+---++
| Variable_name | Value |
+---++
| version | 5.1.46 |
+---++
1 row in set (0.02 sec)
mysql
Following problem: Two tables which must be joined differently depending
joins, you have to take outer joins.
suomi
On 2010-09-07 21:21, Travis Ard wrote:
Does this work?
select *
from t1
join t2 on (t1.datum = t2.sdat or dayname(t1.datum) = t2.tag);
-Travis
-Original Message-
From: mysql [mailto:my...@ayni.com]
Sent: Tuesday, September 07, 2010 1:43 AM
.
--
Shawn Green
MySQL Principal 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
That explains why there is no length to this index.
--
Shawn Green
MySQL Principal 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
).
...
Hank,
I think mysql is selecting ALL the records from both tables then
applying the where clause to all the data from table 1 and table 2 (I
think - guys correct me if I'm wrong)
...
Jangita is correct. Read the bottom of
http://dev.mysql.com/doc/refman/5.1/en/view-algorithms.html
--
Shawn
On 9/2/2010 1:39 PM, neutron wrote:
Hello Johan,
Thanks for the reply.
On Thu, Sep 2, 2010 at 3:34 AM, Johan De Meersman vegiv...@tuxera.be wrote:
I suspect he is talking about the Temp Tablespace concept from Oracle, which
is different from a temporary table or a memory table.
MySQL
On 9/2/2010 3:31 PM, Julien Lory wrote:
Hello,
I've done lot of researches and tests but can't find any answer. I need
to share one table between two db, those two db are in the same path (
/var/lib/mysql/db1 db2 ). I created symbolic links for db2 pointing to
the table in db1.
When I
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
-Original Message-
From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
Sent: Tuesday, August 31, 2010 3:48 PM
To: mysql@lists.mysql.com
Subject: Database design help
Hi
I've a soccer application consisting of managers, teams
Hi listers
mysql server here is
mysql-server-5.1.48-2.fc13.x86_64
this morning i created a message with a literal string in chinese in it.
the messages in the application i used are stored in a mysql database,
when you submit them, like in a sent folder.
With this chinese literal in it, i
Hi Ananda
table structure is:
mysql show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collation
On 2010-08-31 15:17, Ananda Kumar wrote:
desc suomi_contacts2;
mysql desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Extra
Hi Ananda
not sofar. But if you recommend it, i will give it a try.
thanks so much.
suomi
On 2010-08-31 15:41, Ananda Kumar wrote:
did u try changing the collation for history column to UTF8
and try the update.
2010/8/31 mysql my...@ayni.com mailto:my...@ayni.com
On 2010-08-31 15:17
Hi Ananda
that worked fine:
mysql alter table suomi_contacts2 modify history longtext character set
utf8 collate utf8_bin;
Query OK, 6327 rows affected (0.34 sec)
Records: 6327 Duplicates: 0 Warnings: 0
mysql
mysql update suomi_contacts2 set history = concat(now(), ' ', ''
,'concerne: utf
Hello List,
On 8/26/2010 3:00 PM, Daevid Vincent wrote:
ssh to the slave
mysql -uroot -pPASSWORD -P3306 -hlocalhost
show slave status\G
If the Slave IO is NOT Running, but SQL is, then simply try to restart the
slave...
*** 1. row
. Only then do the concepts of before and after
have any meaning.
--
Shawn Green
MySQL Principal 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
;
so replication may break when this MySQL server acts as a slave and has his
hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this
problem.
100703 22:23:41 [ERROR] Failed to open the relay log
'/var/run/mysqld/mysqld-relay-bin.01' (relay_log_pos 4)
100703 22:23:41 [ERROR
On 8/17/2010 6:02 PM, Anders Kaseorg wrote:
On Wed, 2010-08-11 at 14:23 -0400, Shawn Green (MySQL) wrote:
On 8/9/2010 5:27 PM, Yves Goergen wrote:
What's that supposed to mean? If there's no way to force the connection
into SSL, it is entirely useless. Anyone on the wire could simply
pretend
On 8/17/2010 6:13 PM, Yves Goergen wrote:
... snip ...
(Oh look, the MySQL guy already has an oracle.com e-mail address...)
And for a for about two years before that, I had a sun.com email
address, too. MySQL has not been an independent company for quite a
while. Google it if you don't
On 8/18/2010 2:22 PM, Anders Kaseorg wrote:
On Wed, 18 Aug 2010, Shawn Green (MySQL) wrote:
If the server specifies REQUIRES SSL then that client cannot connect
without going through the full SSL validation process. This means that
Mallory would need to present the same security credentials
chewing up a big chunk of your CPU time.
Does it work better if you delay the index creation of your temporary
table until after the table is populated?
CREATE TABLE fp2 ... SELECT ... ;
ALTER TABLE fp2 ADD KEY p(p),KEY q(q);
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA
On 8/9/2010 5:27 PM, Yves Goergen wrote:
Does anybody know how to use SSL-secured connections to a MySQL server?
Has anybody done that at all?
In the manual I have now found the following statement:
http://dev.mysql.com/doc/refman/5.1/en/ssl-options.html
Note that use of --ssl does
1 - 100 of 684 matches
Mail list logo