-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):
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.
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
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 sponsored
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
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 it
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!
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 if
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
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 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!
--
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.
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.
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
--
|...|
| _ _|Victor Medina M |
|\ \ \| | _ \ / \ |Linux - Java - MySQL |
| \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA |
| / / / |___| __/ ___ \ |[EMAIL
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
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 in
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
_
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
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
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
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:[EMAIL
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
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
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
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
#include time.h
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
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 table
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: Keith
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 index
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
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. The
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
deadlock.
Philipp,
- Original Message -
From: Philipp Steinkrger [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
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
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 had a number
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
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 ?
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 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
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
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,
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
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;
I think
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 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
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
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
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 start server :
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 did,
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.
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,
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 Linux
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,
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
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
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
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
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 distribution
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
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
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
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
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))
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
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
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
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:
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
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 as one
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 have
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,
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 know!
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
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
75 matches
Mail list logo
