Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
41110/8/200511.52
51210/8/2005
Gobi wrote:
Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
41110/8/200511.52
512
Marc Pidoux wrote:
I've been using ASP for years but I have to work on a bigger project
involving many users and data so of course, Access is not an option
anymore. Since it's a project requiring thousand of files and several
applications all linked together, I can't create it once and change
Scott Haneda wrote:
I have a field `fedex`, in it is text date, in tab sep \n delimeted form,
for example:
90FedEx Home Delivery (Residential) 14.06
20FedEx Express Saver 22.63
(...)
Is there some way I can do some string parsing on the text field and get to
the
Arno Coetzee wrote:
Gobi wrote:
Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
41110/8/2005
Gobi wrote:
Arno Coetzee wrote:
Gobi wrote:
Not sure if this is the right place to ask. I have a table, Weight,
with the following test data:
idx VBS_ID DateWeight
11110/3/200511.5
2119/5/2004 10
31110/7/200511.51
4
[EMAIL PROTECTED] wrote:
Jigal van Hemert [EMAIL PROTECTED] wrote on 11/02/2005 03:29:14 AM:
If I understand
http://dev.mysql.com/doc/refman/5.0/en/table-and-index.html
correctly, the index of the primary key is stored as the clustered index
together with the data. To me this means that
Hi Gobi,
there was a similar posting in august.
See:
http://lists.mysql.com/mysql/187436
which I think describes what you want.
I'll include a bit of it here as well
--
This is out of the MySQL class and is called the Max-Concat trick.
Johan Höök wrote:
Hi Gobi,
there was a similar posting in august.
See:
http://lists.mysql.com/mysql/187436
which I think describes what you want.
I'll include a bit of it here as well
--
This is out of the MySQL class and is called the Max-Concat trick.
Johan Höök wrote:
Hi Gobi,
there was a similar posting in august.
See:
http://lists.mysql.com/mysql/187436
which I think describes what you want.
I'll include a bit of it here as well
--
This is out of the MySQL class and is called the Max-Concat trick.
Hi Gobi,
the problem with your original query is that there is no
guarantee that your max(date) and it's associated VBS_ID
is picked, so what you have to ensure is that they get picked
together, so I think your statement should be like this:
SELECT VBS_ID,
SUBSTRING( MAX( CONCAT( LPAD(
Hello.
Reading these parts of the manual could answer a lot of questions:
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
http://dev.mysql.com/doc/refman/5.0/en/GRANT.html
Xiaobo Chen wrote:
Hi, all
I am trying to find out how to check which user is connecting to
Hi Jigal, all!
Jigal van Hemert wrote:
[[...]]
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do the job.
^^
No flame war
Dear Tracy,
Tracy wrote:
Dear sir,
I am trying to uninstall my old Mysql version 4.0, however, I don't know
how to. Please give me some directions on how to do that.
You have a very high trust in the capabilities of our crystal balls ...
For a question like this, you should definitely _at
I would venture to guess that support was the issue. That would make a fair
comparison.
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: Joerg Bruehe [EMAIL PROTECTED]
Sent: 11/04/2005 06:28 AM
To: Jigal van Hemert [EMAIL PROTECTED]
Cc:
Hi Joerg (and other list readers),
Joerg Bruehe wrote:
Jigal van Hemert wrote:
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do the job.
2005/11/4, Marc Pidoux [EMAIL PROTECTED]:
I've been using ASP for years but I have to work on a bigger project
involving many users and data so of course, Access is not an option
anymore. Since it's a project requiring thousand of files and several
applications all linked together, I can't
My turn to chime in on this one...
I have been using ASP/MySQL on a Windows AND Linux box without any issues.
Yes, that's right, ASP, with the right 3rd party software, can even run on
Linux. (Don't ask Why??, just note that it can be done!)
As long as you create a system DSN (IMOH, the easiest
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a problem
with the new release.
I have this table...
provasql CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr` varchar(50) default NULL,
PRIMARY KEY (`idrow`)
) ENGINE=InnoDB DEFAULT
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a problem
with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr` varchar(50) default NULL,
PRIMARY KEY (`idrow`)
) ENGINE=InnoDB DEFAULT
I spent several minutes looking at your question and your data model and
nothing jumped out at me that precluded you from determining the quantity of
the this vendor's items sold via this data model. I might have missed
something though.
I'm a little concerned that your LineItem table appeared to
I was working on Php web page and attemtped to use stored procedure.
Last night on Php line, they said that I should consider MySQLi and to
ask MySQL list about it. Do anyone know anything about executing a
stored procedure from php page? Something to do with interface or?
Do I need something
Hello folks,
When I arrived at work this morning I noticed an oh-so-fun email from
cron reporting that chkrootkit had found a hidden process. After a good
hour of research (and some replaced binaries, of course) I came to the
conclusion that it was a false positive.
Although, while
I would first try refactoring your SQL to use INNER JOIN statements
instead of the comma separated lists you are currently using. I would also
not use any subqueries. Test this and see if it works for you:
SELECT SUM(li.quantity) as qtysoldytd
FROM LineItem li
INNER JOIN Sales sa
on
Jigal van Hemert wrote:
Hi Joerg (and other list readers),
Joerg Bruehe wrote:
Jigal van Hemert wrote:
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared
to Linux/Apache/MySQL/PHP (aka LAMP).
You could always run MySQL on Windows Server along with your IIS and
ASP. You
In MS Access, linked tables (not imported tables) are live with the
backend. If you change something in a linked table, that change
automatically propogates to the origin of the link and changes the source
of the data. Try setting up your tables as linked tables and see if it
helps.
Shawn
Jigal van Hemert [EMAIL PROTECTED] wrote on 11/04/2005 03:09:58 AM:
Marc Pidoux wrote:
I've been using ASP for years but I have to work on a bigger project
involving many users and data so of course, Access is not an option
anymore. Since it's a project requiring thousand of files and
I also have the same problem upgrading from 4.1.15 to 5.0.15; this query
hang mysql:
INSERT DELAYED INTO phpads_adstats SET clicks = 0, views = 1, day =
NOW(), hour = HOUR(NOW()), bannerid = '97', zoneid = '15', source = ''
This is happening with every linux mysql 5.0.15 binary distribuition
On Friday 04 November 2005 08:06 am, Chris Wells wrote:
/usr/lib/chkrootkit/chkproc -v -v
PID 1230(/proc/1230): not in readdir output
PID 1230: not in ps output
CWD 1230: /var/lib/mysql
EXE 1230: /usr/sbin/mysqld
... (report the same for 1231 - 1238)
You have 9 process hidden for
On Friday 04 November 2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote:
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a
problem with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr`
Jeff Smelser wrote:
On Friday 04 November 2005 08:06 am, Chris Wells wrote:
/usr/lib/chkrootkit/chkproc -v -v
PID 1230(/proc/1230): not in readdir output
PID 1230: not in ps output
CWD 1230: /var/lib/mysql
EXE 1230: /usr/sbin/mysqld
... (report the same for 1231 - 1238)
You have 9
For a while my application should support both mysql 4 and 5 ( teh same copy
on different sites of course ) so I should keep using a soluting wich should
works well on both revision.
I also have a couple of server with their database configured as master
slave, so I don't trust to use
I am just learning PHP/MySQL, so please forgive if this is a
ridiculously lame question.
I have developed a small web app to simply display information from the
database. The page will refresh itself every 60 seconds (plus the time
it takes to perform the refresh itself). The data in the db is
Dears sirs,
please, how to correct this problems :
*mysql.user table is not updated to new password format; Disabling new
password usage until mysql_fix_privilege_tables is run
051104 15:40:25 [Warning] Can't open and lock time zone table: La table '
mysql.time_zone_leap_second' n'existe pas
My organization runs an online auction on our intranet server for the United
Way. I'm having a hard time printing out a list of the winning bidders (I'm
under a lot of pressure; the baked goods are getting stale).
In these examples, I've just printed out my bidder's first names, to protect
Hi everybody!
It seems like different instances of MySQL do things in different order, with
rather unfortunate effects on the last_insert_ID function.
Consider the following tables and insertions:
create table parent (
ID int unsigned not null auto_increment,
value varchar(50),
primary
Figured out the query:
select idx, vbs_id, date, weight from Weight,
(select vbs_id as maxid, max(date) as maxdate from Weight group by
vbs_id) as t
where vbs_id = maxid and date = maxdate;
It returns the proper weight and idx.
--
MySQL General Mailing List
For list archives:
I was using MySQL 4.1 and have a Users table where I store the UserID
and the corresponding password using the following:
Insert into Users (UserID, Password) values ('someid', password(somepw));
and when people login, I would query using:
Select * from Users where UserID = 'someid' and
KEVIN ZEMBOWER [EMAIL PROTECTED] wrote on 11/04/2005 11:05:05 AM:
My organization runs an online auction on our intranet server for
the United Way. I'm having a hard time printing out a list of the
winning bidders (I'm under a lot of pressure; the baked goods are
getting stale).
In
[EMAIL PROTECTED] wrote on 11/04/2005 11:22:35 AM:
This is such a FAQ that they put the answer in the manual:
http://dev.mysql.com/doc/refman/5.0/en/index.html
OOPS! I copied the wrong link. It should have been:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
Gobi wrote:
I was using MySQL 4.1 and have a Users table where I store the UserID
and the corresponding password using the following:
Insert into Users (UserID, Password) values ('someid', password(somepw));
and when people login, I would query using:
Select * from Users where UserID =
Sylvie,
*mysql.user table is not updated to new password format; Disabling
new
password usage until mysql_fix_privilege_tables is run
051104 15:40:25 [Warning] Can't open and lock time zone table: La
table '
mysql.time_zone_leap_second' n'existe pas trying to live without
them
Marc,
I've been using ASP for years but I have to work on a bigger project
involving many
users and data so of course, Access is not an option anymore. Since
it's a project requiring
thousand of files and several applications all linked together, I
can't create it once and change
it later.
Man, you're awesome. Only two typos in the whole procedure. However, for the
life of me, I'm puzzled over how it works. If you have more patience can you
explain?
Correct query (table is singular, not PHPAUCTIONS_...):
CREATE TEMPORARY TABLE tmpWinners SELECT auction, max(bid) as winningbid
Description:
INSERT DELAYED crashes my new mysqld. Here is the error log:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be
I have used both and I prefer php/mysql
:-)
On 11/4/05, Peter Brawley [EMAIL PROTECTED] wrote:
Marc,
I've been using ASP for years but I have to work on a bigger project
involving many
users and data so of course, Access is not an option anymore. Since
it's a project requiring
thousand
Me, too. One thing that's a plus for my clients is to tell them that is
will cost them less if I develop in php/mysql as opposed to ASP/MSSQL.
Hosting is cheaper and I can do things in PHP that takes 5 lines as opposed
to ASP/MSSQL which takes 20. heh
Jenifer
- Original Message -
select ( select max(c.idrow)+1 from provasql c ) , 'This is only a test';
Does changing max(c.idrow)+1 to coalesce(max(c.idrow),0)+1 solve
your problem?
--Pete
On Fri, Nov 04, 2005 at 04:56:26PM +0100, AESYS S.p.A. [Enzo Arlati] wrote:
For a while my application should support both
How it works...
KEVIN ZEMBOWER [EMAIL PROTECTED] wrote on 11/04/2005 12:40:50 PM:
Man, you're awesome. Only two typos in the whole procedure. However,
for the life of me, I'm puzzled over how it works. If you have more
patience can you explain?
Correct query (table is singular, not
Oops, I meant to post this on the list AND copy the person asking the
question
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Gobi [EMAIL PROTECTED]
Sent: Friday, November 04, 2005 1:46 PM
Subject: Re: Help with an SQL query
I can't test this in MySQL- I'm using an
All,
I need help with using load data to load a text file that is created by another
application.
I have a text file that contains 2 columns, date and smallint and 2 rows:
d,e
2005-12-31,
,2
In the above example the first row, column e should be NULL and the second row
column d should be
After reading one of the recent posts from Gobi [EMAIL PROTECTED]
I took his successful query and modified it for one of my tables. It indeed
produce the correct result, but in the process raised some questions.
1. Why do list_ID and acct_ID not have to be qualified with a table
name
Hi
Will be installing MySQL 4.0.26 in order to be compatible with my Internet
Service Provider (my internet connection)who has MySQL 4.0.24.
On MySQL site there is two version of 4.0.26, they are:
Linux (x86, glibc-2.3, dynamic, gcc)
Linux (x86, glibc-2.2, static (Standard
I don't have any idea about your second question but I have a thought on the
first one.
In DB2, which I use most of the time, you don't need to qualify a column
name like list_ID or acct_ID unless it is ambiguous. In this case, neither
one is ambiguous because both get used in single-table SELECT
I need to rename a database. I read somewhere that I could simply stop the
MySQL database server and rename the folder that contains the data, re-start
MySQL, and I'm good-to-go. However, I tried this, and while it appears to
have worked initially, when I try to access one of the tables in the
I am converting a MS SQL Server ASP application over to use MySQL. I have
two simple stored procedures that I need to convert. I have very little
experience with MS SQL stored procedures, and none-what-so-ever with stored
procedures in MySQL, so I really don't know what this should look like. I'll
I'm converting an application from SQL Server to MySQL. I have the
following query that I need to convert:
SELECT A.*, CO = CASE CounselorOnly WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END
FROM Activities a ORDER BY Activity
What is the proper syntax for this in MySQL?
Thanks,
Jesse
--
MySQL
If your MySQL server is a *nix system than table names are case
sensitive.
SELECT A.*,
CASE CounselorOnly
WHEN 1 THEN 'Yes'
WHEN 0 THEN 'No'
END AS CO
FROM Activities A
ORDER BY Activity
I also just noticed, remove the CO = and add AS CO following the END
of
Jesse,
I need to rename a database. I read somewhere that I could simply stop the
MySQL database server and rename the folder that contains the data,
re-start
MySQL, and I'm good-to-go. However, I tried this, and while it appears to
have worked initially, when I try to access one of the tables
Heikki,
I am about to start a large MySQL project that requires transactions and I
need to know if InnoDb will be around for MySQL after MySQL's license for
InnoDb runs out in 2006. If yes, will you still be supporting it or will
it be up to MySQL AB?
TIA
Mike
--
MySQL General Mailing
Jesse,
VALUES (cFirstName, cLastName, cUserName, cPassword) // error on this
line.
return LAST_INSERT_ID() /*@@Identity*/
END
When I execute this, It bombs on the indicated line stating that there
is a
syntax error.
A stored procedure cannot return a value.
PB
-
Jesse Castleberry
OK, Shawn, nice tip.
I really didn't know if it was actually performed by server or by client.
But I'll study the MySQL client protocols.
But it is still strange and needs investigation, because as I remember, I've
submit a prove fire to the oracle server. The prove was:
I've sent a really really
At 23:06 -0300 11/4/05, Fabricio Mota wrote:
OK, Shawn, nice tip.
I really didn't know if it was actually performed by server or by client.
But I'll study the MySQL client protocols.
But it is still strange and needs investigation, because as I remember, I've
submit a prove fire to the oracle
Mike,
- Original Message -
From: mos [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, November 05, 2005 12:11 AM
Subject: Heikki: What will become of InnoDb once MySQL license runs out
Heikki,
I am about to start a large MySQL project that requires transactions
To Mysql users:
Just to remind you all, Oracle is a
business that expects to make money. As you all know, Mysql is a
threat to the fat cats such as Oracle,DB2,MSSql and others. If you
think Oracle is going to play fair with us then you will believe that
crack will
Last one people:
I just realized that Heikki is
monitoring our post pertaining to innodb. This guy/gal is an oracle
employee. The enemy is amongst us. Beware. Haha Haha
Ezra
On 11/4/05, Ezra Taylor [EMAIL PROTECTED] wrote:
To Mysql users:
There is always Postgres if you're that paranoid ;-)
--Harry
Ezra Taylor wrote:
Last one people:
I just realized that Heikki is
monitoring our post pertaining to innodb. This guy/gal is an oracle
employee. The enemy is amongst us. Beware. Haha Haha
Ezra
There are several opinions... I would like to forecast the real intentions
of Oracle...
FM
-Mensagem original-
De: Ezra Taylor [mailto:[EMAIL PROTECTED]
Enviada em: sexta-feira, 4 de novembro de 2005 23:46
Cc: mysql@lists.mysql.com
Assunto: Re: Heikki: What will become of InnoDb once
When I log in as root using:
mysql -u root -p mysql
I get the mysql prompt:
mysql
I then issue this command or statement:
mysqlGRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED BY
'some_password' WITH GRANT OPTION;
I get the following returned:
Query OK, 0 rows affected (0.00 sec)
At 21:49 -0500 11/4/05, Ezra Taylor wrote:
Last one people:
I just realized that Heikki is
monitoring our post pertaining to innodb. This guy/gal is an oracle
employee. The enemy is amongst us. Beware. Haha Haha
Ezra
Ezra,
Your basis for claiming that Heikki
This simple find is taking 4 to 7 seconds. Way too long!! (This is a
geotargeting query using the database from IP2location.)
select lat,lon from geocodes where ipFROM=1173020467 and
ipTO=1173020467
The database looks like this (how IP2location recommends):
CREATE TABLE `geocodes` (
Relax Paul:
If you noticed it put the words Haha Haha at the
end of my statement. Anyway, as I said, Oracle is out to make money.
They will crush anyone that gets in there way.
Ezra
On 11/4/05, Paul DuBois [EMAIL PROTECTED] wrote:
At 21:49 -0500 11/4/05, Ezra Taylor wrote:
Brian Dunning [EMAIL PROTECTED] wrote on 11/04/2005 10:36:00 PM:
This simple find is taking 4 to 7 seconds. Way too long!! (This is a
geotargeting query using the database from IP2location.)
select lat,lon from geocodes where ipFROM=1173020467 and
ipTO=1173020467
The database looks
I'm using PHP Version 4.3.9 and MySQL 4.1.12. I recently upgraded from
PHP 4.1.x and MySQL 4.0.x.
Basically my SQL worked until my upgrade. ORDER BY relevancy DESC no longer
works?
SELECT *,MATCH (AU,ST,SD)
AGAINST ('johnston' IN BOOLEAN MODE)
AS relevancy FROM ccl.ccl_main
WHERE MATCH
74 matches
Mail list logo