Also, I have to ask the question:
Why is it that Altavista can index terabytes overnight and return
a fulltext boolean for the WHOLE WEB
within a second, and Mysql takes so long?
On Friday 08 February 2002 11:50, Steve Rapaport wrote:
> I second the question. It could also reduce the size
hi all
i' am newly about Mysql. I've tryed to install freeradius with mysql on my
server (SUN SOLARIS 2.8). Mysql seems work perfectly, but i'have problem to
compile freeradius because want Shared Library (i think libmysqlclient.so).
Where can i get this library. I' have installed precompiled mys
Hi, all MySQL team
Here is another question.
I want to get individual MySQL instance's variable(like datadir, tmpdir etc)
using C API. Is there any function can do this?
I know that use mysqladmin and use query "show variables"
can do this.
Thanks and regards
Robert Li
Computer Associates
R
> in Mysql, under sql, we have the function PASSWORD('mypasswd') where we
> can encrpt
> 'mypasswd' into a 16 character scrambled word.
> which function in sql is used to decrypt the same and get back the
> original mypasswd.
There is no such feature. PASSWORD like other hash passwords are one w
dear friends,
in Mysql, under sql, we have the function PASSWORD('mypasswd') where we
can encrpt
'mypasswd' into a 16 character scrambled word.
which function in sql is used to decrypt the same and get back the
original mypasswd.
thanking you
--
Sumeet Shroff
proprietor
Prateeksha Printing Serv
How do you make something like this fault tolerant?
The answer is probably what I suspect, 2 of every thing.
How does the aggregator handle this or are these machines in a cluster?
We are thinking of how to rebuild our fulltext search. Currently it is
in MS SQL 7.0 - MySQL 4.0 seems to blow the
Hi,
I have some text file (10MB per day) might be keep for a year. I have
been keep it in compress format (using WinZip). When I need to see detail
I have been open it and find something I want to see. If I decide to store
these text file in to BLOB field of MySQL. How do you thing
Dear list,
I have a telephone database which has "Name" as one of the fields/columns.
This field contains single name e.g Robert, double names e.g Robert
Downing and more than double names. I want to make a SELECT query using a
form whose input name is "Name" i.e '$Name' against the "Name" fie
On Thu, 7 Feb 2002 22:09:18 -0600, you wrote:
>At 22:58 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>>
>>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I ha
At 22:58 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>
>>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>>
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loo
Hello,
I have finally decided to start using innodb tables in production
enviroments and I noticed that I was able to do a join between
a myisam table and a innodb table. Will the ability to do
joins across table types always be supported in future versions
of mysql?
Also is there a standard set o
On Thu, 7 Feb 2002 21:07:44 -0600, you wrote:
>At 21:28 -0500 2/7/02, Floyd Baker wrote:
>>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>>
>>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do th
Hi Prabhu,
Select cols from tbl where datecolumn > date_add(datevar, interval 1 day);
A look at Date and time functions of the manual would do good.
But you originally asked about sys_date (is it not sysdate pseudocolumn).
Regards,
Anvar
At 04:49 PM 07/02/2002 +0530, you wrote:
i am asking reg
Hi,
An int datatype takes 4 bytes and a bigint 8 bytes. . Since there is an index
created with bigint it will take an additional 8 bytes for the data and
some more
bytes for the pointer to the table rows. Thus a bare minimum
of 20+ bytes is consumed corresponding to a row of data. A billion recor
At 21:28 -0500 2/7/02, Floyd Baker wrote:
>On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>
>>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>>I have a column of amounts that was getting adding in a loop but I see
>>>there's a sum() function to do this. Should have known. But I can't
>>>make it work
Hi Again,
I have honed this question pretty well I think (MySQL 3.23.37):
I am using large-my.cnf as my my.cnf file. It is for servers with 512
MB of RAM from what I read. On our server that has 512MB of RAM I
notice in top the following:
10244 mysql 16 0 147M 147M 1684 S
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote:
>At 19:53 -0500 2/7/02, Floyd Baker wrote:
>>I have a column of amounts that was getting adding in a loop but I see
>>there's a sum() function to do this. Should have known. But I can't
>>make it work. Can someone give me a simple query syntax usi
At 17:29 -0800 2/7/02, Johan van Reijendam wrote:
>Hi all,
>
>I have run into the following issue and was wondering if anyone else
>has ever run into the same and if there is an answer to this
>behaviour.
>
>I have a record which contains the following fields:
>
> id INT UNSIGNED
At 19:53 -0500 2/7/02, Floyd Baker wrote:
>I have a column of amounts that was getting adding in a loop but I see
>there's a sum() function to do this. Should have known. But I can't
>make it work. Can someone give me a simple query syntax using php?
The SQL SUM() function has nothing to do w
Yesterday, from Nathan:
> Since PHP ignores whitespace, I think this is also acceptable:
PHP doesn't ignore whitespace in a quote. But your code is of course
correct.
> $query = "CREATE TABLE query
> tabledef for col a,
> tabledef for col b,
> lots more table defs,
> .
> welcome t
Hi all,
I have run into the following issue and was wondering if anyone else has
ever run into the same and if there is an answer to this behaviour.
I have a record which contains the following fields:
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
create_time TI
I have a column of amounts that was getting adding in a loop but I see
there's a sum() function to do this. Should have known. But I can't
make it work. Can someone give me a simple query syntax using php?
TIA
Floyd
--
--
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
Hi.
I prefer doing like this
$query = "CREATE TABLE query ";
$query .= "tabledef for col a,";
$query .= "tabledef for col b,";
$query .= "lots more table defs,";
$query .= "welcome to line 400";
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wro
> input is >SELECT dog_name FROM hold_tbl WHERE dog_name RLIKE "^sam[0123456789]*"
> ORDER BY dog_name<
>
> (and then printing out each of the matches made)
> Sam
> Sam4
> Sam5
> Sammie6
> Sammy7
> Sampson2
> Samson
> Samuel
>
> As I understand it, only the first three should have match
Shankar Unni writes:
>And one big reason not: no native Windows port. Or Mac port (though that
>has probably changed with OS/X - anyone working on that?).
Here is an unofficial install package of the new PostgreSQL 7.2:
http://www.entropy.ch/software/macosx/postgresql/
You can get an unofficial
Paul DuBois writes:
>At 12:50 -0800 2/7/02, Cindy wrote:
>>"Rutledge, Aaron" writes:
>> >MySQL doesn't support LIKE does it? I got an error when I tried.
>>
>>I use it all the time. Maybe post the error message you got.
>>
>>RLIKE on the other hand
>
>sigh, what? RLIKE works. I
At 12:50 -0800 2/7/02, Cindy wrote:
>"Rutledge, Aaron" writes:
> >MySQL doesn't support LIKE does it? I got an error when I tried.
>
>I use it all the time. Maybe post the error message you got.
>
>RLIKE on the other hand
sigh, what? RLIKE works. It's the same as REGEXP.
>
>--Cindy
-
At 14:57 -0600 2/7/02, Rick Emery wrote:
>The following deletes all records and re-starts renumbering from 1;
>DELETE FROM mytable;
>
>The following deletes all records and continues counting from where the
>table last left off:
>DELETE FROM mytable WHERE 1;
>
>If you are trying to restart numberi
I did this at a previous job, and we split the data up more or less
this way (we used a pre-existing item number for the split which was
essentially random in relation to the text data), with a aggregator that
did the query X ways, each to a separate box holding 1/X of the data.
The results from
It seems to me like the best solution that could be implemented as-is
would be to keep a random int column in your table (with a range of say
1-100) and then have fulltext server 1 psudo-replicate records with a
the random number in the range of 1-10, server 2 11-20 and server 3
21-30 and so
I second the question. It could also reduce the size of the
fulltext index and the time taken to update it.
-steve
> On Thursday 07 February 2002 20:53, Brian wrote:
> > Has anyone made a suggestion or thought about ways to distribute
> > databases which focus on fulltext indexes?
> >
> > ful
Think of the binary log as just a long binary data stream, which simply
happens to be in a series of files. Each slave has a position in that
binary stream, which is expressed as a filename and file position.
Each slave has (potentially) a different position in the stream, and
therefore a differ
MySQL folks,
I am planning on using MySQL replication to mirror a database at
various far-flung locations. I'm anticipating that there might be a
handful of slaves, but they will only come on every few months. In
that scenario, the last slave will have a lot of catching up to do if
all slaves are
There is no limit on the size of strings in PHP. Follow this link for more
info:
http://www.php.net/manual/en/language.types.string.php
Brett
Original Message Follows
From: "savaidis" <[EMAIL PROTECTED]>
To: "'Johnny Withers'" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: long
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
So the limit isn't also set to 255 chars too?
Or is a trick especially for this case?
Makis
> -Original Message-
> From: Johnny Withers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, F
On Thu, 2002-02-07 at 15:40, Tod Harter wrote:
[snip]
> Wouldn't be too tough to write a little query routing system if you are using
> perl. Use DBD::Proxy on the web server side, and just hack the perl proxy
> server so it routes the query to several places and returns a single result
> set.
Thanks, but it was just a typo. And I tried it again, but with the same result. It's
really a strange installation.
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost
-> IDENTIFIED BY 'salach01' WITH GRANT OPTION;
ERROR 1047: Unknown command
JoacHim
> -Ursprüngliche Nachricht-
>
Hi!
>From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create > 4 GB data files in those file systems that allow it.
Thus > 4 G files
Perhaps I should have split this up into two mails, but I saw them related
in the difference of databases
On mysql Ver 11.12 Distrib 3.23.32, for pc-linux-gnu (i686)
this works
SELECT SQL_BUFFER_RESULT DATE_FORMAT(ORDERHEADER.AvailableAt,'%y/%m/%d') AS
'Date', (@tl:=SUM(IF(DISPATCHLOG.ID_STATU
The following deletes all records and re-starts renumbering from 1;
DELETE FROM mytable;
The following deletes all records and continues counting from where the
table last left off:
DELETE FROM mytable WHERE 1;
If you are trying to restart numbering while not deleting records,
forget-about-it.
-
"Rutledge, Aaron" writes:
>MySQL doesn't support LIKE does it? I got an error when I tried.
I use it all the time. Maybe post the error message you got.
RLIKE on the other hand
--Cindy
-
Before posting, please check:
Umm, I take it you haven't read the documentation? MySQL fully supports
LIKE. Can you tell us the error you are getting? Along with the full query?
j- k-
On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote:
> MySQL doesn't support LIKE does it? I got an error when I tried.
--
On Thursday 07 February 2002 14:53, Brian DeFeyter wrote:
> Has anyone made a suggestion or thought about ways to distribute
> databases which focus on fulltext indexes?
>
> fulltext indexes do a good job of indexing a moderate amount of data,
> but when you get a lot of data to be indexed, the qu
The variable will be string of cource that contains nomore than 255 chars.
No, I didn't even tried it :)
(concatenation will be the same)
But it has to be a way...
It is a problem, because my internet MySQL base doesn't permmit me to login
with MySQLfront as I have dynamic IP, for security and oth
...uhm duh. My apologies. I had the LIKE switched around when I tried
it and after reading through the manual and not finding anything about
LIKE (it isn't mentioned as a parameter in the SELECT section) I assumed
it wasn't supported. Thanks for your comments. Aaron
-Original Message--
I am using the following versions of mysql on suse linux 7.2:
frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
server: version 3.23.47
If I try to use the GRANT command I get
#mysql -u root mysql
mysql> GRANT ALL ON *.* TO root@localhost
-
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%';
On Thu, 7 Feb 2002, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> re
MySQL doesn't support LIKE does it? I got an error when I tried.
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Original Mes
Sinisa Milivojevic wrote:
> Shankar Unni writes:
>>And one big reason not: no native Windows port. Or Mac port (though that
>>has probably changed with OS/X - anyone working on that?).
> When you are saying that there is no native Windows or OS X port, what
> were you referring to ??
Oh, P
SELECT * FROM Table WHERE Fruit LIKE "banana%"
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:56 PM
To: Mysql List (E-mail)
Subject: LIKE work around??
I am trying to
Hi,
As I am new to MySQL, perhaps this is a common question you have been asked.
I have a field "Id" which using auto_increment. Now I want to reset the
value of auto_increment, that is the "Id" starts form 1 and does not skip
the number. I have spent a few hours to find a way, but all failed.
Since PHP ignores whitespace, I think this is also acceptable:
$query = "CREATE TABLE query
tabledef for col a,
tabledef for col b,
lots more table defs,
.
welcome to line 400";
I have been using this technique and have not had any problems with it. If you echo
$query, it's all
on
On Thursday 07 February 2002 12:56 pm, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> result set returned that contains everything that starts with banana.
> Any way to do this?
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was wonder
Hi folks -
I am still having 2 related problems with the timezone setting for mysqld &
was hoping to get some help.
Basically my squestions are as follows:
a) the documentation says to set timezone by simply using --timezone=# when
starting mysqld - but WHAT are the valid number values & which
Has anyone made a suggestion or thought about ways to distribute
databases which focus on fulltext indexes?
fulltext indexes do a good job of indexing a moderate amount of data,
but when you get a lot of data to be indexed, the queries slow down
significantly.
I have an example table, with about
Show us your code.
What are your table structures like?
-Original Message-
From: AOK Lansing [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: PHP does not see Table updates
I am using PHP to access a MySQL DB. If I stop MySql and the
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql->connect(undef,"database","username",'password');
$sql = "select blah from blah";
$sth = $dbh->query($sql);
@arr = $sth->fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is ot
Problem Solved!
Thanks
- Original Message -
From: "AOK Lansing" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 1:37 PM
Subject: PHP does not see Table updates
> I am using PHP to access a MySQL DB. If I stop MySql and then restart it
and
> then open my webp
Hello,
I am new to MySql. I have MySql installed in my Linux PC. How do I connect
to MySql using Perl script and assign the result of a query to an array?
Where could I find a sample code? Thank you.
Andy
_
Get your FREE dow
Hello everyone,
There used to be a section in mysql documentation, which explained about all the
entries in my.ini file. Do you know what happened to it?
There is a part about my.cnf but that's not what I want. There was more.
-
I am using PHP to access a MySQL DB. If I stop MySql and then restart it and
then open my webpage the table values are correct. If I make a change to the
table, close my browser and restart it, the table values are the old values.
If I stop MySQL after changes and then restart it, all works well.
Ok.
My hardware hangup and i installing a new server.
Howto i restore from tape to a new instalation.
André Sartori
[EMAIL PROTECTED]
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 7 de fevereiro de 2002 09:56
Para: Andre Sartori
Assunto:
I am in a windows 2000 environment. My level of experience is very low so
please be explicit. I am reviewing mySQL as a solution for multiple web
applications and CDROM applications.
I am trying to start the server for the first time using the command:
c:\mysql\bin>mysqld-max --standalone
Here i
Or you could do it like this:
$query="some query "
."some more of this query "
."still some more query "
."and so on and so forth...;"
;
The tabs are no needed, I just put them there to make
it easy to understand that all those lines are actually
just one line.
I can't read your structures or query from here.
[EMAIL PROTECTED] wrote:
>hi,
>
>i'm running a big query across a table containing more than 137 million rows
>comparing them to another one with about 4000 rows and i'm wondering how long it will
>still take...
>
>is there a way to see how many
Here is how I do it:
$query = "some query ";
$query.="some more of the same query ";
$query.="still more query ";
$query.="and so on... ";
$rst = mysql_query($query);
NOTE: you need to add a space at the end of each line (after the last word
and before the closing quotations) if you
Hello,
I just had a glance at your log-rotation file, and I think I might tell you about a
possible improvement:
In the file "mysql-log-rotate" I came across the following test case:
if test -n "`ps acx|grep mysqld`"; then
/usr/bin/mysqladmin flush-logs
fi
I th
Hello,
Can anyone help with an MySQL RPM installation that doesn't seem to be
working on RedHat 7.1?
First I did an `rpm -i mysql-max-4.0.1-alpha-win.rpm` install and it
didn't seem to give me all the files
but it did put a .sock file in
/var/run/mysql. Don't know how this rpm is different fro
On Thursday 07 February 2002 11:07, Tibor Radvanyi wrote:
> Hi Everyone,
>
> I'm newbie with MySQL with some programming experience.
> I'm about to implement an Internet shop. I would like to serve my
> customers at a high level with, amongst other features, making sure that
> every successful ord
On 7 Feb 2002, at 8:20, Richard Reina wrote:
> I tried both ideas and neither one removed the white spaces. arrr!
> :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage
returns, linefeeds), as it does in some programming languages. It
just removes spaces, unless you specif
Hello,
can anyone suggest a reasonable value for max_join_size
in MySQL server configuration as default value seems too
large? Clients should be able to run applications like
web forum but I want to prevent them from overconsuming
CPU time.
thanks,
Kirill Magdalinin
[EMAIL PROTECTED]
_
Hi Everyone,
I'm newbie with MySQL with some programming experience.
I'm about to implement an Internet shop. I would like to serve my
customers at a high level with, amongst other features, making sure that
every successful order will really be shipped due to a stock availability
check at order
Ok, its not in count(distinct()). It always happends if temptables are used,
but only if the server
runs some minutes/hours/days :(
-Ursprüngliche Nachricht-
Von: Maverick [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 7. Februar 2002 16:48
An: [EMAIL PROTECTED]
Betreff: bug in count(di
Hi,
can it be that there is a bug in count(distinct(putafieldnamehere)) ?
After restarting the server it runs, but after some time it doesnt return
any result-rows.
A count(putafieldnamehere) runs without problems in this situation.
Thanx for any sugesstions to solve this problem ...
mysql,dat
Hi There!
I am using mysql 3.23.41, for redhat-linux-gnu (i386).
My problem is this.
In java, I am trying to extract a blob field from a mysql table - I am
using
Byte[] somebytes = RS.getBytes("FPPICTURE");
String somestring = new String(somebytes);
This gives me a string of the blob dat
I need to optimize the following query:
SELECT user, sum(in), sum(out) FROM stats WHERE from>='20020205'
AND to<='20020206' GROUP BY user;
In,out are bigint, user is varcher(20) and from,to are timestamp
And I want to speed up this type of query, but I have not been able to
to get it to use an
The following just worked in a test case for me:
...user@"test-test.com"...
On Thu, 7 Feb 2002 06:29:59 -0500, Paul Faber wrote:
>Not sure if thius is supposed to go here but my version of MySQL
>
>mysql> status;
>--
>mysql Ver 11.15 Distrib 3.23.45, for pc-linux-gnu (i686)
>
>th
Hi,
more and more frequently we are seeing this error:
Lost connection to MySQL server during query
during queries. I have seen it reported previously on the list, but i
haven't been able to find a remedy. Does anyone have a solution to this?
Any ideas are appreciated.
Thanks,
james
--
Jame
Hi all,
I solved my problem. Problem because another old mysql service running on
the same port.
regards,
sreedhar
- Original Message -
From: "sreedhar" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 6:33 PM
Subject: INSTALLATION and CONNECTION pr
WHERE col BETWEEN $from_date AND $to_date ???
-Original Message-
From: Claire Forchheimer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 5:35 PM
To: [EMAIL PROTECTED]
Subject: Extracting fields from a table
I want to select all entries in my table that in a column with g
At 9:07 -0500 02/07/2002, Ken Menzel was thought to have said :
>Many of the questions on this list are answered by people like
>myself who are users of MySQL. We are busy trying to run our own
>servers and put food on the table. That being said, you are
>wondering why your question did no
>
>
>> I am trying to trim both leading and trailing whitespace from a TEXT
>> column in my SELECT query. I found the TRIM() command in the manual,
>> however, I can't get it to act upon a column name instead of an
>> actual string. Can anyone help?
>
>
> If you just say TRIM(col_name) it wil
It seems that either your server was started with the "--skip-networking"
flag, or that it's not listening on port 3306 (check your my.cnf), or your
machine has a firewall installed locally that doesn't allow network
connections to port 3306.
The MySQL command-line client will probably work in an
Hi James,
Many of the questions on this list are answered by people like
myself who are users of MySQL. We are busy trying to run our own
servers and put food on the table. That being said, you are
wondering why your question did not get an answer, it may be the
length of the message and the
Hi,
I'm wondering what the best way is to remove multiple records matching
against multiple instances found in another table. I'd like to avoid using a
scripting solution doing this in a loop.
Let's say I have two address books and there is some cross-over in entries.
I want to delete from addre
Put quotes around the hostname:
grant Select, Insert, Update, Delete on X.* to X@'X.f-tech.net'
identified by 'X';
Peter
On Thu, 7 Feb 2002, Paul Faber wrote:
> Not sure if thius is supposed to go here but my version of MySQL
>
> mysql> status;
> --
> mysql Ver 11.15 Distrib 3.2
Hi all:
I have various mysql tables (innodb type) where I am
inserting values in auto increment columns. The
value inserted into the auto increment columns is null
which automatically means that the table handler
inserts the next higher value in that column.
Problem is, many of these updates ar
Paul,
> > > I want to dump the contents of one table in to another table
> > > which has the same structure in MySQL, with just one column type changed
> > > from VARCHAR to TEXT. Whats the best way to do this?
> >
> > Would INSERT...SELECT suit you?
>
> Yes, but it's a big table. Is there a w
Not only will mysqldump allow you to work on a specific table, but it will
also allow you to dump directly from one table into another. Sounds like
exactly what your looking for.
You'll need to use the correct syntax to keep it from adding CREATE TABLE
statements, but it's all clear on this pag
Andre,
Thursday, February 07, 2002, 1:55:26 PM, you wrote:
AS> Howto backup databases MySQL direct to a Tape Backup.
You can directly copy files whitch contain tables from mysql data dir.
You can also use mysqldump to dump your database and then you can
backup result file to a tape. But I think
sreedhar,
Thursday, February 07, 2002, 3:03:35 PM, you wrote:
s> Hi All,
s> To Update current version on my new Redhat LINUX server I uninstalled MySQL
s> 3.23.26 rpm and installed all MySQL3.23.47 rpms.
s> When I tried to connect through
s> shell> mysql -u root mysql
s> Can't connect to lo
I am in a windows 2000 environment. My level of experience is very low so
please be explicit. I am reviewing mySQL as a solution for multiple web
applications and CDROM applications.
I am trying to start the server for the first time using the command:
c:\mysql\bin>mysqld-max --standalone
Here
Hi,
Using PHP? If so, this works quite nicely if you pass your dates as unix
timestamps:
SELECT * FROM table WHERE (FROM_UNIXTIME($theMaxTime) > col AND
FROM_UNIXTIME($theMinTime) < col)
In other words, "col" needs to be between $theMinTime and $theMaxTime as
in $theMinTime < col < $theMa
Placed At :
Hi..
I have set up a new slave host for my mysql DB..I have just done a create DB on
it and have setup all replication parameters in my /etc/my.cnf..but when i start
the slave i get the following error..has anybody come across this..any
Paul,
RTFM : http://www.mysql.com/doc/I/N/INSERT_SELECT.html
[quote]
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
With INSERT ... SELECT statement you can quickly insert many rows into a
table from one or many tables.
INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fl
Christo,
Thursday, February 07, 2002, 11:52:06 AM, you wrote:
CR> Hi all
CR> How can I take info from one table and print it into a txt file.
CR> the table is (NAME)
CR> and all the names in it I want to print out to a file name virtusertable.
See info about mysqldump: http://www.mysql.com/
JP,
Wednesday, February 06, 2002, 11:58:49 PM, you wrote:
JA> Amendment to that last post
JA> I don't think the daemon is starting properly, because I can't run a
JA> mysqladmin version - I just get a hung cursor.
JA> Does anyone know if there's something that would be stopping mysqld from
1 - 100 of 130 matches
Mail list logo
