based on the elements
contained within a given statement; in addition, this order is not
guaranteed 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 mate
har`
Error: Can't find file: './some_db/A table 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.
Wou
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
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 for ODBC is one
t schedule Professor 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 te
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
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
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
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
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
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.html>or|SELECT ... LOCK
IN SHARE MODE|), try us
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) |
++
| 1
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 ...a
"Paid" is a view.
But when I try to use 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",
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 encou
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
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,
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
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
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
-
include this
f) the event starts inside the window but ends beyond the window -
include this.
g) the event starts and ends beyond the window - exclude 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 >=
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
. 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
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
r to read 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.my
hich column you 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
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 l
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 Engi
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.
get rid of it?
As Claudio 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 sto
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 r
`),
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
aster.
--
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?unsub=arch...@jab.org
r for table joins was demoted in the
'order of precedence' 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
.5/en/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/mys
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 sta
e before $now that are NOT
also listed in searching.Status
I can't seem to spot the difference. Maybe if you phrased it differently
or provided two or three sample rows for each table I could understand
your distinction?
--
Shawn Green
MySQL Principal Technical Support Engineer
Orac
tern has the added advantage of not eliminating the possibility
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: h
r 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
lts,
just the query.
--
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 re
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_u
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
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
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/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 in the
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) in
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)'
On 1/4/2011 15:53, Hank wrote:
Hello,
I have a background process that runs as a combination of PHP&MySQL. The
end results are records in a table on server #1 (but not the entire table,
just a small subset of the table needs to move). What's the
easiest/cleanest way of mov
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 t
ss 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
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/
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 of
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
HOW
SLAVE STATUS 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
re 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:/
clues?
Mark
SELECT MIN(column) FROM table WHERE column>0 ?
--
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?un
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 there is
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
m/doc/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
ws you 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 persona
ir in your MySQL can help. Your data
appears to belong to a dating site but it could easily belong to a
product catalog or many other types of data sets. In this example,I want
to compute product matches to see how close they are to my search criteria.
In rough symbolic terms, this is one layou
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
definition
--
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
DB AUTO_INCREMENT=1001 DEFAULT 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 Pri
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
the first 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
table. At the end 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 Sup
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 or
should also be an index on both tables where `letter` is the
leftmost element.
--
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 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 fol
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
'yen';
It seems to me 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 b
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 on
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=arch...@jab.org
On 9/9/2010 3:57 AM, Tompkins Neil wrote:
Any help would be really appreciated ?
-- Forwarded message --
From: Tompkins Neil
Date: Wed, Sep 8, 2010 at 5:30 PM
Subject: Query SUM help
To: "[MySQL]"
Hi
I've the following query :
SELECT total_team_rating, m
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
To
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 diffe
NIQUE key I violated, only that the combination already
exists and which constraint is protecting that combination.
--
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
ypes.html
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
he same results).
...
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/
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 i
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 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 will allocate a memory
il: 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 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(), '
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 mailto:my...@ayni.com>>
On 2010-08-31 15:17, Ananda
On 2010-08-31 15:17, Ananda Kumar wrote:
> desc suomi_contacts2;
mysql> desc suomi_contacts2;
+--+--+--+-+---+-+
| Field| Type | Null | Key | Default |
Hi Ananda
table structure is:
mysql> show full columns from suomi_contacts2;
+--+--+---+--+-+---+-+-+-+
| Field| Type | Collat
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 litera
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
or --relay-log-index were used;
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.000
t how you are
sequencing your rows. 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.co
ork that's 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 Engi
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
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
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 simp
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 not
1 - 100 of 711 matches
Mail list logo