TAKAHASHI, Tomohiro wrote:
> 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. :)
>
I have it in there and it still does not work. I have it
Here is the time for creating one unique index.
Query OK, 211921 rows affected (1 day 9 hours 23 min 43.63 sec)
Records: 211921 Duplicates: 0 Warnings: 0
And its already on the todo to disable unique secondary keys temporarily :)
-Ursprüngliche Nachricht-
Von: Christian Rabe [mailto:[
I changed servers and now nothing works at all.
I am bright green to cgi and mysql and just purchased this site last month.
What is the recommended checklist I can check out to see where the problem is..
I need to get this all working asap before my hair turns green too.
Thank you all in advance
Hi,
I have two tables that i want to link via an outer join:
mysql> desc active_monitors;
++--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++--+--+-+-+---+
| monitor_id | int(
Hi all,
we're using 2 tables master1 and master2, in which master2 table's column1
references table1's column1(Forien key). Both are of same type. Since it is
foreign key, the value which is entered in column1 of master2 should be
already available in master1. But while adding MySql is not takin
Everyone,
I am using the MySQL server version 3.23.44 running on Windows 98 machine, I
just found out that as you view the task manage...mysqld is not alone...I
mean, about 6 of them...I am confuse whos running...so, all I want to know
is...is there a problem about it...as far as my client is con
PHP all the way.
This will give you a lot of information on what your options are:
http://uptime.netcraft.com/up/graph?site=www.klym.ca
and substitute site=www.yourdomainname.com
It will tell you what modules they currently support etc.
PHP is faster than JSP and I think its a whole lot more
Aha! That's the reason why my DB has so many "Com_change_db".
Thank you for letting me know.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:10 PM
To: °í¼ø¹Î
Cc: [EMAIL PROTECTED]
Subject: Re: What is "Com_change_db"
On Thu, Mar 21,
Guys
I have a corporate portal application that use MySQL as backend database and Linux OS
(RedHat 7.2)
For clustering service, i've found so many solutions BUT the problem comes when
i realize that i must cluster data to, not only MySQL data but also public folder,
email and others.
Is that p
I have built a MySQL database for a web based survey. I am trying to decide
between JSP and PHP for my programming interface. The reason I am
considering Java is because I have some Java experience. What would you
recommend for someone like me who is starting out?
Also, my two current hosting
I am running the latest stable version: 3.23.49a
but when I use the LOAD DATA command I get the error below:
mysql> load data local infile "theme.txt" into table theme;
ERROR 1148: The used command is not allowed with this MySQL version
any idea what the problem is?
thanks
---
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.
Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same
hardware? Thanks.
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
On Thu, Mar 21, 2002 at 11:26:41AM +0900, °í¼ø¹Î wrote:
> I executed mysqladmin extended-status. There was "Com_change_db"
> head. But I can't understand what it means. I know "Com_xxx" means
> number of times "xxx" command executes. But what does change_db
> mean?
That's "USE " and the eqivel
Thanks...Paul
It appears impossible to reply your note via Outlook Express because it will
return to me like other users. So I am replying this note to
[EMAIL PROTECTED] Hope I will hear the solution soon.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAI
HI everybody!
I am using Linux Red Hat 7.2 and I want to execute
mysqlgui. After I start this program, have a error is:
Can't connect to local mysql server through socket.
Please, show me a way to solve this problem.
__
Do You Yahoo!?
Yahoo! Movie
Hi Joao,
I will check on it...thanks
I know if I send it directly to you; it will be returned to me while the cc:
goes to the [EMAIL PROTECTED] successfully.
>From now on I will just email it to [EMAIL PROTECTED]
I wonder if [EMAIL PROTECTED] has made arrangements to send a personal
copy to y
hi,
I think u r right..
because after recovering from the dumped database, when insert a value
in the foreign key column which is not present in the primary key, it
accepts the row inserted.
which is not true when I do the same think from the mysql command
prompt,( before dumping)
Anybody who h
mysql
Hi Doug,
I am not sure what you want to tell me. But you may be right about shell
available for Windows. I assume it is an add-on program. I have not used
this shell prompt either; it may be available on Windows XP.
But may I ask you one question?
Do you think I can find
mysql_install_
Hi, I'm developing a web content management system for my website. I'm in a
dilemna over which schema would be best for categorizing each document and
really would appreciate some experienced input on this since I've changed my
mind 4 times already and still can't decide between the two following
Hi Again
Thanks for all the responces
> Check the manual section on the query optimiser,.I seem to remember that
if
> MySQL has to check more that some percentage of a table (30% ?) the
> optimiser guesses it can search the entire table just as quickly.
> Someone please correct my if I'm wrong.
mysql
Thanks..thanks, Tony
I think I am still having problems in replying this note to you because it
had returned to me before. I have found emails redirected to me from other
users. In replying to you, should I add anything key word like MYSQL in the
subject?
It is not clear why, but I am kee
Try these:
Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection
("jdbc:mysql://localhost/Testing", , );
Make sure the jar file in the mm.mysql-2.0.11 directory is in your
classpath/
mm.mysql does NOT use the odbc driver.
> Subject: Java to M
mysql
- Original Message -
From: "Tony" <[EMAIL PROTECTED]>
To: "'alan4100'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 2:11 PM
Subject: RE: Adding Columns to table
Just put a carriage return (e.g. the enter key) in your command every, say
72 characters or w
I executed mysqladmin extended-status.
There was "Com_change_db" head. But I can't understand what it means.
I know "Com_xxx" means number of times "xxx" command executes. But
what does change_db mean?
Please help.
-
Before po
Hi Kim,
On Thu, 2002-03-21 at 09:15, Kim Kohen wrote:
> G'day Arjen
Indeed, hi fellow Aussie ;-)
> > FULLTEXT search generally uses an index (the FULLTEXT index), so the
> > server will not use an index on Writer.
> So is an index on Writers worthless in this circumstance? My concern would
> b
The problem is you are not entering any returns. You can do this:
mysql> create table customers
-->(Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
-->First_Name VARCHAR(20) NOT NULL,
-->LAst_Name VARCHAR(30) NOT NULL,
Etc, until you get to the last:
-->;
That's it.
On 3/20/02 2:40
You may also find it more convenient to edit a text file with all of your data and
table creation commands in it, then use the 'source' command inside an mysql session
to execute them. That way when you run into an error, you just edit the file and
repeat.
Another nicety about MySQL is a co
Just put a carriage return (e.g. the enter key) in your command every, say 72
characters or wherever the next logical word occurs. MySQL really only cares about
ending all the entry with a semi-colon (or some maximum line length which I think
you've run up against).
In short, hitting the en
By any chance are you using DBI, and prepare in the query? If so, have you use
prepare_cached and roled the select statement into a function that accepts the
'CONSTANT' as an input param to the function?
That gave me tremendous perf improvements.
-Original Message-
From: BD [SMTP:
It is a big problem for us, and I can only imagine for anyone using
MySQL, when a mysql client hangs on an established connection to
the mysql server because the network to the server is disrupted
(such as someone pulling power to a network hub or many other
scenarios). We have changed the source
Hi,
I am no major linux guru, I am not even sure this is a bug, but here goes:
OK, my host creates databases on its shared hosting systems (redhat 7 and
latest stable MySQL (or it was about 3 weeks ago)) in the format
username_dbname. You can then obviously create users with the permissions,
tha
G'day Arjen
> FULLTEXT search generally uses an index (the FULLTEXT index), so the
> server will not use an index on Writer.
> So far for the answer to Kim.
So is an index on Writers worthless in this circumstance? My concern would
be if someone did a query using the writer's name as the _on
a telnet to mysql works :
www:~/MySQL# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
2
4.0.2-alpha-debug9`VmEN7i,
Bad handshakeConnection closed by foreign host.
but still cant erase this password !
www:~/MySQL# /usr/bin/mys
Normally seen when a client disconnects due to timeout, Or the server
doesn't realize the client has disconnected.
mysql mailing list user wrote:
>
> Hi,
> In my mysql .err file I get a lot of the following error...
>
> "Aborted connection 121031 to db: ..connection details... (Got an error
On Wed, Mar 20, 2002 at 11:51:47AM -, Rob Moore wrote:
> 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 slav
This is a servlet code example for jdbc using the mm driver.
String DB_NAME = "database";
String DB_HOST = "localhost";
String DB_USER = "username";
String DB_PASS = password;
String DB_DRIVER = "org.gjt.mm.mysql.Driver";
String DB_CONNECTION = "jdbc:mysql://" + DB_HOST +
Posted for [EMAIL PROTECTED]
hi,
i'm using php to query a database and output a selection of records.
the problem is that i don't want the output in an html table format.
i
want just a listing of records.
all i'm trying to do now is get rid of the column headers. they are
At 15:30 -0500 3/20/02, alan4100 wrote:
>I am creating a database called Meet_a_Geek at MS DOS prompt. The
>customer table has about 30 fields..no time counting..but I noticed
>that I cannot go beyond 9 fields without ending with a semicolon.
The mysql program does not require that you enter an
I suggest using one of the windows GUI clients to modify tables, rather
than a command prompt (i.e. winmysql etc).
alan4100 wrote:
>
> I am creating a database called Meet_a_Geek at MS DOS prompt. The customer table has
>about 30 fields..no time counting..but I noticed that I cannot go beyond
Dear mysql people:
I am trying set up a dataset in mysql version 3.23.42 on a Mac OS X
Server v10.2.
When I use the "load data" statement, only one record gets read into the
table.
If I edit the file and remove the top record, then when I give another
"load data"
command, mysql reads the n
mysql
Ignore this subject, pls..
On Wed, 2002-03-20 at 12:56, Paul DuBois wrote:
> >With Story_Content, we're happy to use the stricter MATCH selects. So is
> >it possible to do something like Select * from stories where
> >MATCH(Story_Content) against ('param1') AND Writer LIKE "param2%" or am I
> >barking up the wrong (b-) tr
The problem isn't inserting table schema/data - I know how to do that.
I'm referring to the process of inserting an actual FILE (txt, .bat, .jpg)
via command line. And of pulling it out and giving it a name (test.txt).
> -Original Message-
> From: Mark Horton [mailto:[EMAIL PROTEC
Hi all,
It's urgent I upgrade my mysql server with some rpm that I found elsewhere
on the web
But when accessing db I was rehected.
Ii d like an easy way to recover my password or to put a blank pass like it
was !
see what I ve got !
www:~# mysql
ERROR 1045: Access denied for user: 'root@local
Hi,
On Thu, 2002-03-21 at 01:03, Leecher wrote:
> I installed mysql-3.23.49-win on Windows 2000 to drive D: (the installer
> lets one choose the location). After reading the docs, I can see that I need
> to start the daemon like this:
> mysqld --basedir d:\mysql
> However, when I do it I get this
On Wed, Mar 20, 2002 at 11:42:00AM -0800, Lance Prais wrote:
>
> Does anyone know of any good PL SQL Oracle Lists?
How is that considered "important" let alone "on-topic" for a MySQL
mailing list?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 F
Hi Lance,
On Thu, 2002-03-21 at 03:18, Lance Prais wrote:
> 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 th
This might help
http://ecn.www.ecn.purdue.edu/ECN/Documents/VI/
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 1:46 PM
Subject: Cannot access the Database on same Machine
> colin,
> Tuesday, March 19, 2002, 11:04:3
you can edit this file by going into the directory where the file is located
by typing vi filename.Extention.
To save changes hit esc key and the :w and then :q to quit.
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002
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
-
Folks:
I think you are on the right track with that Gerald..
I deleted all the files in my data directory (they were just the ones that
mysql_install_db creates) and then ran mysql_install_db --user=mysql
This time, nothing was created, no files, or anything, cant even find an
error message t
Hi all..
I noticed that the current version of InnoDB that is part of MySQL 3.23.47
does not allow using null foreign keys when doing inserts.. Is this
intentional or a bug? This is allowed by SQL Server as a minimum (a test
is being done by a co-worker currently against Oracle 8i to see how
Hi Sasha,
Ooops ok, LANG is for FreeBSD. I misunderstood. I don't know SuSE
Linux but on my Mandrake Linux system I have this:
[ken@nx01 ken]$ set | grep -i lang
LANG=en
LANGUAGE=en_US:en
RPM_INSTALL_LANG=en_US:en
langfile=/etc/sysconfig/i18n
I am not sure how this works (I prefer freeBSD).
I am creating a database called Meet_a_Geek at MS DOS prompt. The customer table has
about 30 fields..no time counting..but I noticed that I cannot go beyond 9 fields
without ending with a semicolon. Also another problem crops up when I tried to
recreate the customer table with the remaining fi
Check ownership and permissions of MyDatabase_copy directory (and maybe
the files).
On Wed, 2002-03-20 at 02:01, Ashwin Kotian wrote:
> I'm using the following syntax to backup one of my Mysql databses using
> mysqlhotcopy:
>
> #/usr/bin/mysqlhotcopy --allowold MyDatabase MyDatabase_copy
>
> T
On Tue, Mar 19, 2002 at 02:08:17PM +0530, Charitha wrote:
>
>
> Hello all,
>
> Can i use rsync instead of replicating two servers for mysql(
> particular database db). If yes Then just clear off my doubt
> whether it will lead to any data loss as while doing rsync.
If the data on the "master"
select * from accounts where duedate<=convert(float,getdate())
- Original Message -
From: "Chuck PUP Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 12:31 PM
Subject: Date and SQL statement
> I need to do a search where I am looking at the table that h
Hi,
The problem was due to permissions in the end, i used
the following commands to get into the database:
shell> chown -R root .
shell> chown -R root ./bin
shell> bin/safe_mysqld --user=root &
bin/mysqladmin version
.
.
bin/mysql
I can now use the database, but it still doesn't
explain why i
I'm trying to make a connection from a java app to a MySQL database I've
created on my local PC. How can I tell the app where to look for the
existing database?
Code I'm working with:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con =
DriverManager.getConnection("jdbc
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?
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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);
> +--+--+---+--+-+--+-+---
> -+
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
>
>
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
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
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
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
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
$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) {
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
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
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
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
-
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 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
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.
>
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
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
-
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
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
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
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
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
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.
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
1 - 100 of 160 matches
Mail list logo
