Try using myODBC from mySQL, it is an ODBC driver. Use Generic ODBC driver
in listing of visio drivers, then choose the setup option to pick the
specific driver for myODBC.
It will work for reverse engineering but have been unsuccessful in getting
it to work generating a database.
David
Hi,
I was wondering if it's posible to make mysql listen on only one interface
(eth0, eth1 etC)?
Goja
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi
I was wondering if it's posible to make mysql listen on only one interface
(eth0, eth1 etC)?
Goja
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Pada Wed, 31 Jul 2002 09:41:45 +0300
Dogaru Dragos [EMAIL PROTECTED] menulis :
Hi,
I was wondering if it's posible to make mysql listen on only one interface
(eth0, eth1 etC)?
just add on your mysqld options
--bind-address=IP - Ip address to bind to
--
Write clearly - don't be
Hi.
For example one have a table with some fields including text(blob).
Is it faster at all with SELECTs that doesn't use this(those) text
fields if they are moved into another table and linked using
primary key or it does not signify?
sql,query
Best regards Evgeny.
The the configure file and make file are so complicated. Could you tell me a
straightforward method to compile MySQL dynamicly. :-)
I want to run the MySQL upon NGPT.
Thanks!
yours sincerely
Yu Ronghua (Jerry)
Intel China Software Lab
Tel: 021- 52574545 ext. 1328
INet: 8-752-1328
Hi!
I think that the problem that MySQL complains about an uncommitted open
transaction in RENAME TABLE has been reported before. I will take a look at
this. The fix will probably be in 3.23.52.
The behavior that you cannot roll back a RENAME TABLE is as expected. To
perform a data dictionary
The the configure file and make file are so complicated. Could you tell me a
straightforward method to compile MySQL dynamicly. :-)
I want to run the MySQL upon NGPT.
Thanks!
yours sincerely
Yu Ronghua (Jerry)
Intel China Software Lab
Tel: 021- 52574545 ext. 1328
INet: 8-752-1328
i've read up and am able to add users with encrypted passwords.
what i want to do is restrict a user to a database.
in the mysql db there is the users table and the db table. i understand
that permissions in the users table override those of the db table.
so what i do is this:
1) create a
I posted a query on this a couple of days ago, but have tried an alternative
tack.
Using MyCC to add a field to a table, I get an error
[localhost] ERROR 7: Error on rename of '.\rocktest\companies.MYI' to
'.\rocktest\#sql2-15c-15.MYI' (Errcode: 13)
But If I use mysql from the command line
Hello everybody
I'd like to know what does that means: Writing to net in the state row of
processlist.
I have to launch a perl script which do traitement on a mysql table with
1.750.000 records.
The request blocks during a long time everytime on the select of the hole
table and i can see in
This is my first post here.. So be nice! ;)
I have a database with a little over 60,000 records and when I do a search
on that db it takes a little over a minute and a half to return results.
This is very unacceptable, but Im just not sure what I can do to remedy
this. Here is what the query
well this seems to be a very controlled list, this reply had been blocked,
suggestion is to put some keywords in it like sql,query. ok then here it is,
sql query
although i have received some posts to stop this thread i will reply one
more time.
following is what i had intended to write, but did
Hello to everybody,
I installed mysql ver 11.17 distrib 3.23.49a on redhat
7.2.
I would like to import data into database table using
command line instructions.
I tried mysqlimport but I got the following error
messagge
mysqlimport: Error: The used command is not allowed
with this MySQL version,
hai everybody,
i have a problem with query.I have no idea about it,whether it can be done
or not.i want to query out name order by alphabet,The range is provided like
Aa - Ad.
so the result should be like this:-
Browse Aa to Ac
Name
A
Aa
aa
Aabenraa
Aachen
Aakjaer, Jeppe
Abadan
Abaddon
not an sql query
Heh, Get a bigger mail box I guess ;-) Or unsubscribe your self while
you're out.
true, but more hassle
Has anyone ever suggested a put-on-vacation command for this (or any?)
list server?
I'm thinking a put-on-vacation and put-off-vacation commands would not
need the
Please !
I thought I had this working, but it seems unfortunately not !!!
I'm trying to list events for each month and my select query is as follows
SELECT DISTINCT t_city_name,t_city_id_city FROM
t_city,t_zipcodecity,t_location,t_event WHERE (t_city_id_city =
t_zipcodecity_id_city) AND
Description:
If an update is made to a master using the syntax
'INSERT INTO database.table' etc... on a mysql connection
where no 'USE database' command has been given then the updates
are written to the master binary log correctly, and update
the slave
hi,
I have some sql code that I need to use with mysql
it uses nested queries and since mysql doesn't implement them
I would like to know how to do this.
SELECT * FROM apartamentos
WHERE vendido=0
AND Concelho=$row[ConcelhoP]
AND Localidade LIKE '$row[LocalidadeP]' ...
WHERE Referencia NOT
MySQL does not support sub-queries. Take a look at JOINS
(http://www.mysql.com/doc/J/O/JOIN.html)
- Original Message -
From: Luis Rodrigues [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 6:03 AM
Subject: Problem with subqueries
hi,
I have some sql code that I
No can do. Replication is one-way.
You can, however, have multiple Slaves.
- Original Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 12:35 AM
Subject: Replication Circle
Hello,
Is there a way to have DB-A and DB-B such that DB-A is
On Wed, 2002-07-31 at 12:03, Luis Rodrigues wrote:
hi,
I have some sql code that I need to use with mysql
it uses nested queries and since mysql doesn't implement them
I would like to know how to do this.
SELECT * FROM apartamentos
WHERE vendido=0
AND Concelho=$row[ConcelhoP]
AND
Description:
When joining tables using a SELECT statement and using the DISTINCTROW modifier, I
noticed a difference in the resultset by adding the ORDER BY directive on the end of
the SQL command on a column that is not included in the result. If no join is
performed and the
Hi,
this bug was reported to fixed in 3.23.38.
But the mysql vesions 3.23.49 and in 4.0.2
both look like the bug is in them again.
Example:
The following query should use the index on
dog.dog_timestamp_cr but uses filesort instead.
mysql EXPLAIN SELECT dog.dog_id, dog.dog_name,
* Bhavin Vyas
Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
is the slave. However, I also want to make DB-B the master and DB-A it's
slave so that if I have to fail over to DB-B then DB-A is automatically
following the changes. It doesn't seem probable that this
Hi folks,
I am the maintainer of NSS MySQL which is, as you may have guessed, a
nss module using MySQL as backend. It shares a mysql connection between
threads. As explained in the documentation, I use my_thread_init and
my_thread_end functions to properly manage that situation.
As you may
* saraswathy saras
i have a problem with query.I have no idea about it,whether it
can be done
or not.i want to query out name order by alphabet,The range is
provided like
Aa - Ad.
so the result should be like this:-
Browse Aa to Ac
Name
A
...hm... 'A' is not in the range 'Aa' -
Hello everybody.
I was running a web server with mysql-server 3.22.32-log
on a debian box and using perldbi as an interface
from html pages and mysql-server.
I upgraded the dedian package to 3.23.49-log and I am not able anymore to
connect
I use the following PERL sintax:
# database
-Original Message-
From: Simon Hester
Sent: Tuesday, July 30, 2002 4:31 PM
To: '[EMAIL PROTECTED]'
Subject: Install MySQL from the command line
Hello
OS= Windows 2000 Professional
Mysql Version = Mysql servers and clients 3.2.51
I would like to be
Hi,
I am looking for a way to automate the way i take backups.
I run mysql on w2k server and I seek for a way to take backups of the
database at certain times automaticaly.
Is out there any suggestion?
thanks..
-
Before
* Richard Baskett
This is my first post here.. So be nice! ;)
:)
I have a database with a little over 60,000 records and when I do a search
on that db it takes a little over a minute and a half to return results.
That sounds slow, yes.
This is very unacceptable, but Im just not sure what
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
structure to a
Did you also update the perl DBI modules to match?
Luca Bonci wrote:
Hello everybody.
I was running a web server with mysql-server 3.22.32-log
on a debian box and using perldbi as an interface
from html pages and mysql-server.
I upgraded the dedian package to 3.23.49-log and I am not able
On Wednesday 31 July 2002 05:17 am, Richard Baskett wrote:
This is my first post here.. So be nice! ;)
OK, no flames ;o).
I'd want a bit more information in order to really diagnose this. The first
thing I would tell you to do is to EXPLAIN this query. To do that just tack
the keyword
Here's the doc page.
http://www.mysql.com/doc/S/o/Sorting_rows.html
Later,
Larry
From: DonPro [EMAIL PROTECTED]
Subject: Key in reverse order
Hi, I have a MySQL table key on a 7 character VarChar field. Th efile
contains
numeric characters only which I've inserted right justified. Is there
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 8:38 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Backup automation..
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files
Hello,
I have just imported from a textfile database to mysql.. In the
database table, I have the following values:
Id. date
00ca. 1900
011900
021900-tallet = meaning 1900 - 1999
031950-tallet = meaning 1950 - 1959
041500-1600
...
I want to use
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for
windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
structure
Kevin,
Wednesday, July 31, 2002, 7:27:22 AM, you wrote:
K I am hosted on a shared/virtual hosting plan and would like to backup the
K one of the mysql tables on a daily basis. mysqldump is not available.
K I attempted to run the query - SELECT * INTO OUTFILE
K '/path/to/my/file/file.sql' FROM
stcuppet,
Wednesday, July 31, 2002, 3:04:45 PM, you wrote:
Description:
s When joining tables using a SELECT statement and using the DISTINCTROW modifier, I
noticed a difference in the resultset by adding the ORDER BY directive on the end of
the SQL command on a column
s that is not included
von,
Wednesday, July 31, 2002, 3:06:12 PM, you wrote:
vB this bug was reported to fixed in 3.23.38.
vB But the mysql vesions 3.23.49 and in 4.0.2
vB both look like the bug is in them again.
vB Example:
vB The following query should use the index on
vB dog.dog_timestamp_cr but uses filesort
Guilherme,
Tuesday, July 30, 2002, 10:12:57 PM, you wrote:
G Is there any option to substitute Triggers or Stored Procedures on MySQL?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
tlr7425,
Wednesday, July 31, 2002, 10:49:13 AM, you wrote:
t i've read up and am able to add users with encrypted passwords.
t what i want to do is restrict a user to a database.
t in the mysql db there is the users table and the db table. i understand
t that permissions in the users table
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for
windows.
For a cleaner, and what most people would say is a better way you could
schedule a batch file to run mysqldump that would dump the data and
Thanks.
On 31 Jul 2002, Martin Waite wrote:
On Wed, 2002-07-31 at 12:03, Luis Rodrigues wrote:
hi,
I have some sql code that I need to use with mysql
it uses nested queries and since mysql doesn't implement them
I would like to know how to do this.
SELECT * FROM apartamentos
Aye, I forgot to mention to lock the db before backing up...my bad. But
again the idea is the same just schedule win2k to do it.
-Nick
Ed Carp said:
On windows you could simply copy the entire data directory with a
Scheduled job. Copying the files should be all you need to do for
windows.
are there indexes on the right fields? do a describe on the query and
let us know what you get.
On Wednesday, July 31, 2002, at 02:17 AM, Richard Baskett wrote:
This is my first post here.. So be nice! ;)
I have a database with a little over 60,000 records and when I do a
search
on that
I am also using win2k advanced server - what does the back-up syntax look
like if I wanted to to it on Windows?
thanks
Mark
- Original Message -
From: Nicholas Stuart [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 8:54 AM
Subject: RE: Backup
Hi All,
I am hoping this question has already been answered somewhere and I just can't find
it. I recently had my machine upgraded from WindowsNT to Windows2000. Since this
upgrade my access to my MySQL database is degraded noticeably. There seems to be a
constant delay when I connect to the
I'm glad to announce that the new version 1.0.15 is now available. Before
downloading it be aware that some of the mirrors are not yet updated and it
may take some time. You may use the ZEON Host mirror which has a large
bandwidth and is automatically updated.
The list of changes and new features
Hi all,
As I'm not very experienced with DB technology, I'm very sorry if my
question seems stupid.
I have set up a MySQL server as a central data repository where various
clients are to write and read data concurrently. One of the attrbutes
of the tables that are going to be managed by the
Cut, Copy, and Paste functions are not available in the SQL Query tool in
my MySQLManager tool. Any ideas? Thanks.
Mark Herzog
Contour Systems
Phone: (952) 935-0141
Cell:(612) 207-6530
Email: [EMAIL PROTECTED]
-
If you've got to make copies to disk then why not just maintain copies on
disk via replication? Stop the slave, backup the slave, restart the slave.
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 8:55 AM
To: [EMAIL PROTECTED]; [EMAIL
Hi all,
I gave not enough info about indexes. Use SHOW INDEX FROM table_name
sorry, now 2nd try with more info.
This bug was reported to fixed in 3.23.38.
But the mysql versions 3.23.49 and in 4.0.2
both look like as the bug is in them again.
Example:
The following query should use
Mysqlfront works well, though I don't believe you can cut.
-Original Message-
From: Mark Herzog [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 10:02 AM
To: [EMAIL PROTECTED]
Subject: Cut Copy Paste
Cut, Copy, and Paste functions are not available in the SQL Query tool in
my
Yes, just change the row in some way(or insert a row), and it will insert the date
automatically. (be sure to insert null in the timestamp field, or leave it out of your
update query)
I use the feature for many things.
Thanks
dan
-Original Message-
From: [EMAIL PROTECTED]
Desmond Lee [EMAIL PROTECTED] writes:
Hi there
I'm doing fine with the command line interface of mysql, no complaints
from me. Howerver, another team member who knows nothign about mysql
is more familiar with the windows stuff like access. Is there an
graphical interface for mysql on red
You can also use Microsoft Query or Microsoft Access to construct queries if you're
running Windows.
-Original Message-
From: Dan Vande More [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 11:35 AM
To: Mark Herzog; [EMAIL PROTECTED]
Subject: RE: Cut Copy Paste
If you use IGNORE in the insert IGNORE into new_table you will get the
result you want.
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 3:11 PM
To: David Kramer; [EMAIL PROTECTED]
Subject: Re: removing duplicate records
Thanks David!
The
Ok here is the EXPLAIN query:
table, type, possible_keys, key, key_len, ref, rows, Extra
Employers, ALL, NULL, NULL, NULL, NULL, 46175, where used; Using temporary;
Using filesort
Jobs, ref, EmpID, EmpID, 4, Employers.EmpID, 3, where used
JobsLocation, ref, PRIMARY, PRIMARY, 4, Jobs.JobID, 581,
I decreased wait_timeout (from 28,800 to 300) to kill off sleeping threads.
This morning, the server stopped accepting connections and gave me this
error:
ERROR 1129: Host 'hostname' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
flush-hosts worked and I
On Tue, Jul 30, 2002 at 12:31:32PM -0400, Chris Friedline wrote:
hello everyone,
i'm a newbie so please excuse the probably dumb question.
i'm using monitoring software to record the number of processes at a current
time. currently, i'm just sending a show processlist and my monitoring
Hi,
Anywhere under Windows work next sequences:
Ctrl+x-cut selected text
Ctrl+c-copy selected text
Ctrl+v-paste
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
From create syntax, you cannot put , after VARCHAR(1). You have another ,
after AUTO_INCREMENT, maybe it is not correct too.
At 01:56 PM 7/31/2002 -0400, Larry Irwin wrote:
Using MySQL 4.02 on SuSE Linux 7.3
The MySQL docs at http://www.mysql.com/doc/C/R/CREATE_TABLE.html state that
CHECK
In the last episode (Jul 31), Richard Baskett said:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company
AS Comp, Jobs.JobID, Employers.EmpID
FROM Employers
LEFT JOIN Jobs USING (EmpID)
LEFT JOIN JobsLocation USING (JobID)
LEFT JOIN Location USING (LocID)
LEFT
I don't understand very well what you try to say ?
sql,query
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: Dan Vande More [EMAIL PROTECTED]; Mark Herzog [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 9:48 PM
Can anyone tell me if it is possible to connect to a MySQL server running on
Linux from a Windows Visual Basic application without setting up a DSN on
the Windows computer?
I know this can be done with MS SQL Server and I have heard it can be done
with Oracle so I am wondering if there is a
On Tue, Jul 30, 2002 at 01:37:26PM +0200, Mozzi wrote:
Hallo all
I have a database that corrupted.
I managed to save the
radacct.frm
radacct.MYD
radacct.MYI
radacct.TMD
files and recreate the table.This is just a logging file so no real
crisis if I lose some data.
How do I import
On Tue, Jul 30, 2002 at 10:34:36AM +0200, Inbal Ovadia wrote:
Hi All
Is MySQL works with XML?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 62 days, processed 1,313,326,706 queries (242/sec. avg)
On Tue, Jul 30, 2002 at 10:35:06PM -0700, Bhavin Vyas wrote:
Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
is the slave. However, I also want to make DB-B the master and DB-A it's
slave so that if I have to fail over to DB-B then DB-A is automatically
following
On Wed, Jul 31, 2002 at 10:54:54AM +0200, mr wrote:
Hello everybody
I'd like to know what does that means: Writing to net in the state row of
processlist.
I have to launch a perl script which do traitement on a mysql table with
1.750.000 records.
It means just what it says--MySQL is
Hello,
I'm having really strange problems with characters when retrieved to Java from MySQL.
On some columns (or if it is in some tables) it works, in others it do not. I have
checked what charset Java thinks it should be, and that is cp1252 in both cases. I've
checked the list of MySQL
I get the following error when installing the MySql Binary in AIX:
exec(): 0509-036 Cannot load program mysql because of the following
errors:
0509-130 Symbol resolution failed for mysql because:
0509-136 Symbol stpcpy (number 125) is not exported from
I need to run a file called sms.sql from the command line. Is this
possible and what is the syntax?
Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
When they are searching sometiems they do not search for Location.. When
that's the case I leave the location string out, if they do not search for
Category, I leave the Category string out, but when they do.. That's the
query I get.. There has got to be a way of making this faster.. It seems
On Tue, Jul 30, 2002 at 10:04:33AM +0100, Andrew Bryant wrote:
How big have people pushed MySQL databases. Has anyone attempted
terabyte size databases, especially large database that are not just
read-only resources. Databases with some OLTP activity.
Well, I just got access to 0.8TB that
Scott Pippin wrote:
I need to run a file called sms.sql from the command line. Is this
possible and what is the syntax?
Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
In the last episode (Jul 31), Richard Baskett said:
When they are searching sometiems they do not search for Location..
When that's the case I leave the location string out, if they do not
search for Category, I leave the Category string out, but when they
do.. That's the query I get.. There
Subject: Re: Speed issues...
From: Jared Richardson [EMAIL PROTECTED]
===
Richard Baskett [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
This is my first post here.. So be nice! ;)
I have a database with a little over 60,000 records and when I do a search
on that db it takes a
i understand , it's your desire to said us that you don't know to much
about Windows.We can help you but not in this list.
I don't understand very well what you try to say ?
sql,query
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL
Ok I've Analyzed each table and it looks like it has cut around 20 seconds
off of the average time.
Im trying to figure out how I can take out the left joins.. I need some of
that data to be displayed to the user.. Would it be quicker to get rid of
the location and category left join and then
The problem with upgrading hardware is that it belongs to the host, not to
us :) So that's why I was hoping to be able to optimize the query as much
as possible and then if that still doesn¹t work, email my host and see if
they can upgrade their hardware...
Cheers!
Rick
Continuing to cling to
Actually if I just run the Location/Category query once and throw it into an
array, then take the variables that way.. That should cut off that part of
the MySQL query.. Very nice! You've given me a light.. This tunnel was
really beginning to get dark.. :)
Thanks! And of course anymore ideas
Make sure you're using the latest version of the driver (2.0.14 right now)
from http://mmmysql.sourceforge.net/
Also, make sure you add useUnicode=true to your URL if you're not going to
be using straight ASCII.
-Mark
- Original Message -
From: Daniel Flöijer [EMAIL PROTECTED]
To:
Im looking for info on Mysql's Bulk Data Loading Utility? Does it even have
one? Does it just use Perl's DBI? Any syntax would be greatly
appreciated...
Thanks,
DK
David Kramer
Software Developer
Reflect.com
Direct: 415.369.4856
Cell: 650.302.7889
In the last episode (Jul 31), Richard Baskett said:
Ok I've Analyzed each table and it looks like it has cut around 20 seconds
off of the average time.
Im trying to figure out how I can take out the left joins.. I need
some of that data to be displayed to the user.. Would it be quicker
to
In the last episode (Jul 31), David Kramer said:
Im looking for info on Mysql's Bulk Data Loading Utility? Does it
even have one? Does it just use Perl's DBI? Any syntax would be
greatly appreciated...
Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html . It's a
stripped-down version of
Any suggestions on replicating data from DB2 files to a mysql database
across a network? Is it possible to link a mysql table like to a portion of
the DB2 data/tables then hotcopy is across the network to the remote
database?
Thanks
Jon
Bhavin,
Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
Can't help you with the replication question - but here is a replication
answer - have everyone in your installation repeat after me: the DBA is
your master! (and say it again...and again...)
=dn
List fodder:
Is it possible to use MySQL with a chinese charset (utf8) ?
If not, what do you suggest to do if I want to develop a database for a
chinese web site ?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi Folks,
Have only known enough SQL to do what we needed.
Today on mysql-3.23.51 we found out that :
select something from table where index1 = 'value' or index2 = 'value';
Runs considerably slower than:
select something from table where index1 = 'value';
or
select something from table
We just brought a database back up after bringing it down for a hardware
upgrade (added hard drives) and after we brought it back up it started
crashing a lot. The queries that crash it vary. I realize it might be
simple case of database corruption (the data files are now on a
different
Mascon from Scibit (www.scibit.com) has cut, copy, and paste in its query
manager.
Cut, Copy, and Paste functions are not available in the SQL Query tool in
my MySQLManager tool. Any ideas? Thanks.
Mark Herzog
Contour Systems
Phone: (952) 935-0141
Cell:(612) 207-6530
Email: [EMAIL
This almost belongs on the bugs list, but I don't have a stable, sure way
to trigger it.
Symptoms:
mysqld locks itself in a tight loop, consuming all available CPU cycles.
a simple kill sometimes kills the daemon, other times a -9 is required.
While in this state, any access to the daemon stops
Hello everyone,
We can find at mysql documentation, that using transaction may slow down
up to 4 times mysql. This because working with transfaction means to do
a lot of things while updating tables. I'm currently working in a system
where in some cases (very few cases) I realy need to use
I'm trying to start up mysql through dos prompt. When I enter a command
like c:\mysql\bin\mysqld or anything similar (any command in the bin
directory), it just waits there. I can't Ctrl-C out of it. I can end the
process to get out. What's happening?
--
Shion Deysarkar
myODBC and MS Access will let you link (live) to a mysql database. Is there
a way to get the mysql linux client to link to another database system?
Could mysql create a live view of data from a as400/DB2 table ? Using odbc I
presume ?
Thanks
Can someone provide insight into what a good maximum number of
columns is in a MySQL database? I have an extensive list of variables
for an engineering application which number in the 700+ range with
more additions possible down the road. My question is: should I break
up the variables into
Hi All,
I am Arup based at Kolkata India. Mysql problem: when I am trying to
insert a record to a table after 10 or so records I get Insert Failed
but no mysql_error(). I am using php4
see: holland.info/search/qs.php?q=mysqlall=1
Regards,
Arup Bhanja,
Kolkata, INDIA.
Content is king - but
The website works fine for me, Bhanja. It seems like a select query, so I
wonder why you would expect an insert failed error? How do you get to know
that you get an insert failed error?
Some more info would be useful. You say, When I am trying to insert *a*
record, after *10* or so records --
1 - 100 of 101 matches
Mail list logo