Hi!
On Apr 07, Hirofumi Fujiwara wrote:
>
> From: Sergei Golubchik <[EMAIL PROTECTED]>
> > Hi!
> >
> > On Apr 06, Hirofumi Fujiwara wrote:
> > >
> > > I am testing regular expression feature of MYSQL 4.1.1-alpha
> > > (REGEXP) with UTF-8 characters (Japanese). So far it doesn't
> > > seem to w
Hi,
somebody can help me!
my database is: mysql-5.0.0a-alpha
the connection driver is:mysql-connector-java-3.1.1-alpha-bin.jar
I want to test stored procedure of the new feature in MySQL version 5.0. A
I can call the stored procedure procPara in Window Console as next show,
but when I run in pr
Pete Harlan wrote:
On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote:
At 17:29 -0700 4/5/04, Daevid Vincent wrote:
I'm curious when will I be able to do something like this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) as
active FROM wifi_table WHERE active
FABULOUS! It works like a charm, even on a very complex series of commands.
Redirected output into a file, and viola!
Thanks a bunch!
On 4/6/04 22:17, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
>> Okay, so I didn't miss anything... Good to
At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
Okay, so I didn't miss anything... Good to know! Any way I CAN create an
output file with those names? Maybe if I make a table first?
One way, if tab-delimited output is satisfactory, is to just run
mysql in batch mode.
In interactive mode, yo
Okay, so I didn't miss anything... Good to know! Any way I CAN create an
output file with those names? Maybe if I make a table first?
On 4/6/04 21:43, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
>> I've scoured the online documentation, and I
From: Sergei Golubchik <[EMAIL PROTECTED]>
> Hi!
>
> On Apr 06, Hirofumi Fujiwara wrote:
> >
> > I am testing regular expression feature of MYSQL 4.1.1-alpha
> > (REGEXP) with UTF-8 characters (Japanese). So far it doesn't
> > seem to work.
> >
> > LIKE handles each Japanese character properly
At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
I've scoured the online documentation, and I have a good SELECT into OUTFILE
query that gives me what I want... Except that there is no 1st row with
column names.
Hoping I missed something obvious... Any pointers on this one?
You can't do it w
I've scoured the online documentation, and I have a good SELECT into OUTFILE
query that gives me what I want... Except that there is no 1st row with
column names.
Hoping I missed something obvious... Any pointers on this one?
--
David L. Van Brunt, Ph.D.
Outlier Consulting & Development
mailto:
Adam,
That won't work. Daevid doesn't have a column named active. Nor does he
have to do the math twice. As was pointed out earlier, he can do what he
wants using HAVING instead of WHERE, like this:
SELECT *,
IF(((unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) active
FROM wifi
I want to use rsync to backup my db server, how do i lock all the tables for all the
db's to read only so i cando my backup, then unlock them again. It needs to be done
from the command line, not the mysql program. Anyone have any ideas? I have looked
and couldn't find the answer i was lookin
Hi,
I have problem with Mysql 3.23.58 on Linux
Mysql can't auto Flush-Tables
I work with Mysql 3.23.58 windows version on my local computer...
Then I upload to web-hosting that working with Mysql 3.23.58 on Linux..
Everytime I add some record on my local computer then upload to
web-hosti
Daevid,
SELECT *
FROM wifi_table
WHERE active = 1
HAVING unix_timestamp()-unix_timestamp(last_seen) < 600;
Regards,
Adam
On Apr 5, 2004, at 8:29 PM, Daevid Vincent wrote:
I'm curious when will I be able to do something like this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen))
Sorry,
I wasn't paying attention. I didn't realize you were talking about the mysql
db. Downgrade to 3.23.52. Import the .sql from your previous dump. Then
upgrade per the latest manual ensuring your upgrade the grant tables (per
page 138 in the new pdf manual).
I hope this is a little more helpfu
Hey all. I had asked a few days ago if anyone had experience installing 4.1
on the Mac and got no reply, but that's cool :-). Has anyone installed 5.0
on the Mac? Any problems? I'd like to try it, but I thought I'd ask and
see if there was anything I needed to know before I tried installing it.
Sorry. I can imagine how frustrated you must be.
In mysql 5, condition is a reserved word, so the person who told you to
remove the quotes was wrong, at least for that column. (In his defense,
CONDITION is relevant to stored procedures, so it isn't a reserved word for
versions prior to 5, as
Thanks for the responses but after "copying and pasting" this into the
>mysql command prompt I now get the following error:
Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
condition varchar(10) NOT N
What we've done on Red Hat 7.3, 8.0 and 9.0 boxes, then on a SuSE 9.0 box is
to set up InnoDB and have multiple files defined at 2GB. We just keep
adding additional files as we need them and performance seems to be holding
okay.
-Original Message-
From: Eric Gunnett [mailto:[EMAIL PROTECT
Thank you, a much reasoned and sensible reply.
This is information people can use, as oppose to the posts that 'say
well its okay for me, you must be stupid' types.
;)
Dan Nelson wrote:
In the last episode (Apr 06), Alan Williamson said:
the most popular would have been Red Hat, which doesn't
In the last episode (Apr 06), Alan Williamson said:
> >the most popular would have been Red Hat, which doesn't have this
> >limit you speak of, even plain vanilla install (no twiddling
> >needed).
>
> Not to spoil a perfectly good pontification ... but i have to say
> that we have a Redhat8 distri
Brad Tilley wrote:
On Tuesday 06 April 2004 17:28, dan wrote:
Just wanted to point out that 32 bit
systems have limitations. 2^32 = 4 billion that's the max. Addressing more space than that requires a bit of black magic.
All it takes a some arbitrary precision math. Since we are talking
ab
I have had this happen on 2 boxes one running Redhat 7.2 and the other running
Redhat 8. I can tell MySQL does not like not being able to write to the file anymore.
We were using MySQL 3.23 on one box and 4 on the other box. The table crashed. Causing
a lot of corruption. In one instance it ac
Heikki,
Its: mysql-standard-4.0.17-pc-linux-i686
Then I got an other question related, we get those errors after
intensive insert select type of queries.
From MySQL documentation:
To ensure that the binary log can be used to re-create the original
tables, MySQL will not allow concurrent insert
dan wrote:
the most popular would have been Red Hat, which doesn't have this limit
you speak of, even plain vanilla install (no twiddling needed).
Not to spoil a perfectly good pontification ... but i have to say that
we have a Redhat8 distribution running on a Dell PowerEdge Server and
when A
On Tuesday 06 April 2004 17:28, dan wrote:
> nice flame! :)
> btw-
> Doesnt exist in out-of-the-box Linux distros,
> or any distro you can currently download.
> or any distro you could download (or buy) over the last few years.
>
> it doesnt occur in "vanilla" distributions or any other
> retail, c
Patrick,
> >From your description, I assume you already have data in an existing
version
> 4 database that has existing table structures that are different from your
> 3.23 dump.
I didn´t have datas, but I had already run the mysql upgrade script.
Because the original version of the MySQL in Linu
nice flame! :)
btw-
Doesnt exist in out-of-the-box Linux distros,
or any distro you can currently download.
or any distro you could download (or buy) over the last few years.
it doesnt occur in "vanilla" distributions or any other
retail, commercial, or otherwise distribution...
well maybe Suse,
>From your description, I assume you already have data in an existing version
4 database that has existing table structures that are different from your
3.23 dump.
One method of preserving your existing 4.x data would be to create a new
database in the 4.x version for importing your 3.23 data. Wh
On Tuesday 06 April 2004 16:31, dan wrote:
> Uhm,
> what are you talking about?!?
>
> Linux has no such limitation.
> you can grow files as large as you like.
> right now I have an InnoDB dbase with Mysql on a linux
> system and the file is over 60 GIGS in size!
>
> maybe you meant 2 Tb? and if you
The user that mysql run as, has permission to write
in the /var/run/mysql dir?
Ronan
> muhammad alqama wrote:
> > hi
> >
> > **(plz someone help me urgently)**
> >
> > i have tried the procedure mentioned below but of no avail.
> > this is the exact message in .err file
> >
> > "can not s
Hi All,
I have another question:
I have a .sql file from a mysqldump did in a mysql-3.23.x
Is there a way to restore it in a mysql-4.0.17?
I´m trying to do it but the mysql return some errors like:
# mysql -u root -p < ./dump-database.sql
Enter password:
ERROR 1050 at line 1923
muhammad alqama wrote:
hi
**(plz someone help me urgently)**
i have tried the procedure mentioned below but of no avail.
this is the exact message in .err file
"can not start server : bind on unix socket : permission denied
do you have another mysql server running on socket /var/run/mysql
> Uhm,
> what are you talking about?!?
When I put our site on a Linux system, apache stop working when
it´s logfile get major than 2 Gb.
I was afraid of it´d happen with MySQL, too.
> Linux has no such limitation.
> you can grow files as large as you like.
> right now I have an InnoDB dbase with
The 2GB (not 2 Mb) file size limitation on Linux went away years ago.
Unless your distribution is very old you won't have a problem.
--Pete
On Tue, Apr 06, 2004 at 05:05:59PM -0300, Ronan Lucio wrote:
> Hi All,
>
> I always worked with MySQL on FreeBSD systems.
>
> Now I need to install am MyS
On Mon, Apr 05, 2004 at 08:03:33PM -0500, Paul DuBois wrote:
> At 17:29 -0700 4/5/04, Daevid Vincent wrote:
> >I'm curious when will I be able to do something like this:
> >
> >SELECT *, IF(( (unix_timestamp()-unix_timestamp(last_seen)) < 600),1,0) as
> >active FROM wifi_table WHERE active = 1;
>
Uhm,
what are you talking about?!?
Linux has no such limitation.
you can grow files as large as you like.
right now I have an InnoDB dbase with Mysql on a linux
system and the file is over 60 GIGS in size!
maybe you meant 2 Tb? and if you did, let's see you make one that big.
Dan.
On Tue, 6 Apr
Ville Mattila wrote:
Hello readers,
I was wondering if there is a feature in MySQL that allows us to insert
a row with only some values from another table. INSERT...SELECT syntax
helps to insert multiple rows and it seems not to allow any constant
values.
Let's clarify the case with an exam
Volnei Galbino wrote:
Olá pessoal,
Estou fazendo um trabalho em API C na área de otimização de consulta. O
meu problema esta em medir o tempo utilizado pela consulta. Estou usando
difftime(end,start) para avaliar o tempo, só ele está fornecendo o temo
em segundos, o que, na maioria das vezes, não
As root, you start the mysql server. The first thing the server does is
switch to running as the mysql user, then it tries to bind the socket. Most
likely, your problem is that the mysql user does not have permission to
write the socket file in /var/run/mysql. As root, run `chown mysql:mysql
Hi All,
I always worked with MySQL on FreeBSD systems.
Now I need to install am MySQL with InnoDB and MyISAM
tables in ta Linux RH system.
So, do I need to care about the Linux file size limitation of 2 Mb?
Or MySQL deal this situation with Linux FS?
In other words, will my MySQL stop working w
Yves Goergen wrote:
Just a short question:
does MySQL version 5.0 contain all features of version 4.1? And will new
additions to 4.1 also be implemented to 5.0 in the same step or may it
take some time for both versions to be synchronous?
generally yes! =)
--
|
hi
**(plz someone help me urgently)**
i have tried the procedure mentioned below but of no avail.
this is the exact message in .err file
"can not start server : bind on unix socket : permission denied
do you have another mysql server running on socket /var/run/mysql/mysql.sock ?
/usr/lib
Hi,
This post does in fact more belong to a windows-emulator group, but I've had
no success there. Maybe someone on this list knows what's wrong.
I want to make a database with an ms-access frontend (using codewavers wine
implementation) and a mysql backend.
I've installed ms-access (under cod
Joshua,
- Original Message -
From: ""Joshua Thomas"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, March 29, 2004 7:48 PM
Subject: mysqld keeps crashing
> Hello all,
>
> I'm running mysql 4.1.0-alpha-log on FreeBSD 5.1, with InnoDB.
>
> In the last month, I've ha
Hello readers,
I was wondering if there is a feature in MySQL that allows us to insert
a row with only some values from another table. INSERT...SELECT syntax
helps to insert multiple rows and it seems not to allow any constant values.
Let's clarify the case with an example.
I have a table of c
Philipp,
- Original Message -
From: "Philipp Steinkrüger" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 31, 2004 3:59 PM
Subject: Mysql 4.0.18 crashed6384512
> --=_NextPart_000_002D_01C4172E.C75E7F90
> Content-Type: text/plain;
> charset="iso-8859-1"
Bryan,
- Original Message -
From: ""Bryan Heitman"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 01, 2004 1:53 AM
Subject: InnoDB Deadlock cannot find free slot for undo
> Looking for some help on tuning my InnoDB settings. I received a InnoDB
> deadloc
Rick,
- Original Message -
From: "Rick Ellis" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 01, 2004 11:27 AM
Subject: InnoDB problems with 4.0.18-max
> Hi Guys,
>
> We are currently using MySQL as the backend to the RT Request Tracker
> Ticketing system.
Hello,
I successfully compiled MySQL embedded library from
source. It resulted in libmysqld.dll and libmysqld.lib
created in lib_debug directory.
Compiling my test application after linking it with
libmysqld.lib and using libmysqld.dll it is never
going past mysql_server_init.
If I debug it by p
Abdulla,
- Original Message -
From: ""Paizulaev Abdula"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, April 05, 2004 7:43 AM
Subject: mysqld crash, got following
> InnoDB: Error: record field 3 len 4294967207
> Heap no too big 5888 93
> Error in page 117145 in i
Hi!
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, April 03, 2004 1:02 AM
Subject: Re: innodb_buffer_pool_size limit
> In the last episode (Apr 02), Dathan Vance Pattishall said:
> > > -Original Message-
> > > From
Philippe,
- Original Message -
From: "Philippe Lewicki" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, April 06, 2004 5:56 AM
Subject: read_key: Got error 146 when reading table
> Hi,
>
> Found that error in .err log file:
> read_key: Got error 146 when reading t
#include
clock_t start, end;
double elapsed;
start = clock();
... /* Do the work. */
end = clock();
elapsed = ((double) (end - start)) / CLOCKS_PER_SEC;
from
http://www.informatik.uni-hamburg.de/RZ/software/gnu/libraries/libc_17.html#SEC293
This should be really high rez.
Hope that helps-
Jack-
I think it's pretty much based on preference. I prefer doing everything in
epoch, it seems to make it easier for me.
This means that the queries would be selecting for business hours, based
on epoch time. We do this for our
pix logs, web stats, etc... Calculations are much easier this way
Hello,
I am making a work in API C in the area of query optimization.
My problem this in measuring the time used by the query.
I am using difftime(end,start) to evaluate the time, only he is
supplying it fear in seconds, which, most of the time, it is not
relevant.
How to do so t
Marvin Cummings wrote:
I attempt to create this table from the command line and get the following
error:
Error 1064 (42000): You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL version for the right syntax to use near
''ad_id' smallint(5) unsigned NOT NULL auto_
I'm using MySQL to track data throughput information on my company's
routers. The routers are queried every 5 minutes 24 hours/day. I need to
produce a report showing data accumulated during business hours - Monday
through Friday, 8:00-5:00.
The program to pull the data and manipulate it will be
Looks like you are using backticks instead of single quotes on your
column names. You don't really need the quotes on your table name or
column names anyway, so I'd just remove them.
On Tue, 2004-04-06 at 09:29, Marvin Cummings wrote:
>
>
>
> _
>
> From: Marvin Cummings [mailto:[EMAI
Marvin Cummings writes:
>I attempt to create this table from the command line and get the following
>error:
Marvin,
the use of the "'" [single quote] appears to be your problem. I've
been able to create the table on 4.0.18 using the following syntax:
CREATE TABLE nuke_zc_ads
(
ad_id smalli
Hi, the table name and the column names dont have to be inclosed by ' '.
Carlos
Original Message Follows
From: "Marvin Cummings" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Need help creating table...
Date: Tue, 6 Apr 2004 12:29:48 -0400
_
From: Marvin Cummings [mailt
_
From: Marvin Cummings [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:26 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Need help creating table...
I attempt to create this table from the command line and get the following
error:
Error 1064 (42000): You have
Just a short question:
does MySQL version 5.0 contain all features of version 4.1? And will new
additions to 4.1 also be implemented to 5.0 in the same step or may it
take some time for both versions to be synchronous?
--
Yves Goergen <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list ar
Egor Egorov wrote:
Francisco Ivan Anton Prieto <[EMAIL PROTECTED]> wrote:
I am crazy with a problem.
I would like to know the best method to SELECT affected rows after an
UPDATE.
If you set column values to the new (different from current value), you can just use the same WHERE clause i
Francisco Ivan Anton Prieto <[EMAIL PROTECTED]> wrote:
> I am crazy with a problem.
>
> I would like to know the best method to SELECT affected rows after an
> UPDATE.
>
If you set column values to the new (different from current value), you can just use
the same WHERE clause in the SELECT sta
--
|...|
| _ _|Victor Medina M |
|\ \ \| | _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA |
| / / / |___| __/ ___ \ |[EMAIL PROTECTED
Olá pessoal,
Estou fazendo um trabalho em API C na área de otimização de consulta. O
meu problema esta em medir o tempo utilizado pela consulta. Estou usando
difftime(end,start) para avaliar o tempo, só ele está fornecendo o temo
em segundos, o que, na maioria das vezes, não é relevante. Como faz
Egor Egorov wrote:
"Andy B" <[EMAIL PROTECTED]> wrote:
hi...
what would be the best field type and length for an md5 encrypted password sort of thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
Or for binary MD5 (and not the hex version) a TINYBLOB(16) should also
be OK.
Hi all!
I am currently developing a small pos (point of sale) application. The
pos will run on linux and will use java and mysql. I best guess, is that
only one client will access the db during normal operations. I would
like to know wich, in your opinion, should be the best option to use.
The
Hi all!
When compiling mysql(4.0, 4.1 or 5) can I use a external Berkeley db
source, and not the one provided with mysql source? I know that the
configure script provides a --with-berkeley-db-includes and -libs, but..
up to what version of bdb can i use? Can I use the latest?
Best Regards!
--
I am crazy with a problem.
I would like to know the best method to SELECT affected rows after an
UPDATE.
Thanks to all by your help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am trying to install MySQL Administrator 1.0.2.b-alpha on Solaris 7
operating system,
(since it seems I can manage almost nothing from a remote PC thru MySQL
Administrator)
When I try to do what suggested (linux section) in the MySQL
Administrator FAQ on MySQL website that is
===
Hi!
On Apr 06, Hirofumi Fujiwara wrote:
>
> I am testing regular expression feature of MYSQL 4.1.1-alpha
> (REGEXP) with UTF-8 characters (Japanese). So far it doesn't
> seem to work.
>
> LIKE handles each Japanese character properly as one character,
> but REGEXP doesn't.
>
> I'd like to know
hi
i have tried the procedure mentioned below but of no avail.
this is the exact message in .err file
"can not start server : bind on unix socket : permission denied
do you have another mysql server running on socket /var/run/mysql/mysql.sock ?
/usr/libexec/mysqld : shutdown complete
mysqld ended
Hi Joshua,
> Making the MySQL indexes would be your responsibility. Importing the data
> would most likely not import the index definitions also. You need to
> recreate those. Your explain seems to indicate that you have *no* indexes
on
> your table. I would guess that your query doesn't hang
think you for your help,
all things work well know but the problem is when i want to use snort in
mode NIDS i must change the directory of mysql.sock in my.cnf file from
/tmp/mysql.sock to /var/lib/mysql/mysql.sock as knowing as the mysql.sock
directory file is /tmp/mysql.sock so i did a link i
"Andy B" <[EMAIL PROTECTED]> wrote:
> hi...
>
> what would be the best field type and length for an md5 encrypted password sort of
> thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spo
Please reply to the list, and not to me. Thanks.
Making the MySQL indexes would be your responsibility. Importing the data
would most likely not import the index definitions also. You need to
recreate those. Your explain seems to indicate that you have *no* indexes on
your table. I would g
I am testing regular expression feature of MYSQL 4.1.1-alpha
(REGEXP) with UTF-8 characters (Japanese). So far it doesn't
seem to work.
LIKE handles each Japanese character properly as one character,
but REGEXP doesn't.
I'd like to know if REGEXP handles UTF-8 characters.
-
-Original Message-
From: Marvin Cummings [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 3:11 AM
To: 'Michael Stassen'
Subject: RE: Need help creating table using phpMyAdmin
I attempt to create this table from the command line and get the following
error:
Error 1064 (42000): Yo
79 matches
Mail list logo