Yannick Warnier wrote:
Le lundi 03 octobre 2005 à 12:29 +0200, Martijn Tonies a écrit :
Using PhpMyAdmin, I seldom get the warning message:
PRIMARY and INDEX keys should not both be set for column `ID`
I understand its meaning, but I was wondering to what extent having a
field indexed AND
Chance Ellis wrote:
[snip]
of CREATE TABLE entries. I then import those files with a cron script into
mysql. This is where I am looking to convert IP address into something
[snip]
There is a world of possibilities at this point, one is this:
sed \
Hi all,
Willing to test an upgrading path from 4.0 to 4.1 database of MySQL.
Could someone provide a link or some slice of unload from a 4.0 with
encodings different from latin1 ?
Thanks in advance,
Francesco R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Vladimir B. Tsarkov wrote:
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that I've found,
contain solutions based on the
Martijn Tonies wrote:
Does MySQL 5 provide native XML support? ie, can I have a stored
procedure return an XML string instead of a recordset? Can I pass in
an XML string/doc and have the DB update relational tables based on
it?
native xml support, now, that's probably the funniest thing
Sebastian wrote:
i have this query:
SELECT COUNT(*) AS score FROM downloads WHERE date_add(dateline,
interval 1 hour) = now() GROUP BY filename ORDER BY score DESC
unfortunately for other reasons i had to change `dateline` to unix
timestamp so this query is no longer able to run as
Saqib Ali wrote:
Hello All,
What are best practices for deleting records in a DB. We need the
ability to restore the records.
Two obvious choices are:
1) Flag them deleted or undeleted
2) Move the deleted records to seperate table for deleted records.
We have a complex schema.
Mark Dacasco wrote:
SHOW VARIABLES LIKE ''%char%;
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_results utf8
character_set_server latin1
character_set_system utf8
SHOW CREATE TABLE `table1`;
CREATE TABLE `main_peeps` (
`id` int(11)
useful links:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
http://dev.mysql.com/doc/mysql/en/Charset-server.html
http://dev.mysql.com/doc/mysql/en/Charset-map.html
http://dev.mysql.com/doc/mysql/en/Option_files.html
http://bugs.mysql.com/bug.php?id=3611
I've found this in my
[EMAIL PROTECTED] wrote:
Does anyone know a free tool to convert MySQL to MSSQL
Thank you
Andrew
phpMyAdmin (http://www.phpmyadmin.net/) version 2.6.3-pl1 has the option
to export the data in mssql format (and much others).
You need a php enabled web server able to connect to your mysql
Gyurasits Zoltán wrote:
Hello All!
I have a question. I'm using the mysql 4.0 but I want change 5.0 because
I would like to use some features. (Subselect etc)
Maybe some of features you want are already included in 4.1 series, try
a search before switch to 5.0 for a production system.
[EMAIL PROTECTED] wrote:
When i try
mysql -h server --port=3306 --protocol=TCP -u user --password=xxx it works!
The real problem is when using stunnel, i have to do as if i will connect to
a local server... On windows it works but not on linux... :(
Original Message
Nuno Pereira wrote:
Hi all,
I have a MySQL server version 4.1.10a, for pc-linux-gnu (i686)
installed (from official binary RPMs) and running.
My question is if there are problems from updating the server to the
most current version of the 4.1.x series, specially things that fail to
work,
Dan Bolser wrote:
Hello,
I am interested in the theoretical time / space complexity of SQL queries
on indexed / non-indexed data.
I think I read somewhere that a JOIN on an indexed column is something
like O[mn*log(mn)] (m rows joined to n).
I assume without an index it is just
Philippe de Rochambeau wrote:
My version of mysql creates all sorts of xxx-bin.xxx files in the
/var/lib/mysql directory. I regularly remove the oldest files for space
purposes.
What exactly are these files and what is the proper way to manage them?
Thanks.
Philippe
If you
James Black wrote:
I am getting the following error, when I try to use bin/mysqld_safe,
Could not open require defaults file: $MYSQL_HOME/data/my.cnf
Fata error in defaults handling. Program aborted
Don't remember where I've read it but mysql binary packages don't read
anymore the my.cnf
mel list_php wrote:
Hi guys,
I was trying to download the mysqlxml patch for mysql 5.0 but didn't
succeed from the url:
http://d.udm.net/bar/myxml/mysqlxml.tar.g
does anybody know where I could find it?
Did anybody tried to use it or have any link to a doc/tutorial in
addition to the
Greg Whalin wrote:
Care to share any secrets? You guys are running Suse w/ 2.4 kernel yes?
Any specifics as far as kernel/glibc/gcc versions. Are you running
mysql 4.1.*? Are you using NPTL? You using the binary from mysql, or
building yourself? Are you running Innodb or Myisam. You
Jason Johnson ha scritto:
I am running MySQL 4.1.10 and ActivePerl 5.8.6.811 on Windows 2003. When
I upgraded MySQL from an older version, everything using DBD-MySQL
complained about not being compatible and MySQL is telling me to upgrade
to a newer client (in this case, obviously, my client
Prabath Ranasinghe (by way of Prabath Ranasinghe [EMAIL PROTECTED])
ha scritto:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hash: SHA1
Hi All,
I installed a fresh copy of Mandrake Linux 10.0 with MySQL.
I tried to login to MySQL server ,But it says that authorization is failed.
My hostname is
Mike Rains ha scritto:
I've just been wondering if the length parameter of a VARCHAR column has
any effect on storage efficiency or space requirements. Afaik, VARCHAR
columns only store the amount of data actually written into them and
require no significantly more memory. So to be especially
: Bastian Balthazar Bux [EMAIL PROTECTED]
To: shaun thornburgh [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE using 4.0.17
Date: Tue, 15 Feb 2005 23:32:56 +0100
shaun thornburgh ha scritto:
Hi,
I have a table with 26 fields, each row in this table must be
unique. I can't define all
It work with php too (at least with phpMyAdmin)
Martin ha scritto:
I've been running it for a while. Admittedly, I don't do anything
truly heavy with it -- it is part of my non-critical dev stuff.
I've had no issues with it, reliability wise, running it as the
backend to a Tomcat 5 install and
Eli ha scritto:
Hello,
Say I get these rows in a regular query:
col1col2col3
---
NULL B1 NULL
NULLNULLNULL
A3 B3 NULL
A4 NULLC4
A5 B5 C5
NULLB6 C6
(It's important to keep the rows in that order).
I want to get 1 row
Just a shot in the dark
do you have skip-networking or bind-address uncommented in your my.cnf ?
Reading better what you write I suppose the answer is yes ;)
can you connect from one server to the other using the replication user ?
Olivier Kaloudoff ha scritto:
Hi,
As no one answered to the
25 matches
Mail list logo