Hello,
The platform we are working is Mysql 4.1.8 version
and Windows XP os.
In ms sql server the space used and free space
available for each database is obtained through
'sp_spaceused'procedure( built in ).
Primary memory used by ms sql server and related
services like
Thomas Sundberg [EMAIL PROTECTED] wrote on 04/02/2005
11:39:12:
Hi!
I'm looking for the syntax diagram for MySQL and can't find it. I have
downloaded the entire MySQL manual as one html page and searched it for
the
definition of where_definition and I cant find it. Could somebody please
MySql 4.0.14
I understand that the most effective way of speeding
up SELECT statements is to have column level indexes.
Are there any other level indexes exist? I have been
told that there are but I have no idea, looked through
the manual, could not find anything that speeds up
column level
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 12:45
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diagram, where is it located in the doc?
Thomas Sundberg [EMAIL PROTECTED] wrote
on 04/02/2005
11:39:12:
You're right there is none.. .but as you see there is a short line that
says:
In the WHERE clause, you can use any of the functions that MySQL supports,
except for aggregate (summary) functions. See section Functions and
Operators.
Gabriel PREDA
- Original Message -
From:
From the manual, where_definition consists of the keyword WHERE followed
by an expression that indicates the condition or conditions that rows must
satisfy to be selected. http://dev.mysql.com/doc/mysql/en/select.html
That seems simple and straightforward to me. Perhaps if you told us why you
Thomas Sundberg [EMAIL PROTECTED] wrote on 04/02/2005
12:46:02:
Does anybody at the list know the answer to my question? I
sent it a
few days ago and haven't received any response. It does
exist a syntax
diagram
for MySQL, doesn't it?
Since no-one replied to your first
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: den 4 februari 2005 14:19
To: Thomas Sundberg
Cc: mysql@lists.mysql.com
Subject: Re: Syntax diagram, where is it located in the doc?
From the manual, where_definition consists of the keyword
WHERE
Hello, my name's Matteo, probably my question
is basic but I'm new with mysql.
I've an application that write some milion of row in mysql innodb
table. Every day my application creates a new table, write data
and drop table oldest than 15 days.
After the drop table execution command the disk space
Greetings,
I created a table during transaction and was surprised to find out it
still existed after I did a ROLLBACK. The same seems to apply to changes
made using ALTER TABLE statements.
Is there a simple logical explanation to this behaviour?
Any help would be appreciated.
Demonstration
Simple, ROLLBACK reverts DML (data) changes, not DDL (structure)
changes..
mysql select version();
+---+
| version() |
+---+
| 4.1.7-nt |
+---+
1 row in set (0.01 sec)
mysql SHOW VARIABLES LIKE have_innodb;
+---+---+
| Variable_name | Value |
-Original Message-
From: Thomas Sundberg Sent: Friday, February 04, 2005 07:48
To: mysql@lists.mysql.com
-Original Message-
From: Michael Stassen Sent: den 4 februari 2005 14:19
To: Thomas Sundberg
Cc: mysql@lists.mysql.com
From the manual,
Thomas Sundberg [EMAIL PROTECTED] wrote on 04/02/2005
13:48:03:
It is very simple but absolutely not straight forward. It really doesn't
say
anything. Just that you should do things right and then you will not
have
any problems.
The concrete problem I tried to solve were if MySQL supports
Could someone please offer a little help.
I have a table like:
Year, Month, Start_date
20041020041102
20041120041203
20041220050104
20050120050204
20050220050303
I need to get the latest Year,Month for a given date, so for example today
(20050204) I
I found an answer:
mysql -e SET @VAR:=1234; SOURCE xxx.sql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Graham Cossey wrote:
Could someone please offer a little help.
I have a table like:
Year, Month, Start_date
20041020041102
20041120041203
20041220050104
20050120050204
20050220050303
I need to get the latest Year,Month for a given date, so for example today
DDL cannot be rollback
http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html
It also apply to many DB like Sybase for example...
Ville Karjalainen wrote:
Greetings,
I created a table during transaction and was surprised to find out it
still existed after I did a ROLLBACK. The same seems to apply
So today for the second time in six weeks we are faced with rolling back to
mysql 4.0 because of dramas with character sets. I don't know about anyone
else but this supposedly wonderful feature has been nothing but a nightmare
for us.
So our Application servers use Unicode for our non US English
Hello.
4.0.17 is old enough. You may switch to the debug version and attempt to
find the clues in debug or trace files. Can you reproduce an error on the
latest release (4.1.9 now)? Do you lost connection to the server with
other statements, than 'SHOW DATABASES'? Please answer on this
Hello.
Can you connect using the mysql command line client program?
leegold [EMAIL PROTECTED] wrote:
ssh connecting with a mysql client gui I get: ERROR 2013 Lost
connection to MySQL server during query
I'm using mysqlyog and trying connect via the ssh tunnel. I can connect
Hello.
Hello. A lot of thins may cause this behaviour, even
not related to the replication. At:
http://dev.mysql.com/doc/mysql/en/todo-mysql-5-1.html
said that, the one of the new feautures would be:
Online backup with very low performance penalty.
So it can be an answer on your
Hello.
May be it is not exactly what you want, but usually, I look at
the sql/sql_yacc.yy in a source distribution.
Thomas Sundberg [EMAIL PROTECTED] wrote:
Hi!
I'm looking for the syntax diagram for MySQL and can't find it. I have
downloaded the entire MySQL manual as one html
Hello.
I didn't find any bug related to this behaviour. What operation system do
you use? Connect to the server with mysql command line client program and
kill it with the SIGKILL signal. Check the error file to find messages
about aborted connections. Can you reproduce a problem on the
Hello.
Use the max attribute. See:
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
If you want to decrease the size of your tablespace, see:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
[EMAIL PROTECTED] wrote:
Hello, my name's Matteo, probably my
Hello.
See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
[snip]
Hi,
I installed the mysql 5.0.2 alpha for linux and i got an error after
created a view and try to select * from the view.
ERROR 2013: Lost connection to MySQL server during query
Does anyone
Bruce
We're sort of in the same boat but if you persevere you can eradicate
all the problems.
Now we don't run the server as utf8 which does cause a number of
problems - we don't want all the databases to be utf8 just some of them,
and just some tables on some of them.
For a database that needs
I have taken on a job replacing an old AS400 RPM
database with four thin clients. They really like the
feel of the thin client interface, no point and click,
no graphics, just green text on a black background. I
could use any suggestions on what to read, or where to
look to find a way to create a
A Z [EMAIL PROTECTED] wrote on 02/04/2005 07:21:35 AM:
MySql 4.0.14
I understand that the most effective way of speeding
up SELECT statements is to have column level indexes.
Are there any other level indexes exist? I have been
told that there are but I have no idea, looked through
i have taken on a job replacing an old AS400 RPM
database with four thin clients. They really like the
feel of the thin client interface, no point and click,
no graphics, just green text on a black background. I
could use any suggestions on what to read, or where to
look to find a way to create a
Winn Johnston [EMAIL PROTECTED] wrote on 02/04/2005 10:30:54 AM:
I have taken on a job replacing an old AS400 RPM
database with four thin clients. They really like the
feel of the thin client interface, no point and click,
no graphics, just green text on a black background. I
could use any
Hi,
I have a table where users upload various data items via a web site. Some
fields in the table are named DATA_ENC... to denote that the data should be
encrypted uusing the encode function. This all works fine, however when I
come to selecting the data from the table I would like to be able
Thomas,
As you've discovered, MySQL documentation doesn't (yet) include a
syntax diagram, but there's a manual page for WHERE clauses, there's a
manual page for logical operators including XOR, and they show that the
answer to your question about WHERE clauses using XOR is 'yes', as does
--- [EMAIL PROTECTED] wrote:
Winn Johnston [EMAIL PROTECTED] wrote on
02/04/2005 10:30:54 AM:
I have taken on a job replacing an old AS400 RPM
database with four thin clients. They really like
the
feel of the thin client interface, no point and
click,
no graphics, just green text
On Friday 04 February 2005 16:03, Winn Johnston might have typed:
My users have expressed a distinct dislike for point
and click methods. They would rather use the keyboard
in the same way a ticket agent does when she is
looking for a flight :)
You can do this one of two ways.
Give them
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
I have a table where users upload various data items via a web site. Some
fields in the table are named DATA_ENC... to denote that the data should be
encrypted uusing the encode function. This all works fine, however when I
come to
lynx i like it :)
thanks duncan, u the man
winn johnston
-- Duncan Hill [EMAIL PROTECTED] wrote:
On Friday 04 February 2005 16:03, Winn Johnston
might have typed:
My users have expressed a distinct dislike for
point
and click methods. They would rather use the
keyboard
in the
snip
As I'm using 4.0.20 I can't use subqueries so how can I create
a query that
does this?
SELECT year, month
FROM `dc_months`
WHERE start_date = (SELECT MAX(start_date)
from dc_months
where start_date = '20050204')
Any help
On Fri, 2005-02-04 at 11:08, Duncan Hill wrote:
On Friday 04 February 2005 16:03, Winn Johnston might have typed:
My users have expressed a distinct dislike for point
and click methods. They would rather use the keyboard
in the same way a ticket agent does when she is
looking for a
Any advice for upgrading MySQL when it came packaged with a commercially
available code (iTracker by Newark Electronics)?
-Elton
WindowsNT
On Fri, 2005-02-04 at 09:19, Graham Cossey wrote:
Could someone please offer a little help.
I have a table like:
Year, Month, Start_date
20041020041102
20041120041203
20041220050104
20050120050204
20050220050303
I need to get the latest Year
Apparently not!
mysql SELECT DECODE ( CSV_DATA_ENC_FORENAME, test_password ) FROM
DATA_TABLE_PID_1_DESC_137;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near '(
CSV_DATA_ENC_FORENAME, test_password
I want to run a nightly cron job where you iterate throught each row of
a single table and reset a field depending on the conditions specified.
In this case I want to take a date field (RenewalDate) and compare it
to the current date less a 30 day grace period and if true reset the
Hello.
See:
http://dev.mysql.com/doc/mysql/en/upgrade.html
http://dev.mysql.com/doc/mysql/en/windows-upgrading.html
If your MySQL distribution came as embedded version, you should look at:
http://dev.mysql.com/doc/mysql/en/libmysqld-overview.html
The complete answers related to
Hello.
I think you should remove the space after DECODE.
shaun thornburgh [EMAIL PROTECTED] wrote:
Apparently not!
mysql SELECT DECODE ( CSV_DATA_ENC_FORENAME, test_password ) FROM
DATA_TABLE_PID_1_DESC_137;
ERROR 1064: You have an error in your SQL syntax. Check the manual
Hi ALL,
Im using mySQL Distrib 4.0.18 and using single Tablespace
(/data/ibdata/ibdata1).
Now Im planning to upgrade to 4.1.8 and move single tablespace to
Using Per-Table Tablespaces.
Please share your expertise in moving single TB to using per-table TB
with my existing data also.
Thanks
Hi I've a question I have a delphi program that connects to a mysql
database via obdc, and works perfect in the lan and in the server, I want
to know if I can enter the database if I have the program installed in
another city or place, I know that I have to enter the IP of the server
but I've
No ideas internally to mysql, you can always fire up a sniffer
(sniffit, tcpdump, etc).. something like that would tell you.
On Mon, 31 Jan 2005 20:32:49 -0500, John May
[EMAIL PROTECTED] wrote:
Anyone have any ideas on this one? :
I've scoured the MySQL manuals... does anyone know if
Jack Lauman [EMAIL PROTECTED] wrote on 02/04/2005 11:57:37 AM:
I want to run a nightly cron job where you iterate throught each row of
a single table and reset a field depending on the conditions specified.
In this case I want to take a date field (RenewalDate) and compare it
to the
First, check your my.cnf file to see if you have a 'bind-address'
entry. Such an entry will constrain you system only responding to
machines on the same network. Failing that, have you checked you
firewall settings? Are you sure that can can even reach port 3306 on
that machine from the outside
Thanks Tom and Michael,
I got rid of all of the indexes except the one marked PRIMARY and a
new one that I made like this:
ALTER TABLE logs ADD unique (host,date,time,priority,facility,seq);
I see quite an improvement from what I was seeing before. The one
thing that I didn't realize is that
Hi all,
I know this is a silly question but, frankly, I didn't
find any useful and straightforward document in
dev.mysql.com. I want to upgrade mysql server on a
fedora core 3 linux system from 3.23 to the latest
version 4.1. First I want to know if is possible,
because I have read somewhere that
On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
Apparently not!
mysql SELECT DECODE ( CSV_DATA_ENC_FORENAME, test_password ) FROM
DATA_TABLE_PID_1_DESC_137;
Is it so hard to read directions?
select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;
This assumes
Sabeer,
- Original Message -
From: Sabeer MZ [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, February 04, 2005 7:33 PM
Subject: Multiple Tablespace
Hi ALL,
Im using mySQL Distrib 4.0.18 and using single Tablespace
(/data/ibdata/ibdata1).
Now Im planning to upgrade to
Matteo,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, February 04, 2005 3:51 PM
Subject: innodb problem
Hello, my name's Matteo, probably my question
is basic but I'm new with mysql.
I've an application that write some milion of row in
A,
- Original Message -
From: A Z [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, February 01, 2005 2:14 PM
Subject: Premature InnoDB conversion.
MySql 4.0.14
We tried to convert MyISAM table format to INNODB
format, it took forever to finish the process, someone
Hi Thomas,
I'm looking for the syntax diagram for MySQL and can't find it. I have
Just to give you a complete answer to your question, this is what is
valid (I've stripped out the C code parts to leave just the definition):
where_clause:
/* empty */
| WHERE expr
expr: expr_expr
In my version of MySQL (4.1.9), your sample code generates an error:
mysql select decode(encode(foo));
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '))' at line 1
Apparently
On Friday 04 February 2005 03:31 pm, John Trammell wrote:
In my version of MySQL (4.1.9), your sample code generates an error:
mysql select decode(encode(foo));
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the
58 matches
Mail list logo