At 11:39 PM 2/10/2001 -0800, Stephen Waits wrote:
Never mind on the "it doesn't work on my system" more like it didn't
work on my brain :) Works fine.
Oh, phew.
Theoretically it could be as fast as Carsten's method couldn't it? If
it hit a record on the first shot? Otherwise it's pounding
No, you can scroll through your input lines using Up and Down Arrow, then
you can edit the particular line using Left and Right Arrow and Backspace.
At least this is a way things are supposed to work on a terminal.
Maciek
-Original Message-
From: RAJARSHI ADHIKARY [mailto:[EMAIL
i installed MySQL from the Tenon site into OS X pb with the installer.app.
then i did the following:
[doria:~] root# cd /usr/local/mysql
[doria:/usr/local/mysql] root# scripts/mysql_install_db
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your
On Sat, 10 Feb 2001, Mailing List Address wrote:
Yes I tried that too... Same stupid stuff happening
Then have you tried creating the mysql db and
tables?
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
On Sat, 10 Feb 2001, Larry Marshall wrote:
On issuing the command:
rpm -i MySQL-32.23.32.-1.i386.rpm
the following error listed:
I understand that mysql rpm that comes with RH7 is buggy.
I dowloaded the tarball and compiled it. Runs like a dream.
--
/"\
\ /ASCII RIBBON CAMPAIGN
Hi All,
I have a JOIN statement:
SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON
d.domain_id=b.domain_id
WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C'
GROUP BY domain_name
In addition to the fields this statement returns, I would also like it
Mark,
I like CASE but I wish they would add MySQL Reverse Engineering capabilities
to it. The interface is clean and similar to what one expects from it's more
mature brothers. (ERWin, ER/Studio)
A couple of people emailed me and told me to look at
http://www.heraut.demon.nl but I'm not
Erick:
Do not try to copy the database files themselves. Instead use mysqldump to
dump the structure and contents to text files, which you can easily copy
across the network from your Windoze to Linux.
My advice is to create an empty database on the Linux machine, and set your
permissions using
For security reasons, I don't want to run mysql as root of the OS. However, the
only way I can run mysql is if I log into the server as root. So I guess I have
to create another superuser with:
GRANT ALL ON *.* TO lgaal@localhost IDENTIFIED BY 'whocares' WITH GRANT OPTIONS;
Is this correct?
Thanks for the input.
I like this tool better than the other 2. Other than the fact that it's
reverse engineering can be easily broken and cannot infer relationships in
the logical model it's a very nice tool.
Same rant on size limited demos. At least with this one I can build larger
models, I
hi,
i'm a stu so don't all the time in the world... who does!
last night i took a MySQL database (a folder i got out of the
MySQL/data folder) home and copied into the data folder on my
machine, is this ok?
unfortunately i cannot simply 'see if it runs' because i am having
those terrible
1: No.
2: It depends on a lot of things. If your site traffic is heavy and you can
split your data into discrete elements, you could possibly get better
performance by splitting your data into separate databases and running them
on different servers.
Cal
http://www.calevans.com
-Original
Here you go:
select DATE_FORMAT( DateTime, '%M %D %Y' ) as formatted_date,
Platform,
Public,
other_fields
from Features
where Platform='pc'
and Public='Y'
order by DateTime asc
limit0,3
;
Now, you should rename the DateTime field as Bob sudgested,
and
I agree that a time-limited, but otherwise fully functional demo is better, especially
in the case (pardon the pun) of database modelling. It would certainly be worth
sending them a message telling them so. You never know - they might agree with you.
Mark Chalkley
Hi
At 09:36 11/02/2001 -0600, Cal Evans wrote:
Mark,
I like CASE but I wish they would add MySQL Reverse Engineering capabilities
to it. The interface is clean and similar to what one expects from it's more
mature brothers. (ERWin, ER/Studio)
A couple of people emailed me and told me to look at
mysql is easy if you're familiar with SQL92 standards,
if you are a Oracle-guru you will see that mysql doesn't
support half as many things... One things I really miss
is subqueries.
Most of the time I get all my answers from the DOC:
http://www.mysql.com/doc/
search for keywords and you'll
Hi,
I am, currently a student a final year student studying IT For Business
at Aston University In Birmingham.
As part of my final year project I need to produce an online
questionnaire with database functionailty.
I have produced an HTML form, but now I need to be able to write the
answers to
At 7:10 PM + 2/11/01, php php wrote:
Hi!
I've just joined ur mailing list!
i've never used mysql!
i'm wondering if there is only one way to insert data to a table?
i use the command line, no interface!
Yes, you write SQL statements. But even if you write MySQL programs in
a programming
last night i took a MySQL database (a folder i got out of the
MySQL/data folder) home and copied into the data folder on my
machine, is this ok?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_3_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
Erick:
Do not try to copy the database files themselves. Instead use mysqldump to
dump the structure and contents to text files, which you can easily copy
across the network from your Windoze to Linux.
My advice is to create an empty database on the Linux machine,
and set your
Fortunes are being made online everyday! Now is your chance to become involved with
one of the most explosive Internet industries...Internet Gaming!
But wait there is much more...LIVE Webcast Lotto and Bingo, International Sports
Betting, and Virtual Stock Trading.
We are PLAYING GAMES, HAVING
I have created 2 columns:
col1 varchar(20)
col2 varchar(20)
when I add content to the columns it looks like
this for example:
col1
contentA
NULL
contentB
Now when I try to print out the content in Perl
using this code:
while($dirty_words = $sth-fetchrow_array) {
print "$dirty_wordsbr\n";
}
- Original Message -
From: "S MODI" [EMAIL PROTECTED]
Hi,
I am, currently a student a final year student studying IT For Business
at Aston University In Birmingham.
As part of my final year project I need to produce an online
questionnaire with database functionailty.
I have
Multiprotocol Integrated Database Authorization System
The centerpiece of this release of Midas is a multi-threaded NIS
server that uses a MySQL database as its data store. This design
eliminates some of the limitations of Sun's ypserv, specifically those
associated with the dbm file
Hi,
I can only repeat that I have databases that were working before. I can try
them on other systems if you want but I'm pretty sure they're alright.
Something must've gotten messed up in the system since even after switching
back to 3.22 the same stuff happened.
I'm quite confused where this
hi,
some links more at
http://it97.dyn.dhs.org/
click on scripting
Good luck
i.t
Anna schrieb:
- Original Message -
From: "S MODI" [EMAIL PROTECTED]
Hi,
I am, currently a student a final year student studying IT For Business
at Aston University In Birmingham.
As part of
As a suggestion, try phpMyAdmin if you want to insert
records manually. Also, it will provide you with
examples (viewing the source code, that is) on how the
inserts, updates, etc. work. phpMyAdmin can be
downloaded from
http://www.phpwizard.net/projects/phpMyAdmin/
Good Luck!
William Decker
Proof:
Copied it all to another (Win32) Mysql:
It works perfectly.
The Linux system must've taken a beating somewhere.
Thanks for helping
C:\mysql\binmysqlshow
+---+
| Databases |
+---+
| aal |
| copas |
| fedil |
| icq |
|
This is a question for PERL group but anyhow, read again the chapter in MySQL
on printing results from MySQL using PERL. It prints continentA because
that's what you have asked for.
On Sunday 11 February 2001 15:36, Andreas Antes wrote:
=I have created 2 columns:
=col1 varchar(20)
=col2
More news:
I took back an "old" 3.22.32 release from the backups that I knew worked. I
restored it and it did.
There must be some libraries or some stuff that the newly compiled stuff
gets linked with or something else that is causing the trouble.
The problems seem to be resolved (for now) but
try here:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
hth
At 1:38 PM -0600 2/11/01, Anna wrote:
- Original Message -
From: "S MODI" [EMAIL PROTECTED]
Hi,
I am, currently a student a final year student studying IT For Business
at Aston University
Has anyone tried running the TPC-W benchmarks on MySQL? I'm not talking about making
the results official (I assume too much $$$) but just to implement them and see how it
goes.
cheers,
thalis
-
Before posting, please check:
I've got a real weird problem happening after building 4.0.4pl1 and mysql
3.23.32 on my test machine. I previously had 4.0.1 up and running with an
earlier version of mysql - I think it was 3.22.xx - and this combination
worked fine.
I *seem* to successfully connect to my mysql database...
I'm using the following table to store information about a merchant user.
He uses his email address as his username to login. Since I'm going to
be doing WHERE clauses on that field, I'd like it to be indexed for speed.
If I have a UNIQUE property on the email field when I create the table, do I
I thought it is probably an easy question to answer, so sorry if it is repetitive, but
I am new:
I am reading the book "MySQL" by Paul DuBois, and in it, it is mentioned that when
creating a table, you can do it through a client such as telnet (which is what I'm
doing...ttSSH), and you can
The .txt or .sql file you are using must be on the remote server -- either
through FTP or created on that server and then you can issue the command
remotely to populate the database.
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
-- your next best friend
...and this will load the table into your database. Now, in the book
it doesn't specify whether or not you have to be on the computer with
the server, or if you can send the .sql file command from your
computer to the remote server, sort of like a file transfer protocol
as well. Basically,
All-
I'm doing an installation of MySQL where, at least temporarily, a bunch of
clients are running against a server that's on another network behind a
firewall. (The security solution is appropriate.) I'm going to have to
maintain a list of client IPs and have the firewall maintainer allow
I've had questions about this too. What happens if I have a primary key, and
the text file has the columns that are in the existing table, with records.
And I want to insert them. How do I get rid of that duplicate error? I read
the manual, about 'ignore' but I can't get it to work.
Any ideas?
hello,
I am working on project where my database is mysql. I need whole list
of error codes eg code when there is primary key violation, or other
such database related problems.I have tried perror but that all are
system related problems.I want code for database related problems.
vaibhavi
A newbie question...
Does Mysql support SELECT.. INTERSECT? if not, are there any other
options I can use to implement the same function?
Thanks.
Jowena
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
ok, fyi, the below worked fine.
now...
as readers here may know, this db newbie had problems getting MySQL
up and running -much like the other person with pwd problems. i
erased the drive (OS X pb/Tenon iTools), reinstalled and all is well,
it even starts
I got connected finally... actually I've connect several times but each time
something else happens that changes things.
I typo'd the myslq.sock line in the /etc/my.cnf file
but... I need to make sure my DBI is installed correctly.
I followed the instructions based on the manual... but do not
Ok, I am trying to execute the CREATE TABLE command through telnet and the "test.sql"
file is residing in the directory /home2/fullboreidiot/test.sql and I put in the
command how I'm assuming it would be executed:
mysql mysql fullboreidiot /home2/fullboreidiot/test.sql;
and I get the
I am new to MySQL and have just installed the MySQL rpm files to my Linux
box.
I have run "mysql_install_db" with no problems and I have then run
"safe_mysqld " this comes up with the messsage
"starting mysql daemon with databses from /var/lib/mysql
mysqld daemon ended"
I assumed that
45 matches
Mail list logo