I have a sql script that needs to be re entered using the following command
mysql < create.sql but the database already exists. IS there a way to
overwrite or update the database using the script, or do I have to delete the
existing database?
I have a sql script that needs to be re entered
On 12/30/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
> > I guess my question is, how do I make sure the full text search is
> > being done against the CommentsIDX and not just against the individual
> > fields...
>
>
> This shows that the search is done against concatenation of the fie
Maybe it is because I am a programmer, but (unsigned) 0 - 1 = 4294967295.
What's the big deal?
Gleb Paharenko wrote:
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
mysql 5.0.15-standard
UPDATE SET = -1
when the is 0 gives me
I would like to create a trigger that either updates or inserts a row in
my USERS_PER_HOUR table when an entry is made in the LOG table.
The log table has LOG_DATE, LOG_TIME and a CUID columns that I would
like to either create a new row if the LOG_DATE and LOG_TIME do not
exist or update the num
I am having trouble with table lock.
The query is as follows:
INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT (
CUID
) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID
FROM `TV_LOG_ALL`
group by 2,3;
I keep getting this error: #1206 - The total number of locks exceeds the
lock table size
Like to know how to query MySQL for loaded or installed modules. Is this done
through using the code:
I'm looking on my system for loaded modules such as DBD-MySQL, zlib-devel and
perl-DBI.
Thanks
Like to know how to query MySQL for loaded or installed modules. Is
this done through u
Scott Baker wrote:
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the result
is greater 100,000 rows or something? I have a bone head user who
keeps querying two tables and NOT joining them, and then dragging the
D
Danny Stolle wrote:
Hi,
What you perhaps could use is the REGEXP usage in your where clause.
Try this:
update name set first_name=replace(first_name, '\\', '') where
first_name regexp '';
The fun thing is that when you put '\\' instead of the '' after the
regexp function it doesn't w
At 04:31 PM 12/30/2005, Scott Baker wrote:
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the result is
greater 100,000 rows or something? I have a bone head user who keeps
querying two tables and NOT joining them, a
On Friday 30 December 2005 3:31 pm, Scott Baker wrote:
>
> How can I prevent this?
>
> Scott
You know when I deal with users like this, I like to think about what Dennis
Leary said about spanking children; "I don't need to spank them, I find that
waving the gun around works just as well."
-
Is there a way to tell mysqld to stop running a query if it hasn't
completed in over 60 seconds? Or how about stop running if the
result is greater 100,000 rows or something? I have a bone head user
who keeps querying two tables and NOT joining them, and then
dragging the DB server down while i
Hi,
What you perhaps could use is the REGEXP usage in your where clause.
Try this:
update name set first_name=replace(first_name, '\\', '') where
first_name regexp '';
The fun thing is that when you put '\\' instead of the '' after the
regexp function it doesn't work. But this sure do
Well, I found the reason for these table becoming 'read only':
These tables where part of a merge table, which included some read only
tables (read only set in file system).
Now even after the merge table was dropped, all member tables stayed
'read only' regardless of their individual file syste
Hello.
That seems like a bug:
http://bugs.mysql.com/bug.php?id=14543
Marko Domanovic wrote:
> mysql 5.0.15-standard
> UPDATE SET = -1
> when the is 0 gives me 4294967295
> is integer(10) unsigned...
>
> maybe it would be more logical the expression to evaluate as 0, insted 2^3
Hello.
> One think it is astonished: I can agree that there should bu some
>conflict, but why i have remove the same row, with the same key value
>several times about 5-6 times ).Do you have some knowledge of problem
>like that ?
It is difficult to say something, because the whole picture
Hello.
> I guess my question is, how do I make sure the full text search is
> being done against the CommentsIDX and not just against the individual
> fields...
If I've got your question right, you shouldn't worry about
it. As far as I know, the search is done against the union of all
col
Hello.
Sorry. It seems that I've understood your question now. In my opinion,
IGNORE_SPACE not related to CREATE FUNCTION statement, because at:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
for some cases we have "to use a space between the name and the following
parenthe
Hi,
MySQL 5.0.18, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not all
So it should be possible to automate a skip of errors setting by code , at
run-time, sql_slave_skip_counter = 1, each time I check the slave status and
I found an error, and then I restart the slave
Thanks, I should try this way.
One think it is astonished: I can agree that there should bu some c
Hello list
I've just install v4.1.
Every thing works fine exept SQLyong shows all non-latin characters as
question marks and the old Mysql-Front can't connect with tables after
mysql_fix_privilege_tables.
How can I change character_set_client=greek than to latin?
I thing this will solve my problem
Did you try to run OPTIMIZE TABLE, REPAIR TABLE or ALTER TABLE on
those tables? If you run an ALTER TABLE table_name TYPE=old_type (be
sure to replace old_type with whatever the table currently is), it
should rebuild the table.
Check the docs on mysql.com, there are a bunch of pages about
upgradin
I have 290 records in the database with backslashes. I want to remove the
backslashes. Why the query below doesn't remove backslashes?
update name set first_name = REPLACE(first_name,'','') where first_name
like '%%';
Very odd problem. I do have a larger database, with many myisam tables.
A couple days ago, some of them turned 'read only'.
Symptom:
delete from day_48392 where id=28398776259;
ERROR 1036 (HY000): Table 'day_48392' is read only
I checked:
- table file permissions are right ('660 mysql:daemon')
Hi,
I have a web app where I am doing a boolean search. I only want to return
10 results per page, but I'd also like to know how many total rows match the
search query. I'm currently performing this with 2 query statements:
1. (To get the actual rows via the search)
SELECT $
On Friday 30 December 2005 14:05, jean-marc Jegou wrote:
> Re: install mysql-5.0.17 on linux AMD 64 processor
> http://lists.mysql.com/mysql/193352
>
> dir Duncan Hill ,
>
> thank you to answer to my question !
>
> my processeur is AMD 64 2800+ ( 64 Bits processeurs!) and linux is
> seeing an Athlo
Re: install mysql-5.0.17 on linux AMD 64 processor
http://lists.mysql.com/mysql/193352
dir Duncan Hill ,
thank you to answer to my question !
my processeur is AMD 64 2800+ ( 64 Bits processeurs!) and linux is
seeing an Athlon 32 bits processor (see previous message).
My OS IS Linux Aurox ver 1
Hi,
Is there any compiler to Compile Embedded SQL Macros into source codes
for MySql?
In otherwords, what is the equivalent of PRO*C (in Oracle) in MySql?
Thanks,
Ezhilarasan
Thanks, Danny. This "little info" was all I needed. It works perfectly
now.
Have a Happy New Year!
--Marc
On Fri, 2005-12-30 at 10:28 +0100, Danny Stolle wrote:
> Marc,
>
> In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is
> not possible to use functions as default values
I have a table on my forum that's frequently accessing with reads and
writes. On a busy day, the table is locked when people are posting
messages and the page hangs when you try to read a topic.
Is it worth me converting the table to InnoDB, as I've heard that
InnoDB doesn't lock tables during I/O
Gary Richardson wrote:
> We moved directly from 4.0.20 to 5.0.16. Worked like a charm. I had a
> script that went through and optimized all tables with keys on
> text/varchar and char fields.
>
> We're also slowly ALTERing innodb tables to get them into the new
> compact format.
i tryed to update
Hi everyone
One of the projects I am working on requires me to take snapshots of
the Content Management System from certain points in time (usually
before a change is made).
These snapshots contain everything (not just the page contents), from
navigation ordering to user permissions to actual con
On Friday 30 December 2005 10:35, jean-marc Jegou wrote:
> i try to install mysql-standard-5.0.17_linux-x86_64-glibc23, but it did
> not work !
>
> System: Linux localhost.localdomain 2.6.9-10.2.aur.2 #1 Thu Feb 10
> 04:34:27 EST 2005 i686 athlon i386 GNU/Linux
> Architecture: i686
x86_
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: install mysql-SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
i try
Marc,
In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is
not possible to use functions as default values; you could create:
create table tester (f_date date default curdate()); But this doesn;t
work. You have to struggle through your knoda how to present the current
date. B
35 matches
Mail list logo
