Hi,
I was working on some merge tables this morning and it worked fine, but
after a few unsuccessful table creation requests (I was making some
tests), I could not alter or select from a table for the following reason:
mysql> create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE
UNION=
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 i
Hi Tiffany,
The Grant format for the Column privilege is a bit confusing ,bit here
it goes:
GRANT (column1,column2, etc...) ON TO
<'username'@'hostname'> IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
f.e
GRANT SELECT (student_id) ON training_db.student TO
'columnuser'@'localhost' IDENTIFIE
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 i
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
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 th
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 wi
> 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.
>
> DBI::st=HASH
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 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
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 the
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 1NULL
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 it
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
> 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 so
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 cou
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,
>
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 SET
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
* 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
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 =
"driver=MySQL;server=SERVER_IP;uid=UID;p
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
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
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 news_category.
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 (it's
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;
+---+---
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 discussi
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 version
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 1
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 Descrip
>> 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 Linu
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
me
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 16:5
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
> 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 en
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: ./bin/my
Hi there,
Do you know a sql command which I can write to obtain the last date that I
updated a table
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
polymorphis
38 matches
Mail list logo
