Hi,
in my table I have one varchar(20) column where I store version number.
Version looks like:
1.1.2
1.2.1
1.10.3
It is possible order this column in natural order (1.2 before 1.10)?
Stano.
--
Stanislav PaÅka
programÃtor, www skupina
KIOS s.r.o.
tel: 033 / 794 00 18
--
MySQL General Mailing List
Mark Sargent wrote:
Hi All,
I can start mysql with the following cmd,
/etc/rc.d/init.d/mysql start
although, I had to change
bindir=./bin
to
bindir=/usr/local/mysql/bin
to get it to work. I can access the DB with,
mysql -h localhost -u root -p
successfully, but, when trying to access via phpmyadmin
Hi All,
I can start mysql with the following cmd,
/etc/rc.d/init.d/mysql start
although, I had to change
bindir=./bin
to
bindir=/usr/local/mysql/bin
to get it to work. I can access the DB with,
mysql -h localhost -u root -p
successfully, but, when trying to access via phpmyadmin or webmin it
doesn
We have been using MyISAM tables with MySQL merrily for about 18 months.
Recently we upgraded to MySQL 4.1, and even more recently, we converted some
of our MyISAM tables (which needed transactional support) to InnoDB.
After some configuration issues - the worst of which was the need to use a
s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My boss and I were playing with using select statements, and we can
actually execute subqueries as an option if the result is true or false.
Is this expected behavior, or is it something that may be fixed in a
revision, before I begin to depend on it
At 19:39 -0400 4/28/05, Anoop kumar V wrote:
I mean:
Should I enable something like 'strict checking' / verbose so that
MYSQLcomplains and refrains from inserting truncated data in the
tables??
Yes, but you'll need MySQL 5.0 to do it.
http://dev.mysql.com/doc/mysql/en/server-sql-mode.html
Thanks,
I mean:
Should I enable something like 'strict checking' / verbose so that
MYSQLcomplains and refrains from inserting truncated data in the
tables??
Thanks,
Anoop
On 4/28/05, Anoop kumar V <[EMAIL PROTECTED]> wrote:
>
> Thank you,
>
> But the show warnings does not seem to work on my prompt. I
Thank you,
But the show warnings does not seem to work on my prompt. I am using
mysql> SELECT VERSION();
+---+
| VERSION() |
+---+
| 4.0.23-nt |
+---+
And even if it did and does how will that reflect in my tomcat logs?? I mean
I want a way where without user interaction
Andrew Hargreaves wrote:
> In MySQL 4.0, is it possible to find all records that don't exist in one
>query. I managed to do it in Access by referencing a query that I had
>previously created, but I was wondering if it was possible to do this in one
>step.
>
>
Not in one step, no. If you're still
Hi,
I think you shoul dcatch the "show warnings" command cause in mysql
client you see the number of warnings.
Data are even truncated according to the limit of the type (tinyint, int
...).
Example :
mysql> create table toto(a tinyint,b char(5));
Query OK, 0 rows affected (0.06 sec)
mysql> insert
I am using MySQL and SQL server with Tomcat.
Our application writes into both databases (mysql and ms sql server) at once
based on some data collected from an end user. Now if the end user enters
more data (characters) than the column can hold, the data obviously gets
truncated.
But the surpr
In MySQL 4.0, is it possible to find all records that don't exist in one
query. I managed to do it in Access by referencing a query that I had
previously created, but I was wondering if it was possible to do this in one
step.
SELECT C.CustomerID, ([JobStatus]="0" And [JobTypeID]=2) AS KountNA,
Co
Hi,
known as "covering indexes". The advantage to a covering index is that if
your data is numeric and in the index, the engine can read the data
All correct, except that the data does not have to be numeric. It must,
however, be completely indexed, not indexed by prefix. That requirement
us
We've got a customer whose system has been experiencing corruption in
their InnoDB tables. They have returned the system to us and after
testing we've determined that the server has bad RAM.
This is the same system I had posted about in
http://lists.mysql.com/mysql/180785
Memtest86+ v1.55 can
Hmmm, they repeated several times...
Under the agreement, Business Objects will embed MySQL database technology
into BusinessObjects XI for use on the Linux and UNIX
"Linux and UNIX" how can they determine the server is not running on Win32???
Strange. Crystal Reports is a Win32 app.
- Or
For your query, just a where clause :
mysql> select * from seqs where id <3;
+---++
| seqno | id |
+---++
| 00122 | 1 |
| 00123 | 1 |
| 00123 | 2 |
| 00336 | 1 |
| 00346 | 1 |
| 00349 | 1 |
| 00427 | 1 |
| 00427 | 2 |
+---
Should be. You should be able to download a trial and try it out.
>>> "Kerry Frater" <[EMAIL PROTECTED]> 04/28/05 3:26 PM >>>
Thanks for the reply Scott. I found the press release interesting.
I have V9 Dev version and need runtime version for another site. I can buy
V11 but wasn't sure if the S
Thanks for the reply Scott. I found the press release interesting.
I have V9 Dev version and need runtime version for another site. I can buy
V11 but wasn't sure if the STD version was enough to set a report and run it
with MySQL.
Kerry
-Original Message-
From: Scott Pippin [mailto:[E
"Jay Blanchard" <[EMAIL PROTECTED]> wrote on 04/28/2005
04:24:23 PM:
> [snip]
> I have question about how I can get top 2 rows for each group.
> like I have table test
> | seqno |
> +---+
> | 00122 |
> | 00123 |
> | 00123 |
> | 00123 |
> | 00336 |
> | 00346
Hi ,
The table must be myisam. Innodb refused my solution which is here :
Beatifull
auto_increment
mysql> create table seqs(seqno varchar(10) NOT NULL , id int
auto_increment, primary key (seqno,id)) engine=myisam;
Query OK, 0 rows affected (0.03
[snip]
I have question about how I can get top 2 rows for each group.
like I have table test
| seqno |
+---+
| 00122 |
| 00123 |
| 00123 |
| 00123 |
| 00336 |
| 00346 |
| 00349 |
| 00427 |
| 00427 |
| 00427 |
+---+--+
I like have
I have question about how I can get top 2 rows for each group.
like I have table test
| seqno |
+---+
| 00122 |
| 00123 |
| 00123 |
| 00123 |
| 00336 |
| 00346 |
| 00349 |
| 00427 |
| 00427 |
| 00427 |
+---+--+
I like have
+--
I do believe that a problem is with SigmaPlot itself, because of all
research we have done. And, an additional fact that SigmaPlot ODBC
connection works properly with DSN created for MS-Access, but not with
DSN to MySQL.
Best
Mikhail Berman
From: [EMAIL PROTEC
MySQL could die during your query. What is in error log?
Oh my god, it's really dieing. I haven't looked in the error log before,
because I though, it's just this connection that got lost. This is the
error-log output:
mysqld got signal 11;
This could be because you hit a bug. It is also possibl
MySQL is not listed in the screenshot because that is a sample screenshot
provided by the **manufacturer**, not a screen shot from his installation.
I was trying to use it to get a sense of how many connection-specific
options he may have had control over from within SigmaPlot. Basically, it
ap
Hi,
Had you read http://dev.mysql.com/doc/mysql/en/odbc-connector.html
One can't see the mysql ODBC driver in your snapshot.
Best Regards
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-Original Message-
From: [EMAIL PROTECTED] [mailto
Shawn,
I would like to thank you for your great help, no apologies needed. I
have gone through most of the steps describe by you myself in the search
for the answers.
I am going to take this up with Systat Software people, now.
Thank you again,
Mikhail Berman
_
Thank you for being so patient with me. What options does SigmaPlot give
you when selecting an ODBC data source? Have you verified that you are
either using the default settings (as you defined when you set up the
connection) or that you are using the same credentials you used to test
your ODBC
See inserts below
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 28, 2005 12:36 PM
To: Berman, Mikhail
Cc: mysql@lists.mysql.com
Subject: RE: Does anyone have experience?
OK, I am still confused. Let's run down the list of what's work
James,
>I need to figure out how many Tuesdays are contained
>within 1/1/2004 - 5/1/2004, and I need to come up with
>a result where I know how many of each day of the week
>is within that date range.
Supposing a table named tbl and datetime columns named d1 and d2,
something like this (not optimi
Hi,
If you want to move just one (or some) database and keep your datadir as defined
:
* stop the server
* move your database (say world) to a new directory (c:\newdir)
* in the datadir, create .sym and write in a line containing "c:\newdir"
* restart
on Unix, you have symbolic links.
Mathias
OK, I am still confused. Let's run down the list of what's working and
what isn't:
a) In the ODBC manager, create a System DSN and click on the TEST
CONNECTION button. What happens?
b) In SigmaPlot, tell the software to use the connection you just created
and tested. What happens?
If we can't
Hi, there,
I am using MySQL 4.1.10. I have a table which has a LONGBLOB field.
Some length of the blob field of the records varies from a few hundred
bytes to more than 64 MB. I've set max_allowed _packet to 128M on the
server side. I first created the table in MyISAM and the data was added
Does anyone how to interpret the output of 'SHOW INNODB STATUS' ?
It prints quite a bit of stuff but I haven't been able to find any
documentation
explaining what everything means. Specifically:
Total memory allocated 462835256; in additional pool allocated 1385472
Buffer pool size 24576
Free b
Hi,
I do use Data Sources(ODBC) manager to create DSNs.
Either User or System DSN failed to connect from SysPlot to UNIX
databases, with the same error message "Cannot connect to data source"
Sorry I was not precise in description, I have mentioned MS-Access vs.
Excel only to raised a point
"Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 10:50:17 AM:
> Yes,
>
> I do test DSN connection itself. It returns "Success. Connection was
> made". I am creating User DSN.
>
That's a good sign.
> The only tool able to connect to my UNIX databases via ODBC driver is
> MS-Access, no
Andy Ford ha scritto:
I have run out of disk space in the directory where I have a mySQL database.
How do I go about moving it and reconfiguring mySQL to see the new location.
Thanks
Andy
Symple... move to a different directory the data and edit the my file at:
...
#Path to the database root
dat
I have run out of disk space in the directory where I have a mySQL database.
How do I go about moving it and reconfiguring mySQL to see the new location.
Thanks
Andy
This e-mail is private and may be confidential and is for the intended
recipient only. If misdirected, please notify us by telep
> How does one cope with time zones? For example, if I want to timestamp a
> record it will timestanp using the local time of my server. I thought
that, > e.g if my server was in New York and my customer_location was the
UK, I
can > just add 5 hours to the time and it would be correct.
> While th
I'm an idiot. I completely forgot about USER():
mysql> select user(), SUBSTRING_INDEX(user(), '@', -1);
+-+--+
| user() | SUBSTRING_INDEX(user(), '@', -1) |
+-+--+
| [EMAIL PROTECTED] | localhos
Yes,
I do test DSN connection itself. It returns "Success. Connection was
made". I am creating User DSN.
The only tool able to connect to my UNIX databases via ODBC driver is
MS-Access, not Excel.
Regards,
Mikhail Berman
From: [EMAIL PROTECTED] [mailto:[E
"Berman, Mikhail" <[EMAIL PROTECTED]> wrote on 04/28/2005 10:32:53 AM:
> Hi,
>
> I am promoting this E-mail to larger list in hope to find people who can
> help me.
>
> Regards,
>
> Mikhail Berman
>
> -Original Message-
> From: Berman, Mikhail [mailto:[EMAIL PROTECTED]
> Sent: Wednesd
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a table with session information, with a start and stop time.
I can aggregate the information, grouping it by hour or weekday.
But, when I group it by hour and weekday, I need to also show the
average usage, so I need to figure out how many Tu
Sadly, the REGEXP function is only for string comparison,
not substitution. You'll either have to handle the
replacement on the client side or string together an
unwieldy series of REPLACE functions, like so:
SET @phone = '(123) 456-7890';
SELECT
REPLACE(
REPLACE(
REPLACE(
REPLACE(@phone,
' ', '')
Hello.
>But I've been told that the support for Unicode is not yet good in MySQL. Is
>it possible to find whether this is true?
I don't think so, as most bugs related to utf8 are reported about the fifth
version
while utf8 support in fourth seems very stable.
Raul Mauri <[EMAIL PRO
Hi,
I am promoting this E-mail to larger list in hope to find people who can
help me.
Regards,
Mikhail Berman
-Original Message-
From: Berman, Mikhail [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 9:57 AM
To: [EMAIL PROTECTED]
Subject: Does anyone have experience?
Hi every
I haven't tested it but I am using version 10 with no problems. See the
announcement made by business objects at the MySQL users conference:
http://www.mysql.com/news-and-events/press-release/release_2005_10.html
I hope this helps.
Scott Pippin
[EMAIL PROTECTED]
>>> "Kerry Frater" <[EMAIL
You should be shure that the old client is not in the PATH... because seems
to me that when you're not int the mysql bin directory the old client is
called... withc does not know about the new auth methods...
Or else... start the server with the "--old-password" param.
Gabriel
- Original Me
"mdnazrul" <[EMAIL PROTECTED]> wrote on 04/28/2005 08:41:16 AM:
> Dear Sir/Madam,
> I'm new to mysql
> Does any body know following program written in which language? is that
C++
> or Java
>
> Thank you for your support.
>
> Sincerely
> Nazrul
>
If you download MySQL you will also get a copy
Ideally you would want to encrypt the connection, if only to add
another layer of security. But regardless, there are other steps you
can and should take even before implementing a secure connection
between PHP and MySQL. It's actually a smart idea to separate your
database from the front end h
Dear Sir/Madam,
I'm new to mysql
Does any body know following program written in which language? is that C++
or Java
Thank you for your support.
Sincerely
Nazrul
Way ahead of you, that switch was turned on during initial load before
we went live with the new servers.
Mark Leith wrote:
You mention that MySQL is "only using 1.5 gig"..
Out of interest, are you aware that Windows by default when using
"large" amounts of memory, will split the memory allocat
You mention that MySQL is "only using 1.5 gig"..
Out of interest, are you aware that Windows by default when using
"large" amounts of memory, will split the memory allocation down the
middle - between "applications" and "system"? So given your 4Gb of
memory, applications with be getting 2Gb..
Y
I'm more concerned with mysql only using 1.5 gig, wouldnt it be faster
to maximize memory usage? The only thing these box's do is mysql
I do have slow queries, but they are big joins across all the big
tables, and users doing querys on tables without using a key, the
contract requires dynamic
There are several binaries for linux and I picked
following for my Redhat Linux 2.1AS (32 bit) from
MYSQL site.
mysql-standard-4.1.11-pc-linux-gnu-i686.tar.gz
I installed by unzipping/untarring and started the
daemon as per instructions.
I also added mysql bin directory to my PATH variable.
Howe
I have MySQL & the downloaded ODBC drivers.
I am looking to use Crystal Reports to design & run my own reports on my
tables.
Can anyone tell me if the V11 Standard will happily work with MySQL or do I
need a different version?
Kerry
If I understand your problem, MySQL allows you to use regular
expressions - so you could use the REGEXP function to remove the
spaces. Check out the mysql site...
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
I have field varchar(20) that stores phone numbers. Phone number can
be in different format. So I need only digits from the field. How I
can do such replacement?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
Hi!
madderla sreedhar wrote:
Hi,
Iam looking to migrate an Oracle database to MySQL and
trying to write a simple stored procedure in MySQL 4.1
The manual states clearly:
"Stored procedures and functions are a new feature in MySQL version 5.0."
(At the proper place: "19 Stored Procedures and Functi
Hi,
Iam looking to migrate an Oracle database to MySQL and
trying to write a simple stored procedure in MySQL 4.1
.I reffered few examples posted and used the
statements from them but I get errors while creating
procedures
create procedure helloworld (out p_text VARCHAR(30))
BEGIN
set p_text = "
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
That's not good:
> DBD::mysql::db do failed: Lost connection to MySQL server during query
> at /vrmd/admin/cron/apps/purge_logs/purge_logs.pl line 15.
MySQL could die during your query. What is in error log?
Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> the curre
Hello.
The output of INNODB MONITOR is not clear for me (I hope only
for me, and someone more skilled could correct me). At:
http://dev.mysql.com/doc/mysql/en/innodb-locks-set.html
it is said that, SELECT ... FROM is a consistent read, reading a snapshot
of the database and setting no l
Hello.
The good support of timezones is on TODO list. See:
http://dev.mysql.com/doc/mysql/en/todo-future.html
"Monty Harris" <[EMAIL PROTECTED]> wrote:
> How does one cope with time zones? For example, if I want to timestamp a
> record it will timestanp using the local time of my
Hello.
SHOW STATUS and a piece of SHOW PROCESSLIST
with slow queries could give additional information,
so the probability of the helpful answer grows.
matt_lists <[EMAIL PROTECTED]> wrote:
> Anybody have any suggested settings for our my.ini ?
>
> 4 gig box, running windows 2003
>
>
Hello.
Somebody with the sniffer on the transit
router could get enough information about MySQL credentials. Try
to use SSL connection.
Nikola Skoric <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm wondering whether there is a way to hack into my database if I'm=
> connecting with PHP
on 4/28/05 1:41 AM, Johan Höök at [EMAIL PROTECTED] wrote:
> Hi Scott,
> you can do:
> SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
> ORDER BY FIELD(zip,94949, 94945, 94947)
That is too handy, thanks for the tip.
--
-
S
Michael Stassen wrote:
zzapper wrote:
> Hi,
> Final whinge: I wish the mysql website made it a little clearer
which > features are recent additions, I suggested color coding.
Philippe Poelvoorde wrote:
I reckon, it's a bit hidden in the middle :
"Starting with MySQL 4.0.4, you can also perfo
Hi Scott,
you can do:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
ORDER BY FIELD(zip,94949, 94945, 94947)
/Johan
Scott Haneda wrote:
mysql 4.0.18-standard
I am running this select:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
How can I get back a result set in the
mysql 4.0.18-standard
I am running this select:
SELECT a, b, c, from table where zip IN (94949, 94945, 94947)
How can I get back a result set in the order of the `IN` part of the
statement?
--
-
Scott Haneda
From: "Scott Gifford"
>SELECT COUNT(*) FROM firebase_content;
>
> to get the count. That's very fast; it comes from the table summary
> information, IIRC. I use a similar solution for a similar problem,
> and have had great luck with it.
This is true for MyISAM tables, but e.g. InnoDB does *
From: "Frank Bax"
> At 11:07 AM 4/27/05, Jigal van Hemert wrote:
> >So, if we would define that the key entry "0-NULL-Whatever" equals
> >"0-NULL-Whatever" (which MySQL is capable of if you look at the
definition
> >of UNIQUE indexes with BDB tables) then allowing NULLs as part of a key
> >entry w
72 matches
Mail list logo
