iH
getting the following after issueing
./configure --mandir=/usr/local/share/man/ --with-innodb
make
ld: Undefined symbols:
_tgoto
_tputs
_tgetent
_tgetflag
_tgetnum
_tgetstr
make[2]: *** [mysql] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive-am] Error 2
anyone have the
At 07:05 AM 9/4/2002, you wrote:
>Is there a way I can get what the allowed values of an 'enum'
>coulmn are in mysql? I want to eventually list these values in
>a list box or something similar?
mixo,
I can't see an easy way of getting the enum for a particular
column. The best I could
I believe my problem was that I was omitting the word PRIVILEGES. I was
doing just GRANT ALL ON...
I also added *.* instead of * and @'localhost' and that got it working.
Thanks to all who helped out.
Andrew
> I personally have never had a problem with Redhat.
>
> Andrew try this:
>
> grant
* mixo
> Is there a way I can get what the allowed values of an 'enum'
> coulmn are in mysql? I want to eventually list these values in
> a list box or something similar?
I think you have to do a SHOW CREATE TABLE and parse the output.
--
Roger
sql
Martijn van Iersel wrote:
> Hello
>
> I'm writing a small database application on top of
> mysql. It is almost finished and now I'm thinking
> about how to distribute it.
>
> I am thinking of making two separate distibutions, one
> without mysql that you can use if the database server
> is locat
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld file to get the support for row level locks ???
Regards,
Sekhar
-
Is there a way I can get what the allowed values of an 'enum'
coulmn are in mysql? I want to eventually list these values in
a list box or something similar?
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi!
We are running mysql (latest 3.x) on Windows 2000 Server. For some reasons I am not
allowed to use Linux, so I have to fight my way through windows.
All is working fine, I use the "huge".cnf (server is P4 2.w with 1GB RAM) and
performance is good.
My problem is: When really huge calculatio
Ilyas,
Wednesday, September 04, 2002, 2:27:27 PM, you wrote:
IK> Is it in Mysql 4 possible to use foreign keys?
Foreign key constarints are supported in InnoDB tables (3.23 and
4.0)
IK> If yes, how can I create two tables with foreign keys and use them?
Take a look at:
http://www.mysql.co
User,
Tuesday, September 03, 2002, 7:54:05 AM, you wrote:
>Description:
UT> A specific query in the format of:
UT> SELECT DISTINCT a.*, b.* FROM privatemessage LEFT JOIN b ON (b.x = a.y);
UT> Is causing a segfault. This worked fine in the 3.23 series.
Thanks for bug report! It's already fixed
Erick,
Wednesday, September 04, 2002, 10:55:55 AM, you wrote:
EP> i have a date/time column. i insert into it using "now()". works fine.
EP> now i want a query where data/time is either today or yesterday.
EP> how should i do it?
Take a look at DATE and TIME functions such as CURDATE(), DATE_
Azrinsyah,
Wednesday, September 04, 2002, 11:03:30 AM, you wrote:
>Description:
AMA> I can't run both the scripts mysql and mysqladmin to set up the
AMA> root password for my database.
>How-To-Repeat:
AMA> When I run this command;
AMA> ./mysqladmin -u root
Matthew,
Monday, September 02, 2002, 10:25:40 PM, you wrote:
[skip]
thd->>query at 0x88b3798 = SELECT DISTINCT * FROM b2posts WHERE 1=1 AND
MM> ID = 124 AND ((post_title LIKE '%%') OR (post_content LIKE '') OR
MM> (post_title LIKE '%%') OR (post_content LIKE '%%')) AND post_date <
MM> '2002-08-3
EMS HiTech company is very glad to announce the NEW software -- the
MySQL Export tool!
It is a cross-platform (Windows and Linux) product to export your data
quickly from MySQL databases to any of 12 available formats, including
MS Excel, MS Word, HTML, TXT, and more. MySQL Export includes a wiz
HI ALL,
Does anyone know of a simple way of migrating JUST data from a sybase
ASE server to mysql ?
Please Help :)
Thanks
Tonino
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Karthik,
> Instead why don't you try
> select date_sub(now(), INTERVAL 1 DAY)
You suggested this earlier. Are you simply repeating the comment or asking
me (cf the original poster) a question? Herewith an assumption that you want
to maximise your learning.
Obviously I can't answer for Erick. Ho
Is it in Mysql 4 possible to use foreign keys?
If yes, how can I create two tables with foreign keys and use them?
Thanks
ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
Hi Jed,
Though this works,when I tried to insert an inner query in that,it is
giving an error in syntax.Can u please help me in thi matter?I gave the
query as follows:
select TO_DAYS(CURDATE()) - TO_DAYS(select dates from userregistration
where userid like 'abhilas');
Abhilas
Instead why don't you try
select date_sub(now(), INTERVAL 1 DAY)
Karthik.
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Erick Papadakis" <[EMAIL PROTECTED]>; "mysql"
<[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 3:09 PM
Subject: Re: problem with date/time column
Has anyone created a plugin or script that will allow me to
convert my filemaker database to MYSQL
Thanks
Brian Leyland
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Hi Erick,
> i have a date/time column. i insert into it using "now()". works fine.
> now i want a query where data/time is either today or yesterday.
> how should i do it?
Calculate the date required (yesterday and/or today) and then add a time
component of midnight (all zeroes) to make up a da
Hello
I'm writing a small database application on top of
mysql. It is almost finished and now I'm thinking
about how to distribute it.
I am thinking of making two separate distibutions, one
without mysql that you can use if the database server
is located on a different computer, and a standalone
When I do mysql> show processlist;
I get the following
| 18966 | replicate | smtp.lantic.net | NULL | Binlog Dump | 2069 |
Slave connection: waiting for binlog update | NULL |
+---+---+--++-+---+--
its select date_sub(now(),INTERVAL 1 DAY)
- Original Message -
From: "Erick Papadakis" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, September 04, 2002 1:25 PM
Subject: problem with date/time column
> hi,
>
> i have a date/time column. i insert into it using "now()
David,
Wednesday, September 04, 2002, 9:34:55 AM, you wrote:
>From the online manual I see:
DL> --
DL> innodb_data_file_path
DL> Paths to individual data files and their sizes. The full directory path
DL> to each data file is acquired by concatenating innodb_data_home_dir to
DL> the paths specif
Matt,
Wednesday, September 04, 2002, 12:43:51 AM, you wrote:
MTW> On Tue, 2002-09-03 at 05:24, Victoria Reznichenko wrote:
>> MTW> I just installed MySQL from RPM and can connect to it via shell using
>> MTW> the MySQL command, but I can't get anything else to connect to it.
>> MTW> MySQL Conne
Roman,
Wednesday, September 04, 2002, 10:47:18 AM, you wrote:
RM> Server info:
RM> Release: mysql-3.23.52 (Official MySQL RPM)
RM> Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686
RM> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
RM> Thi
>Description:
I can't run both the scripts mysql and mysqladmin to set up the
root password for my database.
>How-To-Repeat:
When I run this command;
./mysqladmin -u root password 'pegasus'
ld.so.1: ./mysqladmin: fatal: libmysqlclient.so.6: open fai
Roman,
try to execute this query:
select e.cid,d.amount,dd.amount
from eee e
left join ddd d on (d.cid=e.cid and d.c>=2 and d.c<=3)
left join ddd dd on (dd.cid=e.cid and dd.c=3)
and after that try to group by them manualy. What do you have as result?
Best regards,
Mikhail.
- Original Mess
hi,
i have a date/time column. i insert into it using "now()". works fine.
now i want a query where data/time is either today or yesterday.
how should i do it?
thanks/erick
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://f
Heikki,
Unfortunately it is not that easy. I've set the
innodb_lock_wait_timeout to 1 because I want locks to fail quickly,
so my program can move on to the next request. In pseudocode:
Fetch a bunch of requests with status=unprocessed
Try to obtain a lock through a select * from x for update
If
Hello mysql team,
Server info:
Release: mysql-3.23.52 (Official MySQL RPM)
Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free softw
32 matches
Mail list logo