Hi,
I finally after 2 weeks battle with asp.net - mysql - myodbc got a
connection.
my only problem now is that I got the connection because I downloaded
microsofts ODBC.NET component and I'm using the Microsoft.Data.Odbc
namespace.
but I can't find any documen
Yes and no
If you are taking info from a live database you would have it in a steady
state to copy it. This means locking the tables.
But once you have a copy of the table all you would need to do is update the
changes from the logs.
Using replication for this I is the most simple way but wo
Hi Allon,
Only one query can be sent to server at a time. But your particular case
can be handled with the single query
Insert Into orders (Number) select Max(Number) FROM Orders;
Anvar.
At 04:45 PM 19/03/2002 -0800, you wrote:
>Hi All-
>
>We are using the mm driver for MySQL and multiple sta
Hi,
I my mysql server database directory (that is the directory that holds the
.err and .pid files) so strange files have apeared. They look line
-bin.001
-bin.002
etc
-bin.index
Some of them are huge! They seem like binary files, but are full readable
SQL commands that could be f
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
mysql does not let me enter german umlauts, though. I tried to start it with
"mysql --default-character-set=latin_de", but it complained about the
character sets not being installed. Then I installed the mysql server, which
Have a look for binary log files in the manual these are binary log files,
needed for replication setup eg.
Lars
mysql mailing list user wrote:
> Hi,
>
> I my mysql server database directory (that is the directory that holds the
> .err and .pid files) so strange files have apeared. They look li
Hi,
Is there a way to speed up inserts on a table with three fulltext
indexes? I'm using the multiple value insert format like:
insert into blah (field1, field2) values ('val1', 'val2'), ('val2',
'val3'), etc..
Perhaps this is a bug in the current mysql4 bk snapshot, but inserts and
selects on a
i believe you've the replication option turned on.
see http://www.mysql.com/doc/R/e/Replication_Options.html for more
details.
mysql mailing list user wrote:
>
> Hi,
>
> I my mysql server database directory (that is the directory that holds the
> .err and .pid files) so strange files have apea
sql,Mysql
>Hi Allon,
>
>Sorry. It wont work. I didn't notice that you were inserting to the
>same table as the select.
>
>
>Anvar.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
Am Mittwoch, 20. März 2002 11:24 schrieben Sie:
> > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
> > mysql does not let me enter german umlauts, though. I tried to start it
> > with "mysql --default-character-set=latin_de", but it complained about
> > the character sets n
Hello,
s possible to create table with default value returned by built-in
function ??
like:
create table x (a int not null default UNIX_TIMESTAMP());
When inserting new column in table field a will contains timestamp?
sql,query
Regards,
Michal Dvoracek [EMAIL PROTECTE
I just took a look at all of that, especially the jar file.
It contains another jar file! (with the mm.mysql driver classes)
maybe it appears that some runtimes don't get this working !?!
it worked fine on my system :
browsers netscape 6 (winnt4 and linux) and opera 5 (winnt4).
Andreas
* sql,sel
Hi,
I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
SET @var, etc.).
I want to execute all these instructions from a C program , using the API.
It is possible to use the function mysql_query(), to execute all the
instructions contained in the file in a single call t
Hi,
Lonnie Wormley wrote:
>
> Is this the correct file to have in your class path?
> addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar
Yes, please add it into jdk.config. :)
--
TAKAHASHI,"KEN",Tomohiro
Borland -- Enabling a new digital world where our customers hav
I run mysql on a SuSe 7.3 and a FreeBSD 4.5 server.
The FreeBSD mysql version is 3.23.49.
The linux mysql version is 3.23.33.
I just copied a large table using mysqldump | mysql from the linux server to
the FreeBSD server.
An explain statement on a select on this table shows different row cou
Jeremy
>>You can set it up so that the slave only gets updates to certain
>>databases. Have you looked at the replication docs in the manual yet?
Yes I did, but what put me off slightly was the concept of a master
and slave. My requirement is per sql database not per sql server.
Am I being stoo
Hi All,
I am getting following error msg when I try to install
MySQL using rpm -i My*
error: MySQL-3.23.49a-1.i386.rpm cannot be installed
error: failed dependencies:
data-showtable is needed by
Msql-Mysql-DBI-perl-bin-1.1823-1
DBI-perl-bin is needed by
Msql-Mysql-DBI-perl-bin-1.
How would I list all users via the command line?
--
Mike Yrabedra
President
323 Enterprises
Home of The MacDock and The MacSurfshop
[http://macdock.com] : [http://macsurfshop.com]
VOICE: 770.382.1195
___
"in all your ways
Young Sul wrote:
>
> Hi,
>
> I've got a website that uses a mysql backend database. Due to the way in
> which
> the database and development has been architected, I'm unable to
> load-balance
> the database between multiple DB servers, taking advantage of replication
> inherent
> in mysql. (this
Hi,
reading the table-dump with MyISAM takes about 30 seconds.
With InnoDB it ran 3 hours before I killed it.
I removed the Unique-key definitions and it took 22 seconds with InnoDB.
Now I'm creating one unique key and it's running more than 20 hours already.
Perhaps someone with a support-contr
Hi Rob
Read the manual, you can do exactly what you need to and it is explained in
the manual. I am doing it myself.
Regards
Warren
>
> >>You can set it up so that the slave only gets updates to certain
> >>databases. Have you looked at the replication docs in the manual yet?
>
> Yes I did, but
Sounds as though you haven't got Perl installed, or more particularly the
DBI modules for MySql. If you on Linux, almost certainly to be found on your
Linux CDs.
HM
Suresh R. Soni writes:
> Hi All,
>
> I am getting following error msg when I try to install
> MySQL using rpm -i My*
>
>
Try:
mysql -e "SELECT user FROM mysql.user"
You may need to add the following as well
mysql -h hostname -uyouruserid -pyourpassword -e "SELECT user FROM
mysql.user"
-Original Message-
From: Mike Yrabedra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 6:55 AM
To: [EMAIL PROTEC
On Tue, 19 Mar 2002, Young Sul wrote:
> Hi,
>
> I've got a website that uses a mysql backend database. Due to the way in
> which
> the database and development has been architected, I'm unable to
> load-balance
> the database between multiple DB servers, taking advantage of replication
> inhere
mysql mailing list user wrote:
> Hi,
> I my mysql server database directory (that is the directory that holds
the
> .err and .pid files) so strange files have apeared. They look line
> -bin.001
> -bin.002
> etc
> -bin.index
> Some of them are huge! They seem like binary files, but are f
Hi, I am using Redhat 6.2 kernel 2.2.20 and am getting
this error below. I know that these paths are
incorrect , should be /jive/usr/biosym/235 instead
of /usr/biosym... where do I change this? Which file?
Sorry if this is obvious, but I am new to mysql.
Thanks,
Amrita
unknown user id: mysql
Thi Cao writes:
> All,
>
> I can't seem to perform an update on my database with MySQL++. The
> execution of the query always throws an exception. Here's a snippet of what
> I did.
>
> Query query(&conn);
>
> query << "update employee set children = 3 where id = 9";
> query.execute();
>
> Th
Michal Dvoracek wrote:
>Hello,
>
>s possible to create table with default value returned by built-in
>function ??
>like:
>
No.
>
>create table x (a int not null default UNIX_TIMESTAMP());
>
What is wrong with the timestamp field type?
>
>
>When inserting new column in table field a will conta
Joel,
I have read the manual related to windows several times. But the problem
that I was not having is not mentioned in the manual.
I am not too sure if I am the one who needs root canal like someone earlier
claimed. Or the manual needs one. I dont think the manual is helpful for
beginners. O
From: "Michal Dvoracek" <[EMAIL PROTECTED]>
> s possible to create table with default value returned by built-in
> function ??
> like:
>
> create table x (a int not null default UNIX_TIMESTAMP());
>
> When inserting new column in table field a will contains timestamp?
In general, this cannot be
See section 4.3.1 "Grant and Revoke syntax" and 4.3.8 "Using
secure connections". There is a very good version of the docs in
frame format at http://www.bitbybit.dk/mysqlfaq . I highly
recommend it.
> -Original Message-
> From: Chris Hanes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, Marc
Not as far as I know, you need to open your file, read
the commands and process them one at a time.
The C API is not magic and has no more capability than you do setting down
and typing in the commands yourself.
What you can do is build one HUGE insert command from lots of individual row
insert
At 11:35 + 3/20/02, Javier wrote:
>Hi,
>
>I have a text file , with several MySQL instructions (CREATE TABLE, INSERT,
>SET @var, etc.).
>
> I want to execute all these instructions from a C program , using the API.
>
>It is possible to use the function mysql_query(), to execute all the
>instr
It looks like you don't have a path to that library. Once you find the
true location of libpthread.so, add that directory path to the file
/etc/ld.conf. After that is done, run:
ldconfig -v
as root and try again.
On Wed, 2002-03-20 at 09:13, Amrita Basu wrote:
> Hi, I am using Redhat 6.2 kern
select distinct User from mysql.user where User <> ''
Mike Yrabedra wrote:
> How would I list all users via the command line?
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
Regarding your issue with accents, I understand more now about your
problem, you are using shell tools in free BSD and you have not set
the LANG shell environment variable. Add the folling line to your
shell environments (usually .profile).
LANG=en_US.ISO_8859-1; export LANG
or for german lang
Hi Again Sasha,
You will find that explain is not always accurate. It makes
guesses about the date based on statistics stored with the table
files. It does not actually run the query, however if you dumped the
table and reimported the table table on Linux you would probably get
the same resu
Hi Guys,
I would like to request an additional feature with EXPLAIN.
EXPLAIN does not run the query guesses on how the query would be run.
This is not always accurate. The slow-log however logs the actual
information the query was run with (like explain only the truth!).
Could we have an option
Hello,
I hope someone here can help me out with this. I can't find anything in the
documentation that does help. Everything points to the port being in use,
however it isn't. I know it for a fact (netstat/telnet), no the mysqld also
is not running, I know that for a fact (process list).
I install
On 19 Mar 2002, at 18:14, Michael Halcrow wrote:
> Any suggestions as to where to start?
There's a Perl module called SQL::Statement that does SQL parsing:
http://search.cpan.org/search?dist=SQL-Statement
--
Keith C. Ivey <[EMAIL PROTECTED]>
Washington, DC
---
Hi,
Application uses Jboss server with mysql backend.
IMDB tables (Heap tables) are created by the app. Things work on fine.
Suddenly we miss Heap tables. We are not able to reproduce this at any
particular event.
It happens randomly. We could not make out the reason for this.
We set max_heap_ta
I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
hav
Can someone look at this at see what I am doing wrong:
The following SQL returns to records:
50
333
select SC_USER_ID as parmSecurename from CP_USER_COMMENT where SC_ID =
107793;
If I include it in the following loop the result is
50
333
333
CREATE OR REPLACE Procedure SP_USER_COMMENT_2
as
-
Hi Liyju,
Before answering your note, I need to explain about the using the syntax for
mysql -u user -p.
If I use the format above for mysql -u root -p,
I can press after typing mysql -u root -p
and wait for the password inquiry. I dont need to enter the password (I dont
have one, anyway) and
thank you very much
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:25 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: URGENT: Update Error with MySQL++
Thi Cao writes:
> All,
>
> I can't seem to perform an update on
- Original Message -
From: "Chuck Roberts" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 9:36 AM
Subject: RE: mysql -u root DENIED
>
>
> > -Original Message-
> > From: alan4100 [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 19, 2002
Hi.. my name is Marco Leiva and i have just downloaded your software...
i want to connect Mysql to Visual Basic, I downloaded the ODBC drivers but
the following error message keeps on popping:
"An error Occurred while copying c:\windows\system\mfc30.dll restart windows
and try installing again (b
I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
one of the things I'm tracking is click-thrus. I'm going to re-direct
traffic thru a script that will just count the number of clicks, and
store that number in a mysql table.
It needs to be fast and efficient, and I'm somewhat
Anis,
My problem has been solved without configurating my.cnf.
It looks like I dont need it at all because WINADMINSQL has created its own
my.ini file.
You may find my email to others about the fix. I still dont know what the
problem is. But it appears to be fixed ; fine and okay now. After clos
At 01:17 AM 3/20/2002, you wrote:
>An Oracle DB programmer reviewed a query that I wrote and told me that
>putting constants at the beginning of the query would make it slower. I
>thought I'd go to the experts on MySQL and be told the truth one way of
>the other.
>
>Example query:
>
>SELECT
>
Ken Menzel writes:
> Hi Guys,
>I would like to request an additional feature with EXPLAIN.
> EXPLAIN does not run the query guesses on how the query would be run.
> This is not always accurate. The slow-log however logs the actual
> information the query was run with (like explain only the tru
Hi,
I'd like to setup two database servers in a dual master/slave config. So
both machines will be each others master and slave.
Only one server will be queried (selects, inserts/updates and deletes). In
case of failure of one master a network switch will handle failover. The
failed machine sh
Odd, I think it does a very good job of helping troubleshoot:
http://www.mysql.com/doc/A/c/Access_denied.html
On Wed, 20 Mar 2002 09:30:48 -0500, alan4100 wrote:
>And does not explain at all when mysql -u root -p does not work.
>
Can a file be inserted to a mysql table from a unix(linux) command prompt?
Also, can I query the same table and output the data to a filename.ext in a
specified directory?
Not sure if this is an appropriate question for the list, but all
clues/examples would be greatly appreciated.
I have:
mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
and wonder about the log file /var/log/mysqld.log
shouldn't that include failed connections??
mvh: Pål Wester
høgskoleingenør/programmerer
never.no as, stortingsgt 30, 0161 Oslo
direkte: 22 01 66 34, 906 900 62
tlf: 22 01 66
Kathy,
Sounds like mine, but it is fixed. I still dont know what the fix was. May
I ask you how you signed in as Kreyes? Did you add username and password
yourself?
Since you are denied access to mysql (default) database, it surely sounded
like mine. Before I may give you some help, may
I ask
Hello all
I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at that
computer now, so that could be wrong slighly) install pkg
I have installed it, and I can get it to run with the --skip-grant-tables
option.
When I try to run safe_mysqld without the skip option I get the foll
Let us know your results ...
Adib.
Keith C. Ivey wrote:
> On 19 Mar 2002, at 18:14, Michael Halcrow wrote:
>
>
>>Any suggestions as to where to start?
>
>
> There's a Perl module called SQL::Statement that does SQL parsing:
>
> http://search.cpan.org/search?dist=SQL-Statement
>
--
Thanks Anvar-
But I guess you didn't really follow this thread. We started with the
statement you are suggesting because we are porting from another datasource.
As it turns out, you cannot do a Insert ... Select from the same table in
MySQL.
It's supported in other databases, so I was surprised
I've tried everything thats in this email and nothing seems to work for me.
I think my situation is a little different because I had access to my
database originally but now I cant connect I can sign on as kreyes but I
cant sign on as root. I can even sign in as ODBC. I dont know what to do. I
hav
Hi All
Could someone explain to me why an index in a select I am doing is only
sometimes used.
The select I do is a complex one with multiple tables, and when it uses the
index it takes 1.5 seconds, but when it dosnt it takes 1 min and 25-50
seconds.
I have simplified it down and founed the place
Hi,
I am loading table A from values in table B with an insert . . . select
statement.
I also need to populate a x-ref table with the new insert ids from the
insert . . . select.
I know in Oracle I would put a trigger in to do the x-ref insert after
each row of the insert. . .select is processed.
At 10:15 -0500 3/20/02, Ramaraju.R.V wrote:
>Hi,
>
>Application uses Jboss server with mysql backend.
>IMDB tables (Heap tables) are created by the app. Things work on fine.
>Suddenly we miss Heap tables. We are not able to reproduce this at any
>particular event.
Is someone restarting the server
Hello,
Does anybody know how MySQL works with MS Access especially when it comes
to preventing concurrent updates from more than two users? I use InnoDB
tables and link them through ODBC driver to MS Access for viewing and
updates. Will there be any issues if two or more people have this type of
Andreas,
I gained some experience putting 15'000 documents into TEXT columns and
indexing them. It's not quite 15gigs, but your amount of data will be
reduced when you go from *.doc to pure ASCII. My table size is:
-rw-rw1 mysqldaemon 187621564 Jan 8 20:02 plaintext.MYD
-rw-rw
Kathy,
This is 2nd copy because I forgot to cc to [EMAIL PROTECTED] myself.
Try to cc to [EMAIL PROTECTED] . There are others who want to read it.
But you said earlier about emails that did not do much of help. I was lucky.
Perhaps you have to wait for your turn.
First, I feel I am not ready to
I have a table with over 60,000 records, I have a text field that is a
full text index. I need to change it to medium text. My question is can
it do it without taking the site offline. will the table still be able
to serve select queries while the alter is running or will they be locked until
it
Hi,
In my mysql .err file I get a lot of the following error...
"Aborted connection 121031 to db: ..connection details... (Got an error
reading communication packets)"
What does this mean, and is it bad, and what do I do about it?
Any help appreciated.
Howard
-
Hi,
You can just do an UPDATE:
UPDATE $table set total_clicked = total_clicked+1
Regards
rory oconnor wrote :
>
> I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
> one of the things I'm tracking is click-thrus. I'm going to re-direct
> traffic thru a script that will jus
From: "rory oconnor" <[EMAIL PROTECTED]>
> I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
> one of the things I'm tracking is click-thrus. I'm going to re-direct
> traffic thru a script that will just count the number of clicks, and
> store that number in a mysql table.
>
I have had very much success with passing sql commands via ado over the
myodbc layer. I wouldn't trust addnew and update batch methods nor have I
tested how or if they work, it's better to keep your connections to the
database stateless for performance purposes. Meaning to execute dml
stat
At 10:48 -0500 3/20/02, Stembridge, Michael wrote:
>Can a file be inserted to a mysql table from a unix(linux) command prompt?
mysqlimport?
>Also, can I query the same table and output the data to a filename.ext in a
>specified directory?
SELECT ... INTO OUTFILE
>Not sure if this is an appropr
I need to do a search where I am looking at the table that has dates and I
need to look only things that are 30 days or younger.
Can so one show me a some SQL statements where you use < , >? And the key
for equal to or less?
Chuck Payne
Magi Design
-
I thought I was sending my email to the [EMAIL PROTECTED] but I guess I
wasnt.
Thank you so much for your help Alan,
I cant figure out how I have lost access to 'mysql' (default) database. When
I attempt to use mysql on my Linux machine I get the error message "ERROR
1045: Access denied for user
Does anyone know of any good PL SQL Oracle Lists?
thank you in advance
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2
with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
$dbh =
DBI->connect("DBI:mysql:database=$database;host=$host","$user","$mysqlpassword",{'RaiseError'=>1});
$update_number = "UPDATE $table set total_clicked = total_clicked + 1";
$sth = $dbh->prepare("$update_number");
if (!$sth) { die "Error:" . $dbh->errstr . "\n"; }
if (!$sth->execute) {
On Tuesday 19 March 2002 11:35, you wrote:
> 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 Forma
Hi,
I am trying to get the following to work but it returns invalid values.
SQLINTEGER size;
SQLExecDirect (hstmt, "Select 8", SQL_NTS);
SQLBindCol(hstmt,1, SQL_C_ULONG, &size,0,NULL);
I tried various datatypes for size but I always get some invalid value. Is
the above correct or do I need to
At 16:31 + 3/20/02, Steve Gardner wrote:
>Hi All
>
>Could someone explain to me why an index in a select I am doing is only
>sometimes used.
>The select I do is a complex one with multiple tables, and when it uses the
>index it takes 1.5 seconds, but when it dosnt it takes 1 min and 25-50
>sec
At 11:42 -0500 3/20/02, Andrew Hazen wrote:
>Hi,
>I am loading table A from values in table B with an insert . . . select
>statement.
>I also need to populate a x-ref table with the new insert ids from the
>insert . . . select.
>
>I know in Oracle I would put a trigger in to do the x-ref insert af
You can avoid the step of extracting the row data by doing:
"UPDATE mytable SET numclicks = numclicks + 1"
-Kevin
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: fast,efficient query for counting
I'm
Does mysql own the mysql database directory, and all its files?
You should have run it as
mysql_install_db --user=mysql
Rance Hall wrote:
>
> Hello all
>
> I have a slackware 8.0 distro that includes mysql 3.39.x (I'm not at
> that computer now, so that could be wrong slighly) install pkg
>
>
On Wed, 20 Mar 2002, Steve Gardner wrote:
> Hi All
>
> Could someone explain to me why an index in a select I am doing is only
> sometimes used.
> mysql> explain select * from mailstat where domain_id in(2);
> +--+--+---+--+-+--+-+---
> -+
If more than a third of the rows would be selected, it is faster not to
use the index.
Over 2 million records match the '2'.
How many are there total?
Steve Gardner wrote:
>Hi All
>
>Could someone explain to me why an index in a select I am doing is only
>sometimes used.
>The select I do is a c
Yeah,
I've abandoned the nice neat insert . . . select.
Instead I am selecting the table B dataset, inserting each row into
table A, capturing the insert id, populating the x-ref, and going on to
the next row. Twice as much code, but it works.
Andrew Hazen
-Original Message-
From: Paul
MySQL Error: 1049 (Unknown database 'databasename')
I having a very weird unpredictable problem. I have a webserver which
makes database connections via Perl and DBI. For the most part it works
pretty much all the time but sometimes (2 or 4 times per month) it gives
an error: Unknown database
Thank you very much for the hint. The problem occurs on SuSE linux, though,
not on FreeBSD, and lang=de_DE.
Following your hint, I set
LANG=de_DE.ISO_8859-1
The problem still remains. Then I set
LANG=de
since there is a directory
/usr/share/locale/de
on the system, but n
Ibrahim,
Wednesday, March 20, 2002, 9:52:25 AM, you wrote:
IKC> I want to knowledge about blob.
IKC> how can write or read blob to/from MYSQL database by using Visual C++.
IKC> Can any body help me.
You can look at example in MySQL++ (C++ API for MySQL) documentation:
http://www.mysql.
Ron,
Wednesday, March 20, 2002, 2:30:56 AM, you wrote:
RS> I'm installing MySQLto a Corel /Debian platform, following
RS> directions in the book Beginning PHP4. Successfully
RS> did ./configure, make, make install, and mysql_install_db
RS> as described on page 387. The book says I'll now need t
colin,
Tuesday, March 19, 2002, 11:04:31 PM, you wrote:
co> When i try to access the database which is on my Linux
co> machine i get the following error:
co> ERROR 2002; Can't connect to local MySQL server
co> through socket '/tmp/mysql.sock' (111)
co> There is nothing in this file, although i d
Shon,
Tuesday, March 19, 2002, 7:48:30 PM, you wrote:
SS> i am running mysql version 3.22.32. yes i am planning an upgrade. in the
SS> meantime, i need to check (and possibly) repair my tables without bringing
SS> down the mysql daemon.
For version 3.22.32 you can use only isamchk/myisamchk for
Mike,
Wednesday, March 20, 2002, 2:55:18 PM, you wrote:
MY> How would I list all users via the command line?
If you mean users in mysql privilege tables you can use the following command:
mysql -e 'SELECT user FROM mysql.user'
If you mean active user that use database you can get list of active
Steve,
Wednesday, March 20, 2002, 6:31:09 PM, you wrote:
SG> Could someone explain to me why an index in a select I am doing is only
SG> sometimes used.
SG> The select I do is a complex one with multiple tables, and when it uses the
SG> index it takes 1.5 seconds, but when it dosnt it takes 1 min
Does anyone know of any good PL SQL Oracle Lists?
thank you in advance
Lance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
On Wed, Mar 20, 2002 at 04:48:11PM +0100, Danny Kruitbosch wrote:
> Hi,
>
> I'd like to setup two database servers in a dual master/slave
> config. So both machines will be each others master and slave. Only
> one server will be queried (selects, inserts/updates and
> deletes). In case of failur
Hi, I'm trying to sort out an inconsistency where adding an index changes
the results of a query. Seems like this is incorrect.
I'm running 3.23.36-debug, under NT. I have yet to try this on other
versions...
The following may be a bug, but it's at least inconsistent.
I wonder if this is fix
I do this from the command line sometimes:
mysql -h HOST -pPASSWORD DATABASE < statements.sql
The statements.sql file should contain full sql statements. This will
read in the file and execute the sql 1 line at a time.
The opposite would be to use mysqldump like so:
mysqldump -h HOST -pPASSW
Oracle-L has a number of PL/SQL gurus on it. Good list.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Lance Prais [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 12:42 PM
To: [EMAIL PROTECTED]
Subject: Important question
Does anyone know of any good PL SQL Oracl
On Wednesday, 20. March 2002 18:31, Chuck PUP Payne wrote:
Hi!
> I need to do a search where I am looking at the table that has dates and I
> need to look only things that are 30 days or younger.
>
> Can so one show me a some SQL statements where you use < , >? And the key
> for equal to or less?
1 - 100 of 160 matches
Mail list logo
