Found solution, the right syntax is:
SELECT hl7incom.id
FROM hl7incom, pid_segment
LEFT JOIN pid_segment
ON hl7incom.id = pid_segment.id
WHERE hl7incom.msg LIKE '%PID%'
AND pid_segment.id IS NULL;
Cheers for try of help,
Karsten
Same result, also if I do not define unique index.
Just a
On Mon, Sep 30, 2002 at 10:24:42AM -0400, Bill Leonard wrote:
on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
It's not a so good decision and not suitable if database contains
InnoDB tables, but you can't limit database size only with MySQL.
Is this a planned
Hi!
Michael == Michael J Fuhrman [EMAIL PROTECTED] writes:
Michael Hello All,
Michael Suggestions Feedback Requested:
Michael I'm looking for a solution that will not lock a table, yet allow me to
Michael retrieve the:
Michaelfield name, field type as integer, field size, and other
Hi!
Michael == Michael J Fuhrman [EMAIL PROTECTED] writes:
Michael Hello All,
Michael Suggestions Feedback Requested:
Michael I'm looking for a solution that will not lock a table, yet allow me to
Michael retrieve the:
Michaelfield name, field type as integer, field size, and other
What is that option? Never saw it before.
If this is the case indeed, how do you change its value?
Thanks again.
Noor
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 4:52 PM
To: Noor Dawod
Cc: MySQL List
Subject: Re: Unknown auto
Thank you for your response.
We tried your example here on shell and it looks like InnoDB locks the table only for
the first transaction after db startup and this lock is held for the whole transaction
(like you observed).
But, contrary to this scenario we have experienced some strange
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi ..
I have a question about mysql++.
give it a version of mysql++ that is optimize for the gcc 3.2 Version or
have someone a tip to compile that with the gcc 3.2 ??
Thanks a lot
- --
Markus Schnelle
-
Email: [EMAIL
hi Victoria,
I stopped both mysql in master and slave. Then I put in the server id for
both master and slave, start the master then the slave. Is it okay?
Thanks,
Chee Peng
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September
sql,query
Hello, All!
Why is temporary tables replecated?
Is it true?
Best regards.
___
Andrey Kotrekhov [EMAIL PROTECTED]
ISP Alkar Teleport
ÔÅÌ. +380 562 34-00-44
Hi all.
Any of MySQL AB team could explain the options used in the compilation of
rpm packages for Linux?
Thanks in advance.
Iago.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Chuck Amadi asked
Has anyone created a plugin or script that will allow me to
convert my filemaker database to MYSQL
Check the archives. There has been some discussion of this in the past.
Has anyone got a link to this archive as I have a Filemaker Pro 5 Works
Database that I would
Tac,
Friday, September 27, 2002, 10:34:46 PM, you wrote:
T We're having a problem with a huge merge table and BETWEEN. The same query
T in MySQL 3, using an identical (binary) copy of the database, takes a
T fraction of a second, in MySQL 4.03 it runs without stopping.
T The query is a simple
CP,
Tuesday, October 01, 2002, 11:29:30 AM, you wrote:
C I stopped both mysql in master and slave. Then I put in the server id for
C both master and slave, start the master then the slave. Is it okay?
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
Pavel,
Monday, September 30, 2002, 9:04:32 PM, you wrote:
PH I've just tried to download the Win32 binaries of the MySQLGUI tool.
PH I recieved about 50kB. When I tried to unpack the archive,
PH WinCommander told me, that the zip archive is corrupted.
I've just downloaded MySQLGUI and unzipped
hi,
got a little problem during learning mysql :
have made a file called create_member.sql, looks like this here :
CREATE TABLE member
{
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL DEFAULT
hans,
Tuesday, October 01, 2002, 1:02:02 PM, you wrote:
hp got a little problem during learning mysql :
hp have made a file called create_member.sql, looks like this here :
hp CREATE TABLE member
hp {
hp last_name VARCHAR(20) NOT NULL,
hp first_name VARCHAR(20) NOT NULL,
hp
DeNewbie,
Monday, September 30, 2002, 9:36:03 PM, you wrote:
D I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake
running mysql_install_db and afterwards running the commands;
D /usr/bin/mysqladmin -u root password 'new-password'
D mysqladmin -u pazin1 sqlpass
D
Description:
Any user in mysql can create as many databases as he wants.
Create a user with 1 database, and let him create database with name
my_data_base. Log into mysql console as user and run command:
CREATE DATABASE my?data?base;
New database will be created and user can create
Mark,
Monday, September 30, 2002, 5:48:59 PM, you wrote:
MH
+-+
MH | Grants for [EMAIL PROTECTED]
|
MH
Hi!
On Oct 01, Plesk Support wrote:
Any user in mysql can create as many databases as he wants.
Create a user with 1 database, and let him create database with name
my_data_base. Log into mysql console as user and run command:
CREATE DATABASE my?data?base;
New database will be
IOD,
thank you for the bug report. I was able to repeat the problem with you
scripts. The bug was that InnoDB failed to release at an SQL statement end
such AUTO-INC locks which were only granted after a lock wait. They were
only released at the transaction commit.
Since AUTO-INC locks normally
Greetings..
I am doing show keys from db.tablename but how can I know whether the key if
fulltext or not. I get to know the key is unique or not by checking
Not_Unique column in the returned resultset.
How to find a key is fulltext.
Thx
Insane
sql,query,mysql
What are the advantages of Mysql over sql or microsoft access.
Thanks
Stella
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Description:
I had a working install of mysql 3.23 in /usr/bin and /var/lib/mysql. I
installed 4.0.3 to /usr/local/mysql and can't get it to run. I followed the
installation instructions to the T. When I run '/usr/local/mysql/bin/mysqld_safe' I
get:
Starting mysqld daemon
Anyone has any experience of trapping error using DBI-mySQL.
The following code is not trapping the error. it is producing system
generated error.
$memberId='2a';
my($memberId)=@_;
my($sql)= select member_id from members
where member_id != . $memberId;
my $sth =
The SERVER needs to be able to read the file, and I doubt very much
that mysql has read permissions here.
Jim Bahr wrote:
Hello
I am trying to use the LOAD command and not having much success. My host
company is using version mysql 3.23.51. I am sshing into server,
starting mysql and getting
Tewfic,
Tuesday, October 01, 2002, 12:21:09 AM, you wrote:
TK Hello, I have a table that keeps track of people and their office visits.
TK This table will have duplicates since people will visit the office more than
TK once...
TK How can I get a list of people and the most recent time they've
Jim,
Tuesday, October 01, 2002, 4:01:18 PM, you wrote:
JB I am trying to use the LOAD command and not having much success. My host
JB company is using version mysql 3.23.51. I am sshing into server,
JB starting mysql and getting a mysql prompt. I have a database called
JB login, and have made
Insanely,
Tuesday, October 01, 2002, 3:49:10 PM, you wrote:
IG I am doing show keys from db.tablename but how can I know whether the key if
IG fulltext or not. I get to know the key is unique or not by checking
IG Not_Unique column in the returned resultset.
IG How to find a key is fulltext.
What do the logs say?
Stella Chipfupa wrote:
What are the advantages of Mysql over sql or microsoft access.
Thanks
Stella
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
jschleigh,
Tuesday, October 01, 2002, 4:06:15 PM, you wrote:
jahdc I had a working install of mysql 3.23 in /usr/bin and /var/lib/mysql.
I installed 4.0.3 to /usr/local/mysql and can't get it to run. I followed the
installation instructions to the
jahdc T. When I run
At 18:19 +0530 10/1/02, Insanely Great wrote:
Greetings..
I am doing show keys from db.tablename but how can I know whether the key if
fulltext or not. I get to know the key is unique or not by checking
Not_Unique column in the returned resultset.
SHOW KEYS shows this information in the
Hi,
The mysql master wasn't restricting the slave by ip. But thanks,
Eric
At 10:28 AM 9/30/02 -0500, gerald_clark wrote:
You need to grant privileges on the master to the new slave machine.
http://www.kwinternet.com/eric
(250) 655 - 9513 (PST Time Zone)
Inquiry is fatal to certainty. --
I was not aware that you were running VB.
In perl and PHP we have a function do do this for us.
in perl:
$qtext=$dbh-quote($text);
$dbh-execute(insert into mytable set myvariable = $qtext);
The above quote() function will put a \ in fronnt of all the special
characters listed in the manual.
Please respond to the list.
It sounds like the server does not like one of the options in your
my.cnf file, and is printing
a syntax/options list.
Stella Chipfupa wrote:
The logs are listing the features of mysql but there is no comparison.
-Original Message-
From: gerald_clark
Hi,
I am getting the following error:
[TCX][MyODBC] Lost Connection to MySQL Server During Query
My code is simply dumping an IP Address to the database... at the most 10
lines of code. Any ideas what is causing this error? I have searched on line
and have not found much help.
Thanks in
gerald_clark wrote:
What do the logs say?
Stella Chipfupa wrote:
What are the advantages of Mysql over sql or microsoft access.
Pet peave: the product being refered to is Microsoft SQL Server, not
SQL.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
Hi,
I wanting to know what the sql statement is that will let me get the total
of database. The feild is amount. I have tried a couple of sql statement and
have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.
Chuck Payne
Magi Design
All,
I have a table which was accessible for the last couple years but is now
inaccessible after performing a simple alter table command.
There are approx. 10 tables in this database on which the same alter table
command was given (alter table table_name add glperiod varchar (3) null
But root user is able to perform the write to file w/o issue.
I wonder what the problem could be.
I will upgrade to 3.23.52 but I don't think it will fix the problem.
Is there anything else it could be?
--
Mark P. Hennessy [EMAIL PROTECTED]
On Tue, 1
Greetinsg...
When I am doing
show index from db.tablename, the columns I am gettings are -
Table
Non_unique
Key_name
Seq_in_index
Column_name
Collation
Cardinality
Sub_part
Packed
Comment
Which one of these will tell me whether a key is fulltext or not.
Rgds
Ritesh
SQLyog (
gerald_clark wrote:
$qtext=$dbh-quote($text);
$dbh-execute(insert into mytable set myvariable = $qtext);
The above quote() function will put a \ in fronnt of all the special
characters listed in the manual.
These in clude '\ and the hex 00 character.
FWIW, before anyone copies and pastes
What privileges do I need for creating a TEMPORARY table? I seem to have
locked myself out of this - and yet I can create permanent tables, which
seems the wrong way round.
N:\mysql -ualec
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1121 to server
Insanely,
Tuesday, October 01, 2002, 6:22:47 PM, you wrote:
IG When I am doing
IG show index from db.tablename, the columns I am gettings are -
IG Table
IG Non_unique
IG Key_name
IG Seq_in_index
IG Column_name
IG Collation
IG Cardinality
IG Sub_part
IG Packed
IG Comment
IG Which one of these
Mark,
Tuesday, October 01, 2002, 5:50:15 PM, you wrote:
MH But root user is able to perform the write to file w/o issue.
MH I wonder what the problem could be.
MH I will upgrade to 3.23.52 but I don't think it will fix the problem.
MH Is there anything else it could be?
As far as I remember
Hi List
I have a table with 90 Millions records and 8 indexes (75GB). I am
trying to drop one of them but I get an errorcode 28 (no space left on
device). df- v gives me an extra 27% of free space.
My questions:
Does MySQL use temporary areas to drop indexes and for what ?
Is there a way to
It is already quoted. That's the point.
Michael T. Babcock wrote:
gerald_clark wrote:
$qtext=$dbh-quote($text);
$dbh-execute(insert into mytable set myvariable = $qtext);
The above quote() function will put a \ in fronnt of all the special
characters listed in the manual.
These in
Hi,
I'm a MySQL Newbie and am working on my first real project. The project
involves removing the Access database off of our system and using MySQL
in its place. Here is what happens now with this database
The Unix machine writes information to the end of a text file every time
an invoice
From: Chuck Payne [EMAIL PROTECTED]
Question are you want to take your data from Filemaker to Excel?
No, I want to just go from FileMaker to MySQL, period. Forever. End of story.
rantI'm tired of paying FileMaker Tax every year. (The version upgrade went from
$149 to $199 this year.) I'm
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql select load_file('/home/alex/post.html') from
test;
+---+
| load_file('/home/alex/post.html') |
+---+
|
Dear Listers:
I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop.
When I start SQLyog and type in the
mySQLHostAddress: 10.0.5.210
User Name: root
Password:
Port: 3306
Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to
connect to
this MySQL
Hi, I am looking for some help installing mysql
I have downloaded a copy and have it on my
desktop , and well I am sorta wondering where to
go from here. Because the instructions are too vague
for me, as a newbie to mysql
please assist james
If MYSQL_OPT_CONNECT_TIMEOUT is set before mysql_connect() or
mysql_real_connect() and the value is set to zero, what is the expected
behavior? (Reason: PHP now does this as the default.)
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
On Tuesday, October 1, 2002, at 10:25 24h, Jan Steinman wrote:
From: Chuck Payne [EMAIL PROTECTED]
Question are you want to take your data from Filemaker to Excel?
No, I want to just go from FileMaker to MySQL, period. Forever. End of
story.
If you export a FileMaker database using
Hi,
I am trying to export a query into a .CSV file using SELECT ... OUTFILE at
the command prompt.
It works ok the first time but all subsequent runs give a 1086 error - File
already exists.
I have to use the command prompt vs. a GUI as I am running this in a .cgi
script. Is there any way
I am running an sql insert against a mysql table version 3.23.52
When from the file system level the table has the following permissions.
rw-rw-r-- table.frm
rw-rw-r-- table.MYD
rw-rw-r-- table.MYI
When the sql runs it says the table is read only. I am connecting to the
table as root
On Tue, 1 Oct 2002, Kevin Tsay wrote:
Dear Listers:
I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop.
When I start SQLyog and type in the
mySQLHostAddress: 10.0.5.210
User Name: root
Password:
Port: 3306
Itis giving me the error: Host
Hi,
I'm using MySQl 3.23.52 on RedHat Linux 6.2
I have a table that is indexed on the description column as FULLTEXT. I
allow the user to enter text in an input field and I return matching rows.
I've noticed that writing a query such as:
SELECT EDescript FROM HSCodes WHERE MATCH(EDescript)
Kevin,
It sounds like you don't have your MySQL access setup correctly. I am also
a newbie to MySQL. I recently experienced the same problem with MyCC, which
is similar software to SQLyog. I have both, MyCC and SQLyog, installed and
currently comparing and contrasting to see which one I like
List,
I would appreciate if somebody has any ideas on the above error.
We are getting this error Error 1030: Got error -30996 from table
handler with BDB tables on a Linux Server (Red Hat 7.3),
the version of MySQL is 3.23.42
Thanks
Sridhar
Hello,
Is there a way to have email from an email account on a MS Exchage Server be
populated into MySQL. I can to this by connecting to the exchange server
with MS Access and then push the data from access into the MySQL table. I
would like not to have to use MS Access. Thanks for any help.
On Tuesday, October 1, 2002, at 10:51 24h, webmaster wrote:
Hi, I am looking for some help installing mysql
I have downloaded a copy and have it on my
desktop , and well I am sorta wondering where to
go from here. Because the instructions are too vague
Try the Mac OS version 10.2 from
A query that took less than a second under 3.23.44 started taking
minutes when we upgraded to 4.0.3. The original query involved
multiple tables including one merge table containing 10 subtables and
millions of rows, but I've trimmed it down to a manageable test case
where the merge table
Check out the excellent package/instructions at
http://www.entropy.ch/software/macosx/mysql/
At 01:51 PM 10/1/2002 -0400, webmaster wrote:
Hi, I am looking for some help installing mysql
I have downloaded a copy and have it on my
desktop , and well I am sorta wondering where to
go from here.
Le 1/10/02 19:51, « webmaster » [EMAIL PROTECTED] a écrit :
Hi, I am looking for some help installing mysql
I have downloaded a copy and have it on my
desktop , and well I am sorta wondering where to
go from here. Because the instructions are too vague
for me, as a newbie to mysql
On Tue, 1 Oct 2002, Rochester, Dean wrote:
I am running an sql insert against a mysql table version 3.23.52
When from the file system level the table has the following permissions.
rw-rw-r-- table.frm
rw-rw-r-- table.MYD
rw-rw-r-- table.MYI
Hi,
Please verify that the user mysqld
To all,
I can not configure mysql on OS X, using the latest build for that OS.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi.
I've such problem.
Is ORDER BY works with MATCH AGAINST ?
i.e.
create table test (
id_test int11,
message text
);
SELECT id_test, message FROM test WHERE WHERE MATCH (message) AGAINST
('example' IN BOOLEAN MODE) ORDER BY id_test
For me in mysql 4.0.3beta this select doesn't work as I want.
IMPORTANT INFORMATION!
This is an automated message.
The message you sent (attached below) requires confirmation
before it can be delivered. To confirm that you sent the
message below, just hit the Reply button and send this
message back (you don't need to edit anything). Once this is
done,
Hi,
I am having problems get how many days out an invoice is from mysql. I have
try this.
SELECT NOW()-summitted_date FROM table;
But it not working as usually. So please guys a little help.
So If an invoice was summitted on 9-26-02 then I should be able to see that
5 days.
Chuck Payne
Magi
Yes, it builds a new index file before deleteing the old.
Oswaldo Castro wrote:
Hi List
I have a table with 90 Millions records and 8 indexes (75GB). I am
trying to drop one of them but I get an errorcode 28 (no space left on
device). df- v gives me an extra 27% of free space.
My questions:
You need the client 'mysql' on the unix machine to talk to the
server 'mysqld' on whatever machine.
This will allow you to write shell scripts that call mysql.
If you want to program in PHP or perl, then you need their
mysql drivers which talk to the server.
Chris Couture wrote:
Hi,
I'm a
Check the db table in mysql database. See what that says
also, I notice the error was that kevin.smith.com not allowed
sould that be [EMAIL PROTECTED] not allowed?
Generally you will get kevin@localhost not allowed.
Grant priviledges to that user on that machine as [EMAIL PROTECTED]
Nestor
mysql probably does not have search permission on /home/alex.
copy the file to /tmp and see what happens.
Alex Safonov wrote:
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql select
No.
How would the server know if you had used the previous output file?
As a matgter of fact, since it is still there, I guess you didn't.
Have your cgi script move it.
Carter, Steve wrote:
Hi,
I am trying to export a query into a .CSV file using SELECT ... OUTFILE at
the command prompt.
It
You are connecting th the server, not the table.
The server must have read and write permissions on the files.
They must be owned by mysql, as must their directories.
Rochester, Dean wrote:
I am running an sql insert against a mysql table version 3.23.52
When from the file system level the
Check out the GRANT syntax in the manual.
I don't see where you granted any privileges.
Kevin Tsay wrote:
Nestor:
I've set the password for root and granted privileges to it.
see below:
mysql select * from user where user='root';
What do you mean 'still' ?
Version 4 just went beta a short time ago, and is only at 03 or 04.
DonPro wrote:
Hi,
The web site states that MySQL 4.03 is still officially beta. Does anyone
have any experience or feedback using it on a production system? I really
require some of the new features
Thanks for the info. Let me see if I have this right.
(I am asking these question on behalf of my UNIX programmer who will be
doing all of the programming so sorry if I am asking simple questions.)
To make this simple, let's label the computers. The MySQL database
server will be labeled B
- Original Message -
From: Rochester, Dean [EMAIL PROTECTED]
To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED]
Sent: Tuesday, October 01, 2002 8:22 PM
Subject: Table says it is read only but it is not from file system level
I am running an sql insert against a mysql table
version 3.23.52
Hi,
I am having problems get how many days out an invoice is. I have try this
sql statement.
SELECT NOW()-submmitted_date FROM table;
But it not working as usually. So please guys a little help.
So If an invoice was submmitted on 9-26-02 then I should be able to see that
5 days.
Chuck Payne
At 15:41 -0400 10/1/02, Chuck Payne wrote:
Hi,
I am having problems get how many days out an invoice is from mysql. I have
try this.
SELECT NOW()-summitted_date FROM table;
But it not working as usually. So please guys a little help.
What do you mean not working as usually? A query written
On Tuesday, Oct 1, 2002, at 16:39 America/Phoenix, DeNewbie wrote:
I am a newbie and I am having a chronic problem getting mysql started
up and running. I got so frustrated that I uninstalled the mysql rpms
and started over again but its hasn't helped my situation. My whole
problem
I am a newbie and I am having a chronic problem getting mysql started up and running.
I got so frustrated that I uninstalled the mysql rpms and started over again but its
hasn't helped my situation. My whole problem revolves around mysql_install_db setup.
This is what I am doing and its
If you are running MySQL on a Solaris 7 machine, would you mind sharing
your startup script with the list? Thanks.
bz
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Stephane Pinel wrote
Le 1/10/02 19:51, $B%)(B webmaster ; [EMAIL PROTECTED] a $BqD(Brit :
Hi, I am looking for some help installing mysql
I have downloaded a copy and have it on my
desktop , and well I am sorta wondering where to
go from here. Because the instructions are too
Philip Lavine scrawled
To all,
I can not configure mysql on OS X, using the latest build for that OS.
Oh?
Thanks
Sure.
(I'm not telepathic. What error messages and/or misbehavior are you
getting during the install?)
--
Joel Rees [EMAIL PROTECTED]
Tuuri,
Thank you for the follow-up. It's great that our efforts were not in vain and I could
contribute towards resolving the issue. I will be looking forward to the next release
of InnoDB/MySQL-Max.
-
regards,
Afroze H. Zubairi (IOD)
-
-
Hi, i am doing a project and it is almost nearing release version.
i planned to do the installation by using install shield to one short doing
the
mysql, myodbc installation and also the ODBC DSN setting.
is anyone have any idea to do the ODBC DSN setting through install shield ?
or writing any
Hi,
I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root
so I use the following commands:
mysql use mysql
Database changed
mysql update user set password=password('l05m')
- where host='localhost' and user='root';
Query OK, 1 row affected (0.00 sec)
Mysql prompt a
On Tue, 1 Oct 2002, DeNewbie wrote:
I am a newbie and I am having a chronic problem getting mysql started up and
running. I got so frustrated that I uninstalled the mysql rpms and started over again
but its hasn't helped my situation. My whole problem revolves around mysql_install_db
setup.
sounds like you need SUM(field name)
- hcir
Hi,
I wanting to know what the sql statement is that will let me get the
total
of database. The feild is amount. I have tried a couple of sql
statement and
have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.
sounds like you need SUM(field name)
- hcir
Hi,
I wanting to know what the sql statement is that will let me get the
total
of database. The feild is amount. I have tried a couple of sql
statement and
have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost.
93 matches
Mail list logo