HI,
I have data on more than 1 db to separate in year name like these:
cust2000-- contain customer infomation in year 2000
cust2001-- contain customer infomation in year 2001
all db have the same field name. I have put db name and table
Hi,
Can anyone tell me how i get a win32 mysql embedded library?
Thanks,
Jeroen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi All,
Tried the following three statements and they are wither too slow or do not
give me what I want. Basically what I want is to search for records for a
whole month and display totals for that month for each individual day. The
date field is indexed.
Tried..
select count(num) as
Hi,
Check the section about How MySQL Optimizes queries for you version - there
is a bit about how indices are not used when calling a function that may be
relevant.
Hope it helps
Quentin
-Original Message-
From: Leon Noble [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 November 2001
i have installed MySQL on W2000
my my.ini is :
[mysqld]
basedir=C:/MySQL
#bind-address=192.168.0.1
datadir=C:/MySQL/data
#language=C:/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
innodb_data_home_dir = c:/IbData
innodb_data_file_path =
Leon Noble writes:
select dayofmonth(date) as mydate, count(num) as mycount from table_name
where date='TO_DAYS(2001-08-01) - TO_DAYS(2001-08-31)' and action=1 group by
dayofmonth(date);
This query makes no sense at all. I don't think the date will
ever be equal to that string constant,
Hi!
I looked from the MS Developer Studio manual:
Code Description Name
2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND
3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND
4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES
5 Access is denied.
Hi ppl!
I have a table with datetime type column in it.
when I make request select * from my_table order by my_datetime
I get the normal sort i.e. first the oldest dates but I want to get
reverse sort to have most recent dates to be the first.
How can I do this?
Hi,
Is it possible to work with VB and MySQL directly using dlls, just like
working with VB and SQL Server.
QB
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
well for starters you should look into updating your grants table, to allowe the
remote server to access the db. Don't forget to properly set the userid, password, and
perms for this...Highly encourage to grant this id read only access...but that's your
call. Then on the prospective webserver
Yes it is possible,
Create a System DSN by using Settings-- Control Panel --32 Bit ODBC data
Sources.
And use ADO to connect MySQL database.
Hope this helps.
Mustafa
- Original Message -
From: Quan Bang [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001 14:44
i log administrator
i have created the directory c:\ibdata\ibdata1
same error..
Regards,
Jean
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001 10:59 AM
Subject: Re: error starting mysql
Hi!
I looked
Henrik Holmberg writes:
Hi
Can MySQLGUI start and stop the daemon?
/Henrik
It can stop it if you have root privileges on the server.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB,
Hi,
Michael Widenius wrote:
Tomohiro, could you be kind and put a copy kind a put a link from the
MySQL software portal to your page ? This way it will be easier for
other MySQL users to find your software!
http://www.mysql.com/portal/software/html/index.html
Sure.
Thank you so
I'm totally new to mysql so I may be asking a real dumb question here.
Does anyone know whether the running of mysql_install_db necessary for the
Windows distribution of mysql? I downloaded the binary
mysql-3.23.43-win.zip file yesterday and ran the setup. However, there is
no
Hi!
At 01:50 PM 11/1/01 -, you wrote:
i log administrator
i have created the directory c:\ibdata\ibdata1
Ok, that explains the error: ibdata1 should be
a file.
If you have a directory of the same name
'ibdata1', then Windows tries to open a DIRECTORY
for reading, which does not succeed, of
select * from my_table order by my_datetime DESC
-Original Message-
From: brainheap [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 5:16 AM
To: MySQL mailing list
Subject: newby question about datetime fields
Hi ppl!
I have a table with datetime type column in it.
when
Erik G. Burrows writes:
I'm having a wierd problem with MySQL, that seems to be begging that I
wait for the next release, but I wonder if anyone else is getting this.
I'm running MySQL 3.23.42, and using the Berkeley DB table type to get
transactional ability. Occasionally, MySQL will
Simply indicate the database name in you query:
SELECT cust2000.mytable.*, cust2001.mystable.* FROM cust2000.mytable,
cust2001.mystable WHERE cust2000.mytable.cust_ID=cust2001.mystable.cust_ID;
-Original Message-
From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
On Wed, 2001-10-31 at 21:53, [EMAIL PROTECTED] wrote:
Description:
Configuring MySQL 4.0.0 with --with-ssl causes the server to
act as though interactive_timeout and/or wait_timeout were
set to approximately 6 seconds, although the variables seem
to have
Gisella,
At 04:24 PM 10/31/01 -0800, you wrote:
Heikki,
The output I get from the Monitor does not have the section
--
LOCKS HELD BY TRANSACTIONS
--
that I see in the manual (www.mysql.com/doc), section 7.5.9.1, The InnoDB
Monitor.
sorry, the
Ian Collins writes:
So how do you use the HANDLER command in a C program?
I perused the code for 3.2x for this, and ended up installing mysql-4.0.0.
I found what I believe to be the code for HANDLER in
libmysqld/sql_handler.cc
in the functions,
mysql_ha_open, mysql_ha_close, mysql_ha_read
Raymond,
I would expect so (although I haven't tried it), since both ODBC and OLEDB
providers (MyODBC and MyOLEDB, respectively) exist for MySQL on Windows. I
have used MyODBC with VBA in an Access 2000 front end to a MySQL database,
and it works, albeit with a few minor glitches and less than
Hi friends,
I am a system administrator.
I am from China:)
We want to build a big system with Mysql for authortication,But we don't know how to
establish cluster for Mysql,
Could you help me please and tell me what we must to do!
Waiting for your answer and thanks very much!
WeiMing.Li
Raymond,
We run ASP with MySQL constantly using both ADO and a JDBC connections to it
and experience great stability with it... this is with ASP on a WinNT/Win2K
platform... we've never tried ChiliASP
best wishes
Chris
Dr Christopher Thorpe
Information Architect
GenomeBiology - biology for
Alex,
If MyODBC is simply passing the query in this case along to MySQL, the MySQL
engine will choke on the subquery IN (SELECT ..., since MySQL doesn't
support subqueries. I have had success, however, using subqueries with
Access and MySQL by linking the MySQL tables to Access using the Get
You might want to try Hurricane Electric, I've been using them for over a
year, MySQL, Telent, cgi, email account, DNS support starting at $10/month.
http://www.he.net
They've been great.
Cheers, T
On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote:
My current web hosting
I use www.ccwebhost.com for about two years... $13/mo for 200mb of space
and their tech support is beyond excellent! mySQL support, CGI-BIN,
FTP, PHP4, SSI, SSL, etc... Anything and practically everything!
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original
At 11:57 AM -0500 11/1/01, Barbara Ferrell wrote:
i am typing a command C:\apache\mysql\bin mysql =
C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to =
Andrew Murphy's help. but i wondered what it meant? i have looked in =
the books..
is part of the DOS prompt.
I use netmegs.net for my metropets.org site and they have been wonderful -
answer questions quickly and accurately, and virtually no down time.
Anne
- Original Message -
From: Tony [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Joe Fan [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday,
Hello,
Does the data stored in a VARCHAR field get truncated on spaces?
All my fields contain the data up to the first space...
What should I use ?
Thanks a lot, sincerely,
Gil.
[ PHP 4.01, MySQL 3.23, FreeBSD 4.2 ]
--
PGP public key at:
keskydee.com/gil.asc
ICQ: 3310801
Try mailing.database.mysql.
Unfortunately its one way, postings on the mailing list do make it to the
newsgroup but postings
on the newsgroup don't make it to the mailing list.
Fred Van Andel
-
Before posting, please check:
i am typing a command C:\apache\mysql\bin mysql =
C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to =
Andrew Murphy's help. but i wondered what it meant? i have looked in =
the books..
Barbara,
Asking Windows questions here is likely to attract all manner of
database,sql,query,table
At 12:29 PM -0500 11/1/01, Gil G. wrote:
Hello,
Does the data stored in a VARCHAR field get truncated on spaces?
Trailing spaces, yes.
All my fields contain the data up to the first space...
What should I use ?
One of the TEXT types.
Thanks a lot, sincerely,
Gil.
At 1:09 PM -0500 11/1/01, Ian M. Evans wrote:
Back when I was working with MSSQL I needed to alphabetize movie titles in
the proper library format where 'A' 'An and 'The are ignored.
For MSSQL I was told to use:
select * from titles order by case when title like 'The %' then substring
(title, 5,
On Wednesday 31 October 2001 21:42, Gary Huntress wrote:
I'm up to over 1 databases in one data directory and that is
becoming a performance problem as users make their connections. I would
like to begin running multiple servers on the same box.I made my
first attempt tonight and was
Damned filter. Anything quoted once is my post. Grrr...
database,sql,query,table
Erica Douglass writes:
I have a text file that is fixed-width delimited (that is, fields are
delimited by certain column widths.)
What is the workaround for this? Will importing large files work if I
Im sorry, this is a very basic question -- but I am new to using SQL via
the web. I am on my own server, able to create databases/tables and
manipulate them to my heart's content at the command line connecting as
root. I cannot connect to the DBs any other way, however (e.g. logging in
at
Description:
Just installed this release with rpm, which says:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root -p password 'new-password'
/usr/bin/mysqladmin -u root -h localhost -p password 'new-password'
Unfortunately
MySQL provides a rich list of APIs with which scripts and programs perform
data management. Other than directly entering INSERT and UPDATE commands
directly at the mySQL command line, there is not built-in data entry
functionality.
Data entry (including, verification, validation,
You don't need the /usr/bin/. Try just: mysqladmin -u root -p password
'new-password'. If your setting this for the first time, you don't even
need the -p.
Jason
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 3:37 PM
To:
Hi,
If your Paradox Apps are written in a reasonably DB-independent way using
Delphi Components, and not expoiting and Paradox-only features (are there
any?), then porting those same applications to MySQL via ODBC should be a
manageable task.
If you do need to start from scratch, and the
First pointer - what errors are you getting!
-Original Message-
From: Greg [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 November 2001 9:32 a.m.
To: [EMAIL PROTECTED]
Subject: Installing Calendar 0.9.33 on Mac OS X
Newbie here who has PHP and MySQL going, but can't figure out how to
PHP4.0.6 claims to have MySQL with it.
Is this all installed with one installation file? Is it just one run of
the setup file and you have PHP and MySQL installed together?
Benj
-
Before posting, please check:
Benj Arriola writes:
Knowing PHP supports every database, why on the download page it
mentions something about MySQL? And why use the words built-in. I was
assuming MySQL came with it already.
Normally you need to link with the mysql client libraries, but
PHP provides a substitute for
Being a PHP programmer, I know that PHP supports almost every database
invented on earth.
Now on the download page:
http://www.php.net/downloads.php
Under Windows Binaries:
PHP 4.0.6 zip Package says MySQL support BUILT-IN
Knowing PHP supports every database, why on the download page it
For windows binaries, if you want to enable other databases, you have to
uncomment the associated .dll file in the php.ini. Php doesn't have a
seperate dll file for mysql, as the module is build right in (you couldn't
disable it if you wanted to). When you compile it directly, if you don't
Now on the download page:
http://www.php.net/downloads.php
Under Windows Binaries:
PHP 4.0.6 zip Package says MySQL support BUILT-IN
Knowing PHP supports every database, why on the download page it
mentions something about MySQL? And why use the words built-in. I was
assuming MySQL came
Hi!
Garry == Garry Williams [EMAIL PROTECTED] writes:
Description:
Garry Note: Thanks to Mr. Chakarat Skawratananond Technical Consultant,
Garry Rapid Port Team, IBM Server Group in Austin, TX USA for his
Garry invaluable help in diagnosing these problems.
Garry make fails because the
I need to select the appropriate price for a product in a table, and the
product has a compund key with 2 fields: product number and date.
For every transaction with a certain product, I need to retrieve the price
that was 'current' at the specific time when that transaction took place.
In
SELECT price FROM mytable WHERE price = theprice DESC LIMIT 1;
-Original Message-
From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 7:53 PM
To: [EMAIL PROTECTED]
Subject: Can I use the concept of Effective Date with MySQL?
I need to select the
I have had to do this problem and i solved it by having 4 fields,
Normalprice (PrPrice),
Tempprice (PrTempPrice),
Start date (PrStart)
End Date (PrStop).
In the select
IF(((CURDATE() = PRStart) and (PRStop = CURDATE())),
PrTempPrice, PrPrice) as CurrentPrice
hope this helps
On Thu, 1 Nov
Hi friends,
I am a system administrator.
I am from China:)
We want to build a big system with Mysql for authortication,But we don't know how to
establish cluster for Mysql,
Could you help me please and tell me what we must to do!
Waiting for your answer and thanks very much!
WeiMing.Li
Hi friends,
I am a system administrator.
I am from China:)
We want to build a big system with Mysql for authortication,But we don't know how to
establish cluster for Mysql,
Could you help me please and tell me what we must to do!
Waiting for your answer and thanks very much!
WeiMing.Li
I'm doing experiments with the table pet where the field birth is of
type date. How come
UPDATE pet SET birth = a2b WHERE name = snort;
gives:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
but
UPDATE pet SET birth = ab WHERE name = snort;
gives:
Query OK, 0
The better way is use myvbql.dll at http://www.icarz.com/mysql/ . Your code
can use both recordset style (ado full syntax only) and sql style (complex
but useful). I recommend to use sql style when u need to manipulate data.
SF
At 14:57 1/11/2001 +0200, M.Ocak wrote:
Yes it is possible,
At 11:34 AM +0100 11/1/01, Harald Fuchs wrote:
In article p05100345b8063ddb205a@[192.168.1.31],
Paul DuBois [EMAIL PROTECTED] writes:
[snip]
Of all the methods suggested I like the look of the one above and will
try that one first.
$count = $sth-fetchrow_array();
$rows = $sth-rows()
Can someone help? Using Linux (Mandrake 8.0), I'm still having great
difficulties getting Apache and PHP installed/configured to interface the
MySQL database I'm using. I've repeatedly tried compiling PHP and Apache
from source, with no luck (I even used newer/older versions the several
I am having a problem with a query and I don't know if it is a bug or
intentional. Anyway any input is greatly appreciated. Here is a basic query
that is simpler than what I am dealing with but should demonstrate my problem.
Lets say:
SELECT A.1, A.2 FROM A
yeilds:
test1 test2
then:
Hi,
You need to read up on Left Joins, which will insert a 'NULL' row in the
results for B where there isn't a real one.
Regards
Quentin
-Original Message-
From: Q [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 November 2001 4:40 p.m.
To: [EMAIL PROTECTED]
Subject: a bug or intentional?
I often find myself in the following situation:
I have a master table and a detail table, the detail table contains
chronologically ordered items (statuses) that relate to the master record.
I now need to display one line for each of the master records with the
latest status from the detail
Robert --
Just in case what Quentin and Rick said isn't clear, the MySQL
DLLs/libraries are linkable and usable from Delphi/KYLIX. Quentin's note
gives a good hint about one way to do it. I seem to recall from my last job
that there are people around using Delphi as a front end to MySQL, so you
Hi friends,
I am a system administrator.
I am from China:)
We want to build a big system with Mysql for authortication,But we don't know how to
establish cluster for Mysql,
Could you help me please and tell me what we must to do!
Waiting for your answer and thanks very much!
WeiMing.Li
Hi,
It's extremely favourable to use MySQL with ASP but I can't find a lot
of web host support both. Most of them support only one of them, MySQL
and PHP is a good pair while ASP and MSSQL is another pair.
Any suggestion that support both?
Thank you.
ST Ooi
At 03:48 PM 01/11/2001 +,
BTW, there are open source solutions for the user-interface which don't
require the web browser. I've heard people mention GTK in this context.
There was even a book (about building user interfaces for MySQL with GTK+)
Maybe even PHP-GTK (Win or *nix)
Example GUIs;
Hi !
I would like to use ASP(Active Server Pages) Mysql
as database for my website,can you please tell me the
procedure for connecting the same.
Pl reply ASAP.
Regards,
Murali
__
Do You Yahoo!?
Find a job, post your resume.
Dear Sir:
I want to ask some questions about Redhat Linux+MySQL installation.
1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43.
Commands is as follws:
# cd /usr/local
# tar ¨Czxvf MySQL-3.23.443.tar.gz
# mv MySQL-3.23.43 /usr/local/MySQL
# cd
Dear Sir:
I want to ask some questions about Redhat Linux+MySQL installation.
1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43.
Commands is as follws:
# cd /usr/local
# tar ¨Czxvf MySQL-3.23.443.tar.gz
# mv MySQL-3.23.43 /usr/local/MySQL
# cd
Perhaps this is more of a general SQL question than a MySQL specific one,
and I may be exposing my ignorance by asking this, but I figure it's worth a
shot.
I have two tables, 'a' and 'b'. Each contains a value 'c'. I want to
select all 'a' rows where a.c is not in the set of b.c. Is this
try to copy mysql libraries to /usr/local/lib and /usr/lib
cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib
cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib
From: YANG [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Ask for Linux+MySQL installation help
Date: Fri, 2 Nov 2001 13:43:46 +0800 (CST)
Hi Mr. Jerry,
Since Mysql does not support sub query, you will have to use temporary
table instead.
Create temporary table tmptbl1 Select keycol, Max(datetimecol) as maxdate
from detailtable group by Keycol;
Create temporary table tmptbl2 Select distinct T.Keycol, D.Status from
tmptbl1 T,
I feel a little wierd doing this, since I'm a newbie here, but here goes:
Do you want to be a paying customer of MySQL AB, or do you want to
participate as a member of the volunteer community?
If you want MySQL AB to give you a quote on designing a cluster of MySQL
servers (or whatever), you
I am a newbie.
When I create a table, when one column contains a space, how can I
create it
correctly in mysql?
for example:
CREATE TABLE mytable(
name CHAR(60) NOT NULL,
this column CHAR(60) ///Here there is a
space?
);
When I use ' or , it does not
You have to setup an ODBC connection using the MySQL ODBC Driver (MyODBC),
and then you use ASP to create connection and recordset objects.
Chris
-Original Message-
From: murali madhav [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 12:40 AM
To: [EMAIL PROTECTED]
Subject:
74 matches
Mail list logo