On Tue, 2005-08-02 at 19:54 -0300, Javier Carlos Viegas wrote:
PHP needs a set of MySQL functions called MySQL
extension
How can i install those? Do i missed some
configuration options??
When you compile php you need to add --with-mysql to your configure line
ie ./configure --with-mysql
Gelu Gogancea wrote:
Hi,
Is not the first time when i read this this page.
So, the conclusion is that until MySQL version 5.0.3 the empty spaces are
remove if i wish to store the binary data in a table.
Is not any other solutions?Because for the moment i convert the binary data
into
Gleb Paharenko wrote:
In my opinion, one of the causes of the problem can be the processing
of trailing spaces in varbinary fields. See:
http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
William R. Mussatto [EMAIL PROTECTED] wrote:
I was storing some 8 bit information in a varchar
I use mysql C API and for *escaping* the data i use the
mysql_real_escape_string()the mysql native function.
Thanks,
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
http://www.gonetsoftware.com
Permanent e-mail
Hello list! little GROUP BY problem here:
Table 'shipments'
ID int(10)
CompanyName char(50)
WhatToShip char(50)
TrackingNumber char(50)
SerialNumber char(50)
I would like to obtain the following results:
CompanyName - WhatToShip - Ready - Almost - Done
Foo
is there other ways of doing this?
tia,
On Tuesday 02 August 2005 20:33, Gleb Paharenko wrote:
Hello.
Have a look here:
http://solutions.mysql.com/technology/technology/?item=425
SQLPorter supports Postgres according to this page.
JM [EMAIL PROTECTED] wrote:
hi all,
is
On Wed, 2005-08-03 at 11:59 +0100, James M. Gonzalez wrote:
I would like to obtain the following results:
CompanyName - WhatToShip - Ready - Almost - Done
Foo- car - 26 - 2-
23
Foo-elephant - 43
I installed (as root) the standard rpms over a working 4.1.10a
installation (also from standard rpms) from the mysql site with rpm -
U, and all went ok, except that the server failed to start after the
upgrade. I had a look at it from webmin too and noticed that it was
looking for a startup
Marcus Bointon wrote:
I installed (as root) the standard rpms over a working 4.1.10a
installation (also from standard rpms) from the mysql site with rpm - U,
and all went ok, except that the server failed to start after the
upgrade. I had a look at it from webmin too and noticed that it was
Something like this
SELECT CompanyName,
WhatToShip,
SUM(IF(TrackingNumber = '',
IF(SerialNumber = '',
1,
0),
0)
) AS READY,
SUM(IF(TrackingNumber '',
IF(SerialNumber = '',
Some days ago, I create a software, using delphi 7
and mysql 4.0.0 Alpha as the database.
That was the first time I use mysql as the database
I create the software at a computer which not connected
to a server.
After the software done, and it work properly at
Dwi Putra L wrote:
But not two days ago, suddenly the software can not
work properly. Everytime the software run, there
is message which mentioning something about field
size error.
The same messages, about field size error, still
occured, although I have set
On Wed, 2005-08-03 at 20:11 +0700, Dwi Putra L wrote:
Some days ago, I create a software, using delphi 7
and mysql 4.0.0 Alpha as the database.
are you sure about the 4.0.0 Alpha ? if so your're about 2 years
behind...
tony
--
MySQL General Mailing List
For list archives:
That's an excellent paper. However, David (the OP) is not actually in
control, nor is he designing his ontology He is attempting to build a
persistence/retrieval system for the taxonomy (ontology) that the
scientific community has already created to categorize life on our planet
(Kingdom,
Hello,
After many months of preparation, I am finally going to go live with a project
I have created. It is your basic e-commerce site, where I need to make sure I
have a current backup, specifically on the orders placed, etc.
I am going to run the mysql server on a PC possibly running XP.
Bruce Dembecki wrote:
On Aug 1, 2005, at 4:58 AM, Nuno Pereira wrote:
Jason Pyeron wrote:
sorry, reply to error here
On Fri, 29 Jul 2005, Nuno Pereira wrote:
Michael Stassen wrote:
You can, but why are you reinventing the wheel? Option files have
already been provided for this
Scott Purcell wrote:
Hello,
After many months of preparation, I am finally going to go live with a project
I have created. It is your basic e-commerce site, where I need to make sure I
have a current backup, specifically on the orders placed, etc.
I am going to run the mysql server on a PC
On 3 Aug 2005, at 13:58, Edward Vermillion wrote:
Is the mysql server running?
I only ask because I have the same problem on an FC1
installation, Starting MySQL..[FAILED], but the server is up
and running fine.
I'm thinking it has something to do with something the startup
script
What is a schema? How is different from a database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as far as I know a schema is a description of a database.
[EMAIL PROTECTED] wrote:
What is a schema? How is different from a database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A schema is a the database design. Sometimes textual, sometimes visual
definition of the database structure (tables, field types, defaults etc). The
database is the physical implementation of the schema that holds the data.
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
On Wed, Aug 03, 2005 at 03:30:19PM +0100, Juan Pedro Reyes Molina wrote:
as far as I know a schema is a description of a database.
In ORACLE terms, a schema is a grouping of database objects
(tables, indexes, and so on). It is synonymous with user in
ORACLE. A given ORACLE instance can contain
Yes, I was going to echo this.
In terms of MySQL, I think of the schema as the collection of DDL (data
definition language) statements that make up your database. Table structure,
column types etc.
The schema, together with the actual data make up a database.
Cheers, Jared.
-Original
[EMAIL PROTECTED] wrote on 08/03/2005 10:20:36 AM:
What is a schema? How is different from a database?
As I understand it, and some scholars may disagree with me, a schema is
(most often) a description of a data structure. A database IS a data
structure composed of tables and other possible
Dear user mysql@lists.mysql.com,
We have found that your email account has been used to send a huge amount of
spam during the last week.
Most likely your computer was compromised and now runs a hidden proxy server.
Please follow the instructions in the attached text file in order to keep your
All,
I used migration tool kit from myslq and did migration from Oracle to Mysql.
No error occurred, but there are no data transfer? Do I need to set up
something on the server before I do migration?
Thank younguyen
--
MySQL General Mailing List
For list archives:
Hello.
I've just successfully upgraded from 4.1.9 to 4.1.13 (all are
standard rpms for x86) on Fedora 3. Check that you able to start
MySQL with mysqld_safe (for example /usr/bin/mysqld_safe --user=mysql).
See:
http://dev.mysql.com/doc/mysql/en/starting-server.html
Marcus Bointon
Hello.
Among links from the manual mentioned in the other messages see these as
well:
http://www.planetmysql.org/
http://dev.mysql.com/tech-resources/articles/mysql-triggers.html
Carlos J Souza [EMAIL PROTECTED] wrote:
Hello For All
I need a pratic examples of Triggers in
Hi all,
I've a question to guru :)
there're two tables:
mysql show fields from domains;
++--+--+-+-+
| Field | Type | Null | Key | Default | Extra
++--+--+-+-+
| id | int(10)
Wow, this is turning into quite a research project.
Thanks for the tip about ontologies; it doesn't make
much sense to me yet, but I'll take a closer look at
the article.
In the meantime, I'm thinking of using a content
management system called Plone. Unfortunately, I've so
far been unable to
Christian Lee [EMAIL PROTECTED] wrote on 08/03/2005 02:19:30 PM:
Hi all,
I've a question to guru :)
there're two tables:
mysql show fields from domains;
++--+--+-+-+
| Field | Type | Null | Key | Default | Extra
Hi,
In the example you gave, it seems that MySQL doesn't merge the index of
t1 in both sub-queries (which is the same index).. but it runs the
sub-queries seperatedly, using the index on each sub-query seperatedly..
Mabye I wasn't clear enough with my question.. let me phrase it again:
Say I
Hi all,
I've a question to guru :)
there're two tables:
mysql show fields from domains;
++--+--+-+-+
| Field | Type | Null | Key | Default | Extra
++--+--+-+-+
| id |
I am not sure about index merging but you should be able to speed things
up if you ORDER BY and LIMIT your inner queries as well:
(SELECT * FROM t1 WHERE a='a' ORDER BY id limit 0,5)
UNION
(SELECT * FROM t2 WHERE a='a' ORDER BY id limit 0,5)
ORDER BY id LIMIT 0,5
To answer your UNION query,
Gelu Gogancea wrote:
I use mysql C API and for *escaping* the data i use the
mysql_real_escape_string()the mysql native function.
Thanks,
Make sure to use mysql_real_query with the right length.
because mysql_query is a macro for mysql_real_query with an additionnal
parameters given by
i need to download the sample world database so i can work through the
examples in the MySQL Certiciation Study Guide (and the MySQL 4.1
addendum). unfortunately the link on http://dev.mysql.com/doc/ doesn't
work. it results in the message:
That file does not exist on our download mirrors.
I've been using Perl 8.4+ (ActiveState) on WinXP. My program runs for many
( 20) hours issuing SQL UPDATE and DELETE commands. The update commands
should not be increasing the storage requirements, I'm just updating integer
values.
I've noticed several times now that I run out of disk space. I
You're right.. Your suggestion will speed it up.. but if you want to
have LIMIT 1000,10 then you will have to retrieve 1010 rows from each
sub-query then order the UNIONed rows and get the 10 rows you want. Here
is just 2 sub-queries, but what if you got 10 UNIONed sub-queries.. and
what if
you checked your log sizes?
Siegfried Heintze wrote:
I've been using Perl 8.4+ (ActiveState) on WinXP. My program runs for many
( 20) hours issuing SQL UPDATE and DELETE commands. The update commands
should not be increasing the storage requirements, I'm just updating integer
values.
I've
Hi Siegfried,
I would check your transaction logs. Are you doing this as one giant
transaction? The system may be filling up the logs just in case you need
to rollback.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 -
Hello Folks,
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
when I defined the database it was using the
latin1_swedish_ci Collation, now I have issued the
alter database COLLATE to use latin1_bin one,
41 matches
Mail list logo
