hello
i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz then
try typing the command perl run-all-test
when this is error message came up. below is the error message.
install_driver(mysql) failed: Can't load
'/usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql
Dan Tappin wrote:
I have a table full of data... a log of sorts. Each row has a timestamp.
I want to generate some reports based on this data.
For example I want a COUNT(*) of the rows for each day for the past
week, 30 days, 12 months etc.
I have no problem generating the query but I am
>My table is:
>type price
>car 1000
>bike 100
>I want the result:
>car bike
>1000 100
You seem to want to turn rows into columns. That's often called a
"pivot
table". There's a step-by-step for pivot tables at
http://www.artfulsoftware.com/queries.php#24. There're other pivot
table examples
Dan Tappin wrote:
I have a table full of data... a log of sorts. Each row has a
timestamp.
I want to generate some reports based on this data.
For example I want a COUNT(*) of the rows for each day for the past
week, 30 days, 12 months etc.
I have no problem generating the query but I a
I have a table full of data... a log of sorts. Each row has a
timestamp.
I want to generate some reports based on this data.
For example I want a COUNT(*) of the rows for each day for the past
week, 30 days, 12 months etc.
I have no problem generating the query but I am stuck on a creativ
the issue was because i was viewing the database through cocoamysql,
which registered the timestamps as null.
stupid me viewing the database through the commandline showed up
fine
---
Hunter Peress
[EMAI
Hello.
>Please, answer next time to the list as well. In my opinion, it is
easier to prepare the create statement on the client side than
on the server. And does this table have any sense, considering the
relational model?
Sorry,I think you misunderstand my purpose,table2 is my query result,in f
Karima Velasquez wrote:
uhmmm...
i'll give a try to mysql_real_escape_string(), which i understand
formats the data into a valid sql string (without any special
characters, like \ and ' ).
shoud i use an analog function when retriving the data? because if i
"encode" the data, shouldn't i "deco
uhmmm...
i'll give a try to mysql_real_escape_string(), which i understand formats
the data into a valid sql string (without any special characters, like \ and
' ).
shoud i use an analog function when retriving the data? because if i
"encode" the data, shouldn't i "decode" it?
if so, which
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote:
Now... don't be so hasty. MS SQL has a form of RCS you can use to check in
and check out stored procedures and other design elements using Visual
Source Safe (VSS). VSS acutally uses extended stored procedures (the
mutant cousins of UDFs) to perform t
Hello.
>I want the values in the 'type' column of the first table to be the
>column name in the second table.
Please, answer next time to the list as well. In my opinion, it is
easier to prepare the create statement on the client side than
on the server. And does this table have any sense,
Jason Pyeron <[EMAIL PROTECTED]> wrote on 08/16/2005 04:17:15 PM:
> On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote:
>
> > After following your link, I am sure that some RCS systems that use
MySQL
> > as a backend *may* use UDFs as part of their persistence logic, but
those
> > would be specific to
Hi,
I want to save date and time of the creation of a row in a field.
That could be handled by a timestamp, I know that.
But I don't want the value to be updated automatically after an update.
I tried
.
creation datetime not null default now()
.
in the create table statement, but got an er
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote:
After following your link, I am sure that some RCS systems that use MySQL
as a backend *may* use UDFs as part of their persistence logic, but those
would be specific to the RCS product you are curious about. There aren't
any "generic" UDFs that will a
On Aug 15, 2005, at 5:07 AM, Logan, David (SST - Adelaide) wrote:
Hi Gary,
If you are running unix (or variants thereof), you can go to the
data directory and remove it at the operating system level if the
mysql client can't do it. Not sure about windows though but I would
think the same
I thought it was something like that ... I just found it strange
allready. I'll give it a try, thanx.
Danny
Paul DuBois wrote:
At 19:43 +0200 8/16/05, Danny Stolle wrote:
Hello all,
can somebody explain to me the c-api mysql_hex_string().
when i debug my example in DDD i get the full sql-dm
Hello
I am looking to determine the best Innodb Settings for our MySQL Instances.
Specifically, the settings for innodb_buffer_pool_size and
innodb_log_file_size. I have read the manual and understand how they work.
I am looking for additional information that would help me determine their
After following your link, I am sure that some RCS systems that use MySQL
as a backend *may* use UDFs as part of their persistence logic, but those
would be specific to the RCS product you are curious about. There aren't
any "generic" UDFs that will apply to all verson contol front-ends. Does
t
I agree with you,
I will upgrade .
Thanks for the advice.
On 8/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Alejandro <[EMAIL PROTECTED]> wrote on 08/16/2005 03:01:59 PM:
>
>
> > Hi,
> >
> > I have installed binary mysql version 3.23.58 downloaded from
> www.mysql.org.
>
Hi all,
I'm trying to INSERT values inf or -inf into a field (double) in MySQL
version 4.1.13 but
it has not been possible. MySQL deny the insertion. Can anyone give me
any suggestions to
solving this problem ?
Thanks
--
/
(=\Daniel Guariz Pinheiro
\=)
/Laboratório de Bioinformát
sorry,
RCS= Revision Control Sytems
it is what backends things like cvs.
and yes user defined functions
http://www.cs.purdue.edu/homes/trinkle/RCS/
On Tue, 16 Aug 2005 [EMAIL PROTECTED] wrote:
Jason Pyeron <[EMAIL PROTECTED]> wrote on 08/16/2005 01:01:03 PM:
Anyone out there heard of a r
Karima Velasquez wrote:
character is: \ (backslash).
Of course that will cause problems. This is the escape character in
SQL, used extensively when inserting BLOB data. Again, I believe
MySQL++ would have prevented this problem, because its escape
manipulator would have escaped the backsla
Alejandro <[EMAIL PROTECTED]> wrote on 08/16/2005 03:01:59 PM:
> Hi,
>
> I have installed binary mysql version 3.23.58 downloaded from
www.mysql.org.
> In changelog from the documentation say that the release is from
> september 2003 and the security bug is in March 2005.
> What can I do ? How
Jason Pyeron <[EMAIL PROTECTED]> wrote on 08/16/2005 01:01:03 PM:
>
> Anyone out there heard of a rcs udf (or similar) for MySQL?
>
> Google is not being nice to me, too much noise in the results.
>
> --
rcs=? Reaction Conrol System? Rear Cannon Sights?
udf = User Defined Function? (just mak
Hi,
I have installed binary mysql version 3.23.58 downloaded from www.mysql.org.
In changelog from the documentation say that the release is from
september 2003 and the security bug is in March 2005.
What can I do ? How mysql provide updates?
Thanks!!
=
Security info:
http://cve.mitre.or
At 19:43 +0200 8/16/05, Danny Stolle wrote:
Hello all,
can somebody explain to me the c-api mysql_hex_string().
when i debug my example in DDD i get the full sql-dml (insert) as a
hex-value; which this function returns. putting a 0x in front of the
hex and use it in a mysql_real_query() return
Is there any one out there using MySql for GIS applications? Any one
using the spatial features? Just taking an informal survey.
--
http://www.douglassdavis.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
Hello all,
can somebody explain to me the c-api mysql_hex_string().
when i debug my example in DDD i get the full sql-dml (insert) as a
hex-value; which this function returns. putting a 0x in front of the hex
and use it in a mysql_real_query() returns an error.
or am i doing it wrong! should
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 16 August 2005 15:04
To: Andrew Hargreaves
Cc: mysql@lists.mysql.com
Subject: Re: Why does this fail
"Andrew Hargreaves" <[EMAIL PROTECTED]> wrote on 08/16/2005
09:13:56 AM:
> Can anyone explain why this SQL stat
Pooly wrote:
Damnit !
Thanks for pointing it, I forgot these things.
But it's a bit more subtle :
If any column in a table has a variable length, the entire row becomes
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR colu
We are using 3.0.9 and the latest is 3.1.10
But we connect to the old 4.0 database fine, would the connector matter?
James
- Original Message -
From: "Jason Pyeron" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 16, 2005 1:59 PM
Subject: Re: French Characters, Still no answer
>
>
> O
thanks to Warren for his comment on the examples...
i modified my code trying to get rigth result, but still no luck. doing a
deeper research on comparing the data stored into the database and the data
stored in the wav file at the same time, i notice that there is a character
that is not prope
Anyone out there heard of a rcs udf (or similar) for MySQL?
Google is not being nice to me, too much noise in the results.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron P
On Tue, 16 Aug 2005, James Sherwood wrote:
I think I have found the problem:
Doing Select @@character_set_database , results, client and connection it
all returns
latin1
I tried set character_set_x = utf8; for them all but it did not work,
they stayed latin1 and need to be utf8
Any ide
I think I have found the problem:
Doing Select @@character_set_database , results, client and connection it
all returns
latin1
I tried set character_set_x = utf8; for them all but it did not work,
they stayed latin1 and need to be utf8
Any ideas how to change this?
Thanks,
James
- Or
this is not exactly what you are looking for, but it is where we started
on the task.
http://public.pdinc.us/cordova
a xml style sheet could easily be added, to create SQL DDL statements.
as far as the data rows that is easy as pie too.
Let us know and we could give cvs access and help on thi
I've got a column called time with the datatype time. When querying the
column from asp/ado the values are the current date with a vartype of date.
query browser: select time from syslog.mailinfo limit 1
result:
"time"
"03:18:26"
asp/ado:
<%set conn=server.createobject("adodb.connection")
conn.
Speaking of Perl scripts that do this: http://codenode.com/mysqlreport
I almost never use SHOW STATUS directly anymore since most the
values have to be transformed one way or another to really be meaningful.
-Daniel
Sid Lane wrote:
I don't know if you can do it directly in a mysql shell like t
DATE_FORMAT()
Doesn't seem like the most elegant solution, but it does seem to work.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I would like to export a part of my MySQL database as a SQL script. I
thought about mysqldump.exe but it's too simple. I need to export rows from
one table which matchs simple criteria and all rows from other tables which
are in relation with them.
The ideal solution would be to make a
> -Original Message-
> From: Dennis Olvany [mailto:[EMAIL PROTECTED]
> Sent: 16 August 2005 16:43
> To: mysql@lists.mysql.com
> Subject: Change Datatype (time)
>
> Is there a function that I can use in a query to return
> values in a different datatype? I've got a column which is
> time
Is there a function that I can use in a query to return values in a
different datatype? I've got a column which is time datatype and I'd like to
return the values in a vb-compatible datatype.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
> -Original Message-
> From: Sid Lane [mailto:[EMAIL PROTECTED]
> Sent: 16 August 2005 14:54
> To: mysql@lists.mysql.com
> Subject: Re: Can I use the information from "SHOW STATUS" in
> a SELECT statment ?
>
> I don't know if you can do it directly in a mysql shell like
> that (like you
On Mon, 2005-08-15 at 20:01 -0700, Patrick Michael Kane wrote:
> Did you ever get any responses on how to get innodb to a consistent
> on-disk state for LVM snapshotting?
>
> FYI, under LVM2 read/write snapshots are allowed.
>
I never got any replies.
If you look closely into my rambling posti
Hello.
> Also when we use EMS mysqlmanager to view the data, it is fine, it is only
> when it comes back to the tomcat server it seems.
That means that data on the server is ok. Check the values of your
character_set_client, character_set_connection and character_set_results
variables from
Hello.
I was able to make a query which retrieves dates where the TA is
available only for specific TA. To list all TA and periods of time
where they're available I wrote a stored procedure which works in
MySQL 5.
Here is the definition and test data in my tbl_notavailable
(I've c
Emmanuel Mwesigwa <[EMAIL PROTECTED]> wrote on 08/16/2005
04:57:53 AM:
> Hi,
>
> I am running MySQL 4.0.13-nt-log on Windowns XP and I
> need help on the following:
>
> 1) I have written a program in vc++ 6 which writes
> data to a mysql table; it runs and even make some
> entries into the tabl
"Andrew Hargreaves" <[EMAIL PROTECTED]> wrote on 08/16/2005
09:13:56 AM:
> Can anyone explain why this SQL statement would fail? A friend was asked
it
> in a pre-interview assessment and it threw him a bit.
>
> SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr
T1
> Where
Peter
>How do i go about saving data to multiple tables from
>one entry form or should this happen automatically
If the model is that a user can have radios which in turn can have
events,
you need a userid column in users and radios, and a radioid column in
radios and events. You need to re
Scott Noyes wrote:
I've got two columns, one is 'integer' (and store negative value), the
other one 'tinyint unsigned' (only > 1 stored in it), when I multiply
these columns, quantity with negative value does not show up.
(I expect -50*10 to give : -500, but the field stay blank.)
I've look a bit
I don't know if you can do it directly in a mysql shell like that
(like you would with v$, dba_ in Oracle) but if you call a show
command from PERL (via DBI) it hashes the result just like it were
from a select.
may not be the most elegant solution but its the best I've come up
with though I'll ha
> I've got two columns, one is 'integer' (and store negative value), the
> other one 'tinyint unsigned' (only > 1 stored in it), when I multiply
> these columns, quantity with negative value does not show up.
> (I expect -50*10 to give : -500, but the field stay blank.)
> I've look a bit at the doc
Isn't AS optional?
-Original Message-
From: Raz [mailto:[EMAIL PROTECTED]
Sent: 16 August 2005 14:19
To: Andrew Hargreaves
Cc: mysql@lists.mysql.com
Subject: Re: Why does this fail
For a start, spot the missing AS...
raz
--
No virus found in this incoming message.
Checked by AVG Anti-
[snip]
Can anyone explain why this SQL statement would fail? A friend was asked
it
in a pre-interview assessment and it threw him a bit.
SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr
T1
Where T1.City='London' AND NOT EXISTS (SELECT T2.Pstl_Address_PK from
PrsnAddress T2
> Can anyone explain why this SQL statement would fail? A friend was asked it
> in a pre-interview assessment and it threw him a bit.
>
> SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr T1
> Where T1.City='London' AND NOT EXISTS (SELECT T2.Pstl_Address_PK from
> PrsnAddres
First glance -- It's missing a comma (,) between T1.BldgName and
T1.StreetName, Missing a period (.) in PstlAddr T1 and in PrsnAddress T2
Also, how does the system know the table names if you are putting them
first, (i.e. shouldn't it be BldgName.T1 not vice versa)?
You don't define what T1 is, u
For a start, spot the missing AS...
raz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can anyone explain why this SQL statement would fail? A friend was asked it
in a pre-interview assessment and it threw him a bit.
SELECT T1.BldgName T1.StreetName, T1.Locality, T1.PostTown from PstlAddr T1
Where T1.City='London' AND NOT EXISTS (SELECT T2.Pstl_Address_PK from
PrsnAddress T2)
You can use INTERVAL i.e.
Lets say you have a table
mysql> CREATE TABLE foo (bar int(14), fdate date );
Query OK, 0 rows affected (0.27 sec)
mysql> INSERT INTO foo
> VALUES (1, now()),
(25,now() - INTERVAL 1 DAY),
(15,now() - INTERVAL 2 DAY);
mysql> SELECT f1.
do something like:
SELECT t1.date, (t1.field - t2.field) as diff FROM your_table t1,
your_table t2 where t1.date = t2.date + 1;
On 8/16/05, Octavian Rasnita <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I define the previous record by date. For each record corresponds a date
> which is unique and the prev
Hi,
I define the previous record by date. For each record corresponds a date
which is unique and the previous record is that that contains the yesterday
date.
Thank you.
Teddy
- Original Message -
From: "Felix Geerinckx" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 16, 2005 2:45 PM
S
Hello,
I dont think we want to go this route as it was working fine on the 4.0
database on the other server.
I also might add that the old server was linux, and the new one is Windows
2000 Server
Thanks,
James
- Original Message -
From: "Ace Dimitrievski" <[EMAIL PROTECTED]>
To: <[EMAI
Sorry, dont know how I missed: http://lists.mysql.com/mysql/187794
The old msql was 4.0 and the new one is 4.1.
When we first imported the data the database was in latin1(my mistake) and
we put it into production as everything seemed to work fine.
We have one site that uses french characters som
Hi there,
> > >
> > > 'USAGE' means that user doesn't have any privileges. Use
> > 'DROP USER'.
> > > See:
> > > http://dev.mysql.com/doc/mysql/en/drop-user.html
> >
> > I disagree here.
> >
> > "drop user" will drop the user, revoking "usage" can be
> > something different.
>
> You can't actual
On 16/08/2005, "Octavian Rasnita" wrote:
> I want to create a query that selects the diference between the value
> of a field from the current record and the value of the same field
> from the previous record.
How do you define "current record" and "previous record"?
(relational databases are not
Hi,
I've got two columns, one is 'integer' (and store negative value), the
other one 'tinyint unsigned' (only > 1 stored in it), when I multiply
these columns, quantity with negative value does not show up.
(I expect -50*10 to give : -500, but the field stay blank.)
I've look a bit at the docu
Hello to everyone on [EMAIL PROTECTED],
In 2 words, what I wish to do is something like :
mysql> SELECT @@Qcache_queries_in_cache / @@Qcache_hits;
Is it possible ?
Thank you.
--
Cheers,
Maxim Vexler (hq4ever).
Do u GNU ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Hi,
I am running MySQL 4.0.13-nt-log on Windowns XP and I
need help on the following:
1) I have written a program in vc++ 6 which writes
data to a mysql table; it runs and even make some
entries into the table (about 10 per half-day), but
after some time (18 hours or less) mysql disconnects;
any
Martin,
Comments in-line:
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 16 August 2005 10:35
> To: mysql@lists.mysql.com
> Subject: Re: Why can't I revoke usage from user?
>
> Gleb,
>
> > Hello.
> >
> > 'USAGE' means that user doesn't have any privileges
Hi,
I want to create a query that selects the diference between the value of a
field from the current record and the value of the same field from the
previous record.
Is this possible?
It should return a list of diferences.
Or, at least I should be able to do that query to do this diference betw
Gleb,
> Hello.
>
> 'USAGE' means that user doesn't have any privileges. Use 'DROP USER'.
> See:
> http://dev.mysql.com/doc/mysql/en/drop-user.html
I disagree here.
"drop user" will drop the user, revoking "usage" can be something different.
If, for example, you do "grant usage on dbname.*" th
Hi,
> Why can't I revoke usage from user?
> mysql> show grants for ''@'172.20.16.110';
> +--+
> | Grants for @172.20.16.110|
> +--+
> | GRANT USAGE ON *.* TO ''@'172.20.16.110' |
> +
Tim Johnson wrote:
it get worse . most of my commercial work is running on
servers with ver 3.23.X (sun and RH servers). I enjoy a
great relationship with my domain hoster (who is also a
programmer who uses mysql a lot), but he has been very
cautious about
Hello.
'USAGE' means that user doesn't have any privileges. Use 'DROP USER'.
See:
http://dev.mysql.com/doc/mysql/en/drop-user.html
Gu Lei <[EMAIL PROTECTED]> wrote:
> Hello everyone:
>
> Why can't I revoke usage from user?
> mysql> show grants for ''@'172.20.16.110';
> +
Hello.
Specify the correct value for datadir when you start mysqld_safe.
For these purposes I normally use configuration file, and launch
mysqld_safe with --defaults-file=/path/to/my/file command line option.
See:
http://dev.mysql.com/doc/mysql/en/program-options.html
James Cooper <
Hello.
MySQL 3.xx is almost out of support now. Even no bugs fixed in 3.23 (only very
critical ones).
General reasons about old software and it's problems can be used
in your dialog with hosting provider. Usually providers leave servers
with MySQL 3.xx in use and provide a new one with MySQL
Hello.
Your question isn't clear enough for me. Do you want that values
in 'type' column of the first table to become column names
in the second table? Or do you want just to see results in a row?
$$ $ <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: gb2312, 17 lines
Hi folks
I have several small data bases running on mysql 4.1.13 no problem brought a
book read it yes well
i have a data base consisting of 3 tables , radios , users , events
radios contains 4 fields csgn , setid , sernum cmmnts. this is populated and
is more a lookup table for the radio
On Tuesday 09 August 2005 08:17, Gleb Paharenko wrote:
> Hello.
>
> > I have noticed that since the update i have multiple instances of mysql
> > running which seem to be causing the problem ps uax output below
>
> I usually see a lot of mysqld processes (these are
> just different threads of the s
Hi Clyde,
On Mon, 2005-08-15 at 19:56 -0400, Clyde Lewis wrote:
> Does anyone have any experience using multiple my.cnf files on a single box?
> If so, how is the my.cnf specified during startup and shutdown?
Try starting mysqld with --defaults-file=/path/to/my.cnf
> I need multiple my.cnf files
mysqld fails with permision denied (/var); runing as a user
>Description:
mysql configures for runing in user space; makes; and installs; tests
wor, but mysqld wont run
>How-To-Repeat:
I built mysql-4.1.14-nightly-20050808 from source, using
./configure
'--prefix=/usr
mysqld fails with permision denied (/var); runing as a user
>Description:
mysql configures for runing in user space; makes; and installs; tests
wor, but mysqld wont run
>How-To-Repeat:
I built mysql-4.1.14-nightly-20050808 from source, using
./configure
'--prefix=/usr
Hunter Peress wrote:
Yes theres all this talk about timestamp returning different results in
4.1 vs. 4.0
but i took the MYI and MYD and frm files from a winnt running 4.0.14
and transferred to a 4.1.11-Debian_4-log
and all the timestamp fields are NULL
it seems all the other data is fine.
I'm using 5.0.9 beta standard. I'll try to upgrade and will re-post if I
still get erroneous results.
s.m.
Am Mon, 15 Aug 2005 18:53:40 +0200 hat Gleb Paharenko
<[EMAIL PROTECTED]> geschrieben:
Hello.
What version of MySQL do you use? On my 5.0.11 I have a correct result:
mysql> show c
84 matches
Mail list logo
