images - info about an image
Any suggestion would be greatly appreciated,
Best,
Nicolas
Nicolas Sebrecht a écrit:
> mysql> CREATE DATABASE dbtest;
> mysql> DELIMITER $$
> mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$
> mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130))
> -> BEGIN
> -> SET newf = REVERSE( SUBSTRING_INDEX( REV
VARCHAR(130))
-> BEGIN
-> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1));
-> END$$
mysql> DELIMITER ;
mysql> CALL test ('/home/ftp/file.foo');
ERROR 1305 (42000): FUNCTION dbtest.REVERSE does not exist
I expect to have the string 'file.
I would like an integer field to capture the current date as a Unix
Timestamp by default.
But this will not be accepted at all.
I get the error "invalid default value for [field name]"
Is there a workaround?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
That is exactly the issue.
Also if you use the real address to determine the lat/lon instead of the zip
code, the result will be different.
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 6:55 PM
To: [EMAIL PROTECTED]; Daevi
I think I said that earlier, but the distance between two zip codes deal is
inaccurate, yet useful, for instance on a Classified Ads Web site.
As for the Zip+4, I do not know of any database that gives the latitude and
longitude for them specifically. But I am certain it has to exist.
The US Post
I'm so confused. I'm finally getting around to needing to do a 'store
locator' thing.
I procured myself some zip/lat/long databases from various places. Then I
noticed that for the same zip code, I got different values in different
databases??!!!
So for a sanity check, I decided to look "online
i have three Values in each row of my MySQL database, im needing to sum
them in the table as they are displayed per Row ?? how do i do this ?
Projectname Elecremain Controlremainotherremain
Project1 2300 1600
250
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to upgr
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to upgr
Dependency issue, I would use RPM Package Manager.
It always solved that type of issue.
http://www.rpm.org/
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 3:17 PM
To: MySQL List
Subject: Older version MySQL
Hello,
I am attempting to upgr
n copy/paste it here that way we'll see
what is wrong.
Maybe the $id variable is not replaced with the proper content.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 2:31 PM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't wor
I change something it outputs Changed:
2, for the case of 2 records in the table.
>>From: "Nicolas Verhaeghe" <[EMAIL PROTECTED]>
>> Normal. MySQL returns 0 changes when the data before and after the
>>UPDATE
>> is
>> the same.
>
> --
> -Rows ma
I change something it outputs Changed:
2, for the case of 2 records in the table.
>>From: "Nicolas Verhaeghe" <[EMAIL PROTECTED]>
>> Normal. MySQL returns 0 changes when the data before and after the
>>UPDATE
>> is
>> the same.
>
> --
> -Rows ma
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't work
Writing echo
"-".mysql_error()."--".mys
Normal. MySQL returns 0 changes when the data before and after the UPDATE is
the same.
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Friday, April 21, 2006 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: WHERE doesn't work
Writing echo
"-".mysql_error()."--".mys
can someone please just send me or post a example of editing feilds of a
mysql database within an html form and then updating the values thanks alot
here is a small database u can use i can expand on your example as needed
/*
""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
>> [snip]
>> I read this as a SQL syntax question, not a math word problem. As in
>>
>> SELECT ..., (some expression equaling sq ft) AS sqft... [/snip]
>>
>> Cool, then do it!
>>
>
>
>
MySQL does seem to have a row number function and the purpose of this is
because it increases the processing time, as you have seen with your
workaround.
I would instead create a temp table with an autoincremented ID, insert the
content of your record set into it and use this autoincremented ID as
I guess the CD could be mounted on MacOS and Unix to be treated as a true
drive but I am confident it would not work on Windows, knowing how every
application has to embed itself with the registry and the system files,
usually register DLLs and what not.
But whatever happens, the CD should never b
I am slowly considering leaving GoDaddy, who has a very good bandwidth and
ok tech support (I have seen better but much much worse) and acceptable
prices, but unfortunately does not support MySQL 5 and PHP 5 either.
I wonder if I could give these people a chance but one thing I'd like to do
is see
Robert,
A RIGHT JOIN would potentially return more results than an INNER JOIN.
I do not see how it could be, in the absolute, be faster.
How large were the tables and how did you do your testing? What platform
did you use and were you InnoDB or MyISAM?
-Original Message-
From: Robert Di
I use Navicat on my dev machine, which is an XP as well.
Navicat backups my live server daily on my dev machine, as well as my
local DBs, in case I screw up.
-Original Message-
From: Neil Tompkins [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 11, 2006 3:49 AM
To: mysql@lists.mysql.com
Can you run without the Order By at all? If not, you may need to
properly join the tables.
I could reproduce the issue with MySQL 4.1 as well and I would go around
it myself by creating a temporaty table, populating it with the
aggregate, doing a select on the temp table and then of course droppin
That SQL 101.
It's a basic INSERT / SELECT.
http://dev.mysql.com/doc/refman/4.1/en/insert-select.html
Scroll down for the examples.
-Original Message-
From: clint lenard [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 8:54 PM
To: mysql@lists.mysql.com
Subject: Need help with
Many "big guys" like the one in Scottsdale, AZ, still have MySQL 3.23.
I myself make my SQL 3.23 compatible.
Yes, it is too new, and it is sad, because stored procedures will make
our job much easier.
I also program for MS SQL and use SPs extensively for all the good
reasons.
-Original Mess
Error message?
Also you seem to take save date from a HTML form.
How do you treat quote signs? And entries too large for a field?
-Original Message-
From: Kleiton L R Soares [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:45 AM
To: mysql@lists.mysql.com
Subject: Not Saving
Error message?
Also you seem to take save date from a HTML form.
How do you treat quote signs? And entries too large for a field?
-Original Message-
From: Kleiton L R Soares [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 3:45 AM
To: mysql@lists.mysql.com
Subject: Not Saving
In this case, cnelson, you can only have a one to one relationship.
He wants to allow a one to many relationship.
Using one field to store all the attribute ids in the product table is
what he is trying to do and it is not the best idea. Better use a table
in the middle, with product ids and attr
Your method is wrong because if you are looking for "5", then "56" will
match and also everything that has "5" in it.
Unless you include the spaces and look for : '% 5 %' but then you need
to add a space at the beginning and at the end of your attributes field.
That method is way too cumbersome a
Is it normal for MySQL to not update fields that are already identical?
I am talking about an INNER JOIN UPDATE, when copying from table A over
table B.
My count did not match at the first run and when I did the second run, I
go a zero rows updated...
--
MySQL General Mailing List
For list arc
You're very helpful, thanks.
Problem already taken care of but thanks for the lesson.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 10:55 PM
To: Nicolas Verhaeghe
Cc: mysql@lists.mysql.com
Subject: Re: How can I isolate the in
l the displacement fields will work fine.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 10:11 PM
To: George Law
Cc: Nicolas Verhaeghe; mysql@lists.mysql.com
Subject: Re: How can I isolate the integer part of a varchar field and
use i
--
From: George Law [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 24, 2006 8:14 AM
To: Nicolas Verhaeghe; mysql@lists.mysql.com
Subject: RE: How can I isolate the integer part of a varchar field and
use it in an ORDER BY?
Nicolas,
Not sure when the "replace" function was introduce
man/5.0/en/adding-functions.html
http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Nicolas Verhaeghe wrote:
> A client of mine sells motorcycle parts and the motorcycle models are
> for instance:
>
> YZ85
>
A client of mine sells motorcycle parts and the motorcycle models are
for instance:
YZ85
YZ125
WRF450
YZF450
Etc...
If you know motorcycles, you know that the number is always the
displacement in cc.
What I am looking to do here is make it so that the models are sorted
properly according to the
Dear mysql supports,
I want to change the font color for database mysql , for example I want to
insert data with red color
when I select this data the font color is the default black.It's possible to
change the font color.
thank you.
--
MySQL General Mailing List
For list archives: http://li
+--+
| isl_player |
+--+
| pla_id |
| pla_username |
+--+
+--+
| isl_login|
+--+
| pla_id |
| log_created |
+--+
+--+
| isl_transfer |
+--+
| pla_id |
| tra_amount |
+-
I am using MySQL 4.0.16 on Xp.
I have two tables, friend table and a gift table.
I have to buy one gift per friend before tonight.
How to do with mysql ?
For RedHat, just download the rpms and install it, it's far much simpler...
Nicolas
- Original Message -
From: "Ryan Sinnwell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 1:21 PM
Subject: Installation Question - RedHat 9.0
I
bd and bdb is that all the data of all db's
are all stored in one (or many) file in the base directory compared to
myisam tables where data resides in the db directory.
Is innodb stable enough to use un mass production environement ?
Nicolas
--
MySQL General Mailing List
For list
robably have a problem of these users actually being
> > authenticated using an anonymous-user account. Dump those accounts
> > by connecting to the server as root and issuing these statements:
> >
> > mysql> DELETE FROM mysql.user WHERE User = '';
> > mys
nts
> by connecting to the server as root and issuing these statements:
>
> mysql> DELETE FROM mysql.user WHERE User = '';
> mysql> FLUSH PRIVILEGES;
>
> Then have the user try again.
>
I get something like :
[EMAIL PROTECTED], which fits the user in the user an
her machine), they can connect
to the mysql server, but they can't do anything. We get :
select command denied to user: '[EMAIL PROTECTED]' for table 'table'
If we connect as root, the select is working properly. It's not the host
either, I tried with % as hos
Hi,
How can I fix an order by using numbers and letters ?
Id Town
56 Paris 1
60 Paris 10
7 Paris 11
262 Paris 12
8 Paris 13
16 Paris 14
22 Paris 15
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
59 Paris 9
I'd like to get :
56 Paris 1
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
5
Hi,
How can I fix an order by using numbers and letters ?
Id Town
56 Paris 1
60 Paris 10
7 Paris 11
262 Paris 12
8 Paris 13
16 Paris 14
22 Paris 15
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
59 Paris 9
I'd like to get :
56 Paris 1
6 Paris 3
57 Paris 4
51 Paris 6
5 Paris 7
61 Paris 8
5
> In the last episode (Jan 15), Nicolas said:
> > > On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote:
> > > > I'm running Freebsd 4.6.2 with mysql server v3.23.49
> > > >
> > > > I have a little question about using Mysql on Freebsd
> On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote:
> > Hi,
> >
> > I'm running Freebsd 4.6.2 with mysql server v3.23.49
> >
> > I have a little question about using Mysql on Freebsd and having a
> > database on a NT 4 linked drive, using Sa
) .
I can query my database on the linked drive, but I cannot insert or update
anything. I've always the read only error message when I try to insert a row
..
Any idea ? Is there any mysql configuration option to apply ?
Than
2.4.x, either
Suse or Gentoo, gcc 2.95.3 or 3.2.1, MySQL version 3.23.x or 4.0.4 and
4.0.6.
--
Nicolas MONNET (Tech) <[EMAIL PROTECTED]>
Carpe Diem
-
Before posting, please check:
http://www.mysql.com/manual.php
On Mon, 2002-12-16 at 16:20, Nicolas MONNET (Tech) wrote:
(...)
Nevermind. This was due to an error in the replication; but nonetheless,
it is impossible to shutdown mysqld cleanly if it's waiting for relay
logs to be freed.
--
Nicolas MONNET (Tech) <[EMAIL PROTECTED]>
6)
# /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld Ver 4.0.5a-beta for pc-linux on i686
--
Nicolas MONNET (Tech) <[EMAIL PROTECTED]>
Carpe Diem
-
Before posting, please check:
http://www.mysql.com/man
No matter what I do on the command line for mysqld, or in my.cnf, ALL
logs get activated!
I'm using the Gentoo ebuilds, with mysqld started from an svscan run
script for supervision.
Any ideas? I'm lost here!
--
Nicolas MONNET (Tech) <[EMAIL PROTECTED
On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote:
> --- Simon Green <[EMAIL PROTECTED]> wrote:
> > MySQL uses memory and HDD the most and so processor
> > speed is not so
> > important.
>
> Well, processor speed is also important, on some of
> our servers processors are almost 100% occupied.
I
On Mon, 2002-11-18 at 15:06, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message,
On Mon, 2002-11-04 at 11:58, Dicky Wahyu Purnomo wrote:
> Pada Mon, 4 Nov 2002 11:55:59 +0100
> "Toni" <[EMAIL PROTECTED]> menulis:
>
> > Hello
> >
> > I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without
> > problems, until now that consumes nearly all available CPU.
> >
>
Hi there,
Does any of you know of a utility to pretty print mysql table
structures? I have a pretty big and messy DB I need to work on, and I
would like to be able to print the table structures with nice tables.
Any pointers?
--
On Fri, 2002-10-11 at 17:07, Ed Carp wrote:
> > Should'nt be too hard to do thanks to PODFUK® AKA uservfs:
>
> Just goes to show you that Linux is so flexible, any hare-brained idea can be
>implemented in software . But you didn't answer
> my question - why would you want to do such a thing?
On Fri, 2002-10-11 at 10:06, Ed Carp wrote:
> > At 12:58 +0200 10/10/02, Alex Polite wrote:
> > >Is there any way I could display a MySQL database as a filesystem
> > >under Linux?
> >
> > What does that mean?
>
> I think he wants to mount a MySQL database as a filesystem, like CFS with the
>lo
(and thus avoiding the license fee).
Best regards
Nicolas
j.random.programmer wrote:
>Hi:
>
>Firstly, I'd like to congratulate both MySQL AB and
>Mr. Mathews on making the JDBC driver an officialy
>supported download.
>
>I have a query though. Newer versions of the mm.m
It worked! Thank you, you just made my day.
/Nicolas
Mikhail Entaltsev wrote:
>Nicolas,
>
>
>
>
>>select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
>>from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
>
Thanks for your reply. Unfortunately that query will not select rows
where Answer.AccountID is NULL which is what I wanted.
/Nicolas
Mikhail Entaltsev wrote:
>Nicolas,
>
>select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
>from Answer a left join
| Persson
2 | 3 | 12.6 | NULL | NULL | NULL << FirstName and LastName is NULL because
AccountID is NULL
Oh, and I can not use version 4+.
Help greatly appreciated.
/Nicolas
-
Before posting, please check:
As far as I understand the concept of Open Source / GPL you don't need a
license for it if you do not alter the Code and/or provide the full
Sourcecode.
For example:
You develop a win32 application using MSVC++ that accesses a MySQL database
on a linux-server through ADO / ODBC.
You need the
Hi all,
I'm trying to have logs of mySQL activity, I read that I need the
option --log[=file] for
mysqld but I can't understand where I must add this argument. (in my.conf
?)
Thanks in advance,
Nicola
mysql -u was -p" works perfectly. But remote
connection doesn't work. I can
see in my application log file : Server configuration denies access to data
source
Do you have any idea about this problem ?
Best regards,
Nicolas Beaumont
Atos Origin
Activité Intégration
Tour Les Miroirs
18
word: YES)
But without password it works...
Do you know how to solve that problem ? (I already try to make a SET
PASSWORD FOR web ... but
it didn't change anything)
Best regards
Nicolas Beaumont
Atos Origin - System Integration
Tour Les Miroirs
18 Av. d'Alsace
92926 Paris La Défense
or 2004
Somebody know something about that
thank you
Nicolas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
somebody know what means this error (with mysql_connect)
thank you
Nicolas.
PS : i don't have the file "mysqld_errors.txt"
-
Before posting, please check:
http://www.mysql.com/manual.php (the
hello,
i must convert a Web application from Unix to Windows NT.
The application is in C (cgi) and uses the library libmysqlclient.a
But this library doesn't exist in the Windows version of MySQL.
Somebody could help me ?
Thank you
N.G.
Hello,
I'd like to do a query with the following form:
select * from (select ...) ...
But it doesn't work. Is it possible to do something like that with mysql and
maybe with another syntax?
Thanx
Nico.
-
Before posting, ple
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As long as MySQL doesn't manage the foreign keys, how do you manage
the deletion of a record if it is referenced in another table's
record?
I am working in ASP, but I will be intersted by solution in any
programming language.
Thanks
Database,sql,query
> -Message d'origine-
> De : Nicolas Villatte [mailto:[EMAIL PROTECTED]]
> Envoyé : mardi 22 mai 2001 23:18
> À : '[EMAIL PROTECTED]'
> Objet : Date format prolem
>
>
> I insert a date like this '2002-10-15' in the
I am trying to see if I can communicate with a MySQL on Free BSD from the
MySQL GUI client on my Windows NT.
The GUI client cannot connect because the MySQL seems to be refusing this
connection. This does not seem to be server-related, but related to MySQL
itself, since, when I try to telnet in p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Query syyntax error, help needed
SELECT descpays.libelle FROM descpays WHERE descpays.pays_id IN
(SELECT pays.pays_id FROM pays where pays.pays_ref IS NULL)
I cannot find the error.
please could someone help me ?
-BEGIN PGP SIGNATURE-
Ver
is it possible? If yes, how ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsub
]Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061)
/4x4/lib/conmysql.js, line 17
Does anyone know a solution ?
Thanks
Nicolas Villatte
__
IT Manager
Creative Web SPRL
Rue Kessels straat, 38
1030 Brussels
Office Phon
Is it possible to procede to a DSNless connection to a mySQL DB in ASP ?
If so could anyone send me a example script ?
Thank you.
Nicolas Villatte
IT Manager
Creative Web
Rue Kessels straat, 38
1030 Brussels
Office Phone: +32 2
> I'd rather see them sent to the MySQL announcements list. It is
> already VERY low-traffic, and that seems like appropriate content.
>
> No sense creating another list just for the VERY occasional
> announcements when we already have one [mostly] for that purpose.
It seems to be a good idea.
Hi,
is it possible to create (I don't think it already exists) a
mailing-list just for security problems about MySQL.
I'm very concerned about the security of my web sites, and I rely on
MySQL to provide dynamic content.
So, for the moment, I must subscribe to the general list and receive
tons
RENAULT Laurent a écrit :
>
> I don't have mySQL root password !
> Is the solution do a backup of databases and cleanup mysql install and
> re-install it ?
If you have Unix root access, you can edit the table where is stored the
encrypted password, and put a new one ...
You can too re-install
msquared a écrit :
> Perhaps you want to distribute a CD full of databases, and people buy
> access to specific databases. access = password
IMHO, this method can't protect the content of the CD.
Hace a closer look :
- you have read acces to the CD (files-level read access), but your
MySQL ser
Hi,
Still not any info about the buffer-overflow discovered last week ?
Shouldn't be fixed at the beginning of the week ?
Please, dear MySQL team, give us info !!
Regards,
Nicob
-
Before posting, please check:
http://www.my
Sergei Golubchik a écrit :
>
> Hi!
>
> On Jan 12, João Gouveia wrote:
> > Hi,
> >
> > I believe i've found a problem in MySql. Here are some test's i've made in
> > 3.22.27 x86( also tested on v3.22.32 - latest stable, although i didn't
> > debug it, just tested to see if crashes ).
>
> Confirm
84 matches
Mail list logo