Hi All,
After migrating to a new server, I have problems importing *.csv files to
the MySQL db.
When I try to do LOAD DATA INFILE
'/home/www/htdocs/helpdesk/systems/forms/users.csv' REPLACE INTO TABLE
`empl_navtech` FIELDS TERMINATED BY ',' ENCLOSED BY ''
I get the error: 13: Can't get
On 10-Mar-2003 Micha Brans wrote:
Hi All,
After migrating to a new server, I have problems importing *.csv files to
the MySQL db.
When I try to do LOAD DATA INFILE
'/home/www/htdocs/helpdesk/systems/forms/users.csv' REPLACE INTO TABLE
`empl_navtech` FIELDS TERMINATED BY ','
Dear all,
Which records in tbl1 are to be updated are determined by an INNER JOIN with tbl2. I
have tried the following:
UPDATE tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.id
SET tbl1.col1 = 0;
UPDATE tbl1, tbl2
SET tbl1.col1 = 0
WHERE tbl1.id = tbl2.id;
UPDATE tbl1
SET tbl1.col1 = 0
INNER JOIN
I use MySQL 3.23.
Hi,
Now my problem is, a user with no privilege is able to
run SQL command TRUNCATE table to empty any table!
Thanks for the bug report.
The bug has been entered into our bug database as bug #138:
http://bugs.mysql.com/bug.php?id=138
This will be fixed in the next release, 4.0.12.
Rgds,
Hi,
I'm very new to MySQL database design, and have been going
through a lot of tutorials and such but haven't seen a good example of
this yet.
I am currently working on a database for an ebusiness which will
need to have a database of products, customer information and so on.
I tried to use MySql 4.0.11-gamma-max gebug on W2K.
Mysql Service hang on delete from tbl_listdat;
Do you want to get further information about this problem?
I' m an experienced MySql user since years. I think this is a problem caused by a
combination of the table structure and the content.
Hi,
What I want to do is to update a table in a database and at the same time post
a message in a message queue. At the same time means in the same
transaction : I must be able to commit both operations or rollback both
operations.
As far as I know, what I need is a transaction manager that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Loïc QUERAN wrote:
Hi,
What I want to do is to update a table in a database and at the same time post
a message in a message queue. At the same time means in the same
transaction : I must be able to commit both operations or rollback both
On Saturday 08 March 2003 09:09, Heo Jungsu wrote:
I have a question about altering table which has foreign key constraints.
MySQL manual says that :
In InnoDB versions 3.23.50 ALTER TABLE or CREATE INDEX should not be
used in connection with tables which have foreign key constraints or
On Monday 10 March 2003 10:40, Hu Qinan wrote:
Which records in tbl1 are to be updated are determined by an INNER JOIN
with tbl2. I have tried the following:
UPDATE tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.id
SET tbl1.col1 = 0;
UPDATE tbl1, tbl2
SET tbl1.col1 = 0
WHERE tbl1.id = tbl2.id;
On Sunday 09 March 2003 11:17, Kian Kok Lim wrote:
Do you have a version of mysql that supports
transaction, with auto-commit (rollback and commit)
feature?
From your manuals, it appears that there is a BDB
version. How/Where can I access it?
Transactions work on InnoDB and BDB tables. You
On Saturday 08 March 2003 23:38, John David Duncan wrote:
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
No, it's not a bug, but a known
hey dudes, i'd really need some insight on this. Does anyone have any idea about this
?
TIA
heya,
I have a quick and painless (i hope :) )question..
Do you know how the username length is limited under MySQL. There is no mention of
this in the manual or books. I figured the username length
THE SITUATION:
We're running MySQL 3.23.51. We have a table which has a primary-keyed
field 'sid'. We have four tables what have foreign key references
on that field. We deleted all rows from those four tables that
had values in that foreign key index and then tried to delete the
row in the
Getting the following errors when trying to link client application
written in C:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0xaa): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
Hi,...
We work with MySQL 3.23.55 in a LINUX REDHAT Machine.
It used to work fine with our BDB Tables,.. but now we got the following
errors when we try to start the Database Server:
##
030310 15:09:08 mysqld started
030310 15:09:08 bdb: Log sequence error: page LSN 1:5242731;
If you want to use DNS, that's the way to go.
You can also use LVS to setup clusters of databases.
http://www.linuxvirtualserver.org
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 6:05 PM
To: John Masterson
Cc: [EMAIL PROTECTED]
Subject:
* Andrew
Actually thinking about this in a bit more depth! I also have
the infamous
items table where individual company records are being stored.
So is the best way to do this:
i) add another field that will coreespond to the items.ItemsID or
I don't know what you mean.
ii) create
Hi,
First, the version: 3.23.49
If I have a table with two elements: name char(128), n int
how do I have it so that n will increment each time?
I take it that name needs to be a primary key. How do I get
n to increment in vaue each time. This is not auto_increment.
I want name to be in the
Found it myself... checking the documentation isn't such a bad idea...
adding -lz did the trick.
/Lars
Getting the following errors when trying to link client application
written in C:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
On Friday 07 March 2003 17:52, gluk at php4 dot ru wrote:
Description:
UPDATE command fail with multiple myisam tables with error:
ERROR 1142: update command denied to user: '[EMAIL PROTECTED]' for table '***'
This situation occures only when non-root user make UPDATE and
On Sunday 09 March 2003 05:04, SUGIOKA Toshinobu wrote:
I found obvious bug that causes segmentation fault while building
on sh-linux. Please apply.
Regards,
SUGIOKA Toshinobu.
--- mysql-3.23.54a.orig/sql/gen_lex_hash.cc Thu Dec 5 18:37:06 2002
+++ mysql-3.23.54a/sql/gen_lex_hash.cc
As I read the manual, the REPLACE command will do what you want.
Make the name field UNIQUE, and the number field AUTO_INCREMENT NOT NULL.
Replace dos a delete-if-present, insert. The insert generates a new ID.
See test below, and note two rows affected by second replace.
mysql create table
Hi,
The date field in my database table looks as below:
07th of March 2003 10:14:29 PM
I need to write a query which gets me all the rows which are entered in last
to weeks.
Any ideas!!
Thanks and Regards
Anil.
-
Before
* Anil Garg
The date field in my database table looks as below:
07th of March 2003 10:14:29 PM
Then it is probably not a 'date field' in the sense that it is of type
date, datetime or timestamp.
I need to write a query which gets me all the rows which are
entered in last to weeks.
Any
Indexing in MySQL.
If while indexing a table I retrieve data from same table the indexing
process seems to get stuck. Mytop keeps saying something about
repairing keycache for days when the indexing shouldn't take more than
a couple of hours.
Can someone please explain!
--
Hi,
Great! This works, I did not use the 'null' and that is
where I had a problem. One other questions: is this atomic?
If I have several processes trying to do this at one time,
will each one correctly update the table (assuming they have
the same 'name' value. Also, in the part: unique
At 11:09 -0500 3/10/03, Douglas B. Jones wrote:
Hi,
Great! This works, I did not use the 'null' and that is
where I had a problem. One other questions: is this atomic?
If I have several processes trying to do this at one time,
will each one correctly update the table (assuming they have
the same
At 09:36 AM 3/10/2003, Anil Garg wrote:
The date field in my database table looks as below:
07th of March 2003 10:14:29 PM
Weird. All of my datetime variables look like '2003-03-07 22:14:29'. Are
these fields datetime field types or are they text that looks like a date?
If they are datetime,
At 14:35 +0100 3/10/03, Chand wrote:
hey dudes, i'd really need some insight on this. Does anyone have
any idea about this ?
TIA
heya,
I have a quick and painless (i hope :) )question..
Do you know how the username length is limited under MySQL. There is
no mention of this in the manual or
Thanks..that helped.
anil :)
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 10:52 AM
To: [EMAIL PROTECTED]
Cc: Anil Garg
Subject: Re: date query.
* Anil Garg
The date field in my database table looks as below:
07th of March 2003 10:14:29
I inadvertantly deleted the colonel's question, which I believe concerned
winmysqladmin.
Please give us more info. You should be able to see your databse(s) under the
database tab.
David
-
Before posting, please check:
On Fri, Mar 07, 2003 at 05:43:29PM -0800, Jeremy Zawodny wrote:
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
Hi. I wanted to connect from a client machine to a MySQL server using
ssh. I execute the following on the local machine (the server is
foo.bar.com):
% ssh -n -N
At 11:24 -0600 3/10/03, Pete Harlan wrote:
On Fri, Mar 07, 2003 at 05:43:29PM -0800, Jeremy Zawodny wrote:
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
Hi. I wanted to connect from a client machine to a MySQL server using
ssh. I execute the following on the local machine (the
Hi all,
I found a problem (bug?) when updating a blob column via MyODBC. The
statement i run is like that:
UPDATE blob_table SET blob_col = ? where id = ?
when i do NOT bind the restriction as input parameter, but write it directly
in the string, it works perfectly.
but when i want to bind the
I can't figure the solution:
#mysql -p -u Me sampdb create_president.sql
#Enter password:
ERROR 1 at line 5; Can't create/write to file './sampdb/president.frm'
(Errcode:13)
Please help.
-
Before posting, please check:
Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes approximately 7 seconds to
execute this 1000 times (UserName is char[50], and it is indexed). If I
change
At 11:36 -0700 3/10/03, Mark Berkwitt wrote:
I can't figure the solution:
#mysql -p -u Me sampdb create_president.sql
#Enter password:
ERROR 1 at line 5; Can't create/write to file './sampdb/president.frm'
(Errcode:13)
Please help.
% perror 1 13
Error code 1: Operation not permitted
Error
This may not be the solution you are looking for, but if you are executing
ths query 1000 times, it must be in a program somewhere, so why not execute
it once, pullout the UserID the run the rest on UserID?
Hope this helps.
Roger
-Original Message-
From: Jason West [mailto:[EMAIL
Hi
If you
tunnel the port, you have to be sure to block access to that
port from the outside, because outside connections to that
port (on the tunneling
client) will be tunneled too (under Linux anyway; I didn't
try it elsewhere).
That's potentially dangerous and not completely
At 13:39 -0500 3/10/03, Jason West wrote:
Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes approximately 7 seconds to
execute this 1000 times (UserName is
sql, mysql...
You might also try indexing only a portion of the char[50] index.
index UserName(20), for example...
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
sql, mysql...
oops, forgot the quotes
You might also try indexing only a portion of the char[50] index.
index (UserName(20)), for example...
David
-
Before posting, please check:
http://www.mysql.com/manual.php
On Mon, 10 Mar 2003 10:41:15 -0600
Paul DuBois [EMAIL PROTECTED] wrote:
At 14:35 +0100 3/10/03, Chand wrote:
hey dudes, i'd really need some insight on this. Does anyone have
any idea about this ?
TIA
heya,
I have a quick and painless (i hope :) )question..
Do you know how the
Description:
Running configure in an empty build directory to perform a VPATH build of mysql,
I noticed that configure created on temporary and one permanent file in $srcdir.
This shouldn't happen: $srcdir should be treated as read-only (e.g. to support
building from a read-only source partition,
On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote:
Whether it's a feature or not, it's not always so easy to figure out
what to do. If you specify -h localhost, it can be argued that you
really want the socket even if you specify the port. It can be
argued conversely that if you
I have a question regarding fixed width char fields. How do you create
them in MySQL? When I create a table and define a field MyField
char[50], when I run the describe table, the field shows up as a
varchar.
Thanks,
--
Jason H. West
Software Engineer
Softek Software International, Inc.
813
If you're indexing all 50 characters, index fewer of them.
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT query to, if anything, go slower...?
I'm probably wrong, though,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sheryl --
...and then Sheryl Canter said...
%
% I have a big problem to solve on my site, and I'm not sure how to approach
% it. I'm selling software that's distributed as trialware (will be--haven't
Best of luck! :-)
% launched yet). Users will
If your create table statement has both char's and varchar's in it, then MySQL
converts the char's all to
varchar's.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
on 3/10/03 9:24 AM, Pete Harlan at [EMAIL PROTECTED] wrote:
If you want to connect to localhost via TCP/IP, you have to specify
the host by IP address (127.0.0.1), not as localhost.
Tried that, it doesn't work. In my case, I call ssh like this:
ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.com
According to the microsoft web site, SQLFetch should
update the variable SQL_ATTR_ROWS_FETCHED_PTR with the
number of rows fetched.
A fairly simple change to results.c, line 657
if (stmt-stmt_options.rowsFetchedPtr)
*stmt-stmt_options.rowsFetchedPtr= 1;
fixes this.
Thanks,
Laramie
On Mon 2003-03-10 at 15:06:05 -0500, [EMAIL PROTECTED] wrote:
If you're indexing all 50 characters, index fewer of them.
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT
Benjamin Pflugmann wrote:
If you have 256MB, the one may fit into memory,
the other may not and therefore requires additional disk reads.
Ah, see.. I hadn't thought of disk reads. I was thinking if you do a
select on a char[50] and the whole field is indexed, wouldn't the search
algorithm
Description:
Performing a VPATH build inside an empty build directory fails to compile
sql/mysqld.c since the generated db.h (which is created in
$top_builddir/bdb/build_unix) isn't found:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\
-DDATADIR=\/usr/local/var\
On 10 Mar 2003, at 16:31, Tab Alleman wrote:
I was thinking if you do a select on a char[50] and the whole field
is indexed, wouldn't the search algorithm know exactly where to go
to look for a match, as opposed to - if only the first 20 characters
are indexed - finding all of the possible
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I am having a bit of trouble with GRANT and users and database access. I
would like to do two things:
- - Given a system user 'junk' I would like to create a master user
'junk' that can have all permissions (including grant?) on all
Description:
If configuring with --with-innobase and non-standard configure flags (like
--enable-maintainer-mode), those flags are not passed to the configure
run in the innobase subdirectory. Since the sub-configure is run with many
variables in the environment (see innobase/config.status sub
Hello
I would asume that these two queries would give the same output? Am I wrong?
Seems like the where part don't have any effect on the LEFT JOIN when it
comes to MIN() and MAX().
SELECT count( plads_ordre.id )
as antal, MIN( forestilling.arrangement_id )
as min, MAX(
I have MySQL 3.23, running on Windows XP. I don't seem to be able to make my
tables Innodb type. Is there something I should install, or some script I
should configure. Looking on the MySQL site, I noticed there was a script I
should run. I'm so inexperience with MySQL, I don't know what it meant
Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the
mysqlcc GUI (through a SSH session), and for some reason when I try to
connect I get the error:
[localhost] ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Now I was reading that
why don't you try...
mysql SHOW GRANTS for 'junk'@'localhost'
just to see what has been granted at present?
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
MySQL must be compiled with support for InnoDB, if yours wasn't, you
wouldn't be able to use InnoDB tables. You can download a MySQL binary here:
http://www.mysql.com/downloads/mysql-3.23.html
According to the InnoDB quick start page
(http://www.innodb.com/howtouse.html), you'll want MySQL-max:
At 22:28 + 3/10/03, Paul Taylor wrote:
I have MySQL 3.23, running on Windows XP. I don't seem to be able to make my
tables Innodb type. Is there something I should install, or some script I
should configure. Looking on the MySQL site, I noticed there was a script I
should run. I'm so
At 14:37 -0800 3/10/03, DuSTiN KRySaK wrote:
Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the
mysqlcc GUI (through a SSH session), and for some reason when I try to
connect I get the error:
[localhost] ERROR 2002: Can't connect to local MySQL server through socket
Description:
Performing a VPATH build on Solaris 8/SPARC with innobase support and
the previously reported VPATH build problem (no -I options for $srcdir) fixed
by editing the generated innobase Makefiles adding -I$(srcdir)/../../include
-I$(srcdir)/../include to INCLUDES proceeds, but fails to
Hi!
On Mon 2003-03-10 at 16:44:40 -0500, [EMAIL PROTECTED] wrote:
[...]
- Given a system user 'junk' I would like to create a master user
'junk' that can have all permissions (including grant?) on all 'junk_*'
databases so that he can create and manage his own databases
- Given a master
Description:
Performing a VPATH build with innobase support included fails since the
innobase headers in $(top_srcdir)/innobase/include are not found:
gcc -DHAVE_CONFIG_H -I. -I/vol/mysql/src/mysql/dist/mysql-3.23.55/innobase/os -I..
-I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF
Well, I'm on the verge of giving up on connecting to the MySQL server
externally. I've updated the Host fields in the User and Db tables to
be %, but I still get error 1130 when I connect, and the user name
isn't transmitted.
The manager of the database (it isn't mine) claims PHPmyAdmin (which
Hi!
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? I know I can create a column
in each table that describes which table the row actually is being
retrieved from, but I am looking for a more intelligent solution.
Thanks! :-)
I have just upgraded from MySQL 3.23.32 to 3.23.55 on my RedHat 8 server.
Everything is working fine except that I get FAILED for MySQL when shutting down.
I have not changed any settings at all. And the FAILED message does
not seem to affect anything with MySQL operations. How do I go abt
I have run into a problem where data is truncated when sending to MySql via
a SSL connection, I can not determine whether this is my server or just the
protocol, I hope the later, as I know web* 4, which is what I am using will
never get it fixed. Anyone with php and apache running SSL, would you
I hope I've subscribed to the right list.
I am using version 3.23.41 of MySQL, and I'm having a problem getting
correct (expected?) behavior with column aliases.
I have a database A which has, among other things, an id field,
something like this:
CREATE TABLE a {
somedata VARCHAR(10),
id INT
Dear All,
I reinstalled the Linux (SuSE Linux ver 8.0) on my machine and selected
MySQL from the Linux CD itself. While starting mysqld daemon through
safe_mysqld script, it is giving the following Error and daemon has ended
immediatly. I had pasted the messages on my screen below. Kindly let me
Hi Loren
I started over; uninstalled mysql and reinstalled.
The file I used was mysql-3.23.55-win
This unzipped ok and installed into a folder called mysql on my c drive.
Following http://www.mysql.com/doc/en/Windows_server_first_start.html
the first thing I tried was:
Well, believe it or not SUCCESS!! That's right, you were running the mysql
Server.
Now for something you should try. Find the winmysqladmin.exe (Should be in
the same folder. Run that one. It will allow you to run the mysqld as a
service, give you stat's on whats going on, and start and stop
Please help me with the following c code:
sprintf(update, update chrc set center=');
len = 24;
memcpy(update+len, center, 128);
len += 128;
sprintf(update+len, ', var=');
len += 8;
At 6:08 +0100 3/11/03, Harish B M (RBIN/ECM2) * wrote:
Dear All,
I reinstalled the Linux (SuSE Linux ver 8.0) on my machine and selected
MySQL from the Linux CD itself. While starting mysqld daemon through
safe_mysqld script, it is giving the following Error and daemon has ended
immediatly. I had
At 16:15 +1100 3/11/03, Philip McCarthy wrote:
Hi Loren
I started over; uninstalled mysql and reinstalled.
The file I used was mysql-3.23.55-win
This unzipped ok and installed into a folder called mysql on my c drive.
Following
Hi,
query question:
I have 2 tables created using Mysql:
1) Players
Name(varchar),Team(varchar),Goals(tinyint),Assists(tinyint),Shutouts(tinyint),points(int).
2)draftees
ID(smallint),Name(varchar),Phone(varchar),Player(varchar)
The problem I run into is when I run this statement only
How do I write a SQL call to take the results of a select statement and
plug them into a new table in the DB?
Thanks
Phillip
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi!
Sorry for the repost, but I am really eager to hear the verdict so I
give it another go, thanks ;-)
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? The reason I need to know
this is that I present info from different tables
Hi all,
I got MySQL 3.23.55-nt running on XP and MySQL Client 3.23.36 running on
Linux Red Hat 7. I'm trying to have the client connect to the server but I
get the same error all the time:
[EMAIL PROTECTED] /root]# mysql -h 10.0.0.41 -u guest
ERROR 1130: Host '10.0.0.220' is not allowed to
84 matches
Mail list logo