That's what it was... I was doing this in a test database and forgot that I
changed some values manually before.
Thanks,
Sergei
-Original Message-
From: Ady Wicaksono [mailto:[EMAIL PROTECTED]
Sent: Friday, February 18, 2005 10:55 PM
To: Sergei Skarupo
Subject: Re: cannot add a foreign
Hello everyone,
I'm trying to add some foreign keys to the database... It works fine for one
table but not for another. I need to make them both children of a third table.
I'm using mysqld-max 4.0.16 on RedHat Linux.
This is the statement that I ran:
alter table signal_segments
add foreign
(REPOST: I never got my original post, or any answers, so I am
reposting, assuming it was lost in the mail)
Hi,
I apologize in advance, I am sure this question has been asked dozens
of times, but my searches came up empty.
I am building an IRC based application "bot" (using libmysql) .. that
will
Hi,
I realised that install mysql 4 thru rpm is the best way for a smooth
installation.
Can anyone please point me to a site where I can download mysql 4 rpm
for Redhat9?
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Hi,
I think you can find all the information you are looking for there:
http://dev.mysql.com/doc/mysql/en/c.html
You have a description of all the functions :
http://dev.mysql.com/doc/mysql/en/c-api-functions.html
For example:
http://dev.mysql.com/doc/mysql/en/mysql-fetch-row.html
MYSQL_ROW row;
un
Dears,mysql_list_tables returns name of tables.(tables of a DB)
It returns MYSQL_RES type.
I want to split it to an array.
I'm newbie in SQL,Please guide me.
I'm working C.
yours,Mohsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hi all,
I'm a bit new to MySQL, it's my first email to the list.
Well, my question is: Can I have a key on a function of the column.
I have some table with a date column in it. I wish to have a key on
yearweek(datecolumn). I don't want to allow having duplicate weeks in
the table.
Thanks for yo
The memory deal gave me an idea.
A little hotcopy to a Memory table once a day and perform the search from
there. Since the search is a nicity for the users and not critical to be
100% accurate or up2date.
How do you do a hotcopy with php then? Never even seen it done.
Thanks
Donny Lairson
Pre
On 18 Feb 2005, at 14:24, Thomas Sundberg wrote:
I would approach this problem by isolating the where the problem
occurs.
I.e. Remove, comment out, half of you insert queries and see if the
problem
still exists. If it does, then remove yet another half of the
remaining part
leaving only 1/4 of t
Dear Peter,
I need to name of each table,But mysql_list_tanles() creates a sql result.
Can i make an array from those names?Each element of that is a name of table.
Please guide me.
regards
> Mohsen, not sure what you mean here, to get a list of tables in a db you
> have to issue an sql re
Mohsen, not sure what you mean here, to get a list of tables in a db you
have to issue an sql request, which is all mysql_list_tables() does
(http://dev.mysql.com/doc/mysql/en/mysql-list-tables.html).
PB
Mohsen Pahlevanzadeh wrote:
Dears,Problem of my Makefile is solved.
But i have a new problem
Hi Andy,
I see that. Unfortunately, I have no idea why mysql is trying to create
a symlink to a symlink it just created. Does anyone have any idea why
mysql would do that?
Thanks,
Mark
Ady Wicaksono wrote:
Hi Mark,
There's perror to check what happen, so when you have Error 17 you
check from
> See:
> http://downloads.mysql.com/archives.php
Thank you. Nice link to have around.
>> Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2).
>
>Do you have the same values for full-text parameters (ft_mit_word_len
>for example)?
Not at first. I had noticed that not long after
it doesn't work with innodb table.
http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html
InnoDB does not support the AUTO_INCREMENT table option for setting the
initial sequence value in a CREATE TABLE or ALTER TABLE statement. To set
the value with InnoDB, insert a dummy row with a value one
I am not really experienced on this, but i have noticed that simply
truncating an innodb table doesnt reset the autoinc key, u have to redump
the table.
I cant see what you are trying to do here
ALTER TABLE users auto_increment = 590;
set it to start @ 590 ?
> Hello,
> I am trying to get auto_
Hello,
I am trying to get auto_increment to begin at a certain integer.
CREATE TABLE USERS (
user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username varchar(50),
firstname varchar(50),
middlename varchar(50),
lastname varchar(50),
email varchar(100),
Dears,Problem of my Makefile is solved.
But i have a new problem:
I need to create an array of my DB's tables.
I have saw mysql_list_tables() function,But it returns a result of sql.
Please help me...
Yours,Mohsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
Hi Mark,
There's perror to check what happen, so when you have Error 17 you check
from your bash shell like this
# perror 17
Error code 17: File exists
Gotcha ! The reason is file exists :)
Good luck
Mark Uhrmacher wrote:
Hi all,
I've been getting a strange error when attempting to add an i
John McCaskey wrote:
On Fri, 2005-02-18 at 08:08 -0800, Jason Martin wrote:
On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote:
There should be tools on this website, but i see only a message from
Infektion Group.
What happened ?
Looks like the website got hacked.
I
There's nothing you can do except get really fast hard drives. Since
you are searching for random parts of words you can't use an index. So
you're stuck with doing a full table scan. Your entire table probably
won't fit in memory, so you will be reading from disk. Thus, fast disk
drives in a RA
Hi,
I need some SQL guru help on this one.
I'm trying to re factor an existing application where a number of clicks
grouped by keyword for two different time periods are needed. For
example, a user picks a date range and the application selects a count
for how many times a keyword appears in a
At 11:15 -0800 2/18/05, Scott Klarenbach wrote:
I can't seem to pass in the LIMIT clause variables into a stored procedure
http://dev.mysql.com/doc/mysql/en/select.html says:
The LIMIT clause can be used to constrain the number of rows returned
by the SELECT statement. LIMIT takes one or two numer
I can't seem to pass in the LIMIT clause variables into a stored procedure
i.e.
Select * from table limit param1, param2;
I get a syntax error compiling the procedure, but when I replace
param1 and param2 with hard coded ints, ie, 10, 10, it compiles and
works fine.
Is this functionality not av
We want to be able to
search through 1 million words looking for matches and a count of how many times
they have been searched.
Example. Words
like:
guns
shotguns
longguns
long guns
shot guns
So I want to search
all million words for the use of the word 'gun' Then it would return me
James,
We've had this issue twice (every 4 months) - running on 4.0.20 - due to
an old kernel (we just upgraded the kernel after the last issue).
Do you have a replicated (slave) database? We shut down the master and
then the slave (a few minutes after the master to let all changes
propigate),
On Fri, 2005-02-18 at 08:08 -0800, Jason Martin wrote:
> On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote:
> > There should be tools on this website, but i see only a message from
> > Infektion Group.
> > What happened ?
> Looks like the website got hacked.
>
I guess they should hav
Nestor,
1. LOCK TABLES;
FLUSH TABLES;
(allow reads, stall writes)
2. Copy the db dir
3. UNLOCK TABLES;
4. cd datadir
mv mysql.log mysql.old
mysqladmin flush-logs
PB
Nestor Florez wrote:
TO back up the databases in Mysql, isn't there a way where you can just copy
somefiles
to another direc
We have something I can't figure out happening on one of our servers. It's
running 4.0.23 on OSX.
One of the InnoDB tables is locked even though we can't see any process that is
even active that
could have locked it. SHOW OPEN TABLES doesn't show it as in use or locked.
We've tried all sorts
On Friday 18 February 2005 11:28 am, Nestor Florez wrote:
> TO back up the databases in Mysql, isn't there a way where you can just
> copy somefiles to another directory and in essence you have a backup? I
> thought I read this somewhere
mysqlhotcopy does this for myisam tables, there is a hot c
Brian,
>I'd like to be able to query the db to find which columns are indexed
>depending on the table to be searched so i can then create my MATCH().
>I'm having a heck of a time googling for this.
Until MySQL implements a proper data dict, you'll have to parse the
output from SHOW INDEX, where 'c
TO back up the databases in Mysql, isn't there a way where you can just copy
somefiles
to another directory and in essence you have a backup? I thought I read this
somewhere
No I can do a dump, but I was wondering if I can just copy some lies or a
directory.
Thanks,
Néstor Alberto Flórez Tor
I have several tables which have some columns indexed for full text
searching.
table 1:
FULLTEXT(foo,bar)
table 2
FULLTEXT(pip,pop,pup)
table 2:
FULLTEXT(hip,hop)
I'd like to be able to query the db to find which columns are indexed
depending on the table to be searched so i can then create my M
AESYS S.p.A. [Enzo Arlati] wrote:
I get an application with several thread , with each thread using it's own
connection.
What I mean is that the thread create a connection at the beginning and
close and detroy it before it close.
Under some circustances some of these threads close itself and reopen
Hi all,
I've been getting a strange error when attempting to add an index to a
set tables that make up a merge table. Here is a transcript of the session:
mysql> alter table he_access_offline_3 add index status (status);
ERROR 25 (HY000): Can't create symlink './Logs/#sql-156e_48d8.MYI'
pointin
Depends a lot on your server setup and table engine choices. See
http://dev.mysql.com/doc/mysql/en/table-size.html
etc.
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Raph
> Sent: Friday, February 18, 2005 10:08 AM
> To: mysql@lists.mysql.com
> Subject:
Hi all,
My 1st post in this ng !
Does anyone know what is the "physical limitation" of a mysql server ?
I have several db on my server (freebsd,p4,mysql 4.0.22), one of them with
many tables (2394), and I'm afraid to reach this "pysical limit" one day
Please tell me that I'm far from it ;-)
T
I have a database thats full of ingredients that are placed in various
categories. and then there are mixtures that are allowed to
be labelled with a certain grade based on the quality and
composition of the ingredients it is comprised from.
But the formulas are not always the same, as long as the
Hello,
I have problem to configure MySQL datasource for
WebSphere Application Server 6 (WAS6) from admin console.
1.) I have configured new JDBC Provider for MySQL (4.0.20a) as
following:
Name: MySQL JDBC Provider
Class path: ${UNIVERSAL_JDBC_DRIVER_PA
On Fri, Feb 18, 2005 at 10:06:38AM +0100, Anton Kornexl wrote:
> There should be tools on this website, but i see only a message from
> Infektion Group.
> What happened ?
Looks like the website got hacked.
-Jason Martin
--
Useless Invention: Motorcycle seat-belts.
This message is PGP/MIME signed
Hi,
On running the hot backup tool we receive:
ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1
ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1
050218 15:18:01 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex
eeaefd1a0
Hello,
Sorry for my insistency but I would like to resume this discussion again.
A few days ago Gleb answered the question I asked before about 0 PK values
(look for "Re: auto_increment=0" topic in the archives).
I had a look at http://dev.mysql.com/doc/mysql/en/server-sql-mode.html and
found t
Hi,
If a client wants an offline solution for a mysql database online, what
do you think? Is that even possible? The mysql database right now is
with the hosting company(with a private server hosting plan) somewhere
in US while the client's physical office is in Africa. What kind of
options do
Reinhart Viane wrote:
Concerning datetime type:
Eg. in a forum if someone posts a message the date and the time is stored
and shown of that message.
I suppose they use timestamp in that case?
They could, but because of the 'magic' behaviour of TIMESTAMP a DATETIME
is often used. To conserve space,
Dear Michael,
I have found mysql.h.Yes,It is in /usr/include/mysql
My code is :
CMysql::CMysql()
: CCore()
{
MySQL *x;
mysql_connect(x,"127.0.0.1","root","");
}//end of CMysql constructor
& My Makefile is :
INCS=-I'/usr/include/mysql'
#LIBS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm
#
> -Original Message-
> From: Marcus Bointon [mailto:[EMAIL PROTECTED]
> Sent: den 18 februari 2005 14:47
> To: mysql@lists.mysql.com
> Subject: log-warnings
>
> I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and
> I'm getting some infrequent warnings when importing data
> dumps
Did you want
WHERE Name LIKE 'sandy'
OR (main_data.Display_In_Search = 1
AND main_data.Expiry_Date >= CurDate())
OR
WHERE main_data.Expiry_Date >= CurDate()
AND (Name LIKE 'sandy'
OR main_data.Display_In_Search = 1 )
-Original Message
I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm getting
some infrequent warnings when importing data dumps created with
mysqldump, but I can't seem to find out what the warnings are.
I'm typically importing around 100,000 records at a time, so using
'SHOW WARNINGS' manually is no
Jan Bartholdy wrote:
Thanks Roger, but it does not work:
SELECT CASE
when Species_1_e > 0
THEN 'extern'
when Species_3_e > 0
THEN 'intern'
ELSE ''
END AS `species_1_l` from species where statsample=1820;
--Gives at a result 'extern'
What is the value o
I get an application with several thread , with each thread using it's own
connection.
What I mean is that the thread create a connection at the beginning and
close and detroy it before it close.
Under some circustances some of these threads close itself and reopen after
few minutes ( for example
Thanks Roger, but it does not work:
SELECT CASE
when Species_1_e > 0
THEN 'extern'
when Species_3_e > 0
THEN 'intern'
ELSE ''
END AS `species_1_l` from species where statsample=1820;
--Gives at a result 'extern'
_
Reinhart's request was to keep it's DATE type in place instead of changing
it to DATETIME... that's why I emphasized that DATE is better and he should
keep it that way ! (Comming back to it if I think... a DATE column beside a
TIME column would use 6 bytes... not 8 bytes as DATETIME... at 100 milli
Jan Bartholdy wrote:
Dear List, I have a select case question
SELECT CASE WHEN `Species_1_l` > 0
THEN 'intern'
when 'Species_3_e' > 0
'Species_3_e' is surrounded by single quotes, not backticks... thus it
is treated as a string, numeric value is 0, which is never > 0.
BTW, th
Dear List, I have a select case question
SELECT CASE WHEN `Species_1_l` > 0
THEN 'intern'
when 'Species_3_e' > 0
THEN 'extern'
ELSE ''
END AS `species_1_l` from species where statsample=1820;
The result is only
--
species_1_l
int
Gabriel PREDA wrote:
Let me assure you that DATETIME is the worst choice ever... because it need
8 bytes per record...
TIMESTAMP uses only 4
...but TIMESTAMP has a special behaviour which may not be wanted in all
cases: the first TIMESTAMP column of a table is updated automatically
when _any_ col
Hello,
the URL http://highperformancemysql.com/
is mentioned in the online available chapter 7 of the book
"High Performance Mysql"
There should be tools on this website, but i see only a message from Infektion
Group.
What happened ?
--
Anton Kornexl
--
MySQL General Mailing List
For list archi
Thank you very much, that indeed did the trick.
Concerning datetime type:
Eg. in a forum if someone posts a message the date and the time is stored
and shown of that message.
I suppose they use timestamp in that case?
-Oorspronkelijk bericht-
Van: Gabriel PREDA [mailto:[EMAIL PROTECTED]
Let me assure you that DATETIME is the worst choice ever... because it need
8 bytes per record...
TIMESTAMP uses only 4
DATE uses only 3, so does TIME
YEAR is the smallest... 1 byte.
You can do:
SELECT * FROM activities WHERE act_date >= NOW()
But for optimization... you should not compute in
Hey list
I need a query like this:
Select * from activities where act_date = today or any day
in the future
I have made it work like this:
Sselect * from activities where UNIX_TIMESTAMP()<
UNIX_TIMESTAMP(act_date)
Problem is with this thing I have to manually add 23:59:59
to e
Hi!
We are trying to migrate our applications to UTF-8 and so we started testing
the new features of MySQL 4.1 (still using 4.0 currently). But we are facing
some problems now. In our applications it could be theoretically the case
that there is arabic, hebrew, japanese and korean content in on
Hello.
Do you use mysql client program from the old release? Use
mysql --version
to check the version.
"Sehn, Timothy" <[EMAIL PROTECTED]> wrote:
> I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the =
> strangest error:
>
> mysql> use devmail
> Reading table informa
Hello.
>Where can I download it
See:
http://downloads.mysql.com/archives.php
> We now get table corruptions constantly (it only takes a minute before
> several tables get marked as crashed). I'd like to revert to the 4.0.18
Do you use official binaries? Sometimes after upgrad
61 matches
Mail list logo
