On 18-Jun-2003 Becoming Digital wrote:
...
>> if(!mysql_query($array[$i])) {
>> $flag = false;
>>break;
>> }
>>
>> after the loop I do
>> if($flag)
>> mysql_query("commit");
>> else
>> mysql_query("rollback");
>
> Be careful with that last if() statement. I would either change the
>
Hi List
Is there any way to get an estimate of the release date of the next
stable version of MySQL? The reason I'm asking; I am currently busy
configuring new webservers, but it is not crucial as to the exact time I
deploy them ( they will replace currently running servers), so if I knew
4.1 woul
> You have to implement the view functionailty in code. Or maybe someone
> else has a better suggestion :)
There are PHP classes that create "views." Check the Repository for them.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Oh Chye Yong" <[EMAI
Sorry, but what did dou mean with 'Are you still using VisualFoxPro...'?
:)
Mensaje citado por: "Ruiz González, Jose de Jesus" <[EMAIL PROTECTED]>:
> Are you still using VisualFoxPro as the programmig language in your
> project?
> If so, you can use SQL functions from VisualFoxPro to connect to m
View is not supported in MySQL version 4.x. You have to wait for version 5.
You have to implement the view functionailty in code. Or maybe someone
else has a better suggestion :)
OH Chye Yong
Software Engineer
OpenFeel Pte Ltd
Web: http://www.openfeel.com/
Email: [EMAIL PROTECTED]
Tel: (+65) 633
> if(!mysql_query($array[$i])) {
> $flag = false;
>break;
> }
>
> after the loop I do
> if($flag)
> mysql_query("commit");
> else
> mysql_query("rollback");
Be careful with that last if() statement. I would either change the script to
read '$flag = true' or 'if( isset($flag) )'
It's qu
Hi,
I am trying to install MySQL 3.23 to Solaris 2.8.
After the step -> scripts/mysql_install_db
I try the command -> chown -R root, error show "usage: chown [-fhR] owner[:group]
file..."
and the command -> chrgrp -R mysql, error show "chgrp [-fhR] group file..."
Do i need to groupadd for the roo
At 01:54 PM 6/17/2003 -0400, Michael Cortes wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello. I am a new member to this list. I would like to run an sql query
as a
cron job and can't figure out how. Here is some background.
I have mysql loaded on several of our linux servers. I curr
If not, is there a way to get the same effect in MySQL?
Thanks in advance,
Lingua
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Description:
1: running safe_mysqld it just stops at end of statement
bash-2.05a# safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
030618 10:09:11 mysqld ended
2:running mysql -u root
bash-2.05a# mysql -u root
ERROR 2002: Can't connect to local MySQL server throug
Hi
Interesting ...
The argument usually used by people looking for
- triggers
- functions + procedures
- foriegn keys
is the persuit of data integrity, and encapsulating business logic within the
database.
Whilst this goal is noble, it can be fully achieved within the application
code, and
On Tue, Jun 17, 2003 at 10:47:03AM +0900, Nils Valentin wrote:
> Hi Jonas,
>
> don't get me wrong, but I strongly believe there is some (not a lot) of
> advanced documentation around, the point is that it is spread all over the
> place. MySQL's documentation is anything but complete yet, so you
On Mon, Jun 16, 2003 at 01:05:22PM -0700, Jonas Geiregat wrote:
>
> I've been learning sql using mysql. Now I got the basics. But I'm
> stuck I want to learn more advanced things, and since all the site's
> I know handle mysql stuff with php it doesn't get really advanced.
> Anyone knows any good r
I noticed from the example given by William Mussatto that I needed to
include the Port Number on the URL. Yes, I am a Linux idiotbut
hopefully learning as I go.
Thank you, everyone.
This list is awesome!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
On Tue, Jun 17, 2003 at 03:08:37PM -0500, Jay Blanchard wrote:
> Is anyone else seeing a long turn-around time with their messages going
> to the MySQL list or do I need to check my local mail server (which has
> experienced some hiccups the past couple of days)?
It doesn't seem to have been that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Weeks wrote:
> I can't access MySQL using Java on Linux! It's killing my project. I
> can access that very MySQL from PHP just fine. I have the same
> database running on Windows so I can develop what I need to. Just can't
> run anything fo
> I can't access MySQL using Java on Linux! It's killing my project. I
> can access that very MySQL from PHP just fine. I have the same
> database running on Windows so I can develop what I need to. Just
> can't run anything for our users!!!
>
> I don't think it's the firewall because I get t
At 05:59 PM 6/17/2003 -0700, Jeff Weeks wrote:
I can't access MySQL using Java on Linux! It's killing my project. I
can access that very MySQL from PHP just fine. I have the same database
running on Windows so I can develop what I need to. Just can't run
anything for our users!!!
I don't
I can't access MySQL using Java on Linux! It's killing my project. I
can access that very MySQL from PHP just fine. I have the same
database running on Windows so I can develop what I need to. Just
can't run anything for our users!!!
I don't think it's the firewall because I get the same
the main reason I might suggest NOT to do this is a data integrity one.
As long as someone can go in through a mysql prompt and touch data, PHP
or ASP will do you no good.
Data integrity checks should, in so far as possible, always be put into
the schema, and not in an API.
just my two cents ..
On Tue, Jun 17, 2003 at 07:50:08PM +0300, Primaria Falticeni wrote:
> Why nobody answered me?
I didn't see your post. Very few people have the time to read
everthing posted to this list.
> 2. How could I make accumulated sums in MySQL (described in the actual
> forwarded message)
>
>
> - O
Is anyone else seeing a long turn-around time with their messages going
to the MySQL list or do I need to check my local mail server (which has
experienced some hiccups the past couple of days)?
Thanks!
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Hi,
On the "CREATE TABLE" statement some mistake in syntax is not reported.
STATEMENT:
CUT-
---
CREATE TABLE prodconfirm(IDPC INT(16) AUTO_INCREMENT
> Folks PHP is available from the command line...we
> use it for triggers and stored procedures all the time.
Most people I've spoken too are either not aware of or not comfortable with CLI
PHP. I can't explain why, but I've almost given up on suggesting it.
Edward Dudlik
Becoming Digital
www.be
At 02:46 PM 6/17/2003 -0400, Kerry Colligan wrote:
I think I mentioned this. The problem is, I need reproducible results from
both web interface AND command line. If I implement the triggers in PHP, I
only get the results from the web.
I would recommend that you build application objects in java to
Thank you very much!
I was worried because I posted the first question about a week ago twice.
And guess why I am interested in 5.0? Because of the sweet triggers. I
compiled the rest of the folders of 5.0 version.
I like this list and MySQL.
Respectfully Yours,
Iulian
- Original Message
I like triggers and I'm anxiously waiting for them but only when the 5.0
version will be for production.
I spoke from the risk point of view of a new version.
Also, in C/C++ we can make precompiled triggers which can hide the tables
only until the MySQL 5.0 version will be ready.
The server-side
[snip]
There are a few MySQL trigger-emulation classes in the PHP Classes
Repository, too, taking away some of the development work.
Unfortunately, these won't work from the command line, so perhaps that's
why the
original poster hasn't taken this route.
[/snip]
Why will they not work from the com
Your thinking on access points and validation are correct.
Based on the response below, would you suggest using CGI/mod_perl to run the
web-end? Am I correct in thinking I'll need to update to 4.1 for
transactional support in order to make this work appropriately? Finally, any
suggestions for forw
I'm trying to implement transaction (mysql) in my php code. Could anyone
tell me if this is a good way of using them. I make an array with all
the query's I loop through them. like this mysql_query($qarray[$i])or
die($flag = false);. After the loop I do if($flag) commit; else rollback;
Is this a
Becoming Digital wrote:
I found one item in the PHP Classes Repository that may be of use.
Unfortunately, the comments are in Spanish, so it's up to you to
figure out the
code.
http://promoxy.mirrors.phpclasses.org/browse.html/file/3077.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Use PERL to make a script which acts like a trigger. It can be launched from
the command line.
Iulian
- Original Message -
From: "Kerry Colligan" <[EMAIL PROTECTED]>
To: "MySQL LIST" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 9:46 PM
Subject: RE: Triggers
> I think I mentioned thi
Becoming Digital wrote:
I found one item in the PHP Classes Repository that may be of use.
Unfortunately, the comments are in Spanish, so it's up to you to figure out the
code.
http://promoxy.mirrors.phpclasses.org/browse.html/file/3077.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
-
Shane Bryldt wrote:
Just a thought, what about encryption of passwords? Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
No, it should not.
Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your probl
Hello Shane,
> I found nothing better than the standard
> MySQL C API standard with MySQL.
That's true. I read it now i find it very easy in comparison to the C++
documents.
This one reminds me of PHP functions a lot.
> I have made 2 such classes, which are quite
> simple, not a significant ammo
# [EMAIL PROTECTED] / 2003-06-17 21:28:12 +0300:
> From: "Kerry Colligan" <[EMAIL PROTECTED]>
> > I see that 5.x will support triggers. Does anyone have any advice for
> > implementation of triggers on the DB? I will need to be able to utilize
> > them from web applications AND from command-line ty
This is a good point, my last post was under the assumption that your ISP
did not firewall any ports, since you are on a static IP, that suggests a
server package with no restrictions on hosting. If so, and you are in fact
running the MySQL on the machine directly live on the internet with no
fire
[snip]
I think I mentioned this. The problem is, I need reproducible results
from
both web interface AND command line. If I implement the triggers in PHP,
I
only get the results from the web.
[/snip]
Bt!
Nope, you can use PHP CLI (command line interface) where PHP scripts can
be run from t
> After I set starttime to now(), anytime I run another update query against
> the row starttime changes to a new value.
If starttime is the timestamp data type, and the first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected behav
> mysql> SELECT CONCAT(LEFT(@v, 4), 'e', SUBSTRING_INDEX(@v, 'e', -1)) as v;
Nice job. The only problem now is that the result doesn't round properly.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Don Read" <[EMAIL PROTECTED]>
To: "Paula R. T. Coel
> Why nobody answered me?
> I posted two questions on this list.
> 1. I have a problem with MySQL 5.0 Tree compiling. The configure after I
> launched configure.in made an error.
Probably because there are very few people using MySQL 5.0 and we don't have an
answer.
> 2. How could I make accumul
We recently bought a kick $%#%% machine for ~10k
HP DL380
2x2.8GHz Xeon
1GB RAM
5 15k scsi drives (2 RAID 1 for OS and logs/3 RAID 5 for data)
RedHat Linux Enterprise Edition 2.1
This machine easily handles 200 queries/sec and never gets a load
average above 1.5. For your space requirements, yo
What version of MySQL are you running.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "John Farkas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 13:28
Subject: Open Tables
I am new to mysql so please excuse my ignorance.
That should have had a question mark.
What version of MySQL are you running?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "John Farkas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 13:28
Subject: Open Tables
I am new to
On Tue, Jun 17, 2003 at 10:52:27AM -0400, Keith C. Ivey wrote:
> It's not bad enough that we have subscribers with challenge-response
> systems misconfigured so that they respond to each message from the
> list. Now one of the list admins is apparently doing something
> similar. At present rat
> Why don't you use PHP or ASP functions on the server-side in Web page code.
> They act like a trigger and you don't need MySQL 5.0 for them.
That's an excellent suggestion. There are a few MySQL trigger-emulation classes
in the PHP Classes Repository, too, taking away some of the development wo
Thanks, Mike. I should have checked the bug database first. I thought for sure we had
it working right before, but I think someone might have snuck a newer version of the
MySQL on the server without telling me. :-)
Oh well, go figure.
-Shane
---Original Message---
From: Mike Hillyer <[
John Farkas wrote:
I am new to mysql so please excuse my ignorance.
I am running mysql on windows 2000 and have noticed that when a table is
opened to do an insert or update it is not closed after the query is
finished but is left open.
Then when I shut down the mysql server and do a myisamchk
Thanks, Mike. I should have checked the bug database first. I thought for sure we had
it working right before, but I think someone might have snuck a newer version of the
MySQL on the server without telling me. :-)
Oh well, go figure.
-Shane
---Original Message---
From: Mike Hillyer <[
That's really odd. I've never experienced that problem, but I'm running the
latest production release (4.0.13), so I perhaps it's been fixed between
versions.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Lucas Heuman" <[EMAIL PROTECTED]>
To: <[EMAIL
Since you are providing the web page, it depends on how you write the
web page.
This really isn't a MySQL question, is it?
v7rg8 wrote:
Hi all,
My table is like this:
professor(name, gender, bodyImage)
I am not sure if this is correct to set up the table:
create table professor (name char(10),
I think I mentioned this. The problem is, I need reproducible results from
both web interface AND command line. If I implement the triggers in PHP, I
only get the results from the web.
KC
-Original Message-
From: Primaria Falticeni [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 2:2
Just a thought, what about encryption of passwords? Shouldn't it be:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY
PASSWORD('password');
Not sure if that is related to the problem, but it may cause an invalid
password error.
However, your problem is most likely similar to the problem
Yes, indeed. You don't have a firewall.
But the firewall from the Internet Service Provider's computer prohibits the
access of the others users from the Internet to the port of your MySQL
server. Or you are in a private network which must use IP port forwarding to
be reached from the Internet. Talk
I found one item in the PHP Classes Repository that may be of use.
Unfortunately, the comments are in Spanish, so it's up to you to figure out the
code.
http://promoxy.mirrors.phpclasses.org/browse.html/file/3077.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message
Are you running AIX?
This problem was just addressed, and is fixed in 4.0.13
I thought it was a name resolution problem, sorry for the misdirection on
whoever had this problem earlier.
-Shane
- Original Message -
From: "Shane Kirk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tu
This is a know bug that has been addressed in version 4.0.13, you will
need to upgrade.
See http://bugs.mysql.com/bug.php?id=164
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Shane Kirk [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 12:25 PM
> To: [EMAIL P
To me the question of reliability is that of the drive, not the
interface. I cannot see SATA itself being any more or less reliable than
ATA drives. I think certain controllers will accept a new drive that has
similar characteristics as long as the replacement drive is larger than
the lost drive.
On 17 Jun 2003 at 14:05, Lucas Heuman wrote:
> After I set starttime to now(), anytime I run another update query
> against the row starttime changes to a new value.
You don't give the structure of your table, but it appears that
you're using a TIMESTAMP column, which has automatic updating by
Optimally, Yes, you should replace with exact same brand/model etc...
but you CAN replace with a different brand/ model drive of the same
amount of disk space or more. It isn't recomended (because of
different seek times, cache .. etc..) but if you are carefull and do
your research, you can get a
I am new to mysql so please excuse my ignorance.
I am running mysql on windows 2000 and have noticed that when a table is
opened to do an insert or update it is not closed after the query is
finished but is left open.
Then when I shut down the mysql server and do a myisamchk on the tables
they sh
You are absolutely correct.. I did set it to timestamp by mistake!
-//Lucas
On Tue, 17 Jun 2003, Jennifer Goodie wrote:
> > After I set starttime to now(), anytime I run another update query against
> > the row starttime changes to a new value.
>
> If starttime is the timestamp data type, and th
Why don't you use PHP or ASP functions on the server-side in Web page code.
They act like a trigger and you don't need MySQL 5.0 for them. Remember that
you can benefit from the both servers: MySQL and Web server.
- Original Message -
From: "Kerry Colligan" <[EMAIL PROTECTED]>
To: <>
Sent
Sorry I forgot to mention:
We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of
spending up to $10K.
I also wanted the redundant data for speeding up the seeks, I also need to
speed up the writes.
Bernd
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello. I am a new member to this list. I would like to run an sql query as a
cron job and can't figure out how. Here is some background.
I have mysql loaded on several of our linux servers. I currently use
mysqldump in a cron job in conjuction w
Many IDE RAID cards have a setting called gigabyte-boundry. What this means
is that it rounds down the capacity of the drive to the next gigabyte. A
120.3 gig drive becomes a 120 gig drive. This means that if you replace the
drive with a different make/model (say a 120.5 gig drive, which will be
ro
At 10:44 -0700 6/17/03, Jonas Geiregat wrote:
I'm trying to implement transaction (mysql) in my php code. Could
anyone tell me if this is a good way of using them. I make an array
with all the query's I loop through them. like this
mysql_query($qarray[$i])or die($flag = false);. After the loop I
On Tue, 2003-06-17 at 09:58, David Griffiths wrote:
> Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise SX-6000
> IDE RAID cards? Specifically for Linux. Heard bad things about Promise, good
> about 3Ware.
If I had to choose between the two, I would go with the 3wares. They
wor
> I have heard good thing about 3Ware, but I would suggest looking at the
> 8500-4 in combination with Western Digital's Raptor drive
> (http://www.tomshardware.com/storage/20030501/index.html). The Raptor is
> a 10,000 RPM SATA drive which, combined with the 8500-4 SATA Raid card
> should give ex
I see that 5.x will support triggers. Does anyone have any advice for
implementation of triggers on the DB? I will need to be able to utilize them
from web applications AND from command-line type interface. Any suggestions
welcome at this point. (RH 7.3, MySQL 3.23.56 presently)
Thanks
--
Kerry
RE: SCSI needed for best performance -
While this is true in some cases, if you are using striping or any
RAID level (RAID 5 for example) that splits reads and writes across
drives, then there will be several IDE channels feeding data to the
RAID card at a time. Two ATA100 IDE channels will accept
Alright, I was messing around with some time functions in Mysql and ran
acrossed a wierd bug.
After I set starttime to now(), anytime I run another update query against
the row starttime changes to a new value.
Here is what I did when I noticed the bug.. Does anyone else have a
problem doing thi
I have heard good thing about 3Ware, but I would suggest looking at the
8500-4 in combination with Western Digital's Raptor drive
(http://www.tomshardware.com/storage/20030501/index.html). The Raptor is
a 10,000 RPM SATA drive which, combined with the 8500-4 SATA Raid card
should give excellent pe
Im using a 3ware (which has great linux support) Escalade 7800 with 8
120GB/8MB cache ide drives in RAID 10 under Debian with 2.4.20 kernel.
I guess what we need to know is what platform and how much $$ you wanna
spend
-Original Message-
From: Bernd Jagla [mailto:[EMAIL PROTECTED]
Sent: T
Tried a Promise FastTrak 100 TX2 in a Dell; RH 7.3. Miserable. Bailed on it
after one month.
Kerry
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: RAID hardware suggestions/experience
Anyone had
Anyone had any experience with 3Ware 7500-4 IDE RAID or the Promise SX-6000
IDE RAID cards? Specifically for Linux. Heard bad things about Promise, good
about 3Ware.
David
- Original Message -
From: "Patrick Shoaf" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 9:
Why nobody answered me?
I posted two questions on this list.
1. I have a problem with MySQL 5.0 Tree compiling. The configure after I
launched configure.in made an error.
2. How could I make accumulated sums in MySQL (described in the actual
forwarded message)
- Original Message -
From: "
Hi all,
My table is like this:
professor(name, gender, bodyImage)
I am not sure if this is correct to set up the table:
create table professor (name char(10), gender char(10), bodyImage blob);
If it is correct, I was wondering how users are going to load images into the
database from the webpage
On 16-Jun-2003 Paula R. T. Coelho wrote:
> Hi,
>
> I can't format properly a double number in scientific style. The number
> is
> around 3e-32, so I need it in scientific format with 2 decimals. In a
> usual
> 'select' it comes in scientific format but with a large number of
> decimals.
> If I tr
I am using 4 120G IDE Drives with an Adaptec IDE RAID Controller on RedHat
Linux providing 240G of RAID 5 storage. While not quite as fast as SCSI, I
have found this to work very well. You should be able to pickup a nice
dual processor XENON 2.4Ghz system w/1G Ram and IDE RAID loaded with RedH
Hi there,
Our databank with all tables and idices is about 130GB big. The biggest
limitations we encounter are on the I/O side.
Therefore we are willing to update our data storage system to a RAID system
(RAID 0+1, RAID 5, or RAID 10).
Has anyone experience with such RAID systems?
What should we
> You are using "left blank" to mean "set to NULL", but many people
> would describe a last name of "" (the empty string) as blank, and
> using NOT NULL does nothing to prevent that.
Fair enough, but I see NOT NULL as just another way of preventing such errors.
It's still the programmer's responsi
I tired both statements you suggested. The update is what I would like to
use, but I got an error, ERROR 1064: You have an error in your SQL syntax
near ' sdtik set sales.sales '
I used the REPLACE command, but it had the effect of adding records for
customers not in the statistics file.
"Baris Akin" <[EMAIL PROTECTED]> wrote:
> LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every
> connection returns it's own last inserted ID not actual ID. Is this a
> bug?
No. LAST_INSERT_ID() works per-connection. It returns the last inserted auto_increment
value from current
"Murray Wells" <[EMAIL PROTECTED]> wrote:
>
> I have a local MySQL db (4.0.12) which I use for developing content for
> my web site, and my remote website MySQL db (3.23.56) which powers my
> site.
>
> I spend a fair amount of time synching individual records from my local
> db to my remote db (i
Problem solved. Thanks victoria.:)
[EMAIL PROTECTED] wrote:
Veysel Harun Sahin <[EMAIL PROTECTED]> wrote:
I am using mysql 3.23.49 on openbsd3.2 with php4.2.3. Formerly I was
connecting to mysql with php without any problem but now (I don't know
what I have changed) when I try to connect to
Hello Ryan,
Thanks for your answer.
There two boxes are used for different purposes. Say Box 1 contains
Database A which is replicated to Box 2. Box 2 contains database B which
is replicated to Box 1. So both databases are on both boxes. some
applications send update database A on Box 1. Other
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Keith C. Ivey wrote:
> It's not bad enough that we have subscribers with challenge-response
> systems misconfigured so that they respond to each message from the
> list. Now one of the list admins is apparently doing something
> similar. At present
It's not bad enough that we have subscribers with challenge-response
systems misconfigured so that they respond to each message from the
list. Now one of the list admins is apparently doing something
similar. At present rates of growth, it will be interesting to see
whether spam or anti-spam
Hello,
I need one complex query which makes partial sums on some dates.
Let's get the structure of table rates: Day Date, Amount.
01/05/20033,000
01/06/20032,000
01/09/20034,000
SELECT Day as DayF,SUM(Amount) as S_Am FROM rates GROUP BY Day
gives the list of totals each one
On 16 Jun 2003 at 19:29, Becoming Digital wrote:
> Think of the many cases in which you would not want a field left
> blank: a customer's last name or zip code, a product's name or id
> number, a payment amount. Were any of those fields allowed to be
> NULL, the system of which they are a part co
Thank you for your answer Anselme!!
I am working on Windows98. I've read some documents on mysql home page which
explain the difference between version. That information talks about some
script to be run for upgrading version but there is no related file to
download.
Could you help me??
Thank yo
On Tue, 2003-06-17 at 16:05, Manuel Diaz-Regañón wrote:
> Hi all !!
>
> I am trying to upgrade to MySql 4.0 from 3.23 version. I dont know how to
> proceed. I was looking for some files for upgrading but i found nothing. Any
> help??
>
on which os ? if it's FreeBSD, I've just done it this morning
On Tuesday 17 June 2003 03:35 am, George Chelidze wrote:
> Hello,
>
> I have two RH boxes with mysql on them and replication is enabled from
> box 1 to box 2 and from box 2 to box 1. The amount of data on each of
> them is round 400-500MB. Now I have to replace one of them with new box.
> As both b
Hi,
I have a busy MySQL slave which is directly updated
by a periodic "purge" script which throws
away irrelevant data.
Occassionally, (er, a few times a day, actually),
the slave "quietly" falls over, but ITS slaves
trip with
"[SQL...] partially completed on the master and was aborted. There
Thanks for taking the time to reply. Could you maybe elaborate and tell me
how I can make mysql the owner of the directory. (Would I also have to stop
and restart mysqld as this was part of my original problem).
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: 17 June
Hi all !!
I am trying to upgrade to MySql 4.0 from 3.23 version. I dont know how to
proceed. I was looking for some files for upgrading but i found nothing. Any
help??
Thanks
Broad Telecom S.A. (BTESA) - Spain
Manuel Díaz-Regañón
phone: 913274363
e-mail: [EMAIL PROTECTED]
--
MySQL General Mai
On Tue, Jun 17, 2003 at 04:02:46PM +0300, Baris Akin wrote:
> I try to get last inserted autoincrement record ID on table with
> LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every
> connection returns it's own last inserted ID not actual ID. Is this a
> bug? Also it returns more
Good day.
I have encount some problem when try to configure MySQL 4.0.12 source
distribution with BerkeleyDB support.
I have donwload only available BerkleyDB distribution on SleepyCat
Software server (4.1.25) and install it with default configuration.
This is configure script command line:
./co
Hi,
I am hoping you can help me please.
The following query, while valid, returns me an Empty set.
--
SELECT plan, cardNr, crdholdersName, cardType, cardExpDate,
strAddr, townCity, stateProvince, p
1 - 100 of 126 matches
Mail list logo
