Assuming everything is properly indexed.
(1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1,
field2 FROM my_table_2;
or
(2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1,
field2 FROM my_table_2;
Is there anything to say about this in a general sense, or does it
Hi, in a fedora i install mysql 4, i upgrading to mysql 4, but when i
put mysqld, say can´t start server: bind on tcp/ip port, before
restart computer when i put ps, appear an mysql_safe but now no, with
the same error.
--
MySQL General Mailing List
For list archives:
Ashley M. Kirchner wrote:
Mark Sargent wrote:
[EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p
-bash: mysql: command not found
You don't have mysql in root's path. Once you fix that little problem,
you should be all set.
Hi All,
heck, how exactly do I do that..? Move the whole mysql dir to a path
Assuming everything is properly indexed.
(1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1,
field2 FROM my_table_2;
or
(2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1,
field2 FROM my_table_2;
Is there anything to say about this in a general sense, or
I just installed phpMyAdmin, made the appropriate changes in the
config.inc.php file, and got the following error when accessing it via
both IE and Safari on Mac OS X Panther client.
#1251 - Client does not support authentication protocol requested by
server; consider upgrading MySQL client
I am
Did you try searching on the error message first? I got hundreds of hits in
Google for this. Searching the mysql docs, the first hit
http://dev.mysql.com/doc/mysql/en/old-client.html has the explanation.
The short version is that password security has been improved in mysql 4.1,
so clients
Even I had the same problem so I moved to using SQLyog
and its an awesom client.
http://www.webyog.com
Karam
--- Asad Habib [EMAIL PROTECTED] wrote:
I just installed phpMyAdmin, made the appropriate
changes in the
config.inc.php file, and got the following error
when accessing it via
both
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT statement on server5
My server has mysql: version 3.23.58
// Performing SQL query
SELECT cities.city, regions.region, countries.country
FROM cities
JOIN subnets on subnets.cityid=subnets.cityid
JOIN regions on subnets.regionid=regions.regionid
JOIN countries on subnets.countryid=countries.countryid
where
I know this issue has been brought up many times and I have tried to
search and read as much as possible but still have not been able to
resolve my issue. I have a mysql database (not the latest but it
supports unicode). I am keeping some columns in utf8 format and only
save data that is in utf8.
I'm having trouble compiling myodbc-3.51.11 against mysql 5.0.0 -
something about int2str has too many arguments - should I be using a
newer version of myodbc (I couldn't find one), or is it not supported
yet for mysql 5.0.0, or ...?
Running debian / linux 2.6.9-2-k7.
Frederik
--
MySQL, Third Edition (Sams Developers Library, 2005) has been published.
More information is available at the book's Web site:
http://www.kitebird.com/mysql-book/
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list
Good evening all,
I've got an Oracle text dump from a client for conversion to MySQL.
Before I dive into SED or Perl does anyone know of a script to convert
the dump file?
I did the dev site by hand, not much to it, the site is fairly simple.
Mostly NUMBER to INT, VARCHAR2 to VARCHAR, and CLOB
13 matches
Mail list logo