Hi,
I've a situation where I want to put an ascii file as a set of rows in a
table (one per line), whereas it may appear that some do already exist.
In either case, I'm looking for 1 command that just puts the set of rows in
the table. Is that possible in MySQL?
In normal behavior, this would
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
salamat kabayan!!
thnx!
=
Thanks,
Louie Miranda...
WebUrl: http://axis0.endofinternet.org
Email: [EMAIL PROTECTED] - [EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 15, 2002 11:02 AM
Subjec
Having a hard time coming to grips with the password setup for mysql in
windows. I follow the instructions below from the documentation.
C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysq
At 10:36 +0800 8/15/02, louie miranda wrote:
>Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for
>pc-linux-gnu (i686)
>my db(var) resides in /usr/mysql/var/. I have this new server which i have
>mysql too.
>Now what im thingking about is, instead of dumping all database/tab
Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for
pc-linux-gnu (i686)
my db(var) resides in /usr/mysql/var/. I have this new server which i have
mysql too.
Now what im thingking about is, instead of dumping all database/tables on my
old redhat
server. Compressing and movin
At 17:37 -0700 8/14/02, Richard Baskett wrote:
>Is there a way to combine these queries?
>
>SELECT count(SeekID) FROM Seekers
>WHERE DateLastLog(NOW()-INTERVAL 7 DAY)
>
>SELECT count(SeekID) FROM Seekers
>WHERE DateLastLog(NOW()-INTERVAL 1 MONTH)
>
>Or these?
>
>SELECT count(ResumeID) FROM Resumes
Hi all.
Hello spam filter! sql. query.
I had to restore from a backup and run through part of the day's
transactions from the --log-update option ... I had accidentally deleted
2500 records, and wanted to replay the logs minus that one delete
command :-)
One problem which I encountered was tha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello--
I'm developing a client for a box office that uses MySQL as the
backend. I *was* using Access (yes, bad idea) but having converted to
MySQL I'm finding that I have to rewrite some nested SELECTs that
MySQL barfs on. Some of the queries are fa
On Thu, 15 Aug 2002 10:37, you wrote:
> Is there a way to combine these queries?
>
> SELECT count(SeekID) FROM Seekers
> WHERE DateLastLog(NOW()-INTERVAL 7 DAY)
>
> SELECT count(SeekID) FROM Seekers
> WHERE DateLastLog(NOW()-INTERVAL 1 MONTH)
SELECT
SUM(DateLastLog > (NOW()-INTERVAL 7 DAY)) AS
In the last episode (Aug 14), Mark Jones said:
> Thank you!!! It works!!
>
> I'm curious how the creation of the temporary table would behave in a
> web server environment. At which point does mysql delete the temp
> table? After the db connection instituted by the script disconnects
> (in my
Thank you!!! It works!!
I'm curious how the creation of the temporary table would behave in a web
server environment. At which point does mysql delete the temp table? After
the db connection instituted by the script disconnects (in my case, after
the Perl DBI database handle is disconnected)?
it means access denied. either cos you dont have permissions in your mysql
privilege table or your password is wrong. did you supply a valid username
and password in the command string?
- Original Message -
From: "Dave Reinhardt" <[EMAIL PROTECTED]>
To: "MySql Support" <[EMAIL PROTECTED]
Is there a way to combine these queries?
SELECT count(SeekID) FROM Seekers
WHERE DateLastLog(NOW()-INTERVAL 7 DAY)
SELECT count(SeekID) FROM Seekers
WHERE DateLastLog(NOW()-INTERVAL 1 MONTH)
Or these?
SELECT count(ResumeID) FROM Resumes WHERE testResume='1'
SELECT count(ResumeID) FROM Resumes
Hi.
On Wed 2002-08-14 at 15:06:02 -0700, [EMAIL PROTECTED] wrote:
> If you were here right now I would kiss you! Well not really, but I can not
> believe what that did!! It takes around 2-4 seconds now for the query to
> execute completely! I wish I understood when to use what type of join sin
seaport:/# mysqladmin -h `hostname` version variables
mysqladmin: connect to server at 'seaporthost.com' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
What does this mean?
Dave
-
Before posting
What is the purpose of creating the symlink if I
manually edit the data directory variable? Would it be
better to:
a) Move the data, and edit the data directory to the
new location
b) Move the data, and create a symlink to the new data
TIA,
--- Rahadul Kabir <[EMAIL PROTECTED]> wrote:
>
>
>
I am creating a VB6 application and using option = 1 in my connect
string to obtain the defined size for each column. This option does not
return the define size of VARCHAR columns but the current Maximum Value
in the Field. Any attemp to update a field with a string longer than
the Maximumn
For an example let's say that I have clients in multiple countries and I
want a list of the number of clients per country. In order to do this I
would think a statment like:
select country, count(*) clients from addresses group by country
would work just fine. I have have been working in VB on N
Hi
To help improve the performance, it would help knowing
- table structures, use show create table ;
- how many records in each table
- have all the tables being analyzed/optimized recently
Inner joins whilst very useful, do impact on performance. In some cases
it is more efficient to use a s
I wrote:
>> SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
>> Comp, Jobs.JobID, Employers.EmpID
>> FROM Location
>> INNER JOIN JobsLocation ON JobsLocation.LocID = Location.LocID
>> INNER JOIN Jobs ON Jobs.JobID = JobsLocation.JobID
>> INNER JOIN Employers ON Employ
If you were here right now I would kiss you! Well not really, but I can not
believe what that did!! It takes around 2-4 seconds now for the query to
execute completely! I wish I understood when to use what type of join since
it is very obvious to me that it matters, and matters greatly! Thank y
I am using DBD-mysql-2.1018 with a binary mysql_3.23.51 on Solaris 2.8.
I can get thru Makefile.PL and make without errors or warnings. However I
always get the same errors returned during make tests regardless of my
command line parameters.
Below is the Makefile.PL params that I used last afte
On 14 Aug 2002, at 14:46, Richard Baskett wrote:
> Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
> STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
> the new query:
You say the EXPLAIN output looks the same, so the 5 second savings is
just r
I am using 3.23.51 also
"Dost thou love life? Then do not squander time; for that's the stuff life
is made of." - Ben Franklin
> From: Rahadul Kabir <[EMAIL PROTECTED]>
>
> what version of mysql are you running? I was having similar problem then I
> upgraded my mysql to 3.23.51 and the problem
what version of mysql are you running? I was having similar problem then I
upgraded my mysql to 3.23.51 and the problem was solved.
Richard Baskett wrote:
> Ok Im still having some serious speed problems and obviously since more
> records are being added every day the problem is getting worse.
Hi there,
I posted this a few days ago and recieved no responses, so I thought I would
post it again:
Hi All;
I am working on a front end to my database, but I am running into a bit of
trouble. I have a user who has the proper privileges and grant option create
other users, but I need to know th
sql,query
Hello,
This might be off the topic, but I thought I'd ask in case anybody has an
answer. I downloaded the latest version of FreeMascon, but when I run the
installer, a Command prompt window opens and closes and then nothing
happens. Has anyone else installed FreeMascon on Win2K Serv
Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
the new query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Location
INNER
On 14 Aug 2002, at 14:09, Richard Baskett wrote:
> SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
> Comp, Jobs.JobID, Employers.EmpID
> FROM Employers
> INNER JOIN Jobs ON Employers.EmpID = Jobs.EmpID
> INNER JOIN JobsLocation ON Jobs.JobID = JobsLocation.JobID
> INN
Ok Im still having some serious speed problems and obviously since more
records are being added every day the problem is getting worse. Here is the
query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Employers
INNER JOIN Jobs
I'm having trouble with a vbulletin database running mysql as the back end.
It's running on linux server. Basically we had some weird problems and was
hoping someone else has seen this. First the boards went down because
somehow all the permissions on the table files in
/usr/local/mysql/var/ wer
My Linux installation only has about 1gb in the /var
partition, so I need to relocate my databases to the
/home partition. I'm pretty sure the following
commands will shutdown mysql, move the data directory,
create a symbolic link, and then restart mysql. My
question is, is this complete, or do I
On 14 Aug 2002, at 13:31, Sean C. Burbidge wrote:
> The query is: select t.lu_cn as cn,
> sum(if(strcmp(t.work_item_type, 'OPERATIONS'),
> t.reference_dollars_labor +
> t.reference_dollars_equip +
> t.reference_dollars_travel +
> t.reference_dollars_matl +
>
At 16:33 -0400 8/14/02, Michael McClennen wrote:
>I just noticed that creations and deletions of temporary tables are
>recorded in the MySQL binary log. My question is: during replication,
>are these transmitted and replayed on the slave servers? If so, could
>someone explain to me why? This wo
I just noticed that creations and deletions of temporary tables are
recorded in the MySQL binary log. My question is: during replication,
are these transmitted and replayed on the slave servers? If so, could
someone explain to me why? This would seem to be useless, since the
temporary tables ar
Hi,
- Original Message -
From: "Thomas Seifert" <[EMAIL PROTECTED]>
To: "Tod Harter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 14, 2002 10:19 PM
Subject: Re: Persisten Connections
> And I disagree with this view.
>
> If you've got a server with 512 MB RAM and r
sql,query
Hi,
Few days ago ,was someone(i try out to find in my e-mail list ...but i
didn't find him) which was wish to calculate some fields using variables
I don't know if this person it's solved his problem but today i meet a
similarly situation and i solved in the next way :
TABLE DEFINI
>Description:
HAVING Max(x) IS NULL always TRUE.
This has changed since 3.23.39, when if the x column had all Nulls,
Max(x) IS NULL was TRUE and FALSE otherwise.
>How-To-Repeat:
CREATE TABLE test1 (
ID int unsigned auto_increment not null primary ke
Is there a tool out there for Windows that will let me monitor how many
connections to my MySQL database are currently open at any given moment?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
My own server handle more than 200 queries per second (up to 800 queries per
second), and I use pconnect with a wait_timeout of 20 s only.
With a low wait_timeout number and a high number of queries per second I
think I have both the advantages of connect and pconnect (not too many IDLE
threads, b
Hasan,
The only way I was able to do this was by creating a database in MySQL with
the tables set up the same way as those in Access, exporting each table in
Access to a separate CSV file, and then using "LOAD DATA INFILE ..." to
import the data from the CSV files into the tables. Good luck.
Da
I am wondering if this will help me any, I currently serve 800K+ pageviews
all requesting mysql connections. 120 Queries Per Second. I'm wondering if
persistant connection will help me, and how I could go about it, if there is
40 different pages all using the same db/tables. I'm kinda new to mysql
It's why I think it's a good idea to lower the wait_timeout parameter, but
to still keep the pconnect.
(my server handle 1M pageviews/day (webserver and database))
Jocelyn
- Original Message -
From: "Thomas Seifert" <[EMAIL PROTECTED]>
To: "Tod Harter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROT
Thomas,
1. Yes different servers for webserver and database
is the key. They have competing priorities.
2. The 100kb estimate is db-dependent, no?
P.
> And I disagree with this view.
>
> If you've got a server with 512 MB RAM and running the webserver and the
> db-server on t
Hey,
I have four servers here, all identical when it comes to the hardware as
well as software (same installed packages).
Two of the servers run absolutely beautifully, not a single problem, but
the other two are plagues by insane load as soon as they start receiving
traffic.
The machines are
And I disagree with this view.
If you've got a server with 512 MB RAM and running the webserver and the
db-server on the same machine, 100 idling mysql-processes are a HUGE overhead.
At most if not every http-request requires a mysql-connection.
I did many benchmarks and I got a huge decrease of
Heh.. Only $150?? At the most.. Its $75/hour and is hardly what I call
resonable compensation as my clients pay more than that for database
services.
:P
But good luck in any event.
Daniel Gormley
Internet Developer
Cyberbasin Internet Services
http://www.c
I am encountering some strange behavior with the results returned from a
query on a table in MySQL. The query is:
select
t.lu_cn as cn,
sum(if(strcmp(t.work_item_type, 'OPERATIONS'),
t.reference_dollars_labor +
t.reference_dollars_equip +
t.reference_dollar
Hello,
My name is Sumeet Chahal and I work for Usability Sciences in Dallas, TX.
We will be conducting industry research for a large data modeling software
company. The results of this study will be used for product development and
marketing purposes. We are looking for people to participate
I'm trying to enforce one column of my table to contain strictly 6 chars.
string. However I've some columns of type VARCHAR (e.g name, etc.) so
mysql silently changes the column to VARCHAR.
Is there any way I can force the column to contain only 6 chars.
Thanks,
-Pushkar S. Pradhan
Sabdy Serrano wrote:
> I have installed in Linux Red Hat the server of MysQL, and I have the user
> management WEBMIN.
>
> >From a PC with Windows'98 and OOo 1.0.1 (F4) I connect (ODBC) to the server
> MySQL (Linux), and I can create my databases , but when I want to modify a field
> or record,
Hi,
The solution for this problem is to decrease the wait_timeout variable to
something more reasonable than 28800 seconds.
If you have a very loaded server, I thing a wait_timeout of 60s is great (in
my case).
However I hardly understand why in some cases mysql seems to be no able to
reused IDLE
Dear MySQL company,
How can I transfer datas from Microsoft Access database to MySQL database?
And also if you could please answer how can I transfer datas from Microsoft
Access database to SQL database.
Best regards.
Hasan
_
MS
At 11:14 -0400 8/14/02, Tod Harter wrote:
>On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote:
>
>I disagree entirely
>
>Persistent connections have little or nothing to do with increasing load!
>
>Given that you mention you are using PHP I'll assume you have mod_php running
>in Apache
Having done some further work (I re-built using 3.23.51) I have managed to
have the server startup and run, however I am still experiencing the :
020814 15:25:48 /usr/local/mysql-3.23.51/libexec/mysqld: Can't create/write
to file '/usr/local/mysql-3.23.51/var/host.domain.pid' (Errcode: 13)
Whic
I am preparing to do something similar, so I read your post with interest.
I think that the excel cells that only contain alpha characters will have to
have quote marks added in excel. I am thinking of writing a macro to check
my string columns and add quotes if necessary. The resulting csv
I am preparing to do something similar, so I read your post with interest.
I think that the excel cells that only contain alpha characters will have to
have quote marks added in excel. I am thinking of writing a macro to check
my string columns and add quotes if necessary. The resulting csv
We are in Agreement on this point Gerald. I would prefer Mysql to
Postgresql. The problem is that the shop where I work had a major Oracle
system - full of triggers and functions (Oracle $$$ - Yuck!). So the
decision was made to move to Postgresql. The systems that I developed have
been based up
Hi All (Gerald),
Not sure why that should make a difference as the daemon is trying (it
claims) to write to /usr/local/mysql/var.
Have updated the privs :
from ls -al /usr/local/mysql/var
total 32
drw-rw-rw- 4 mysqlmysql512 Aug 14 11:27 .
drwxr-xr-x 12 mysqlmysql512
here is is ...
'check to see if agent/dist code are already in temp table
sSql = "SELECT *" & _
" FROM TempSap " & _
" WHERE ProducerID='" & FixSQLString("" &
rs3!WritingAgentID) & "'" & _
Let us know how your support issues are addressed when you have your
first problem.
Mine were never even acknowledged on the postgresql group.
That was the reason I went with MySQL. I have never regretted it.
Norris, Joseph wrote:
>Group,
>
>I have to move my work from Mysql to Postgres ( polit
That is really odd, because I don't see a select statement anywhere.
Mary Stickney wrote:
>SQL QUERY SQL QUERY
>
>
>I inserted a row , and set the sales to 0 for the years that there is none ,
>and set the sales to the sales amount for th years
>that there were some
>
>
>INSERT INTO TempSap
Selon Thomas Spahni <[EMAIL PROTECTED]>:
>
> what is your character set in use? (do: mysqladmin variables | less)
> I assume you have latin1.
Yes, you're right, my mysql server uses latin1.
> sql/share/charsets/latin1.conf maps character E8 (=é) to 45 (=E) in the
> sort_order array. This is no
Group,
I have to move my work from Mysql to Postgres ( political decision ) - Need
any and all recommendations for books on advanced SQL. Mysql is a holds a
lot less to the standard than
postgres - or so it seems and I need to look more at standard SQL for some
of the things that
I am doing.
Th
Hi,
The best way to speed up your query would be to create a compound index
on (first,last):
create index first_last on subscriber(first,last);
In this case, mysql will use it for both fields instead of doing a
linear search for the second one.
In order to reduce index size without loo
On Wed, 14 Aug 2002, Ludovic GENOT wrote:
> I need to make search in mysql with "accent sensitive" request.
> It seems that my MySQL server (3.23.41) request are accent insensitive.
> Is there an option to make mysql "accent sensitive".
>
> When I launch "SELECT * FROM table where name LIKE 'Jos
SQL QUERY SQL QUERY
I inserted a row , and set the sales to 0 for the years that there is none ,
and set the sales to the sales amount for th years
that there were some
INSERT INTO TempSap
(taxid,Company,FirstYear,SecondYear,ThirdYear,ThruDate,WritingAgentID,GroupI
D,
NewCasePercent,Region
Wednesday, August 14, 2002, 5:53:22 PM, Eduardo wrote:
ES> Helo,
Hi!
Eduardo, first of all, don't send me questions. Please, send them to
the mailing list.
ES> How do I verify if a table already exist on my database ?
ES> In Oracle there is an o
walt wrote:
> I've run into a weird problem. If I try to insert this value, 78978978,
> into a FLOAT(9,2) column, the value changes. See below.
> System info:
> MySQL-shared-3.23.51-1
> MySQL-client-3.23.51-1
> MySQL-devel-3.23.51-1
> MySQL-Max-3.23.51-1
> MySQL-3.23.51-1
> Red Hat Linux release 7
On Wed, 14 Aug 2002, Jean-Pierre Georgin wrote:
> I saw in the MySQL documentation that the myISAM tables maximal size was 8
> millions TB. But I couldn't find any information about the maximum number of
> tables it can support. Can you give me this information ?
Bonjour Jean-Pierre,
each MyISA
On Tuesday 13 August 2002 06:50 pm, Steinar Kolnes wrote:
Just create indexes on first and last, that should improve the speed of your
query drastically. It will of course be a BIG index. You might experiment
with only making the width of the index small, like maybe 8 or 10 characters
might be
* Jean-Pierre Georgin
> I saw in the MySQL documentation that the myISAM tables maximal size was 8
> millions TB. But I couldn't find any information about the
> maximum number of tables it can support. Can you give me this information
?
There is no limit in mysql, but there may be one in the OS
I've run into a weird problem. If I try to insert this value, 78978978,
into a FLOAT(9,2) column, the value changes. See below.
System info:
MySQL-shared-3.23.51-1
MySQL-client-3.23.51-1
MySQL-devel-3.23.51-1
MySQL-Max-3.23.51-1
MySQL-3.23.51-1
Red Hat Linux release 7.3 (Valhalla)
#Wrong
mysq
On Wednesday 14 August 2002 07:03 am, Balaji Nallathambi wrote:
I think you're expectation is simply wrong.
In MySQL recent versions if you use InnoDB tables you can create a 'foreign
key' constraint. All this means is that you cannot create a record in a
dependent table where the same value
Hello,
I need to make search in mysql with "accent sensitive" request.
It seems that my MySQL server (3.23.41) request are accent insensitive.
Is there an option to make mysql "accent sensitive".
When I launch "SELECT * FROM table where name LIKE 'José';"
I just want José in the answer and not J
On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote:
I disagree entirely
Persistent connections have little or nothing to do with increasing load!
Given that you mention you are using PHP I'll assume you have mod_php running
in Apache. Each Apache child process in this configuration
I had the same problem.
It occurs when you try to load (3.23.51 or higher) dump file to lower
version of MySQL.
Look at this line...
> /*!4 ALTER TABLE mobile_dev DISABLE KEYS */;
As soon as version is not equal 4 everything in comments will be
deleted.
So we have
> ;
empty query.
Mikhai
At 15:27 +0100 8/14/02, John Wards wrote:
>I have read somewhere that persistent connections in MySQL have a default
>timeout of 8 hours. How would I reduce this?
For interactive clients, set the interactive_timeout server variable to
the number of seconds of inactivity before timeout. For non-i
jan,
Tuesday, August 13, 2002, 12:34:23 PM, you wrote:
jb> Hello i got a problem with mysqldump,
jb> i'm forced to dump it to to place the database on a new laptop
jb> mysql -u root -p hardwaredb < hardwaredbbackup.sql
jb> Enter password:
jb> ERROR 1065 at line 25: Query was empty
jb> and t
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the maximum number of
tables it can support. Can you give me this information ?
Thanks a lot !
-
I have read somewhere that persistent connections in MySQL have a default
timeout of 8 hours. How would I reduce this?
Cheers
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Subject: Re: [cobalt-users] glibc download
Date: Tue, 13 Aug 2002 11:26:57 -0700
From: Brian Quinn <[EMAIL PROTECTED]>
To: Rahadul Kabir <[EMAIL PROTECTED]>
>Yeah i installed the new glib and still can't get it to work.
>I got PHP4 to work fine after upgrading, but not mySQL
>I always see people
it will reduce the load for sure!
MySQL is very fast in opening and closing connections at least if the database-server
and webserver are on the same machine.
I don't know how it will perform on different machines.
Thomas
On Wed, 14 Aug 2002 14:40:31 +0100
"John Wards" <[EMAIL PROTECTED]> wrote
Look again.
/usr/local/mysql is owned by root.
Mark Gillett wrote:
>Hi all,
>
>Have built mysql (mysql-3.23.49.tar.gz)
>
> --prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enable
>-assembler
>
>on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended
Patrick,
Wednesday, August 14, 2002, 4:27:58 PM, you wrote:
PS> I know I must be having brain gas, but where are the MySQL source
PS> distributions currently?
On the MySQL web site, of course:
http://www.mysql.com/downloads/index.html
--
For technical support contracts, goto https://or
I am running a website which generates around 100,000 pageviews a day and I
am wondering if I stop using persistent conections to the MySQL database and
use
normal open and close conections this would reduce the load onto my server?
Most conections are either made through my "main" file or the ph
Send the set autocommit=0 just as you send any other query in perl.
Bob Boden wrote:
>Attempts to disable auto-commit mode in Perl using the DBI command
>$dbh->{AutoCommit} = 0; returns the following message, "Transactions not
>supported by database".
>
>I am using the latest version of MySQL-
- Original Message -
From: "Patrick Sherrill" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 14, 2002 9:22 AM
Subject: MySQL Source Dist.
I know I must be having brain gas, but where are the MySQL source
distributions currently?
Pat...
---
I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
> I'm trying to set up a replication database and cannot get the slave
> to parse the log files on the master.
> The slave is connecting to the master as indicated in the log file.
>
> I have trie
l,
>
> I want to create an one to one relationship among
> tables using SQL. How can i do this. I creates an
> relation but it dose not expect my needs. For Ex they
> are two table say tbset nad tb tbprocess. If i set an
> one to one relation between the two tables in which
> the master table is
Balaji,
Wednesday, August 14, 2002, 12:15:14 PM, you wrote:
BN> I want to create an one to one relationship among
BN> tables using SQL. How can i do this. I creates an
BN> relation but it dose not expect my needs. For Ex they
BN> are two table say tbset nad tb tbprocess. If i set an
BN> one to on
Aron,
Tuesday, August 13, 2002, 4:58:40 PM, you wrote:
AP> Sorry, but I can't seem to locate the page that addresses this question
AP> specifically -- so, what version is scheduled to support views?
Views will come around v5.1
--
For technical support contracts, goto https://order.mysql.com
javier,
Wednesday, August 14, 2002, 12:51:10 PM, you wrote:
>> Hi, I would like to change the name of one column of
>> a
>> table.
>>
>> I did:
>> ALTER TABLE name_table ALTER COLUMN old_column
>> RENAME
>> new_column
>>
>> but it did not work due to don't understand a RENAME
>> after ALTER COL
Keith,
Tuesday, August 13, 2002, 12:20:28 AM, you wrote:
KJ> Is this command supported under version 3.23.51?
Nope. This command is supported since 4.0
KJ> SHOW NEW MASTER FOR SLAVE WITH MASTER_LOG_FILE='logfile' AND
KJ> MASTER_LOG_POS=pos AND MASTER_LOG_SEQ=log_seq AND
KJ> MASTER_SERVER_ID=ser
Mike,
Wednesday, August 14, 2002, 1:09:40 AM, you wrote:
MH> I am working on a front end to my database, but I am running into a bit of
MH> trouble. I have a user who has the proper privileges and grant option create
MH> other users, but I need to know this: can that user delete users he has
MH>
Hi all,
Tho this is a Visual C++ Group i hope that i will get
the result for my quesion with lot of hopes.
I want to create an one to one relationship among
tables using SQL. How can i do this. I creates an
relation but it dose not expect my needs. For Ex they
are two table say tbset nad tb tbpro
Hi all,
Have built mysql (mysql-3.23.49.tar.gz)
--prefix=/usr/local/mysql --with-named-z-libs=no --with-low-memory --enable
-assembler
on a new Solaris machine that we have (v 2.8, patched to June 8_Reccomended
patch level).
The configure, make and install seemed to go ok and were done
Hi,
If you have 512 simultaneous connection MySQL could eat up to 128 + (8 + 1)
* 512 = 4736 MB of memory
What is your max_used_connections (displayed with SHOW STATUS;) ?
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "ThomasSeifert" <[EMAIL PROTECTED]>
Cc: <[EMAI
1 - 100 of 111 matches
Mail list logo
