Daevid,
CONSTRAINT `0_359` FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`)
you do not have ON UPDATE CASCADE in your constraint. MySQL versions 4.0.8
ignored it.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level
Mike,
you cannot run two mysqld instances on the same InnoDB data files. Think
what happens with the indexes cached in the buffer pool.
The same holds for MyISAM, because its indexes are in the key buffer, unless
you flush the table after each access to it, and prevent simultaneous
accesses with
Gabriel Ricard [EMAIL PROTECTED] wrote:
I'm running MySQL 4.0.14 on Mac OS X 10.2.6 on a development server. We
have around 60 tables on the development server and the production
servers. 18 tables that exist on the production server are replicated
to our development server. We use the
Andy Jefferson [EMAIL PROTECTED] wrote:
I'm trying to do a simple UNION in MySQL (4.0.11a on Linux). I am trying the
following ...
If I do
SELECT THIS.PRODUCT_ID,net.ajsoft.WebShop.Inventory.Product AS
JPOXMETADATA,THIS.ID FROM PRODUCT THIS LEFT OUTER JOIN BOOK SUBCLASS0 ON
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 11 Sep 2003, Dyego Souza do Carmo wrote:
I try to compile MySQL/InnoDB 4.1.1 ( loaded from BK )
My Configure Line is:
export CFLAGS=-O6 -mpentiumpro
export CXX=gcc
export CXXFLAGS=-O6 -mpentiumpro -felide-constructors -fno-exceptions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
(please Cc: me directly, if you want to catch my attention - I don't
always follow this list very closely)
On Thu, 11 Sep 2003, Jeremy Zawodny wrote:
On Thu, Aug 28, 2003 at 04:20:50PM -0400, Nick Gaugler wrote:
Thanks for the response. I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 12 Sep 2003 [EMAIL PROTECTED] wrote:
is there such a gui tool for linux ? i like sqlyog alot so anything similar
would be excellent.
Have you looked at MySQLCC?
http://www.mysql.com/products/mysqlcc/index.html
Bye,
LenZ
- --
Daniel Rossi [EMAIL PROTECTED] wrote:
hi i was wondering if there is a way to check for a table type ?
SHOW CREATE TABLE, SHOW TABLE STATUS.
ie i have an authentication class, in some situations it uses innodb and sometimes
its myisam and currently its not autocomitting
--
For
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 11 Sep 2003, Peter Koutsoulias wrote:
OK, here are the last few lines from make. I configured using the
following:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
errors:
libmysql.c: In function
Hi,
Hope someone can guide me how to generate sql scripts in Mysql?Thanks.
regards,
florence
Yahoo! Games
- Who Wants to Be A Millionaire? Play now!
Jeff Roberts [EMAIL PROTECTED] wrote:
I have a fresh install of mysql 4.0.11 on a linux box. When I try to
open mysql as a [EMAIL PROTECTED], I get the following error:
mysql -u [EMAIL PROTECTED] -p db_name
Enter password:
ERROR 1045: Access denied for user: '[EMAIL
On Fri, Sep 12, 2003 at 03:16:41PM +1000, Daniel Rossi wrote:
hi there, i am trying to use transactions on some innodb tables although a few
things i am experiencing, on one query the value appears, i refresh the page and the
value dissapears again, i am using persistant connections in php,
Dear ALL
I am Nick, I come from Taiwan company - EC-SERVER~~I have two WEB
SERVER to make load balance. Both of the WEB SERVER was installed mysql~~
I used the mount NFS instruction the storage spaces in linux.At the
same time,WEB's Data and mysql's data both in NFS paration~modify
On Fri, Sep 12, 2003 at 09:58:03AM +0200, Lenz Grimmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
(please Cc: me directly, if you want to catch my attention - I don't
always follow this list very closely)
Oops. Good point.
It's always felt like FreeBSD became a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 12 Sep 2003, Jeremy Zawodny wrote:
I think the best way to do this would be to provide the standard FreeBSD
build just like you do now and to also provide a LinuxThreads-enabled
build for people who really want it. I don't think
Florence,
Section 3.6 of the manual explains...
3.6 Using mysql in Batch Mode
In the previous sections, you used mysql interactively to enter queries and
view the results. You can also run mysql in batch mode. To do this, put the
commands you want to run in a file, then tell mysql to read its
Hi,
Hope someone can guide me how to set the auto_increment for an integer and the
value start with 1000?
I know how to set the value start from 1 but don't know how to start from 1000
or 2000 etc. Hope somebody can help me.
Thanks.
regards,
florence
Yahoo! Games
- Who
Hello list
I have a problem. I have 4 tables (in Mysql 3.23). All of them have a filed
named cod.
I want a query to find which cod of table1, table2, table3 is/are not in
table4.
cod values in table1, table2, table3 are diferent.
Thank you
Nikos
--
MySQL General Mailing List
For list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 12 Sep 2003, Michael Stassen wrote:
I have Mac OS X 10.2.6 with December 2002 Dev Tools and the Dec 2002 gcc
updater, which means I'm using gcc 3.3.
[...]
I assume you mean the August 2003 updater? This is the one that included
the
Hi,
I need to periodically load a dumpfile from another DB into
mysql. Now, since this is a cronjob, and for which I would
need to avoid interactivity, I DO NEED to run this as a
non-root user.
I have setup such a user, and have granted the user all on
the destination database. The user also
Hello,
I'm a french journalist writting an article for Décision Micro Réseaux
(#2 french IT mag) about open source RDBMS.
The goal of this article is to understand :
- if french SMB (PME) are using MySQL, PostgreSQL, etc.
- what they do with it
- etc.
If you are a french company which have
If I do
SELECT THIS.PRODUCT_ID,net.ajsoft.WebShop.Inventory.Product AS
JPOXMETADATA,THIS.ID FROM PRODUCT THIS LEFT OUTER JOIN BOOK SUBCLASS0 ON
THIS.PRODUCT_ID = SUBCLASS0.BOOK_ID WHERE SUBCLASS0.BOOK_ID IS NULL AND
THIS.PRICE .15E3
i get
How do I compare blank spaces in a string using LIKE ?
I tried the following:
SELECT * FROM table WHERE name LIKE '% John %';
But it didn't work.
To explain: I don't want the string 'Johnson' to be shown when running the query
above.
Thanks.
Nelson Azambuja Jr.
SELECT table4.cod, table1.cod, table2.cod, table3.cod
(BFROM table4
(BLEFT JOIN table1 ON table4.cod=table1.cod
(BLEFT JOIN table1 ON table4.cod=table2.cod
(BLEFT JOIN table1 ON table4.cod=table3.cod
(BWHERE table1.cod IS NULL
(BAND table2.cod IS NULL
(BAND table3.cod IS NULL
(B
(BI think
I have a flat file that I am trying to load to a MySQL database
(fixed-length fields).
When I try:
LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable
It is generating a ton of errors, but the end result is that it's populating
only the first field for all records and all subsequent fields are
It's actually mentioned in the user comments in the online manual (was there after the
other reply looking for MINUS support),
that in a union, in any column that is a literal, the top most query defines the
datatype (non-literals obviously use the column type) for the column.
I agree it's
I have a flat file that I am trying to load to a MySQL database
(fixed-length fields).
When I try:
LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable
It is generating a ton of errors, but the end result is that it's populating
only the first field for all records and all subsequent fields are
Hi,
IMHO it's nice idea...
http://www.ashleyit.com/blogs/brentashley/archives/000339.html
Best regards,
Mikhail.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetings,
I've been trying to work out a query for this project
and I'm finally at the end of my rope. Basically, I
have a ticket sales app. There is a table that has
row_num and seat_num and seat_status. What I need to
do is retrieve X number of seats that are sequential.
For example, if
florence florence [EMAIL PROTECTED] wrote:
Hope someone can guide me how to set the auto_increment for an integer and the
value start with 1000?
I know how to set the value start from 1 but don't know how to start from 1000
or 2000 etc. Hope somebody can help me.
For
Hi all. I am italian and i have to insert into a database a string with
cyrillic character in a field varchar but mysql give me this error:
?
query was empty
anyone can help me?
Thanks in advance?
-
This email was sent using SquirrelMail.
Webmail for
MyWeeklyLeads.com wrote:
I have a flat file that I am trying to load to a MySQL database
(fixed-length fields).
When I try:
LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable
It is generating a ton of errors, but the end result is that it's populating
only the first field for all records and
Title: Mensagem
Hi,
Can I run two MySQL
Servers in same machine ??I have Red Hat 8, and MySQL 4.0.x installed and
running (RPM install).
Could I install
MySQL 4.1.x in same machime with RPM install ??
Any conflicts ? How
to configure MySQL to listen in other port ?
Thanks,
* Robert Kilroy
I've been trying to work out a query for this project
and I'm finally at the end of my rope. Basically, I
have a ticket sales app. There is a table that has
row_num and seat_num and seat_status. What I need to
do is retrieve X number of seats that are sequential.
For example,
On 12 Sep 2003 at 8:39, Nelson Azambuja Jr. wrote:
I tried the following:
SELECT * FROM table WHERE name LIKE '% John %';
But it didn't work.
Please explain what didn't work. What were you expecting to happen,
and what actually happened?
To explain: I don't want the
I have a connection problem about MySql vs Oracle, I put an enter in TnsNames of BBDD
Mysql, using the object Oracle HS, and I get this error TNS
Packet checksum transport, Can you help me?
--- Roger Baklund [EMAIL PROTECTED] wrote:
* Robert Kilroy
I've been trying to work out a query for this
project
and I'm finally at the end of my rope. Basically,
I
have a ticket sales app. There is a table that has
row_num and seat_num and seat_status. What I need
to
do is retrieve
You might want to check that the developer tools were installed with Red
Hat 9; if not, you'll have trouble. The RPM is easiest to use, works like a
charm.
Cheers mate! It worked. When I googled for that error, I had removed the
c:1790 part of the message (the link you provided has the exact same error
message except it occurs on a different line) so the page didn't come up.
I tried export CXX=gcc first because it was the easiest, and it didn't
I always get that with MySQL 4.1:
alter table ACL_GROUPS add description varchar(255) default 'N/A';
ERROR 1025: Error on rename of './downloadgrid/#sql-1361_1a3' to
'./downloadgrid/ACL_GROUPS' (errno: 150)
If the table type is MyIsam, it works fine, I can alter the table. However
I can not
I'm sure this has been discussed before, I just haven't found it.
When creating numeric data types you have the option of putting a display
attribute. After reading the docs, I'm not really sure why you would want
to do this.
From a DBA point of view, I don't care how the number is displayed.
Here it is:
select floor(avg(selection.bandwidth))*8000 as avgbandwidth from (select
avg(bandwidth) as bandwidth from FEEDBACK_DOWNLOADS where servername= ?
and ( bytesdownloaded 50 or timeduration 3000 ) group by id order
by starttime desc limit 20) as selection;
This complex (?)
Hello all,
I am running into a problem with the C client and I would like to know if
the error I am seeing is expected or not.
The application I am running does not know anything about the SQL statements
it is running. So I don't know whether
I am executing a statement with bound parameters or
Irwin,
do you have in my.cnf
default-character-set=...
set to something else than latin1?
Can you make a small test case which demonstrates the problem?
Can you test with MySQL-4.0.15, and if the error happens also there, please
post the output of SHOW INNODB STATUS after that unsuccessful
Hi,
Can I run two MySQL Servers in same machine ??
yes you can, just place it into 2 distinct directories, like :
SERVER 1 : /usr/local/mysql-4.0.x
SERVER 2 : /usr/local/mysql-4.1.x
Could I install MySQL 4.1.x in same machime with RPM install ??
i don't try it, but with binary distribution
Lenz Grimmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 12 Sep 2003, Michael Stassen wrote:
I have Mac OS X 10.2.6 with December 2002 Dev Tools and the Dec 2002 gcc
updater, which means I'm using gcc 3.3.
[...]
I assume you mean the August 2003 updater? This is the one
Hello:
According to this company:
http://www.evidian.com/safekit/index.htm
They have a way to create a cluster out of two distinct
machines running MySQL.
Has anyone heard of this?
Has anyone used it?
Is it just pure marketing hype?
Thanks,
Neil
--
Neil Aggarwal, JAMM Consulting,
I believe it, as there's an open source project c-jdbc (clustered jdbc) that can do it
for x number of machines running any jdbc compatible db's (and they don't even need to
be the same type...)
-Original Message-
From: Neil Aggarwal [mailto:[EMAIL PROTECTED]
Sent: Friday, September
Hi I am trying to convert an existing access database to MYSQl and not having
much luck I have tried dbtools but I end up with nothing transfering. Am I
doing something wrong or is there a better conversion tool
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
...just a shot in the dark, but isn't 'description' a reserved word? If so,
um, maybe a bug/inconsistency between table types. If not, ramble on.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 1:04 PM -0400 9/12/03, [EMAIL PROTECTED] wrote:
...just a shot in the dark, but isn't 'description' a reserved word? If so,
um, maybe a bug/inconsistency between table types. If not, ramble on.
DESC and DESCRIBE are reserved, but DESCRIPTION is not...
--
Paul DuBois, Senior Technical
Dear List.
This morning we made some changes in the user field of the mysql database,
we changes the root password there, after that we can not get access to
our mysql server with the new root password and with the old password
neither.
How can we do? Is there any procedures for recovery the
Hello,
Is it possible to retrieve a file stored in a blob field using a mysql
client from a host which is not the server ?
Thanks for your help,
Karim.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here is the scenario:
4.0.15 as the master
3.23.57 is the slave
I can't get them to replicate until I downgraded 4.0.15 to 3.23.57
This was the error produced
030911 23:45:47 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication star
ted in log 'FIRST' at position 79
030911
Edwin,
check this link. Hope it will help you.
http://www.mysql.com/doc/en/Resetting_permissions.html
Best regards,
Mikhail.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 12, 2003 7:22 PM
Subject: How to recovery the root password?
Dear
Hi!
On Sep 12, Irwin Boutboul wrote:
Here it is:
select floor(avg(selection.bandwidth))*8000 as avgbandwidth from (select
avg(bandwidth) as bandwidth from FEEDBACK_DOWNLOADS where servername= ?
and ( bytesdownloaded 50 or timeduration 3000 ) group by id order
by starttime desc
I am sure this is a slam-dunk, but I am new to this and stumped ... thanks.
I have the following statement, but I need it to pull only unique listings - I get
repeated items.
SELECT state_ID FROM financial_master WHERE category_ID = '1'
SELECT state_ID FROM financial_master WHERE category_ID = '1'
becomes
SELECT unique state_ID FROM financial_master WHERE category_ID = '1'
-or-
SELECT distinct state_ID FROM financial_master WHERE category_ID = '1'
2 points !
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
SELECT DISTINCT(state_ID) FROM financial_master WHERE category_ID = '1';
OR
SELECT state_ID FROM financial_master WHERE category_ID = '1' GROUP BY
state_ID;
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject:
Try
SELECT DISTINCT state_ID FROM financial_master WHERE category_ID = '1'
Roger
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: SELECT only unique records
I am sure this is a slam-dunk, but I
---Original Message-
--From: Comcast [mailto:[EMAIL PROTECTED]
--Sent: Friday, September 12, 2003 11:03 AM
--To: [EMAIL PROTECTED]
--Subject: SELECT only unique records
--
--I am sure this is a slam-dunk, but I am new to this and stumped ...
--thanks.
--I have the following statement,
At 01:02 PM 9/12/2003, Comcast wrote:
I am sure this is a slam-dunk, but I am new to this and stumped ... thanks.
I have the following statement, but I need it to pull only unique listings
- I get repeated items.
SELECT state_ID FROM financial_master WHERE category_ID = '1'
SELECT DISTINCT
At 2:07 PM -0400 9/12/03, Dan Greene wrote:
SELECT state_ID FROM financial_master WHERE category_ID = '1'
becomes
SELECT unique state_ID FROM financial_master WHERE category_ID = '1'
-or-
SELECT distinct state_ID FROM financial_master WHERE category_ID = '1'
DISTINCT will work, but UNIQUE will
Ah! So what I had to do was then...
show create table rep_table;
alter table rep_table drop foreign key 0_359;
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
It all works now. Man, talk about good timing 'eh? A few
Yes, that is exactly what I am experiencing. The result comes back, and
the server dies
So it's probably a known bug
It s via mysqlcc. With command line it works fine in fact (good catch).
I'm not familiar with the JDBC driver/mysqlcc. Does it (the JDBC) also use
mysqlcc ? Or can I run
Hi!
On Sep 11, Matt W wrote:
Hi Sergei!
I'll try to keep my observations/ideas below as short and simple to
understand as possible. :-)
Thanks :)
Here I reply very quickly to some questions.
Another reply will follow...
Sure, boolean mode is faster in *some* cases, since, as you said,
Dan,
- Original Message -
From: Dan Greene [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, September 12, 2003 7:58 PM
Subject: RE: Has anyone heard of SafeKit?
I believe it, as there's an open source project c-jdbc (clustered jdbc) =
that can do it for x number of
Heikki:
I agree that there a many issues to addres when trying to use
multiple databases as a single database.
The C-JDBC project (at least on the surface) seems to think
it is possible. Their web page is at:
http://c-jdbc.objectweb.org/
They even have a way to use multiple controllers to
On Fri, Sep 12, 2003 at 05:02:29PM +, [EMAIL PROTECTED] wrote:
Hi I am trying to convert an existing access database to MYSQl and not having
much luck I have tried dbtools but I end up with nothing transfering. Am I
doing something wrong or is there a better conversion tool
You can
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
SELECT ... outfile to generate the file
On Fri, 12 Sep 2003,
Hi, I have a master - slave setup that's been working for years. Then
yesterday I shutdown the slave with a shutdown -r now, added some more
ram, booted it back up. Then a few minutes later data stopped being
inserted/updated into tables. The slave process was still running, and
the
I almost forgot to mention versions:
Master is:
MySQL 4.0.14-standard-log
Redhat 8
kernel 2.4.18-14
Slave is:
MySQL 4.0.12-log
Redhat 9
kernel 2.4.20-19.9
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all,
i've a question concerning the calculation of the
number of days between 2 dates, and after searching
the mailing list i'm still stuck, any help will be
appreceiated :}
actually i've a table with a lot of rows (varying
between 5 to 15 millions), each row has a unique id
and 2 date:
arrgg, sorry i made a mistake and my precedent mail
was sent before i finished wrting it :-{,
the query is:
INSERT INTO `TBL_COUNT_EXCLUDE`
SELECT MAIN.id, SUM(IF(EX.excl_date BETWEEN
MAIN.start_date AND MAIN.end_date, 1, 0)) AS
excl_count
FROM TBL_MAIN_DATE AS MAIN, TBL_EXCLUDE_DATE AS EX
Robert Kilroy wrote:
I've been trying to work out a query for this project
and I'm finally at the end of my rope. Basically, I
have a ticket sales app. There is a table that has
row_num and seat_num and seat_status.
If you have the luxury of being able to change this, consider replacing
it with
I have a mysql server running on a dual processor pentium 233 (a real power
house :) ). And I have serveral php web sites that access it locally. One
of about 15 reads results in the following error being generated:
Error
MySQL said:
Lost connection to MySQL server during query
Anyone
Can you send youre my.cnf options in /etc? You might have wait-timeout
set.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Daniel Baughman [mailto:[EMAIL PROTECTED]
--Sent: Friday,
I'm running mysql-standard-4.0.14-pc-linux-i686.
I've got a database netscore which I want to be able to bulk load. The
database already exists and I can do inserts into tables:
[EMAIL PROTECTED] schema]$ mysql -s
mysql use netscore
mysql insert into boat values (100, 'foo', 'foo', 'foo',
At 8:59 PM -0400 9/12/03, Roy Smith wrote:
I'm running mysql-standard-4.0.14-pc-linux-i686.
I've got a database netscore which I want to be able to bulk load.
The database already exists and I can do inserts into tables:
[EMAIL PROTECTED] schema]$ mysql -s
mysql use netscore
mysql insert into
Nice subject line huh ?
Mysql 4.0.14 freebsd. (why does it say unknown by the way ?)
I get this when trying to run
badboy# Starting mysqld daemon with databases from /usr/local/mysql/data
030912 22:08:06 mysqld ended
[1]Done ./mysqld_safe
I RTFM twice. I followed
On Friday, September 12, 2003, at 10:24 PM, Paul DuBois wrote:
FILE is a global privilege (it's recorded only in the user table)
and must be granted at that level:
GRANT FILE ON *.* TO 'roy'@'localhost';
Ah. That makes sense. Thanks.
I'm not sure why you're trying to grant to just roy. That's
At 10:32 PM -0400 9/12/03, Roy Smith wrote:
On Friday, September 12, 2003, at 10:24 PM, Paul DuBois wrote:
FILE is a global privilege (it's recorded only in the user table)
and must be granted at that level:
GRANT FILE ON *.* TO 'roy'@'localhost';
Ah. That makes sense. Thanks.
I'm not sure why
badboy# ./mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (
2)
that file is not there.
should I touch it ?
argggh !
and ya say windows sucks. (ok the beer is talking now)
--
MySQL General Mailing List
On Fri, Sep 12, 2003 at 10:28:11PM -0400, SWIT wrote:
Nice subject line huh ?
Mysql 4.0.14 freebsd. (why does it say unknown by the way ?)
I get this when trying to run
badboy# Starting mysqld daemon with databases from /usr/local/mysql/data
030912 22:08:06 mysqld ended
[1]Done
I have inherited a mysql install, in the user table, there are many
usernames and passwords that are not connected to any databases or tables.
Looks like someone deleted the databases at one time and neglected to d it
right and left ghost users around.
Any way to issue some sql that would search
At 9:26 PM -0700 9/12/03, Scott Haneda wrote:
I have inherited a mysql install, in the user table, there are many
usernames and passwords that are not connected to any databases or tables.
Looks like someone deleted the databases at one time and neglected to d it
right and left ghost users around.
Hi,
I want to put the OMIM databse locally on my computer. I downloaded the
file genemap from ftp://ftp.ncbi.nih.gov/repository/OMIM/ It contains a
list of fields, separated by the '|' character. An example is:
1.1|9|11|95|1pter-p36.13|CCV|P|Cataract, congenital, Volkmann
type||115665|Fd|linked
87 matches
Mail list logo