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
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
adv
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 !!
> m
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 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
-
Bef
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 pos
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
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
Hi.
You didn't mention your MySQL version. I assume some 3.22.x?
This 30% reatio is based on empirical data, and on your system, it
seems to be not ideal.
On Sat, Mar 31, 2001 at 09:50:57PM -, [EMAIL PROTECTED] wrote:
[...]
> mysql> show index from accounting;
> +++-
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 th
"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
>
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 installi
"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/
---
On 3/31/01 3:34 PM, "MikeBlezien" <[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
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
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 Ada
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 G
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
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
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
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
---
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 (like
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
/ Seyyed
"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 instal
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 t
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 null
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 outpu
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 PROTE
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
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 couldn't
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 m
Hi,
Thanks a lot, the select is much faster now. But I find something
weird, it return nothing when match against the string "the", which
return 255568 entries when select "% the %", is it possible mysql
does not indexed some words for some reason?
select count(*) from Books where match Title
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 lis
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,
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 %"
+-
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)
http://lists.mysql.com
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]
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 Mad
On Sat, Mar 31, 2001 at 10:11:33PM +0530, P.V. Sajan wrote:
> 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.
>
> I did
> select Last_Insert_Id () from trans ;
What you were doing is like:
select 1
On Sat, Mar 31, 2001 at 05:26:18PM +0200, Benjamin Pflugmann wrote:
> Hi.
>
> Whether MySQL can benefit from several CPUs or not depends on whether
> the OS you are going to use, can split threads to these CPUs.
>
> I know Linux can (quite good, indeed). AFAIK, FreeBSD had a user space
> threads
1. please don't crosspost
2. please provide us with sample code and env. info so that we can help you
out.
Filip
~
Namaste - I bow to the divine in you
~
Filip Hanik
Software Architect
[EMAIL PROTECTED]
www.filip.net
> -Original Message-
> From: Carlos Godoy [mailto:[EMAIL PROTECTED]]
>
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
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
ve
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
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
> followi
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 no
Hello!
As I tried to get the latest mysql version through CVS I encountered the
following error:
mb@:~ > cvs
-d:pserver:[EMAIL PROTECTED]:/cvsroot/mysql login
(Logging in to [EMAIL PROTECTED])
CVS password:
mb@:~ > cvs -z3
-d:pserver:[EMAIL PROTECTED]:/cvsroot/mysql co
mysql-4.0
cvs serv
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 pa
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
WHERE datestamp BETWEEN Date_sub(CURRENT_DATE, INTERVAL 5 DAY)
AND Date_sub(CURRENT_DATE, INTERVAL 7 DAY)
>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
Hi.
Whether MySQL can benefit from several CPUs or not depends on whether
the OS you are going to use, can split threads to these CPUs.
I know Linux can (quite good, indeed). AFAIK, FreeBSD had a user space
threads implementation and therefore could not use multiple CPUs. I
cannot say, whether t
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 cac
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
->
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" Hu
No, it does not.
Cal
http://www.calevans.com
-Original Message-
From: Aarón Reyes [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 10:40 PM
To: [EMAIL PROTECTED]
Subject: question...
I am interesting in develop tools, for plataforms,like
PHP, Linux, Apache, etc...
but I have a
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.
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> -DDATADIR="\"/usr/local/mysql
Hi ,
Sorry for this question may be this question asked before but I can't find
it .
I want to know that an SMP Dual CPU machine for a MySQL server is better
that a single CPU machine ?!
I mean is the MySQl use the both CPU's for processing or not ?
and how much affect on the responding and which
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 develo
Fernando,
Te sugiero que veas la página 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 código
donde se resulve este problema.
Maximiliano.
- Original Message -
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 this
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
>
> 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
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
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 cli
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 mysql_thread_id
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 ans
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 (
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.
> Not
[EMAIL PROTECTED] writes:
> I'd like to write a simple application with API of MySql.
> I see "4.4.1 A Simple Exaple" of the manual but I can't find the file
> "simple1.cc" that should be in my computer... but there isn't.
> How can install it?
> thank you in advance, Mario.
simple1.cc is
[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
Hi!
> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
Tim> On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>>
mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
Peter> ERROR 1192: Can't execute the given command because you have active locked
Peter> table
We (http://www.countrybookshop.co.uk) have been using Mysql For the last 2
years and we have had no problems.
- Original Message -
From: "Jed Verity" <[EMAIL PROTECTED]>
To: "Anthony R. J. Ball" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 8:53 PM
Subject: Re: Need
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 soon as possible,
bye
Thank You
N.S.Re
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
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 ge
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,
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 in a table as combined primary key.
e-mail= [EMAIL PROTECTED]
80 matches
Mail list logo
