I may have a misunderstanding of this, but as I have been told, if I have a
table with 3 columns, Idx (an Index column, unique, auto-increment), Name,
Value (both varchar), and I try a command like this:
INSERT IGNORE INTO myTable SET Name = "Variable1", Value = "100";
or
INSERT IGNORE INTO myTa
On Wednesday 24 August 2005 02:25 am, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> added to the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/s/mysql/430c12dd47626c9c/hal=thresholddigital.com
>
> This confirmation ser
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> David,
>
> >1. Some species names are shared by more than one
> >mammal. For example, there's a marsupial named
> >Antechinus leo.
>
> >2. Species are more properly cited with the name
> of
> >their parent (genus), so I eventually want my
> spe
I'll give that a try. Thanks.
--- [EMAIL PROTECTED] wrote:
>
>
> David Blomstrom wrote:
>
> >-- [EMAIL PROTECTED] wrote:
> >
> >
> >
> >>Can
> >>you just concatenate
> >>the two strings together after you get them from
> the
> >>database? e.g.
> >>$parent.$name? And, just split() or explo
David Blomstrom wrote:
-- [EMAIL PROTECTED] wrote:
Can
you just concatenate
the two strings together after you get them from the
database? e.g.
$parent.$name? And, just split() or explode() the
string when you get it from the URL?
Consider the following URL's:
1. stacks/leo
2
David,
>1. Some species names are shared by more than one
>mammal. For example, there's a marsupial named
>Antechinus leo.
>2. Species are more properly cited with the name of
>their parent (genus), so I eventually want my species
>URL's to look like this:
As you note, the names aren't guaran
Marcus Bointon wrote:
I have a single-table update query that's giving me a "Cannot add or
update a child row: a foreign key constraint fails" error. Fair enough,
I do have several constraints defined - but how can I find out which
constraint is failing?
Marcus
SHOW INNODB STATUS
See
[EMAIL PROTECTED] wrote:
You are right. There are a lot of date functions in MySQL. However, I am
not sure exactly what your needs are...
I think you are trying to compute date intervals (did you NOT see the
INTERVAL keyword when you RTFM?). Most of the date functions currently
supported a
Barbara Deaton wrote:
> All,
>
> I know MySQL comes with all sorts of wonderful functions to do date
> arithmetic, the problem is the context that my application is being
> called in I don't know if a user wants me to add or subtract days. I'm
> just given the number of days that need to be eithe
-- [EMAIL PROTECTED] wrote:
> Can
> you just concatenate
> the two strings together after you get them from the
> database? e.g.
> $parent.$name? And, just split() or explode() the
> string when you get it from the URL?
Consider the following URL's:
1. stacks/leo
2. stacks/Panthera_leo
The
David Blomstrom wrote:
<>I'm trying to make my first content management system
and am wrestling with a problem that seems to be about
equal parts PHP, Apache mod_rewrite and MySQL. I
wondered if anyone on this list can suggest a MySQL
solution - or partial solution.
I'm dealing with a single
--- David Blomstrom <[EMAIL PROTECTED]> wrote:
> I'm trying to make my first content management
> system
> and am wrestling with a problem that seems to be
> about
> equal parts PHP, Apache mod_rewrite and MySQL. I
> wondered if anyone on this list can suggest a MySQL
> solution - or partial sol
I'm trying to make my first content management system
and am wrestling with a problem that seems to be about
equal parts PHP, Apache mod_rewrite and MySQL. I
wondered if anyone on this list can suggest a MySQL
solution - or partial solution.
I'm dealing with a single database table named
gzanimals
Hi Bruce,
I am not much worried about pre 5.0.11-Beta, my question is:
How the following tables would be stored:
CREATE TABLE NonUnicodeTable (NonUnicodeColumn LONGTEXT);
CREATE TABLE UnicodeTable (UnicodeColumn LONGTEXT UNICODE);
Would both of the above tables have 2^32 - 1 characters?
Thank
The limit you are running into is the maxdsiz or max data size for a
process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to
recompile your kernel to set a different maxdsiz. See
/boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in
/boot/loader.conf should work.
T
I have a single-table update query that's giving me a "Cannot add or
update a child row: a foreign key constraint fails" error. Fair
enough, I do have several constraints defined - but how can I find
out which constraint is failing?
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you
Hi,
why not using the -e otion to mysqldump ? it make an INSERT command as
long as your max_command_packet permit it.
2005/8/23, Bruce Dembecki <[EMAIL PROTECTED]>:
> Once you decide to use mysqldump, be aware that the quickest way to
> export/import large files is to use the --tab feature on ex
hi,
should I use mysqldump from the Mysql 4.0 or 4.1?
Regards,
Rafal
p.s.
Thx for all other tips!
At 21:44 23.08.2005, Bruce Dembecki wrote:
Once you decide to use mysqldump, be aware that the quickest way to
export/import large files is to use the --tab feature on export and
mysqlimport to l
Darryl,
>Unfortunately the item field has got data with quotes around it.
IE
>"KP-00310". I need to clean up the data and have the field contain
>just KP-00310. Since I have 10,000 records, I need a update
>statement or something to clean that up.
To remove all double quotes: UPDATE tablena
how did you install MySQL 5.0?
did you do it by rpm?
or did you do a make install.
could you attach the output of
for i in `rpm -qa --queryformat '%{name} '`; do rpm -q $i && rpm -V $i; done
You will be able to get your compat rpms at
http://public.pdinc.us/rpms/mysql
we may have to make up
Unfortunately no, because I don't know if I'm being asked to add or subtract
days. I'm just given a value, and have to transform that into something that
can be added or subtracted.
So for example, all I get with is value 1 meaning 1 day and I need to do
something with a date, for db2 through
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 08/23/2005 03:36:52 PM:
> All,
>
> I know MySQL comes with all sorts of wonderful functions to do date
> arithmetic, the problem is the context that my application is being
> called in I don't know if a user wants me to add or subtract days.
> I'm
Do You know about INTERVAL?
Use it in an exprecssion or funtion as
..INTERVAL expr type
where expr is any numerical value
* The INTERVAL keyword and the type specifier are not case
sensitive.
The following table shows how the type a
Barbara,
Can't you use the ADDDATE function ?
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
Freddie
> -Ursprüngliche Nachricht-
> Von: Barbara Deaton [mailto:[EMAIL PROTECTED]
> Gesendet: Dienstag, 23. August 2005 21:37
> An: mysql@lists.mysql.com
> Betreff: Date arit
Once you decide to use mysqldump, be aware that the quickest way to
export/import large files is to use the --tab feature on export and
mysqlimport to load the data...
Essentially:
On the old (4.0) server:
mysqldump --tab=/var/tmp/directory mydatabase
On the new (4.1) server (assuming you
All,
I know MySQL comes with all sorts of wonderful functions to do date arithmetic,
the problem is the context that my application is being called in I don't know
if a user wants me to add or subtract days. I'm just given the number of days
that need to be either added or subtracted from the
On Aug 23, 2005, at 10:20 AM, Sunil Vishwas wrote:
I was looking into the storage requirement for the various data types
and
got confused by following comment:
'For the CHAR, VARCHAR, and TEXT types, L and M in the preceding table
should be interpreted as number of bytes before MySQL 4.1 and a
[snip]
Unfortunately the item field has got data with quotes around it. IE
"KP-00310". I
need to clean up the data and have the field contain just KP-00310.
Since I
have
10,000 records, I need a update statement or something to clean that up.
Any ideas ?
[/snip]
http://dev.mysql.com/doc/mysql/en
Hi,
When I run a Perl script that uses DBI and DBD::mysql on a RHEL 3 machine,
I got this error:
==
Can't load
'/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so'
for module DBD::mysql: libmysqlclient.so.10: cannot open shared object
file: No such file or directory
Greetings,
I have a table in my database called item. It has two fields: item and
description.
Unfortunately the item field has got data with quotes around it. IE
"KP-00310". I
need to clean up the data and have the field contain just KP-00310. Since I
have
10,000 records, I need a update state
This is my sample error in my MySQL Log
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the pro
did you start mysql with --initial ??
Dotan Cohen wrote:
Hi list,
I just setup mysql and apache on my Fedora Core 4 machine. I intend to
use MySQL through php. I understand that I must first create a user,
but I can't find out how! Even on the mysql site the tutorial starts
off assuming that
Hi list,
I just setup mysql and apache on my Fedora Core 4 machine. I intend to
use MySQL through php. I understand that I must first create a user,
but I can't find out how! Even on the mysql site the tutorial starts
off assuming that there is already a user created. I have tried
googleing for mys
Hello
See some of this:
MySQL Snap 2.1
http://3d2f.com/programs/2-075-mysql-snap-download.shtml
Backup Watcher for MySQL 1.8.3
http://3d2f.com/programs/4-919-backup-watcher-for-mysql-download.shtml
MySQL Dump Timer 1.2.4
http://3d2f.com/programs/12-670-mysql-dump-timer-download.shtml
MySQLBackup
Hello
P> I'm using QT4.0 which works with MinGW.
What is the MinGW ? Database server?
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/
--
MySQL General Mailing List
For list archi
I was looking into the storage requirement for the various data types
and
got confused by following comment:
'For the CHAR, VARCHAR, and TEXT types, L and M in the preceding table
should be interpreted as number of bytes before MySQL 4.1 and as number
of
characters thereafter.'
Then I looked into
Could you post your local mods and versions, if you need this, then others
may too. Did you file a bug with redhat?
I am making the openssl-0.9.8-0 rpms right now.
rpmbuild -ta openssl-0.9.8.tgz
table for you to fill in:
package version reason
--- ---
Yes. I installed zlib in /usr/local/zlib and openssl in
/usr/local/openssl. I then added /usr/local/zlib/lib and
/usr/local/openssl/lib to the /etc/ld.so.conf file and ran ldconfig.
It still was giving me errors. So I had to manually add the paths to the
Makefiles and it worked.
Enrique Sanc
I couldn't find the an rpm for the lastest version of zlib, openssl, etc...
I could use the mysql rpm but does it have all of the features and
extras in it or does it come barebone? Does it know where to look for
all of the necessary libraries and includes? I have never ventured into
the rpm r
did u add the directories where the SSL and others
live in /etc/ld.so.conf, then run ldconfig ? I believe
this is the path were ReaHat stores what directories
to search for libraries.
regards,
esv.
--- RedRed!com IT Department <[EMAIL PROTECTED]>
wrote:
>
> Now that I'm done. I have looked
Just curious, why not use the rpm to install?
We use RHEL3 and RHEL4 here, every thing is done by rpm.
Is something missing? If so could you let us know, I would like to get the
rpms patched.
-Jason Pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-
Maybe I am taking your rant the wrong way, and I apologize if I am, but:
You've seen what all the time?
I'm using RHEL because the I can't find drivers for RH7.3 for the new
Dell servers (raid controllers, etc...) we bought. I don't want or need
the support from RedHat but we had to buy RHEL
Thanks a ton Shawn, very illuminating. Will try this tomorrow with good hope. :)
BR /Kenneth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 23 augusti 2005 16:50
To: Lindh Kenneth
Cc: mysql@lists.mysql.com
Subject: Re: The table '' is full
"Lindh Kenn
John thegimper wrote:
Ok how can i mix boolean and regexp searches?
SELECT * FROM tbl WHERE MATCH (name) AGAINST ('TEST' IN BOOLEAN MODE) OR name
REGEXP 'TEST';
That dont work :(
"That dont work" does not provide any useful information on which to base a
reply. We aren't mind readers. If
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/full-table.html
Your MySQL version is rather old, upgrade to 5.0.11.
"Lindh Kenneth" <[EMAIL PROTECTED]> wrote:
> When I run a query I get this error-message. It doesn't say which table, =
> but I checked all my tables and n
Hello.
Use mysqldump, but be aware of incompatibles between 4.0 and 4.1:
http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html
Rafal Kedziorski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> we have an J2EE application which ist using MySQL 4.0. There is an
> bug, which was fixed in MySQL
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
G
[snip]
I need some help with a MySQL query using PHP can someone help please?
[/snip]
First of all, do not threadjack. Start a new thread to the list with
your request.
Second, sending a general request like this will likely get you flamed.
Usually I am pretty good at flaming folks, but today I h
OK, I *DID* have a major cut and past mistake. In Part A the terms in
parentheses in the first CREATE...SELECT... statement should either be
erased or delimited as comments (your choice)
[EMAIL PROTECTED] wrote on 08/23/2005 10:49:33 AM:
>
> /* part A - collect the 'required' information */
I need some help with a MySQL query using PHP can someone help please?
Andrew
>
> Have you adjusted your queries? MSSQL uses a different dialect (T-SQL),
> then MySQL uses. There are quite some difference, although some queries
> still might work.
>
> Arjan.
>
>
> -Original Message-
> F
"Lindh Kenneth" <[EMAIL PROTECTED]> wrote on 08/23/2005
07:52:23 AM:
> When I run a query I get this error-message. It doesn't say which
> table, but I checked all my tables and none is near max_table_size.
> We have MyISAM-tables and we're using version: 5.0.4
> Any ideas?
>
> BR /Kenneth
>
>
Sorry for replying to my own post, but here is the manual page of PHP
about mysql functions: http://www.php.net/mysql and specificly to
mysql_connect: http://www.php.net/manual/en/function.mysql-connect.php
Nuno Pereira wrote:
Martin Olsson wrote:
Hi,
I'm using PHP/MySQL to development a we
At 15:30 23.08.2005, Jason Pyeron wrote:
Would I be correct in assuming you need to minimize down time on a
productions system? Or are you just asking how to upgrade?
Correct, I wan't minimize downtime :)
Regards,
Rafal
On Tue, 23 Aug 2005, Rafal Kedziorski wrote:
Hi,
we have an J2EE app
On Tue, 23 Aug 2005, Jeremiah Gowdy wrote:
The limit you are running into is the maxdsiz or max data size for a process.
It is defaulting to 512MB. In FreeBSD 5.x you don't have to recompile your
kernel to set a different maxdsiz. See /boot/defaults/loader.conf. Putting
kern.maxdsiz="107374
Martin Olsson wrote:
Hi,
I'm using PHP/MySQL to development a web-based application. I just
upgraded both PHP and MySQL and I noticed that some of my MySQL calls
are now broken and I don't see any easy way to fix them.
My script calls mysql_connect() and does very careful error checking.
It
AFAIK, to move the data from one InnoDB file to one table per file,
the only option is to dump and restore.
(you may want to remove index, and foreign key checks before the
restore, and put it back afterwards)
2005/8/23, Rafal Kedziorski <[EMAIL PROTECTED]>:
> Hi,
>
> we have an J2EE application
Would I be correct in assuming you need to minimize down time on a
productions system? Or are you just asking how to upgrade?
On Tue, 23 Aug 2005, Rafal Kedziorski wrote:
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an bug, which
was fixed in MySQL 4.1. We are using tr
The limit you are running into is the maxdsiz or max data size for a
process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to
recompile your kernel to set a different maxdsiz. See
/boot/defaults/loader.conf. Putting kern.maxdsiz="1073741824" in
/boot/loader.conf should work.
T
Hi,
we have an J2EE application which ist using MySQL 4.0. There is an
bug, which was fixed in MySQL 4.1. We are using tracactions and
InnoDB is don't use query cache. Now we have to migrate our DB to
MySQL 4.1 for use this feature. In our actual installation we store
our data in one inndodb
SUMMARY
While I am fairly certain the problem is with FreeBSD, since this is
InnoDB/MySQL related, I thought I would post here to see if others have had
this problem. I have googled several different phrases to find this answer
-- how does FreeBSD 5 set resource limits, and how do I override them
When I run a query I get this error-message. It doesn't say which table, but I
checked all my tables and none is near max_table_size.
We have MyISAM-tables and we're using version: 5.0.4
Any ideas?
BR /Kenneth
This query works:
SELECT
Pooly wrote:
Hello,
I'm using QT4.0 which works with MinGW. Now I want to use the MySQL
API, but it seems to be only working with MS VC++. Should I recompile
my own ? Is there any official MinGw libmysqlclient.dll ?
I have lot of trouble with it, It compiles and links OK but calling any
func
Hello,
I'm using QT4.0 which works with MinGW. Now I want to use the MySQL
API, but it seems to be only working with MS VC++. Should I recompile
my own ? Is there any official MinGw libmysqlclient.dll ?
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archi
63 matches
Mail list logo
