Hey there!..Don!
The Problemo returns! :(
Let me be explicit this time with my query :
#1
mysql > desc table A;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| mId | int(
Hello mysql,
I meet in share ver. of MySQL different lang. driver but no where
UKRAINIAN.
AND now I ask - I wont translete "errmsg.txt" and "errmsg.sys" for
UKRAINIAN lang?
Waiting for ansver!
--
Best regards,
suh mailto:[EMAIL PROTECTED]
--
Jason,
Hope this will help you get what you want. Of course you need at least one
more loop (calculating the number of 'display' actions from
"sth->numrows()") to repeat the display process for rows 5-10, 11-15, etc.
#!/usr/bin/perl
use DBD::mysql;
#connect to database
$
You should refer to manual, your case depends on the type of your table.
MyISAM tables do assign new number always, and there's some another kind of
table which is reusing numbers the same way you need. I don't remember what
type exactly, so refer to the manual.
-Original Message-
From:
i know it is large. the user must do his own calculations to determine if
he can substitute eliminate for postpone.
this is his call; not mine nor yours.
At 09:57 AM 7/8/01 +0307, you wrote:
>tj marlin wrote:
>
>
>>you can postpone this problem for a very long time by using an unsigned
>>bigint
Greetings !
Suppose I have a table in MySQL Database:
idName
-
1 ABC
2 BBB
3 CAB
like this id being auto_increment. If I delete all the three records and
start with new then it starts from
I realize that i'm regressing by trying to achieve a flatfile style of
database as opposed to a DBMS, but for my purpose it would be sufficient. In
my quest for a solution, I realize that to run a full DBMS would actually
waste resources due to lack of use, but I'd still like to utilize SQL an
My guess is that you have logging on for php but it has problems saving to
it's current location but I'm not psychic so I don't know. (ie. provide the
list with some code)
- Original Message -
From: "Stink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 7:05
Subje
Of course there is no unix versions of Access. Microsoft wouldn't create
anything to assist their competitor. If you are setting up a Linux machine,
what's wrong with setting it up to run a DB server? MySQL would be quite
suitable as it is quite easy to use, allows you to connect from Windows
m
On Sun, 8 Jul 2001 19:10, Kevin Smith wrote:
> Hi All,
>
> Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39
> running on Apache 1.3.20 on Windows 2000 Professional SP!?
>
>
> Warning: Supplied argument is not a valid MySQL result resource
> in d:\program files\apache
> gro
On 08-Jul-01 Michael Collins wrote:
> At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
>>Use the utility "perror" to get meaning of OS low level errors.
>
> I have taken a look at the perror utility for viewing the text for
> MySQL error codes and decided I wanted to see all the MySQL error
> mess
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
>Use the utility "perror" to get meaning of OS low level errors.
I have taken a look at the perror utility for viewing the text for
MySQL error codes and decided I wanted to see all the MySQL error
messages so I created a simple PERL script:
#!/usr/
- Original Message -
From: Tonu Samuel <[EMAIL PROTECTED]>
To: citizen <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, July 07, 2001 11:57 PM
Subject: Re: Where is the "MySQL-DBI-perl-bin" RPM?
> citizen wrote:
>
> >
> > $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm
> > e
I've been dealing with this problem for a few days now and I got no idea
what's going on:
the base is working properly but for one thing - when changing anything in
base, i.e. saving new record or creating new tables or dropping tables -
anything that involves change in the base - MySQL says:
"u
You want to search for the LIMIT keyword at http://mysql.com
> Is there a way of doing a select and out of the results saying only give me
> 5-10 or 10-15?
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, T
I needed to add a couple of things to the original posting. What i'm trying to
do is have a browser interface for manipulating and viewing the data. The
database would be manipulated with cgi on a linux web server. I thought about
access, but i don't believe there are api's for creating and man
I needed to add a couple of things to the original posting. What i'm trying to
do is have a browser interface for manipulating and viewing the data. The
database would be manipulated with cgi on a linux machine. I thought about
access, but i don't believe there are api's for creating and manipu
I am trying to get on of my apps to display only 5 records at a time. With
Perl attaching to a mysql database. Does anyone have any good Ideas of how
to do this.
Is there a way of doing a select and out of the results saying only give me
5-10 or 10-15?
Any help would
At 11:15 AM -0700 7/8/01, tj marlin wrote:
>MySQL, Paul DuBois, New Riders publishing, 2000, $40
better price here:
http://www.bookpool.com/.x/SSCOLL/sm/0735709211
I have no association with this book dealer
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mai
At 11:47 AM -0700 7/8/01, { randy } wrote:
>When I was running OS X, I just used the installer that I found on
>versiontracker.com .
I also had no problem using the pre-built installer at:
http://www.entropy.ch/software/macosx/
Here are some others:
http://www-u.life.uiuc.edu/~mwvaugh/MacOSX/
- Original Message -
From: Tonu Samuel <[EMAIL PROTECTED]>
To: citizen <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, July 07, 2001 11:57 PM
Subject: Re: Where is the "MySQL-DBI-perl-bin" RPM?
> citizen wrote:
>
> >
> > $ rpm --test -i MySQL-bench-3.23.39-1.i386.rpm
> >
Hello,
I'm architecting a web-based system that needs to be able to handle 5
million records and roughly up to 3,000 inserts an hour. Although I'm
willing to sacrifice referencial integrity for speed, I must have
transaction support (commit/rollback) and row-level locking. Is anyone out
there
Hit the nail on the head... infact, the problem wasn't the query itself, it
was the way in which I imported the tables and data from a Unix platform to
my Windows platform that caused the problems... sorry.
Many thanks for you help, as it made me look at running the query as you
suggested which c
At 10:38 AM 7/8/01 -0800, Chris Lott wrote:
>What kind of methods have any of you used for storing text that needs to be
>displayed as both multi-page (for reading) and single-page (for printing)?
>My plan is to store the articles with basic HTML formatting that will render
>based on the site styl
When I was running OS X, I just used the installer that I found on
versiontracker.com . If you do a search for MySQL, it should bring up a
precompiled version of MySQL. It should be the most rescent, the guy who
provides it usually keeps it up to date. He even has instructions on his
site about se
At 10:36 AM 7/8/01 -0700, you wrote:
>Hello,
>
>I am creating a database that will be used by about 5 people very
>infrequently. I have looked into things like xbase, which would be
>acceptable, but are there any relational db's with a c/c++ api that would
>access the files directly without a ser
What kind of methods have any of you used for storing text that needs to be
displayed as both multi-page (for reading) and single-page (for printing)?
My plan is to store the articles with basic HTML formatting that will render
based on the site stylesheet(s).
I'm using MySQL.
My main question i
database install problem:
I'm having difficulty getting 3.23.3x to install on MacOS X 10.0.4.
I didn't have any problems on 10.0.0 or 10.0.2. And I've tried to
compile 3.23.37, 38, and 39. I also went through a variety of flag
combinations and tried running the make process as root, as was
sugges
MySQL, Paul DuBois, New Riders publishing, 2000, $40
At 10:25 PM 7/7/01 -0800, you wrote:
>The Mysql/Msql book I have from O'Reilly is definitely showing its age. I
>know there are books in the MySQL FAQ, butI am looking for recommendations.
>Any books that stand out as better than others?
>
>I'm
At 11:46 AM +0200 7/8/01, Werner Stuerenburg wrote:
>See http://www.mysql.com/doc/S/t/String_syntax.html
>
>> I thought that the way the data was stored you could not use certain
> > characters.
Now you have come full circle. This is where I had started and what
generated my question. I though
Hello,
I am creating a database that will be used by about 5 people very
infrequently. I have looked into things like xbase, which would be
acceptable, but are there any relational db's with a c/c++ api that would
access the files directly without a server? Is this possible? If so, could
S
At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
>Use the utility "perror" to get meaning of OS low level errors. This
>is an "Access denied" and means that in some reason you are not
>allowed to write into this "/" directory. I think, this is normal :)
I had checked the directory to make sure I ha
At 8:36 AM -0500 7/8/01, MikeBlezien wrote:
>Hi All,
>
>When assigning new Users to various databases, and access settings,
>in order to
>have it take effect immediately, all that is needed is to do a FLUSH
>PRIVILEGES
>or does the MySQL server need to be restarted??
>
If you use the GRANT sta
_
Win98 4.10.98, AMD Duron, 128 MB RAM
MySQL 3.23.39 running on localhost
_
Query is
DELETE FROM staticStrings
WHERE ruri LIKE 'staticAnzeigen%'
___
Hi,
SELECT COUNT(*) FROM TABLE;
will give you the number of rows in the entire table.
Don't worry about performance, this query is optimized
by mysql.
Check:
http://www.mysql.com/doc/W/h/Where_optimizations.html
for details
Regards
--
Joseph Bueno
NetClub/Trader.com
Nelson Goforth wrote:
>
>
On 08-Jul-01 Nelson Goforth wrote:
> I thought "mysql_numrows(result_identifier)" - which I'm using to get
> the number of rows in the found set - was ONLY to get the number of
> rows in the result set. What I'm after is how to get the number of
> rows in an entire table without doing a searc
That's probably because you didn't set up access for root from
www.mydomain.com
If you have logged into the server through telnet, you shouldn't need the -h
option. If you do, it should then be "localhost" and not yourdomainname.
- Original Message -
From: "Anoop K Gupta" <[EMAIL PROTEC
I would say it is because you need and "or" in
ct.Fk_Targets_Id='1' and ct.Fk_Targets_Id='3'
and not an "and". How can a column equal 2 different values at the same
time?
- Original Message -
From: "Simon" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001
Well, it's difficult to tell but I would say it would be your SQL statement
but since you didn't provide us with that...
- Original Message -
From: "Kevin Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 08, 2001 17:40
Subject: PHP and Mysql
> Hi All,
>
> Has anyon
I thought "mysql_numrows(result_identifier)" - which I'm using to get
the number of rows in the found set - was ONLY to get the number of
rows in the result set. What I'm after is how to get the number of
rows in an entire table without doing a search to find everything in
the table (concerne
On 08-Jul-01 Nelson Goforth wrote:
> I'd like to include a line in certain output lists like this:
>
> "Showing 97 contacts out of 324"
>
> Other than doing a SELECT...FROM CONTACTS and getting the count from
> that result and THEN doing a SELECTWHERE for the results I
> actually want
No. To rename a database, rename the directory in mysql's data dir. There is
no SQL command to rename a database.
> [mysql]
>
> is this how to change the the name of an existing populated db?
>
>
> RENAME DATABASE old_name TO new_name;
>
> TR
I'd like to include a line in certain output lists like this:
"Showing 97 contacts out of 324"
Other than doing a SELECT...FROM CONTACTS and getting the count from
that result and THEN doing a SELECTWHERE for the results I
actually want to see, is there some more efficient way of getti
On 08-Jul-01 Jonah Klimack wrote:
>
> What I don't want, is the same category name and
> customerID twice, even if it does have an index column
> that differentiates it from other rows.
>
>
> I've tried this:
> ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
> customerID INT UNSIGNED,
> categor
[mysql]
is this how to change the the name of an existing populated db?
RENAME DATABASE old_name TO new_name;
TR
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi All,
When assigning new Users to various databases, and access settings, in order to
have it take effect immediately, all that is needed is to do a FLUSH PRIVILEGES
or does the MySQL server need to be restarted??
THX,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain
> Use an index
If you mean use a primary key to create a unique record
regardless of the other data in the row, I've already done
that. However I'm using that primary key as a means of
creating a relationship with another table.
What I don't want, is the same category name and
customerID twice,
Hi!
Sun is shining and the weather is excellent in Helsinki :).
I will be on vacation July 9th to July 16th. I will read email
a couple of times.
Regards,
Heikki Tuuri
Innobase Oy
(Bait for mail filter: database sql)
-
Befo
If someone has been using the database browser tool, "DB Tools", I've got a few
questions, if you could possibly contact me off the list, I'd appreciate it. :)
THX
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that wor
what is the [MySQL] command to change an existing db name?
(is there a book or manual with straightforward question and answer like this?)
TIA
TR
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
See http://www.mysql.com/doc/S/t/String_syntax.html
> I thought that the way the data was stored you could not use certain
> characters.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049)
This is how I did it on http://kuehnle.de
I don't rely on browser information, though. I let users make
their choice.
I didn't try to find a single solution for all purposes. Instead,
I have a general translation table 'strings' for words or sentences
that normally would appear in my code and th
Hi All,
Has anyone ever had this problem when using PHP 4.06 and MySQL 3.23.39
running on Apache 1.3.20 on Windows 2000 Professional SP!?
Warning: Supplied argument is not a valid MySQL result resource in
d:\program files\apache
group\apache\www.lemonlaineydesign.com\www\top_frame.php on line
On Sun, Jul 08, 2001 at 10:29:04AM +0307, Tonu Samuel wrote:
> Jeremy Zawodny wrote:
>
>
> >> Perhaps, but it's not listed here:
> >>
> >>http://www.mysql.com/doc/manual.php?search_query=handler&depth=0
> >
> >
> > I *think* that only searches the 3.23.xx docs. I just found the same
> > t
54 matches
Mail list logo
