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 ASCII(print
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 --wi
Carlos,
I need a pratic examples of Triggers in Mysql 5.x
There are examples at
http://dev.mysql.com/doc/mysql/en/create-trigger.html and
http://dev.mysql.com/doc/mysql/en/using-triggers.html.
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / V
May be you should consider building an ontology with your data base. This links
will provides ideas to explore this avenue:
http://www.ksl.stanford.edu/people/dlm/papers/ontology-tutorial-noy-mcguinness-abstract.html
Raoul
David Blomstrom <[EMAIL PROTECTED]> wrote:
I've been gathering data for
Hello
CJS> I need a pratic examples of Triggers in Mysql 5.x
Chapter 20. Triggers
http://dev.mysql.com/doc/mysql/en/triggers.html
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
I see these really need to be int or time types.
Is there no way they can default to NULL or blank?
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
mysql> select '3' - '1';
+---+
| '3' - '1' |
+---+
| 2 |
+---+
1 row in se
Hi, im kind of new using mysql, i used to have it
installed on my Mandrake 9 using rpm, but i m testing
the source installation, the thing is that i´ve
succesfully compiled mysqld and it works, but now im
trying to use a php page, and im asked to install :
PHP needs a set of MySQL functions called
Gleb Paharenko said:
> Hello.
>
> 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
Thanks, you may be right since the results are too short.
>
> "William R. Mussatto" <[EM
Hello For All
I need a pratic examples of Triggers in Mysql 5.x
Regards For all
Carlos Souza
From Brazil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
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 binar
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 3:14 PM
To: Kapoor, Nishikant
Cc: mysql@lists.mysql.com
Subject: RE: SQL query taking a long time...please
"Kapoor, Nishikant" <[EMAIL PROTECTED]> wrote on 08/02/2005 02:58:08 PM:
> Just
"Kapoor, Nishikant" <[EMAIL PROTECTED]> wrote on
08/02/2005 02:58:08 PM:
> Just wondering if someone would be kind enough to take a look at it -
Nishi
>
> > -Original Message-
> > Following query is taking a long time (upto 10 secs) to
> > return the resultset. Would greatly appreciate
Brian Dunning wrote:
In one case I do need to jump back and forth between databases that are
on different physical servers. What's the most efficient way to handle
this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" erro
At 01:58 PM 8/2/2005, you wrote:
Just wondering if someone would be kind enough to take a look at it - Nishi
Nishi,
What did "EXPLAIN" show? Also what happens if you have just one
Match? Is it faster? If so, why not run 2 queries and build a temporary
table from the results. Using "O
I was storing some 8 bit information in a varchar binary field (encrypted
stuff) and I think its getting corrupted. I thought they were (except for
size) interchangable? I'm running debian GNU Linux and haven't moved to
sarge so I'm still on 3.23.x but will be moving shortly.
---
William R.
Just wondering if someone would be kind enough to take a look at it - Nishi
> -Original Message-
> Following query is taking a long time (upto 10 secs) to
> return the resultset. Would greatly appreciate if someone
> could help me understand why.
>
> I have run 'analyze table ' on all t
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" error. Now, it is
getti
On Tue, Aug 02, 2005 at 02:38:01PM -0400, Jason Pyeron wrote:
> why does this list not have the reply to header set?
This is covered in the mailing list FAQ at
http://lists.mysql.com/faq.php
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
why does this list not have the reply to header set?
-jason pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager
Hello.
I don't know the relationships between program articlebot and MySQL.
But error message tells me to ask you to check if you have MyODBC
properly configured and whether your MySQL server is running. See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
There is
Hello.
It works for me on MySQL 5.0.10:
mysql> CREATE TABLE `manager_new` (
-> `id` bigint(20) NOT NULL auto_increment,
-> `id_from_hits` bigint(20) default NULL,
-> `from_ip` varchar(15) default NULL,
-> `pool` char(1) NOT NULL default 'n',
-> `to_ip` varcha
Hello.
Have you changed InnoDB log file sizes? See:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
Manual says that you have to stop mysql, then change the parameter in my.cnf,
then I moved to another directory the log file just to be cautious, and then
restarted mysql
But then replication would not work.
On Tue, 2 Aug 2005, Octavian Rasnita wrote:
Hi,
I think that I have seen many times the advice not to store the images in
MySQL, but to store them on the hard disk while putting the path to them in
the database.
They could be accessed much faster this way.
I have never had a problem storing BLOBs in MySQL or any other DB for that
fact.
I have on many occasions forgot to use the proper methods for send a BLOB
to the db. That means proper escaping, etc.
On Tue, 2 Aug 2005, Andy Hilton wrote:
In my data structure I have many BLOBs which are no
My RaQ4 is throwing the "Too many connections" error. Now, it is
getting hit pretty hard by traffic, but I wonder if my coding might
be exacerbating this error.
Due to my relatively lazy structure of includes and functions, my
pages might have half a dozen or so of these (most are to the sa
Can you also sent it to me.
Thanks!
Nesto r:-)
-Original Message-
From: "J. David Boyd" <[EMAIL PROTECTED]>
Sent: Aug 2, 2005 8:20 AM
To: mysql@lists.mysql.com
Subject: Re: Database equivalent to NorthWind for M$ SQL
Peter Brawley <[EMAIL PROTECTED]> writes:
> Scott,
>
>>Is there a
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
Is this string arithmetic? Can/should I do this?
(I see the second one won't work without single-quotes.)
mysql> select '3' - '1';
+---+
| '3' - '1' |
+---+
| 2 |
+---+
1 row
In my data structure I have many BLOBs which are not images - so I am hoping
that MySQL can indeed deal with BLOBs ok ?
Andy
On 8/2/05 12:14 PM, "Octavian Rasnita" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I think that I have seen many times the advice not to store the images in
> MySQL, but to stor
Hi,
I think that I have seen many times the advice not to store the images in
MySQL, but to store them on the hard disk while putting the path to them in
the database.
They could be accessed much faster this way.
Teddy
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To:
when I startup I got error like
Innodb: error: log file .\ib_logfile (0,1) is different size
Innodb: than specifiled in the .cnf file
050729: {eror} can't init database
050729:{error} aborting .
Could you please tell me why?
Thank youNguyen
--
MySQL General Mailing List
For list ar
Your second statement hit the spot. :) Thanks!
On 8/2/05, Mark Leith <[EMAIL PROTECTED]> wrote:
>
> > -Original Message-
> > From: Scott Hamm [mailto:[EMAIL PROTECTED]
> > Sent: 02 August 2005 15:38
> > To: [EMAIL PROTECTED]
> > Cc: Mysql
> > Subject: Re: STORED PROCEDURE
> >
> > On 8/2/0
> Hmm nice screwed formatting, but anyway.. ;)
Please guys - the overquoting!!
Thank you.
--
Martijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Mark Leith [mailto:[EMAIL PROTECTED]
> Sent: 02 August 2005 15:56
> To: mysql@lists.mysql.com
> Subject: RE: STORED PROCEDURE
>
> > -Original Message-
> > From: Scott Hamm [mailto:[EMAIL PROTECTED]
> > Sent: 02 August 2005 15:38
> > To: [EMAIL PROTECT
> -Original Message-
> From: Scott Hamm [mailto:[EMAIL PROTECTED]
> Sent: 02 August 2005 15:38
> To: [EMAIL PROTECTED]
> Cc: Mysql
> Subject: Re: STORED PROCEDURE
>
> On 8/2/05, Mark Leith <[EMAIL PROTECTED]> wrote:
> >
> > CREATE PROCEDURE title()
> > BEGIN
> > DECLARE title VARCHAR(255);
MySQL 5.0.9 Beta :)
On 8/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Scott Hamm <[EMAIL PROTECTED]> wrote on 08/02/2005 10:12:01 AM:
>
> > I'm used with MS SQL and could not understand MySQL's document. I'm
> trying
> > to create something like the simple example
> >
> > DECL
On 8/2/05, Mark Leith <[EMAIL PROTECTED]> wrote:
>
> CREATE PROCEDURE title()
> BEGIN
> DECLARE title VARCHAR(255);
> SET title = '%Unconditional%';
> SELECT title;
> END;
> //
>
> mysql> CALL title()//
> +-+
> | title |
> +-+
> | %Unconditional% |
> +-
Scott Hamm <[EMAIL PROTECTED]> wrote on 08/02/2005 10:12:01 AM:
> I'm used with MS SQL and could not understand MySQL's document. I'm
trying
> to create something like the simple example
>
> DECLARE @title varchar(255)
> SET @title='%Unconditional%'
> SELECT @title;
>
> How do I get around to
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title = '%Unconditional%';
SELECT title;
END;
//
mysql> CALL title()//
+-+
| title |
+-+
| %Unconditional% |
+-+
1 row in set (0.01 sec)
HTH
Mark
Mark Leith
Cool-Tools UK Lim
I'm used with MS SQL and could not understand MySQL's document. I'm trying
to create something like the simple example
DECLARE @title varchar(255)
SET @title='%Unconditional%'
SELECT @title;
How do I get around to it in MySQL?
--
Power to people, Linux is here.
enrique...
i wasn't looking for away around the behavior... i was simply posting this
as a potential bug.
my version of mySQL (1.4.12) gives me the error that i described.. i'd be
willing to bet other versions act in a similar manner...
-bruce
-Original Message-
From: Enrique Sanchez V
After installing mySQL along with a program called articlebot, I tried to
run the application and I keep getting this message:
"An unhandled exception has occurred in a component in your application.
Click continue and application will ignore this error and attempt to
continue.
ERROR [HY000
Following query is taking a long time (upto 10 secs) to return the resultset.
Would greatly appreciate if someone could help me understand why.
I have run 'analyze table ' on all the three tables involved. The
EXPLAIN output, record count and table description is also included.
SELECT SQL_CALC_
Thankyou. But, when I startup I got error like
Innodb: error: log file .\ib_logfile (0,1) is different size
Innodb: than specifiled in the .cnf file
050729: {eror} can't init database
050729:{error} aborting
Could you please tell me why?
Thank you
-Original Message-
From: Scott Hamm [
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Kumar Gaurav <[EMAIL PROTECTED]> wrote:
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> I installed mysql-standard-4.1.11-pc-linux-gnu-i686] in my sy
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 there a howto on this? or an application for this?
>
> tia,
>
--
For technical sup
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote:
> I used command: c:\mysql\bin\mysqladmin -u root shutdown
> and I got error :
>
> mysqladmin: connect to sever at 'localhost' fail
> error 'Access denied for user 'root'@ 'loc
"Alvaro Cobo" <[EMAIL PROTECTED]> writes:
> Hi guys:
>
> I have the following problem:
>
> In the organization I work for, we have several standard formats which
> we have to write for each project we manage (for example:
> reports). These are MS-Word documents, for which I have created a
> databa
Do you have any root password set? If so, you should mention -p option in
the command. The command should be of the following :
c:\mysql\bin\mysqladmin -u root shutdown -p
Which will ask you to enter the root password, else you can type your
password along with the -p option as follows :
c:\
Peter Brawley <[EMAIL PROTECTED]> writes:
> Scott,
>
>>Is there any database file similiar to M$'s Northwind that I can use to play
>>with? It would be nice if there is one inside MySQL by default for newbies
>>to start out with.
>
> For our chapters on Connector/ODBC and dotNet, Arthur & I wrote
Hi all
I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow
| manager_new | CREATE TABLE `manager_new` (
`id` bigint(20) NOT NULL auto_increment,
`id_from_hits` bigint(20) default NULL,
`from_ip` varchar(15) default NULL,
`pool` char(1) NOT NULL default 'n',
`to_ip` varchar
Hi all
I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow
| manager_new | CREATE TABLE `manager_new` (
`id` bigint(20) NOT NULL auto_increment,
`id_from_hits` bigint(20) default NULL,
`from_ip` varchar(15) default NULL,
`pool` char(1) NOT NULL default 'n',
`to_ip` varchar
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p
it should prompt for password.
On 8/2/05, Nguyen, Phong <[EMAIL PROTECTED]> wrote:
>
> I used command: c:\mysql\bin\mysqladmin -u root shutdown
> and I got error :
>
> mysqladmin: connect to sever at 'localhost' fail
> er
I used command: c:\mysql\bin\mysqladmin -u root shutdown
and I got error :
mysqladmin: connect to sever at 'localhost' fail
error 'Access denied for user 'root'@ 'localhost' (using password: NO)
Does anyone know why? Please share with us.
Thankyou..Phong
--
MySQL General Mailing List
For l
First check whether MySQL server is running on your machine or not.
You can use 'ps -aux | grep mysql' for checking this.
sujay
-Original Message-
From: Kumar Gaurav [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 10:31 AM
To: mysql@lists.mysql.com
Subject: Please Give me Solut
Usually those kind of errors mean that the MySQL server program is not
running -- there is nothing to connect to. The socket file is used for when
you connect to MySQL from the server that is running it.
Make sure that the server is up and running before connecting. Look for it
in the process list
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I have installed mysql-standard-4.1.11-pc-linux-gnu-i686 .
Please reply .
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I installed mysql-standard-4.1.11-pc-linux-gnu-i686] in my system.
There is no file in '/var/lib/mysql/mysql.sock'.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
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 ASCII(printing ASCII) string,i add
Hi!
Gregory Machin wrote:
Hi all.
Please could you advise.
I would like to know if one could do a recursive search through a data
base and get a result of wich column and field is holding the string ?
SQL (the language) always requires the table and column name to be given
as constant text w
Where do you see that?
I didn't type the command to execute the mysql client, and "database" is
not the password, is the default database of the session. So, in the command
mysql -u user -p database
the user is user, the password is prompted interactively, and the
default database is databas
hi all,
is there a howto on this? or an application for this?
tia,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
It seems that your DBD::MySQL module doesn't read configuration file,
or [client] group. Use mysql_read_default_group and mysql_read_default_file
in your DSN:
$dbh = DBI->connect
("DBI:mysql:test:localhost;mysql_read_default_file=/etc/my.cnf;".
"mysql_read_default_group=dbdmysql"
Hello.
MySQL uses indexes in queries which are parts of UNION. See:
mysql> explain (select * from t1 where a=5) union (select * from t1 where
a=3)\G;
*** 1. row ***
id: 1
select_type: PRIMARY
table: t1
type:
On Mon, 1 Aug 2005, Heikki Tuuri wrote:
> unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and
> later.
Hi Heikki,
Thanks for your response. The fix seems to consists only of a few lines:
http://mysql.bkbits.net:8080/mysql-4.1/[EMAIL PROTECTED]|[EMAIL PROTECTED]
It look
64 matches
Mail list logo
