Thanks to Kevin, who yesterday emailed me with a solution to my JOIN
problem.
Thanks to all who helped me see the wood for the trees.
George
- Original Message -
From: "Doug Thompson" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
S
At 07:57 AM 3/19/02 +0100, you wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire
Hi,
On Tue, 2002-03-19 at 16:24, Chuck "PUP" Payne wrote:
> Ok, but that still doesn't any why MySQL is filling the delete slot, I
> understand that I can do any SQL statement to put into the order I want. I
> guess what I am trying to wonder how it place a record into the table, does
> MySQL see
hi,
We can take backup for the subject above by two ways, One way is by
mysqldump ( Which I am using ..)
Now, I the second method
1. Shut down your MySQL database and make sure it shuts
down without errors.
2. Copy all your data files into a safe place.
On Tue, Mar 19, 2002 at 01:24:06AM -0500, Chuck PUP Payne wrote:
> Ok, but that still doesn't any why MySQL is filling the delete slot,
> I understand that I can do any SQL statement to put into the order I
> want. I guess what I am trying to wonder how it place a record into
> the table, does My
--- alan4100 <[EMAIL PROTECTED]> wrote:
> The problem begins when I type in use mysql;
> Please look at the very left edge with three
> asterisks..*** where I marked. ACCESS denied
> Hope it will be fixed with your help so I can mind
> my own chores.
>
> =
ugh..I guess that would be a question for the developers:) I don't know the
answer to that question..
Gurhan
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:24 AM
To: Gurhan Ozen; [EMAIL PROTECTED]
Subject: Re: ID order...
Ok, but
On Tue, Mar 19, 2002 at 12:45:57AM -, Alex Speed wrote:
> Ok, no support for it (d'oh), so, how do I go about breaking it down into a
> join or something like that?
>
> - Original Message -
> From: "Alex Speed" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 19, 2
>Description:
A timestamp value selected back is 38 seconds later than what
was inserted.
>How-To-Repeat:
ln -s /usr/share/zoneinfo/right/US/Pacific /etc/localtime
mysql test
mysql> create table teststamps (stamp timestamp);
mysql> insert teststamps
jim and lois flaherty wrote:
> gcc analysis.c
>
> analysis.c:6:19: warning: extra tokens at end of #include directive
> analysis.c:7:19: warning: extra tokens at end of #include directive
> /tmp/ccsKk2GG.o: In function `main':
> /tmp/ccsKk2GG.o(.text+0x14): undefined reference to `mysql_init'
>
Ok, but that still doesn't any why MySQL is filling the delete slot, I
understand that I can do any SQL statement to put into the order I want. I
guess what I am trying to wonder how it place a record into the table, does
MySQL see that the slot is empty and then fills it with a new record?
Chuck
Hi,
Just add "order by ID" in your query it will give you the results in the way
you'd like...
Gurhan
-Original Message-
From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:17 AM
To: Gurhan Ozen; mysql lists.mysql.com
Subject: Re: ID order...
Ok, here i
Ok, here is a copy of my database and you will see what I am talking
about...
| 55 | j| programming | http://webdeveloper.earthweb.com/pagedev/webjs
| Javascripts.com|
| 56 | h| webdesign | http://www.htmlgoodies.com
| HTML Goodies |
| 57 | l
Maybe. Just I have delete let say ID 63, 64 and when I added 74,75. They are
place into the slot where 63, 64 were. So I read this in the ID list 61,62,
74, 75, 66, 67... I am trying to understand why it's placing 74 and 75 in
the slots that were deleted. Is there a re-index command that will plac
Uma Shankari T queried:
> I am having all mysql database contents in one txt file.how i will dump
> all those contents to mysql database tablespls tell me how to do it
Have you looked at the manual, section 4.8.7?
mysqlimport
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
jake williamson 28 queried:
> hello!
>
> i've been developing a MySQL database in mac osX - i would like to
transfer
> it to work onto a win2k box running apache and mysql.
Have you looked at mysqldump and mysqlhotcopy, in section 4.8 of the manual?
> what files from X do i need to copy over? i
Chris Boget queried:
> I've looked through the documentation and if this question
> is answered there, please point me to the relevant section
> because I've obviously missed it.
Section 4.6?
> What foreign languages does MySQL support definitively.
> As in can do all kinds of searches in, etc?
Yes it is a strange question.. MySQL result sets are in the order you asked
in the query. IF you would like the result set to be in order by a field
called ID then just add "order by ID" at the end of your query..
Is this what you were asking? If not , can you give more insights of what
the query
Hi all,
I'm a new MySQL user.
Does MySQL database support Unicode (UTF-8)?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
Hi!,
INSERT INTO ... SELECT statement works in MySQL. The web site is :
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
I have no idea what you meant by "it doesn't work for the same tables"..
But as the answer to your question, you could do something like:
SELECT @a:=MAX(fieldname) FROM TABLE;
It looks like you need a root kit. No. A root canal. No, wait! That's not
right, either. ;)
alan4100 queried:
[snipped]
> C:\mysql\bin>mysql
[snipped]
> ***mysql> use mysql;
> ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
I know the manual takes a lot of reading, but i
Ok, strange question. I have delete some records and I have notice that ID's
are no longer in order when I do a SQL statement. Why is that? What can I do
put the records back into order?
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.c
I have a Redhat 7.1 box, I want it to connect to its own mysql db . Here is
my code
#include ;
#include ;
int main(char **args){
MYSQL_RES *result;
MYSQL_ROW row;
MYSQL *connection, mysql;
int state;
/* connect to the mysql db */
mysql_init(&mysql);
connection =
mysq
Some airhead wrote:
> Ehhhtto. You're using windows, right? Have you checked in your php.ini
file?
I think that airhead must have meant the my.ini file. Or the my.cnf file.
:^,
PS: The MySQL Reference Manual, section 2.1.2.2 for MSWindows and section
4.1.2 in general.
Airhead
Alps Giken Kansa
Hi all,
How can we set multiple connections for multiple users in mySQL. I'm
accessing MYSQL using MYSQL++ library. This code is in the middle tier,
which can be accessed by any number of users. Its working fine for 3
clients, when connecting for the next it is giviing problems. Please help me
o
hi
I have got g++ running on my machine but I would like to know if anyone
has run the mysql c++/c libraries with g++? and if so could you let me
know the steps.
thank you
david Phoon
-
Before posting, please check:
http
Hi all,
How can we set multiple connections for multiple users in mySQL. I'm
accessing MYSQL using MYSQL++ library. This code is in the middle tier,
which can be accessed by any number of users. Its working fine for 3
clients, when connecting for the next it is giviing problems. Please help me
o
All,
I am having difficulty converting the results of a query to a character.
Here is A snippit of code.
...
//Connect to server
Connection con("Table", "localhost", "USER", "");
// Create query object
Query query = con.query();
query << input; // This is working as I can print
use an auto_increment column.
Or if this is during an "UPDATE"
UPDATE tbl SET col = col + 1 WHERE ..;
Allon Bendavid wrote:
>
> Hello All-
>
> I just read that an Insert ... Select naming the same table is not supported
> in MySQL.
>
> What is the alternative? What we need to do is simply
Hello list,
This is the output of mysql myisamchk -s */*.MYI, which seems very badly
corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is
any idea to know what made the corruptions?
myisamchk: ISAM file stocks/TimelyDeals.MYI
myisamchk: error: Size of datafile is: 5645430
Hello list,
This is the output of mysql myisamchk -s */*.MYI, which seems very badly
corrupted. I know myisamchk -o or myisamchk -c will rescue this, but is
any idea to know what made the corruptions?
myisamchk: ISAM file stocks/TimelyDeals.MYI
myisamchk: error: Size of datafile is: 5645430
Hello All-
I just read that an Insert ... Select naming the same table is not supported
in MySQL.
What is the alternative? What we need to do is simply insert the max of a
column + 1 to create essentially a counter in a situation where an
auto_increment counter would not work.
Anyone?
-Allon
Richard Trahan responded:
> Stephano Mariani wrote:
> >
> > Use symbolic links :)
>
> Actually, that's a good idea; it does let me put my table data
> somewhere else, but it's my fault that I didn't reveal my secret
> motivation in my original post. I have a general backup scheme which
> backs up
Michael Widenius wrote:
> > "Joel" == Joel Rees <[EMAIL PROTECTED]> writes:
>
> Joel> But comp_err doesn't seem to be in the win32 distribution. So I am
thinking,
> Joel> I should be able to load mysql into openBSD and do the conversion
there. Or
> Joel> is the comp_err tool available for MSW
Hello list,
When I periodically do myisamchk -s *.MYI,
it sometimes complains that some tables are corrupt.
Is there any way to keep mysql tables healthy? What are the reasons to
cause the table corruption?
Thanks.
-
Before p
Steve Wright queried
> I am looking for a command to delete all user that do not have access to
any
> databases.
>
> Does anyone know of such a command ??
Off-the-wall answer from a newbie:
Since the user information is kept in a table, it should be fairly easy to
build a short MySQL script to
Newbert, Joe queried
> Hi, I have a database with a list of users who I would like to contact
> periodically. So I need a mailing list manager.
>
> Ideally I would like a client side application that enables you to send
> individual email messages based on a sql query (not all people will be
> i
Hello,
I am having all mysql database contents in one txt file.how i will dump
all those contents to mysql database tablespls tell me how to do it
-Uma
-
Before posting, please check:
http://www.mysql.com/manual.php
At 19:45 -0800 3/18/02, Richard Trahan wrote:
>I like mysqlc because of the command line editing capability, but I
>can't find any documentation on this utility. Specifically, I haven't
>been able to figure out how "edit" works.
Good question. I suspect that it's a mistake for it to be listed
in
Hi,
On Tue, 2002-03-19 at 11:41, Campbell McLeay wrote:
> I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and
> had a few basic questions which I am hoping someone can help me with.
> My plan is simply to download and unpack the binary distribution, stop
> mysqld, move the symli
On Mon, 18 Mar 2002, Victoria Reznichenko wrote:
VR>Uma,
VR>Monday, March 18, 2002, 11:34:07 AM, you wrote:
VR>
VR>UST>To get German sorting order, you should start mysqld with
VR>UST>--default-character-set=latin_de. This will give you the following
VR>UST>characteristics.
VR>
VR>UST
Alex:
I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a
very well-designed, well-behaved service.
I have installed about 80 MySQL servers on customer-owned WinNT/2K servers.
If this were a 'general mysql-nt problem', I would have had to set a login
account in the SCM f
Greetings,
I wish to upgrade mysql server from 3.22 to 3.23 running on Linux and had a few basic
questions which I am hoping someone can help me with. My plan is simply to download
and unpack the binary distribution, stop mysqld, move the symlink to point to the new
distribution, and restart.
Hi all,
I too new to php and mysql, trying to get things works. I installed Redhat
7.2, Apache, mysql and php. I copied a sample php script from the internet
and save it as phptest.php in my cgi-bin. When calling it from my browser, I
got Format error. Did I not do it right? Should I put it
I'm having trouble with Apache dying after log rotation and have tracked
it down to the mssqladmin. When I try the:
/usr/sbin/logrotate -f /etc/logrotate.conf
I get the following error:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost
At 19:43 -0800 3/18/02, Richard Trahan wrote:
>Why is there no "tee" in mysqlc?
Because, unfortunately, it dates back to MySQL 3.22.7, even in
MySQL 4.x distributions. It hasn't been rebuilt since then.
-
Before posting, please
Ok, no support for it (d'oh), so, how do I go about breaking it down into a
join or something like that?
- Original Message -
From: "Alex Speed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 19, 2002 12:13 AM
Subject: SubSelect Problem
> SELECT textid, title, descript
I like mysqlc because of the command line editing capability, but I
can't find any documentation on this utility. Specifically, I haven't
been able to figure out how "edit" works.
Any help, please.
-
Before posting, please check
Why is there no "tee" in mysqlc?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To uns
Stephano Mariani wrote:
>
> Use symbolic links :)
Actually, that's a good idea; it does let me put my table data
somewhere else, but it's my fault that I didn't reveal my secret
motivation in my original post. I have a general backup scheme which
backs up everything in a set of directories cont
Hi Alex,
MySQL doesn't support sub-selects yet.
Gurhan
-Original Message-
From: Alex Speed [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 7:13 PM
To: [EMAIL PROTECTED]
Subject: SubSelect Problem
SELECT textid, title, description from structure where textid in (select
subtopic
Use symbolic links :)
> -Original Message-
> From: Richard Trahan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 19 March 2002 3:13 AM
> To: [EMAIL PROTECTED]
> Subject: Re: (newbie) how can I regenerate the data/mysql tables?
>
> Doug Thompson wrote:
> (snip)>
> > Perhaps you have misunder
Alex,
I believe you'll find that MySQL does not support subselects. This is
why you're getting the error message. I suggest you consult the SELECT
syntax manual page (http://www.mysql.com/doc/S/E/SELECT.html) to see
what you can do with selects.
You could try to convert this into a join, or
Perhaps I am missing something right in front of me, or I have not been in
the loop, but it is my understanding that MySQL does not support
sub-selects, yet.
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
BTW, you may receive lots of replies of this very nature, because it is
something ev
SELECT textid, title, description from structure where textid in (select
subtopicid from subtopic where topicid='Top');
this gives an error at the opening bracket.. I am assuming that mysql
realises that
structure.textid=subtopic.subtopicid
...any ideas on getting this working?
thanks for any
Doug Thompson wrote:
(snip)>
> Perhaps you have misunderstood how mysql organizes everything and you are wanting to
>do something that you don't need
> to do.
I haven't misunderstood anything, I think. I know how to create
additional databases with CREATE DATABASE. My problem is that I want
to
At 18:15 -0500 3/18/02, John Burns wrote:
>I've looked throught the MySQL documentation and I can't seem to find the
>answer to this problem. I have a query that will work on a Microsoft SQL
>server, but I've tried moving it to a MySQL server and it won't work. I
>tried modifying it and I can't
On Monday 18 March 2002 4:22 pm, [EMAIL PROTECTED] wrote:
> Everyone,
>
> What's the differences with MySQLD and MySQL-max?
MySQL-max supports more table types.
-
Before posting, please check:
http://www.mysql.com/manual.php
What error message do you get? Have you tried fully spelling out your join
condition's table names? Have you tried specifying that you are doing a LEFT
join? Have you tried using USING instead of ON?
On Monday 18 March 2002 4:15 pm, John Burns wrote:
> I've looked throught the MySQL document
Gabriel,
I have a sneaky suspicion your primary key is a CHAR or VARCHAR,
right? If so, your select statement is using an integer which means it has
to convert it for each record. If you put quotes around the "30460203" it
will run faster as in:
select IndexField1,Field1,Field2 from t
Everyone,
What's the differences with MySQLD and MySQL-max?
R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
The directory space in which mysqld places the data is capable of containing multiple
databases (related groups of
tables) and tables (related groupings of data) up to the physical limits of your
computer system.
The "mysql database" contains the tables that hold information concerning user
p
I'd highly recommend just downloading the binary distribution from
mysql.com. Works great for me.
Jim Weber wrote:
> Friends,
>
> I am trying to install MySQL on a Powerbook G$ running Mac OS 10.1.3
> and am having problems. I've followed your instructions and installed
> Fink but when I go t
I've looked throught the MySQL documentation and I can't seem to find the
answer to this problem. I have a query that will work on a Microsoft SQL
server, but I've tried moving it to a MySQL server and it won't work. I
tried modifying it and I can't get it to work either. The scenario and
synta
On Mon, Mar 18, 2002 at 05:32:07PM -0500, Kathy Reyes wrote:
> Can I have a default value call a function in a MYSQL table for example
>
> convert(float,getdate())
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell:
The problem begins when I type in use mysql;
Please look at the very left edge with three asterisks..*** where I marked. ACCESS
denied
Hope it will be fixed with your help so I can mind my own chores.
==
C:\mysql\bin>net start mysql
The MySql service i
Can I have a default value call a function in a MYSQL table for example
convert(float,getdate())
Kathy Reyes
Live Technology International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com
--
Friends,
I am trying to install MySQL on a Powerbook G$ running Mac OS 10.1.3 and
am having problems. I've followed your instructions and installed Fink
but when I go to step 2 (Install packages required for MySQL - " " (you
can copy this line from
this document and paste in terminal to avoid
I'm running 3.23.43 on Windows 98. I've done the default binary
installation, which created the mysql and test databases in
c:\mysql\data, and I've added the menagerie and other sample databases
to it. I would like to leave that structure in place but create another
database somewhere else. I can'
Your base table is transactions. I assume you want to do a LEFT JOIN.
I think you might see an improvement if "transactions" were consistently named on the
left side of the equalities as:
$Itemlistquery.= "transactions.Pdownload ";
$Itemlistquery.= "from bib_extract,scanrates,transactions where
I just wanted to say that MySQL absolutely rocks!
We are using Mysql with a very large database and it's working
beautfully. Needless to say we will be buying licenses to further
support mysql.
Here are some rough stats on what we were doing:
Inserts: 13,000,000 per day
Updates: 12,000,000 p
Well, what are the permissions on safe_mysqld? And if this is a Linux
box, where is this Irix/SGI stuff coming from in the error message?
On Mon, 2002-03-18 at 13:58, Amrita Basu wrote:
> Hi,
> I wanted to know what the error possibly could be.
> I am using RedHat 6.0 Kernel 2.2.20 on i686 and
In my experience InnoDB tables are superior to BDB, but during my
comparisons I was working with a lot more data -- millions of rows -- than
you will be; BDB's problems seemed to center around the size of the tables.
So, BDB could work well for you.
But, I can recommend InnoDB as a good way to go
On Fri, 15 Mar 2002, Peter Zaitsev wrote:
> Hello mysql,
>
> Some time ago I wrote about slow down of mysql with large number of
> threads, which is quite common in Linux-Apache-Mysql-PHP enviroment.
>
> The test was simulating the worst case of concurrency - all the
> threads are modif
From: Philippe Cand <[EMAIL PROTECTED]>
> - Is there a way to script MySQL to execute a list of commands then execute
> the load query?
Yep, Perl makes this whole list of tasks simple. Or possible, depending on your
stance. If you don't write any Perl, then I'd say to use a batch script and wr
I don't think MySQL has a mechanism for doing any sort of stored procedure,
but, I just saw this earlier today and went adn looked at it.
It may help you, but I know nothing about it and con offer no further
advice.
Ken Hylton
Programmer Analyst IV
LEC Systems & Programming
Billing Concepts, In
key_buffer is 384M, table1.MYI is 17.5MB.
Jeremy Zawodny wrote:
>On Mon, Mar 18, 2002 at 11:39:09AM -0500, Gabriel Ricard wrote:
>
>>Greetings,
>>
>>We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large
>>table ( 200,000+ records, 120+ columns) and some simple queries on that
>
Hi to all,
does mysql have a type of libraries where you can keep queries or functions.
For example if I need to run a query everyday, but I don't want to type the
same query everytime I need it. How can I store that query in one place and
call it every time I need it?
Is this possible??
Thanks
Hi,
I wanted to know what the error poosibly could be.
I am using RedHat 6.0 Kernel 2.2.20 on i686 and
installed mysql 3.23.47-sgi-irix6.5. I m running sh
./bin/safe_mysqld from the root directory and am
getting the error : cannot execute binary file.
Here is the error:
./bin/safe_mysqld:
/osc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've read the docs on mysql.com about the BDB and InnoDB table formats, as
well as their pro's & con's and I was wondering if anyone could give their
opinion on the matter. I don't need row-level locking or other fancy
features other than transactio
I use a perl method for a full week's worth of backups, this could be
migrated to have a weekly, monthly, yearly snapshot as well.
#!/usr/bin/perl
my $szToday = `date +%a`;
chop ($szToday);
$dbDumpName = '/var/backup/dbDump.mysql';
$backupFile = '/var/backup/siteFiles';
$siteDir= '/home/dir
Hi,
I wanted to know what the error possibly could be.
I am using RedHat 6.0 Kernel 2.2.20 on i686 and
installed mysql 3.23.47-sgi-irix6.5. I m running sh
./bin/safe_mysqld from the root directory and am
getting the error : cannot execute binary file.
Here is the error:
./bin/safe_mysqld:
/osc
On Mon, Mar 18, 2002 at 11:39:09AM -0500, Gabriel Ricard wrote:
> Greetings,
>
> We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large
> table ( 200,000+ records, 120+ columns) and some simple queries on that
> table have pretty inconsistent performance. Due to licensing issues
Am Montag, 18. März 2002 19:23 schrieb Jim Kaufman:
> Which of the many books I see online at barnesandnoble.com do you all
> think is the indispensible MySQL guide? I have used SQL on Sybase for
> several years, but want to start fresh and clean with MySQL.
>
One of the best is the book from Pau
Which of the many books I see online at barnesandnoble.com do you all
think is the indispensible MySQL guide? I have used SQL on Sybase for
several years, but want to start fresh and clean with MySQL.
Would it better to wait for a new book that covers new generation MySQL?
--
Jim Kaufman
Hello,
I would like to use MySQL as a fast reporting database for a dotnet EIS.
The source of the data is mainly 4 different huge and slow corporate db;
Oracle 7, Oracle 8, Oracle 9 and MS SQL
I need to perform daily load of tables at night. The load can be either
Append or Replace.
I have the sql
>Description:
mysql binaries from AIX binary distribution will not run.
1 % cd /tmp/mysql/bin
2 % ./mysql
Could not load program ./mysql:
Dependent module /usr/lib/libz.a(shr.o) could not be loaded.
Member shr.o is not found in archive
Rebuild libz with shr.o, put in LIB
I just installed
MySQL-3.23/mysql-3.23.49-win.zip
from www.mysql.com Then opened it.
But I still could not run mysql..it looks like it could not find the server. Where is
the remote server?
Anyway, see below how I was struggling..
C:\mysql>cd\mysql\bin
C:\mysql\bin>mysqladmin ping
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Christian Hammers writes:
>> Hello
>>
>> There is a problem with the myslq_read_default_group function!
>> It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very
>> latest Debian unstable (I'm the m
We asked on the MySQL training last year and were told that this is a manual
job...
Just have to delete entree for each table.
Unless some one else knows different?
Simon
-Original Message-
From: Steve Wright [mailto:[EMAIL PROTECTED]]
Sent: 18 March 2002 16:52
To: [EMAIL PROTECTED]
Sub
This one has been troubling me for some time now. For my project the
most ideal and quickest solution to archive data is to do an
insert...select followed by a delete on the original table. The problem
is, I'd like my archive tables to exist in another database (makes it a
lot easier on the progra
At 10:39 AM 3/18/2002, you wrote:
>Greetings,
>
>We're running MySQL 3.23.47 on MacOS X 10.1.2. We've got a rather large
>table ( 200,000+ records, 120+ columns) and some simple queries on that
>table have pretty inconsistent performance. Due to licensing issues I
>can't give an actual example of
hello!
i've been developing a MySQL database in mac osX - i would like to transfer
it to work onto a win2k box running apache and mysql.
what files from X do i need to copy over? is this a fairly simple process or
am i heading for a world of pain?!
cheers,
jake
p.s. if this is possible, does
> Hello
> I have a database abc with one table xyz
> The html page is to sign up a new user and calls the following signup.cgi
> script.
> The new data is not getting inserted in the table when I execute it from the
> ip address - the page getting called by the form.
> BUT I can INSERT data in t
I've looked through the documentation and if this question
is answered there, please point me to the relevant section
because I've obviously missed it.
What foreign languages does MySQL support definitively.
As in can do all kinds of searches in, etc? I'm curious about
Chinese and Japanese (and o
Hello,
I have a system running MySQL with old user accounts I wish to remove.
I am looking for a command to delete all user that do not have access to any
databases.
Does anyone know of such a command ??
With Thanks,
Steve.
Uma,
Monday, March 18, 2002, 11:34:07 AM, you wrote:
UST>To get German sorting order, you should start mysqld with
UST>--default-character-set=latin_de. This will give you the following
UST>characteristics.
UST> To get Tamil sorting order , i have started the mysqld with
UST> --defau
Markus,
Monday, March 18, 2002, 1:54:46 PM, you wrote:
ML> There -has- to be an easy solution to this, but I just can't for
ML> the world figure it out.
ML> I have a table called members(id,membernum,firstname,lastname)
ML> and a table called paid(id,membernum,year,paid).
ML> How on earth do I
Richard,
Monday, March 18, 2002, 8:03:36 PM, you wrote:
RR> In order to run perl scripts that use DBI ( from a cleint machine ) to
RR> query a MySQL server on the LAN Do I need to install MySQL on the client
RR> machine or do I just need DBI? Both machines are running Red Hat 7.2.
You should t
I am currently migrating my DB and associated apps to MySQL from Postgres,
and I am running into a couple of limitations that I couldn't figure out
how to work around from the docs, mostly stemming from sequences, views,
and triggers. I am currently using the "stock" RH7.1 MySQL 3.23.36,
please l
1 - 100 of 139 matches
Mail list logo
