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
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.
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
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
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
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 same
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
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
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
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.
'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';
Tim Johnson wrote:
grin 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
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' |
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.* this is
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
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. Use
'DROP
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
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:
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
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 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 actually revoke USAGE, without
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
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: [EMAIL
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: mysql@lists.mysql.com
Sent: Tuesday, August
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 previous
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.bar
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)
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]
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,
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)
[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
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
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
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
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
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
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
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 table (about
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
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
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 posting,
-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 would
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:
-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
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
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]
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
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)
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
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
-
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
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
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
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: mysql@lists.mysql.com
Sent: Tuesday, August 16, 2005 1:59 PM
Subject: Re: French Characters, Still
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
-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
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
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
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()
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:
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 making
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 mysql
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
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
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
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.
In changelog
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
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
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
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
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
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
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 the RCS
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,
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
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
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 decode
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
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
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
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
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 on the
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
83 matches
Mail list logo
