Dear all,
I have the following problem,
I am trying to select records from two tables.
the tables are constructed like:
block
block_id
sequence_id
snp_required
first_polymorphism_index
last_polymorphism_index
first_reference_positio
last_reference_position
start_pos
end_pos
tiled_bp
Hi there,
Do you know a sql command which I can write to obtain the last date that I
updated a table
Hi,
I am trying to install myql on redhat.
mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz
While following the instructions in install document..when i run the
follwing command..
scripts/mysql_install_db
following errors appear:
-
scripts/mysql_install_db:
but the different lanaguage setting in MySQL seem to
mainly apply to its error messages
Collation and sorting, too.
To my knowledge, MySQL does not yet
offer full UTF-8 support
True, but UTF-8 is Unicode, and it sounds like the OP wants to work with
BIG-5, a two-byte Chinese national
On 5 Aug 2003 at 9:49, Eben Goodman wrote:
The data type of the field I am
storing this info in is a bigint(16) unsigned. It appears that isbns
that start with 0 are going in as 9 digit numbers, the 0 is being
ignored or stripped. I have experienced this before with integer data
types
Thank you for the information about LIKE and equal.
I have another question.
What is better/quicly 50 simultaneously query/update at the same time from
50 different users or 50 simultaneously query/update at the same time from
one user?
Thanks for your information in advanced,
eli
At
My database experiences a similar effect, but I can't pinpoint the specific
queries because it gets thousands per second. I have not noticed the
problem on a machine that is only used occasionally. Is there a way to get
queries out of the binlog for a specific date/time range? That might help
When I try copying and
pasting it into the mysql client command-line, the data gets trashed.
Not necessarily. May just be that the command-line window doesn't know
to display Chinese unless you tell it to. What OS are you working on?
Working on Windoze with a telnet window open to a Linux box
Hi!
On Aug 06, David Bordas wrote:
Hi list,
I've got a little bug with MySQL.
I can insert a row into my table but this row will not appear in the table
:(
Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz
from MySQL team.
Table Description :
mysql
Tiffany Wilkes [EMAIL PROTECTED] wrote:
I am having problems granting column privileges. I want to grant the
update privilege (only) to a column (called pass) in a table (called
Acct). Here's what I get:
mysql grant update pass on practicedb.Acct to [EMAIL PROTECTED];
ERROR 1064: You
Hello dear all,
i have 2 table :tbl1 and tbl2
i need to make an update on tbl1 based from tbl2 records.
Ex:
update tbl1, tbl2 set tbl1.conf='1' where tbl2.name='AD' and tbl2.date=tbl1.date;
mysql: MySQL 3.23.54
i see this kind of query works on mysql 4.0.2
How i can do this with my
Walt,
Thanks for the suggestion. I ran myisamchk on the table and it said it was corrupted.
So I ran myismachk on the table with the -r and it said the table was fixed. I then
ran the update queries I was running before and received the same 127 error. The
update queries were:
update
I have a problem understanding why MySQL is deleting a unique key
instead of a primary key.
from Documentation: DROP PRIMARY KEY drops the primary index. If no
such index exists, it drops the first UNIQUE index in the table.
When I do it then I get this:
mysql desc uksample4;
Hi folks, trying to set up replication and I'm getting this problem
which I can't see how to fix despite reading of the manual and
google.
I have set up a master and a slave according to the manual. The
master runs 4.0.12 and the slave runs 4.0.14, they are both actually
on the same machine
You have not shown us anything that would indicate that your output is
not correct.
If you think something is missing you have to show us what is missing,
and why you think
it should not be.
John Wards wrote:
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON
On Tue, 5 Aug 2003, gerald_clark wrote:
You are ORing on two different fields. The index cannot be used to
check the value of z for an OR.
ORing on two different fields is what I have been asking about :).
Using a composite index was suggested, which strangely seems to work
only when there are
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master setup. I see log-bin, but I think that only applies to
Depending on what driver of MySQL ODBC you are using.
The one below I use for v3.51:
strConnString = drver={MySQL ODBC 3.51
Driver};server=SERVER_IP;database=DB_NAME;user=UID;password=PWD;OPTION=4
The one below I used in the past for v2.50:
strConnString =
* NEWMEDIAPLAN
what variable values /mysql tuning you suggest for more than 2000
potential concurrent users and big tables.
2000 concurrent users is much, at least if you mean 2000 concurrent requests
to the database, as opposed to 2000 concurrent users of a web site. It is
hard to give you a
No functions as default values is a bummer, but timestamp will do he trick,
so thanks for your help; much appreciated.
Phil.
-Original Message-
From: Cybot [mailto:[EMAIL PROTECTED]
Sent: 06 August 2003 15:37
To: [EMAIL PROTECTED]
Subject: Re: Functions as default values
I am trying
Hi Everyone;
As I was perusing the MySQL documentation, I noticed that there is a
lack of documentation regarding the MySQL SET datatype and the queries
used to manipulate it. In fact, the comments are longer than the
documentation. A google search shows a similar lack up information
regarding
Walt,
Since this is a one time data load, I made a copy of the table and named it
discussion_categories_2 and then did a join with that table and the original one. The
errors didn't appear then when I ran the query. The old query was:
update discussion_categories discussion_categories1,
Ryan A wrote:
Hi,
This is my first post here so forgive me if its too simple or not right.
basically what i do is:
SELECT COUNT(*) FROM table1 where cno=3;
(and dumping it into a variable $theResult - I am using PHP)
and it gives me the result, but now i need to do this in 5 tables...
I can of
When I try copying and
pasting it into the mysql client command-line, the data gets trashed.
Not necessarily. May just be that the command-line window doesn't know
to display Chinese unless you tell it to. What OS are you working on?
For example, how do I insert the Chinese text from my
On Wed, Aug 06, 2003 at 10:32:23AM -0400, walt wrote:
Andy,
Can you send a copy of your my.cnf file for both the slave and master
database.
Sure.
Slave:
[client]
port=3307
socket=/data/mysql-backup/mysql.sock
[mysqld]
port=3307
socket=/data/mysql-backup/mysql.sock
server-id=4
log-warnings
I don't know of any way to sort before the grouping. That would be
peculiar, since the GROUP will be eliminating potentially many of those
rows.
In your case, a simple solution should be:
select jobnum, min(milestone), min(shipdate) from jobs
group by jobnum
order by 2, 3;
I've always found
I have this query:
SELECT *
FROM news_category
LEFT JOIN news_x_cat ON news_category.id = news_x_cat.cat_id
WHERE (
news_x_cat.news_id = 9 OR news_x_cat.news_id IS NULL
)
Which gives me this output:
id title perm show news_id cat_id
1 About Us 1 1
Hello,
I have a table with a FULLTEXT index on a column of type 'text'.
Searches on this table using MATCH() AGAINST() work fine for most
words. However, I needed to match against a 3 letter word. So I
lowered the ft_min_word_len to 3 in /etc/my.cnf. I then restarted
MySQL. I checked that
I was under the impression that InnoDB tables took care of this for you.
You only need to be concerned if you add/delete repeatedly from anywhere
but the end rows of the table.
I'd like to know if I'm wrong about this.
Adam Nelson wrote:
I just did a major insert of new data and now all my
Hi,
I am having problems granting column privileges. I want to grant the
update privilege (only) to a column (called pass) in a table (called
Acct). Here's what I get:
mysql grant update pass on practicedb.Acct to [EMAIL PROTECTED];
ERROR 1064: You have an error in your SQL syntax near 'pass
I am just learning mysql and I'm trying to write a cgi to update the
database from a form. Also just learning Perl. I have the following script
started that is called by an HTML form. I get the follwing message when I
execute it. Where can I find the message descriptions.
Kittiphum Worachat [EMAIL PROTECTED] wrote:
I try to set thread stack with ver 4.0.14 it never success the stack
size still 128K (I can do with the same command with ver. 4.0.12 it work)
The command is put in my.cnf like this
set-variable = thread_stack = 512K
how to set with ver
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm considering
moving to a P4 2 Ghz with the same amount of RAM. I have a few specific
tables with several million rows of data, and it takes quite a long time to
process that data on my current server. Does anyone have a good idea of
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
Andy,
I just noticed that you have
a mix of port numbers. Can you try
`netstat -an | grep 3306`
from the command line and see if the master is indeed listening on that
port?
$ netstat -an | grep 3306
tcp0 0
Hello,
I found the key to solve this problem in:
http://darkstar.ist.utl.pt/mysql/doc/en/InnoDB_foreign_key_constraints.html
You'll probably need an INDEX for that new foreign key you are declaring in
older versions this isn't neccesary but in latest ones it is a restriction.
You can have more
Hi Tiffany,
The Grant format for the Column privilege is a bit confusing ,bit here
it goes:
GRANT privilege (column1,column2, etc...) ON dbname.tblname TO
'username'@'hostname' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
f.e
GRANT SELECT (student_id) ON training_db.student TO
36 matches
Mail list logo