how to use more than one field in a table as combined primary key.
e-mail= [EMAIL PROTECTED]
Hello,
please let me know, if you are have some ideas about following:
--
mysql set @a='1';
Query OK, 0 rows affected (0.00 sec)
mysql select @a:=concat(@a,',',id) from message
how to use more than one field as combined primary key
emailk= [EMAIL PROTECTED]
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
Hello John,
We are developing the next version of MySQLDAC (MySQL Direct access
components for Delphi/C++ Builder).
We've found
const char * STDCALL mysql_character_set_name(MYSQL *mysql) in mysqlh.h
But we've not found this function in libmysql.dll (ver.3.23.33)
Is ther alternative ways to
I obtain the next message error in the servlets where I have to modify the
content of the tables.
This error has appeared without changes in the servlets code.
Message: Before start of result set
SQLState: null
ErrorCode: 0
Does anybody know where is the problem?
Thanks.
Carlos Godoy
[EMAIL PROTECTED] writes:
Description:
I have installed MySQL version 3.23.36 (having previously used 3.23.34a) After
I restarted the daemon, I ran the mysql 'monitor' program to check on the existing
databases and tables. Mysql reported for each table: "Didn't find any fields in
Silvio Picano writes:
Received the error again this morning;
I was able to copy an older copy of .frm file into
tbl_status.frm (via Sinisa's response), and the problems
went away; all data appears to be intact.
[Largest *.MYD files is 186 mbytes *.MYI is 32 mbytes.
Note that
mySQLDAC writes:
Hello John,
We are developing the next version of MySQLDAC (MySQL Direct access
components for Delphi/C++ Builder).
We've found
const char * STDCALL mysql_character_set_name(MYSQL *mysql) in mysqlh.h
But we've not found this function in libmysql.dll
subba reddy pidugu writes:
Hi !
We have small doub't regarding your software,
We are using WindowsNT operating system we are installed Mysql database after that.
we want how to create a databasae and create a user and how to set the password
specified user. please give answar as
Hello Sinisa,
Saturday, March 31, 2001, 3:45:27 PM, you wrote:
SM There is no such function in mysql.h.
Small piece from mysql.h is below:
**
char * STDCALL mysql_error(MYSQL *mysql);
char * STDCALL mysql_info(MYSQL *mysql);
unsigned long STDCALL
Dear MySQL Team
first of all, excuse my English. Im from Argentina,
Im a java developer and use MySQL database.
I connect to MySQL to Type4 Driver JDBC fron Java.
I have one machine with Mysql server in port 3306 and
another machine with an application in Java.
I want to know how to start a
Edward Smirnov writes:
Hello Sinisa,
Saturday, March 31, 2001, 3:45:27 PM, you wrote:
SM There is no such function in mysql.h.
Small piece from mysql.h is below:
**
char * STDCALL mysql_error(MYSQL *mysql);
char * STDCALL mysql_info(MYSQL
Hi Sander!
On Thu, Mar 29, 2001 at 02:11:02PM +0200, Sander Pilon wrote:
I'm getting a whole lot of mysql++ link problems on freebsd :/
Used gcc 2.95.3, latest mysql++
The program links fine under linux win32.
Any idea's?
[...]
What version of FreeBSD are you currently
Sander Pilon writes:
FreeBSD 4.2, stable.
But I rewrote mysql++ (at least, the functionality I was using) so that the
same build compiled on linux, win32, and freebsd, ditched all the stream
stuff (but kept the cool query operator), ditched all templates (still
can't figure
Hello all
I am looking for a way to return 3 days worth of data with an offset of five
days (in the past) from today.
For example, say we had the following dates and today is 2001-03-31. First
we do:
select name, datestamp from visitor_data order by datestamp desc;
and are returned with
Fernando,
Te sugiero que veas la pgina http://mmmysql.sourceforge.net/ por un JDBC y
en su docs vas a encontrar ejemplos de como resolver tu problema.
Si necesitas mayo ayuda, no tengo problema en enviarte porciones de cdigo
donde se resulve este problema.
Maximiliano.
- Original Message
Try this:
select * from visitor where
datestamp between
date_sub(now(), interval 5 day) and
date_sub(now(), interval 2 day)
order by datestamp desc;
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to
Hi!
"Scott" == Scott Ellsworth [EMAIL PROTECTED] writes:
Scott When compiling .36 under OS X release, the following error occurs:
Scott c++ -DMYSQL_SERVER
Scott -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
Scott
Hello Gary
Thank you for your timely response, however MySQL server version 3.21.33b
responded:
ERROR 1064: parse error near '(now(), interval 5 day) and
date_sub(now(), interval 2 day)
order by datestamp d' at line 2
:-((
when I entered exactly what you suggested. What am I doing wrong?
S.
Yes, the problem is the version that you are using. The date_add and
date_sub functions are new in mysql 3.22. How painful would it be for you
to upgrade to the current version?
Given the amount of development since version 3.21, it might be advisable to
go to 3.23.
Regards,
Gary "SuperID"
Hello all,
I'm stumped with the following issue and I don't know how to resolve it (I
think that sentence is just rhetoric)
I have the following SQL Statement and results:
mysql SELECT MAST.CODE
- ,MAST.ADVRT_NBR
-
Hello.
As I said in my last mail, you can tell MySQL how much memory to use.
On Fri, Mar 30, 2001 at 03:44:14PM +0100, [EMAIL PROTECTED] wrote:
At 18:52 29/03/01 +0200, you wrote:
Hello again!
Sorry but didn't see your other comments on first reading.
I thought that the key cache
Let me see if I understand you correctly. You created a new table
(CREATE TABLE?) and you imported data from a file that had nothing to
do with MySQL (comma or tab delimited file?), and therefore couldn't
be affected by whatever crashed your server. And this brand new table
with pristine data
I have spent the past 24 hours trying to install and configure MySql on my account at
my ISP. Every try failes.
I have three different instructions and none works.
Installing is no problem. What I can't do is change password to one I want or even run
the server without changing the dafault
Thank you Dan!
I do not have access to a FreeBSD computer during this weekend but
your stack prints already tell the origin of the problem.
I have implemented my own mutexes in the purpose that I can use
an assembler instruction for the atomic test-and-set operation
needed in a mutex. But for
Hi
Since the cvs is hosted on sourceforge, I think you should direct your
comments to them. We have no control over the sourceforge cvs server.
On Saturday 31 March 2001 16:40, Matthias Brunner wrote:
Hello!
As I tried to get the latest mysql version through CVS I encountered the
following
Hello Bob, first at all thank you for your support.
Bob Hall wrote:
Let me see if I understand you correctly. You created a new table
(CREATE TABLE?) and you imported data from a file that had nothing to
do with MySQL (comma or tab delimited file?), and therefore couldn't
be affected by
hi
i have installed mysql binary distribution and the perl modules DBI,mysql modules on
one machine and want to copy the data and the bin directory , to onother machine and
make it work in that machine ,without copying the lib directory , is it possible
if yes , how do i do it ..
thanks
Helllo All !!
I 've a problem i want to retrieve the primary key value of the last
Inserted record in a table and use it in another table.
My Table is
TRANS
( transID int not null auto_increment primary key,
.
...
..
)
Ordertable
(OrderID int not null auto_increment primary key,
transID int
I use MySQL for my personal web site, but as the Director of Information
Systems (I suppose I am one of those higher ups) I can't imagine using MySQL
for mission critical applications until it has transaction support (commit
and rollback).
Jim Gillaspy
- Original Message -
From: "Jason
but I thought 3.23 supports transactions.. doesn't it?? Even I am facing the
similar question from higher ups about MySQL and its support for
transactions and how stable is the version 3.23 with trasactions.
-Original Message-
From: Jim Gillaspy @ bellsouth.net [mailto:[EMAIL PROTECTED]]
Can anyone tell me where to get and how to install MySQL on the new Mac
OS X?
Thanks for your help!!
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi,
Here is the fulltext index I add:
CREATE TABLE Books (
isbn char(10) NOT NULL default '',
Title char(255) NOT NULL default '',
FULLTEXT KEY full_title (Title)
) TYPE=MyISAM;
select count(*) from Books -- 2028971
select count(*) from Books where Title like "% cisco %"
On Sat, 31 Mar 2001 11:46:54 -0800 (PST), Chai-Hup Chen [EMAIL PROTECTED] wrote:
Try this:
SELECT count(*) FROM Books WHERE MATCH Title AGAINST 'cisco'
We use a FULLTEXT index search in a couple of our table for business referral
searches, and it works like a charm!
Hope this helps
Hi,
Does anyone know where to get MySQL for the new Mac OSX and how to install
it?
Thanks for the help.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
This email was delivered to you by The Free Internet,
a Business Online Group company. http://www.thefreeinternet.net
---
Hi,
I realise this mailing list must get bombarded with questions about
indexes but can someone please spare a
Pie Charts
I have just downloaded and installed the most recent stable version on my
Redhat 6.1 server. I can't figure out how to access the MySQL server
application itself! (Yes I have actually started the daemon) I did download
a GUI client app but I can't get past the password and I
On Sat, 31 Mar 2001 12:39:59 -0800 (PST), Chai-Hup Chen [EMAIL PROTECTED] wrote:
I think if you take a look at the MySQL docs on FULLTEXT it'll explain it alot
better then I probably could.
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
Thanks a lot, the select is much faster
Make sure that /tmp is writable by the user running MySQL.
You say you are setting MySQL up on your account, do you have access to the
root account on this box? If not, are you sure that the box your on doesn't
already have MySQL running?
- Original Message -
From: "Tatti" [EMAIL
Oliver,
Well,I decided to try out some new stuff, and was going to compile PHP 4,
but got stuck at the following when running configure:
checking for flex... no
checking for lex... no
./configure: flex: command not found
checking for flex... lex
checking for yywrap in -ll... no
checking lex
OpenBSD 2.8
swap partition is 256mb
/tmp partition is 1gb
Pentium III 667mhz, 256mb ram
MySQL 3.22.32 (installed by: pkg_add mysql-3.22.32.tgz)
df reports that I have plenty of free disk space
I have a table that has 422,000 rows, and has a key field defined as:
integer unsigned not
The initial install has no password for root.
Fix this by running the command line client as follows:
Mysql -u root
That will allow you to connect.
Then give root a password!
The userids in mysql are completely separate from any security model that
your OS uses.
Therefore,passwords, are not
"Lindsay Adams" [EMAIL PROTECTED] wrote:
Well,I decided to try out some new stuff, and was going to compile PHP 4,
but got stuck at the following when running configure:
checking for flex... no
checking for lex... no
I've installed flex from source on Cobalt RaQs. It's a simple install.
Therefore if I am using Linux for my MySQL server both of my CPU's will help
to serv the MySQL queries if I am installing the SMP in my kernel right ?!
I am using RedHat 6.2 with Linux 2.2.14-5.0smp #1 SMP .
--
Regards
/
I should start reading this list more..
I've had a similar problem, and good luck finding many people who'll help
you with OBSD problems on this list (or any problems for that matter).
Anywho, it's ports specific I think. I installed MySQL from source
compiling with -O6 and the proper arch
How do I set the location of the var directory when I
install?
Joseph
Say I'm Hot! - Post Your Picture!
http://www.sayimhot.com
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
On Sun, Apr 01, 2001 at 02:55:02AM +0330, Hamid Hashemi Golpayegani wrote:
Therefore if I am using Linux for my MySQL server both of my CPU's
will help to serv the MySQL queries if I am installing the SMP in my
kernel right ?!
Correct.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo
On 3/31/01 1:51 PM, "[EMAIL PROTECTED]" [EMAIL PROTECTED]
wrote:
MailMarshal (an automated content monitoring gateway) has stopped
the following message:
Message: B00049bf4.0001.mml
From:[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Odd issue
Because it
Hi ,
I have installed the MySQL 3.23.5-alpha-log on a RedHat 6.2 Linux with 512
Megabyte of RAM and 2 PIII 550 CPU installed on this machine .
This is machine is very high load SQL server that do all of my accounting
and web report for my customers .
Works quite well . But I have a Radius server
I am getting this warning also and I have installed Norton Antivirus 2001
with the lastest update and sure that don't have any viruses .
--
Regards
/ Seyyed Hamid Reza/WINDOWS FOR NOW !!/
/ Hashemi
I have received several of the same messages, and I too believe that I'm
virus free (I just updated and ran NAV).
Since the message is signed with an ad for marshal software, which is sells
anti-virus services, I am viewing this as 100% spam.
Gary
- Original Message -
From: "Lindsay
On Sun, 1 Apr 2001 04:07:35 +0330, "Hamid Hashemi Golpayegani" [EMAIL PROTECTED]
wrote:
I think everyone is getting bombarded with this virus message. I gotten 3 of the
already!
I am getting this warning also and I have installed Norton Antivirus 2001
with the lastest update and sure that
On 3/31/01 3:34 PM, "MikemickaloBlezien" [EMAIL PROTECTED] wrote:
On Sun, 1 Apr 2001 04:07:35 +0330, "Hamid Hashemi Golpayegani"
[EMAIL PROTECTED]
wrote:
I think everyone is getting bombarded with this virus message. I gotten 3 of
the
already!
I am getting this warning also and I
"Joseph Bannon" [EMAIL PROTECTED] wrote:
How do I set the location of the var directory when I
install?
./configure --localstatedir=PATH_TO_DATA_DIR See ./configure --help for more
info.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
Hi,
I'm having some trouble getting MySQL to install properly on my
NetBSD/macppc 1.5 system from source package. Here's the MySQL version
information:
% /usr/pkg/libexec/mysqld -V
./mysqld Ver 3.22.32 for -netbsd on powerpc
And below is the error that occurred when
"MikeBlezien" wrote:
On Sun, 1 Apr 2001 04:07:35 +0330, "Hamid Hashemi Golpayegani" [EMAIL PROTECTED]
wrote:
I think everyone is getting bombarded with this virus message. I gotten 3 of the
already!
I am getting this warning also and I have installed Norton Antivirus 2001
with the
Hi.
Note, that when you do a GROUP BY, according to ANSI SQL you may
SELECT only the columns grouped by and any grouping functions (like
SUM), i.e. selecting PACK_INC would result in an error.
MySQL extends ANSI SQL in that it allows to select abitrary columns,
but chooses a random value from
Hi.
I got the warning too, and also run Linux. So this doesn't seems to be
connected to the operating system. And neither to a certain thread: I
got it on mails to abitrary threads.
Bye,
Benjamin.
On Sat, Mar 31, 2001 at 08:54:08PM -0700, [EMAIL PROTECTED] wrote:
[...]
I've never
On Sun, Apr 01, 2001 at 07:58:19AM +0200, Benjamin Pflugmann wrote:
I got the warning too, and also run Linux. So this doesn't seems to
be connected to the operating system. And neither to a certain
thread: I got it on mails to abitrary threads.
Same here.
--
Jeremy D. Zawodny, [EMAIL
Hello all !!
mysql show grants for root@localhost;
ERROR 1064: You have an error in your SQL syntax near 'grants for
root@localhost ' at line 1
Could anyone please tell me where i'm going wrong ..
Thank you
Sajan
-
Before
Hello all !!
Is there any method by whick we can use the Sys Admin commands
like
Mysqlacess ,
Mysqldump ,
mysqladmin
etc
in Java.
I mean thro ' " PreparedStatement/ Statment " classes
Thank you
Best Regards
Sajan
-
I have a SQL file that I generated on MS SQL 7. The file looks like this (a portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[AuthorID] [int] NOT NULL ,
[Date] [datetime] NOT NULL ,
[SubjectID] [int] NOT NULL ,
[Pages]
I have a SQL file that I generated on MS SQL 7. The file looks like this (a portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[AuthorID] [int] NOT NULL ,
[Date] [datetime] NOT NULL ,
[SubjectID] [int] NOT NULL ,
[Pages]
Hello.
You seem to use an older version of MySQL which did not support SHOW
GRANTS. Too see when a feature was introduced, have a look at the
Changes History section in the fine manual.
Bye,
Benjamin.
On Sun, Apr 01, 2001 at 12:27:13PM +0530, [EMAIL PROTECTED] wrote:
Hello all !!
Hi all,
I'm designing a table to hold classified ads...one of the columns i want
to have is date_entered...i was wondering if using a default value of
NOW() is ok...my guess is that its probably both stupid and not the most
sound way to do it (maybe not even possible), but i'd appreciate some
Hi.
On Sun, Apr 01, 2001 at 03:30:48AM -0400, [EMAIL PROTECTED] wrote:
I have a SQL file that I generated on MS SQL 7. The file looks like this (a
portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[...]
I am using
66 matches
Mail list logo