Hi There,
(mysql, query)
From the online manual I see:
--
innodb_data_file_path
Paths to individual data files and their sizes. The full directory path
to each data file is acquired by concatenating innodb_data_home_dir to
the paths specified here. The file sizes are specified in megabytes,
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
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
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
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
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
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 This
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 Connection
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 specified
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(). works
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 |
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
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
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)
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
Hi
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');
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)
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.
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)
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
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-31
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
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(),
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.
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:
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
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,
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
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 located on a
* 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
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 all
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
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
33 matches
Mail list logo