Can anyone guess why I am getting this error:
"ERROR 1: Can't create/write to file
'/Users/johnmistler/Desktop/TestFile.txt' (ERRCODE 13)"
when using this statement:
mysql> SELECT * INTO OUTFILE '/Users/johnmistler/Desktop/TestFile.txt' FROM
theTable WHERE column1 != 'thisString';
? I am loggi
I am trying to build a stored procedure in v. 5.
This is what I have so far.
delimiter |
create procedure get_id(out oid int)
begin
insert into mercury.merchant (name) values(null);
select last_insert_id() into @mid;
insert into mercury.customers( address1 ) values (null);
select l
ColdFusion Lists wrote:
Hi
my table have an field when users can enter any chars
If users dont send any content for that field(phone), mysql store "( ) - "
without quotes in that
What im looking for:
Display IF phone field is ( ) - NOT ENTER
Otherwise display the phone of user.
> Peter,
> Actually,
>
> Mysql -uUSERNAME -pPASSWORD works just fine.
>
> Donny
And `mysql -u root -p somepassword` will not work. With the space between
-p and "somepassword", mysql will attempt to interpret "somepassword" as the
name of a database.
As to the original question, the problem app
At 12:38 -0700 on 05/27/2004, Daevid Vincent wrote about Re: Feature
Request: UPDATE 'error codes' or mysql_affected:
REPLACE INTO won't work, as I need the previous record (hence the update). I
store the first and last time I saw a node, amongst other info. REPLACE
would delete that data.
REPLAC
[EMAIL PROTECTED] wrote:
Ultimately simple, but I don't find the answer: how to stop a list
from scrolling to the bottom when the command SHOW TABLES is entered.
I assume you are referring to the command line of the mysql client?
I use:
mysql>\P more
or
mysql>\P less
depending on my mood.
Other
Nik Belajcic wrote:
This may be a silly question, but I am wondering if there is something
opposite to:
@row = $sth->fetchrow_array
In other words, instead of fetching rows from MySQL and loading them
into an array that can be accessed from Perl, I want to do the opposite
- take a Perl (associative
i had the same problem,
for me it was here:
c:\mysql\lib\opt
and I copied it to
c:\mysql\bin\
that got me up and running. maybe it'll work for you.
cheers
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 01, 2004 10:38 AM
Subject: error
I've
sure that isn't c:\winnt\system32? see if you can find the libmysql.dll
file on your computer and copy it into c:\winnt\system. It's not the most
elegant solution...but it'll work.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 31, 2004 7:38 PM
I've installed mysql on my windows 2000 system, with the windows installer. When it's
done and I double click on winmysql admin I get this error -
The dynamic link library LIBMYSQL.dll could not be found in the specified path
C:\mysql\bin;.;C:\WINNET\system32;C:\WINNT\system
etc
Jonathan,
I have no idea, but I can tell you about the stability of the 4.1 tree from
my experience. If you are using MySQL for anything besides prepared
statements, I would say don't worry if it's beta or not. It works and works
great! The only reason I mention anything about prepared statement
This may be a silly question, but I am wondering if there is something
opposite to:
@row = $sth->fetchrow_array
In other words, instead of fetching rows from MySQL and loading them
into an array that can be accessed from Perl, I want to do the opposite
- take a Perl (associative) array and load i
Hi Guys,
I'm just wondering if anyone could tell me when 4.1 will be moving to Beta?
I was told by a MySQL guy at Linux Conf AU 2004 (January) that 4.1 would
be in Beta by March!!
As such, we have been developing applications on 4.1, but are hesitant
to roll them into production on Alpha softwar
Peter,
Actually,
Mysql -uUSERNAME -pPASSWORD works just fine.
Donny
> -Original Message-
> From: Sunmaia [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 31, 2004 7:44 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Root users permissions not working
>
> hi
>
> this may be
hi
this may be the problem or it may just be a typo!
you are showing
#mysql -u root -psomepassword
which should be
#mysql -u root -p somepassword
(note the space after -p)
the first will not pass the password, which would explain the lack of
privileges.
Otherwise start with skip-grant-tables
Hi Guys,
I have been using mysql for a year now without any problems. Recently, I
just noticed that my root user is not able to create any databases when I
login. I have tried to change my root password and try but it does not
work:
--
#mysql -u root -psomepassword
Welcome to the MySQL monitor.
I've been running OPTIMIZE TABLE on a MyISAM table with an index on two
varchar type columns. The process status shows as "Repair with
keycache". The table has 73 million rows. OPTIMIZE TABLE has
been running for several days with constant disk activity but low cpu
usage and no way to estimate wh
Hi
my table have an field when users can enter any chars
If users dont send any content for that field(phone), mysql store "( ) - " without
quotes in that
What im looking for:
Display IF phone field is ( ) - NOT ENTER
Otherwise display the phone of user.
It's possib
I want to do something like this:
delete from records where records.id in (select audit_log_records.id
from audit_log_records, audit_log where
audit_log.tracker_id=audit_log_records.tracker_id and
audit_log.operation='D');
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Oropeza Querejeta, Alejandro wrote:
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Is it possible to select data from different Databases on Different
servers across the network?
I searched for information on how to do it, but i haven't found any.
Best
Rhino wrote:
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 31, 2004 2:20 PM
Subject: Stop Scrolling
Ultimately simple, but I don't find the answer: how to stop a list from
scrolling to the bottom when the command SHOW TABLES is entered.
Rhino wrote:
Ultimately simple, but I don't find the answer: how to stop a list from
scrolling to the bottom when the command SHOW TABLES is entered.
I was wondering that myself so I took a look in the manual and found
something promising: pager. See
http://dev.mysql.com/doc/mysql/en/mysql_Command
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 31, 2004 2:20 PM
Subject: Stop Scrolling
> Ultimately simple, but I don't find the answer: how to stop a list from
> scrolling to the bottom when the command SHOW TABLES is entered.
>
I was wonderi
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Is it possible to select data from different Databases on Different
servers across the network?
I searched for information on how to do it, but i haven't found any.
Best Regards
Alejandro
What version of MySQL are you using? Subqueries aren't available until
4.1.x.
saiph wrote:
hi,
mysql> update table1
set c = (select c2 from table2 where c2 = 'value')
where id = 123;
give me an ERROR 1064.
i.e.
create table t1 ( id int primary key, name varchar(20) );
create table t2 ( id int pr
Bernard Chambon wrote:
I try to understand index usage for 'order by'
but that's seemn hard to me.
Here is what I have tried :
1_ About documentation
I have read carefully related documentation (7.2.9 How MySQL Optimizes
ORDER BY) but
I don't understand it.
- What is the difference betwween 'ke
Hi,
I am trying to compile MySQL cluster source code on linux RedHat 9. The software
required are all installed with the right versions. And I use the file
BUILD/compile-pentium-max as suggested in Introduction documents. But the compilation
fails, and I got some output about errors as below
Daevid Vincent wrote:
Well, my "hack" (which is sort of like what you suggest) is to change my
primary key from just an auto_increment 'id' field to a combination of two
other fields (mac/scanner_id) that I know must be unique. Then I rely upon
the fact that mySQL will not allow a duplicate PK. (I
On 05/31/04 15:42 Donny Simonton spoke:
It depends on which version of MySQL you are using. Since you are using a
subquery, I assume you are using a fairly new version.
Delete audit_log_records from audit_log_records, audit_log where
audit_log_records.tracker_id = audit_log.tracker_id and
audit_lo
It depends on which version of MySQL you are using. Since you are using a
subquery, I assume you are using a fairly new version.
Delete audit_log_records from audit_log_records, audit_log where
audit_log_records.tracker_id = audit_log.tracker_id and
audit_log.operation='A'
That should be it. It
I need help with this SQL.
I want to delete all records from the 'audit_log_records' table that
have 'tracker_id' columns that are the same as those from the audit_log
table that have 'A' for the operation type.
delete from audit_log_records where tracker_id=(select tracker_id from
audit_log wh
Ultimately simple, but I don't find the answer: how to stop a list from
scrolling to the bottom when the command SHOW TABLES is entered.
Ken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 31 May 2004 12:08 pm, Kirti S. Bajwa wrote:
> Hello List:
>
> I want to setup two servers (later more servers added) sharing mysql data
> as a NFS Server & Client relationship;
There is a document on the mysql web site that cleary states tha
Hi Marco,
You can create one database for each user, and grant access to this database
only for this user.
Laercio.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 31 de maio de 2004 14:40
To: [EMAIL PROTECTED]
Subject: independent database
Hi
Hi all!
I would like that my users can read/write/execute just them database and
that they can not read/write/execute other users's database.
How shoul I set up?
This is because I have to host some web site and I want to give
independent access to features.
Tnks!
marco
--
MySQL General Maili
Hello List:
I want to setup two servers (later more servers added) sharing mysql data as
a NFS Server & Client relationship;
Server-A:
--
RH9, mysql-4.0.20, NFS Master
This server is a DATA server. All data for the entire site is kept on this
server in "/usr/local/mysql/var" which is sym
Hi Michael,
Problem for this variant: merge table has to be dropped and recreated
periodically.
during the short lag interval the log merge table
does not exist
You don't have to drop and re-create the table. Please don'
saiph <[EMAIL PROTECTED]> wrote:
>
> mysql> update table1
> set c = (select c2 from table2 where c2 = 'value')
> where id = 123;
>
> give me an ERROR 1064.
>
>
> i.e.
>
> create table t1 ( id int primary key, name varchar(20) );
> create table t2 ( id int primary key, name varchar(20) );
>
>
"Carlos J Souza" <[EMAIL PROTECTED]> wrote:
> Hello ALL,
>
> I need a examples of stored procedures and triggers in mysql 5.0.
>
> Please send me all sintaxes of this
>
Triggers are not supported in v5.0.
Example of stored procedure you can find in the manual at:
http://dev.mysql.com/do
Hello ALL,
I need a examples of stored procedures and triggers in mysql 5.0.
Please send me all sintaxes of this
regards
Carlos J Souza
[EMAIL PROTECTED]
2004-05-31
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
hi,
mysql> update table1
set c = (select c2 from table2 where c2 = 'value')
where id = 123;
give me an ERROR 1064.
i.e.
create table t1 ( id int primary key, name varchar(20) );
create table t2 ( id int primary key, name varchar(20) );
insert into t1 values(1, 'not right')
insert into t2 v
Hey, I have RedHat 9, with the default MySQL RPM pre-installed.
I'd like to set up multiple instances of MySQL.
That is, have multiple data directories(all with separate mysql database and
tables) on different ports.(I have a few projects which "share" user names
but different privileges).
What
Folks,
> FreeBSD 5.x does a lot of things really well, and it can be very
> fast too, but there's no stable release of 5.x yet, and the 5.x
> code is clearly hampered speedwise by the presence of loads of
> debugging code. From the 5.x documentation:
>
> ---
> NOTE TO PEOPLE WHO THINK THAT FreeBSD
Monday, May 31, 2004, 12:28:20 PM, you wrote:
J> I'm sorry, but I'm using Windows. There is no 4.1.2 version available yet
Ok.
Could you create a repeatable test case? You can upload structure of tables and data
for testing to ftp://ftp.mysql.com/pub/mysql/upload/ and let me know a file name.
J
On Mon, May 31, 2004 at 02:03:09PM +0200, Michael Arndt wrote:
>
> Problem for this variant: merge table has to be dropped and recreated
> periodically.
> during the short lag interval the log merge table
> does not exis
On Thu, May 27, 2004 at 02:20:46PM -0400, RV Tec wrote:
>
> Eric,
>
>
> > I am sure all FreeBSD users are sick and tired of saying this. USE
> > 4.10
> > Lots of people blindly follow version numbers but 5.x is a lot different
> > than 4.x in ways I don't yet feel comfortable with using on p
Hello *,
goal: using merge tables for annual / monthly storage of syslog information
using php-syslog-ng and syslog-ng
problem:
-one "actual table" must be available for inserts
-the merge table needs to be the target for "reports and queries"
-static parts of the merge table should be c
I try to understand index usage for 'order by'
but that's seemn hard to me.
Here is what I have tried :
1_ About documentation
I have read carefully related documentation (7.2.9 How MySQL Optimizes
ORDER BY) but
I don't understand it.
- What is the difference betwween 'key1' and 'key_part1' ?
Hello,
got this error when upgrading our MySQL:
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing...### [100%]
file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0
conflicts with file from package MySQL-shared-compat-4
Jaime <[EMAIL PROTECTED]> wrote:
>
> I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to
> get those combinations matching a given constraints. It is a very simple task, but I
> get less results than I expected. In fact, I tried to execute the same query in
> ORAC
Alaios <[EMAIL PROTECTED]> wrote:
>
> Do u know how many users the MySQL server v4 can't support?
> I am talking about the users that are currently online.
> I want to know the maximum number for the MyISAM tables and InnoDB
> Do u know any links for continue reading?
Number of connection
Hi all!
I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get
those combinations matching a given constraints. It is a very simple task, but I get
less results than I expected. In fact, I tried to execute the same query in ORACLE and
I get 23 results (in MySQL I
Hi there
Can someone tell me what process MySQL follows to process SQL
statements/queries? Is it top down or bottom up?
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Development.Multimedia.Branding
emotionalize.conceptualize.visualize.realize
Tel: +2
53 matches
Mail list logo
