There are really only two. mm.mysql (varisous version)
and the twz one.
I suggest the mm.mysql one. They are both type 4 I believe there
is no reason to choose the twz one over the mm one.
I would use the latest 2.0 version unless you have code that
would have a problem with it then you can u
Kenneth Kopelson wrote:
> So, how do we get support in MySQL so that multiple instances of the mysqld
> daemon running on separate machines can all access the same database files
> located on a central server? I can see how the file system of the central
> database server could be exported throu
What you are asking to do is not built into MySQL :(
Mysql matintains its own internal database locking that would not
be shared amongs the other computers, if you have multiple machines
reading a writing to the same database file you will corrupt it
in short order.
Your best bet in such an en
Look up link or something in the manual. There is a way to do
virtual symbolic links in NT with mysql without installing anything,
it has to do with adding paths to the my.cnf file, see the docs
for details.
"Tracy A. Mitchell" wrote:
>
> You can do this with NT Server as well. It is called
VVM Ravikumar Sarma Chengalvala wrote:
>
> Joshua,
>
> > Comparing Oracle vs. MySQL myisam tables, MySQL will
> > save disk space, and provide you with much faster
> queries, but you have to be aware of the table
> locking issues if you are doing
> updates/inserts/deletes mixed > with reads.
>
Cyber Monkey wrote:
>
> I have found an isp that will leave port 3306 open for me to talk to the mysql
>server, my question is
>
> Is anything sent over this connection secure, if not is there some way of encrypting
>it such as ssl?
Yes.. you ssh like here
www.ssh.com
www.openssh.org
an
< mytextfile_fromaccess
Chris Wilkinson wrote:
>
> Can you give me a sample command line please
>
> CHRIS
>
> In message <[EMAIL PROTECTED]>, Steve Ruby
> <[EMAIL PROTECTED]> writes
> >Chris Wilkinson wrote:
> >>
> >> I am attempting to up
by correct configuration.
>
> Hope you can follow what I am doing or doing wrong from this.
>
> CHRIS
>
> In message <[EMAIL PROTECTED]>, Steve Ruby
> <[EMAIL PROTECTED]> writes
> >Chris Wilkinson wrote:
> >>
> >> I am attempting to upload an A
Chris Wilkinson wrote:
>
> I am attempting to upload an Access db to a remote mysql server - at
> dsvr in the UK.
>
> I get connected (I think) but receive the following error message:
> Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
>
> Can you point me in the right di
Heikki Tuuri wrote:
>
> Steve,
>
> on what operating system you are running?
>
linux, intel 2.2.12
> Was the rollback (and the table load) disk bound? Did you configure much
> memory to the InnoDB buffer pool?
>
I would say the rollback was processor bound, the machine was running
with almos
There seem to be some operations that cannot be performed on the
server whie InnoDB is doing something.
For example I inserted about 200,000 rows in to a table from
a file (mysql database < file) the file starts with begin; and
contains many inserts, I cancelled (ctrl-c) in the middle of the
o
Is there a plan to have any tablespace management tools for innobase?
I personaly dont' care if these are via a separate program or through
the mysql SQL interface but the following would be very handy.
move tables between tablespaces
list tables in a tablespace
shrink tablespace
It is very
Due to the fact that piping a table from mysqldump to an INNODB table
can be as much as 30X slower if the insert is not done with
transactions,
would it make sense to add some option to mysqldump to make every X
inserts a transaction.
for example
mysqldump --transactionrows=10 mydatabase |
Steve Ruby wrote:
>
> Steve Ruby wrote:
>
> > I'm inserting 49,990 rows via file containing individual inserts
> > (1 insert per sql statement). The table contains 7 columns and 6
> > indexes.
> >
> > Why is there so much difference on the time tak
Heikki Tuuri wrote:
>
> Steve,
>
> you should set autocommit=0 and only call commit after the
> whole batch of inserts.
>
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
> If you use autocommit=1 and insert each row in a separate transact
I've been doing some testing to determine tradeoffs with performance
for using the Innobase or BDB tables.
The testing application contains bulk inserts which must be processed
as quickly as possible. The results I'm getting look very bad for
innobase. Am I doing something wrong?
I'm inser
Don Pro wrote:
>
> Hi,
>
> I'm reading in my documentation (I have a book) that MySQL allows up to
> 101 simultaneous connections. Gadzooks! How can MySQL claim to be at
> the Enterprise level with this limit? Is there any way around this?
>
> Thanks,
> Don
>
http://www.mysql.com/doc/T/o/
Don Pro wrote:
>
> Hi,
>
> I'm reading in my documentation (I have a book) that MySQL allows up to
> 101 simultaneous connections. Gadzooks! How can MySQL claim to be at
> the Enterprise level with this limit? Is there any way around this?
>
> Thanks,
> Don
http://www.mysql.com/doc/T/o/Too
InnoDB definately provides more features that BDB, and is probably
going to be faster, Gemini isn't available yet. BDB might be more
complete/stable.
So I'd say Gemini is out of the picture unless you are looking longer
term. I'd do some testing with both we found some bugs in the 3.23.37
distr
green jon wrote:
>
> Hello,
>
> I have recently converted my Java Servlets to run against mySQL where previously I
>was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything
>works fine, more or less. However, I have one big problem which is as follows :-
http://w
when a BDB table is being written to and another thread
issues a query I sometimes get this error code. Ideas?
The table is fresh it was created by the dumpfile that another
thread is loading in while I'm running the count query.
this is mysql-max 3.23.37
mysql> select count(*) from _data;
+-
VVM Ravikumar Sarma Chengalvala wrote:
>
> Hi,
> How can I have an UNIQUE key in MYSQL which
> differentiates between case sensitive strings.i.e If I
> want to store "XYZ","XYz" and "xyz"
> differently.Currently mySQl is not accepting this type
> of strings and treating them as the same.
>
> Reg
Alec Solway wrote:
>
> Hi,
>
> In various create table statements char columns are converted to varchar..
> I was wondering why this was happening. Here's an example:
>
> CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
> null, city VARCHAR(255) not null, state CHAR(2)
Your Name wrote:
>
> dear sir/madam
> i'm currentlly doing a research on MYSQL and i would like to know more
> information about it :where does MYSQL come from who created it ...
www.mysql.com
-
Before posting, please check:
[EMAIL PROTECTED] wrote:
>
> Dear Friends ,
>
> The basic problem I face in the new project is to convert the previous Stored
>Procedures in MS SQL Database into My SQL . How to Replicate the same in My SQL .
> The Front End is VB 6.0 . The Back End previously was MS SQL . Now Client want it
For over a year the topic of mathematical operations on date values
has been disussed. It has never been possible to perform such math
on a date value without using DATE_ADD or converting the to days or
seconds first.
Why is this now all the sudden a reasonable bug?
Aurelian:
I suggest that yo
http://www.mysql.com/doc/c/o/configure_options.html
http://www.mysql.com/doc/A/d/Adding_character_set.html
Luis Hoeks wrote:
>
> I would be very pleased, if someone could tell me if MYSQL supports asian
> character sets like big5 or thai charctersets.
> If yes, what do I need to install to ge
Roger Karnouk wrote:
>
> Is it possible in a Select query to get values from the previously read row
> in order to do things like cumulative sums or other formulas which require
> the previous value in order to calculate the current value.
>
> ex.
> day current sales cumu_total
> - --
> > Hi all,
> >
> > I'm looking for some pointers towards some good information on accessing
> and using MySQL with Java/Javascript.
> >
> > Can anyone point me towards a book you like, or some good web resources?
> >
> > Thanks much,
> > /Rob
> >
You'll need a servlet and/or JSP engine such as
Matthew Hafner wrote:
>
> does mySql support triggers or transactions
>
> Matthew Hafner
> Web Applications Engineer
> The Ohana Foundation
> 1099 Alakea st
> 22nd floor
> Honolulu, HI, 96813
> 1-877-61-ohana
> [EMAIL PROTECTED]
RTFM
www.mysql.com
-
Istiaque Hussain wrote:
>
> Dear Friends ,
>
> One of our clients wants to port the Database which was originally in MS SQL , to
>MY SQL . he main problem we are facing is that how to make previous stored procedures
>run . There are a lot in the application . Front end was in VB .
> We are
Andrew Warner wrote:
>
> how do you query on a TIMESTAMP column to return all records of date today?
>
> I've been using "where date >= 20010418 AND date < 20010419" syntax
> and changing the dates as necessary, but I'd like to replace this
> with some kind of today() function.
>
> Andrew
Use
Fabio Galarraga wrote:
>
> Hi to all:
> I have a linux script and I need it can execute some mysql commands.
> Is it possible? If possible, how?
>
> Best regards,
> Fabio Galarraga
> [EMAIL PROTECTED]
see
mysql --help
you probably want
mysql -e ""
-
Kevin Pratt wrote:
>
> I have heard mysql is the access for unix... i would like to hear about
> comparisons with Mysql SqlServer and PostgresSQL
>
> Kevin
differences are in the archives for this list as well as on the mysql.com
list.
Mysql doesn't compare will to Access. access is simply a
Probably should change that first line to
rpm -qa | grep -i mysql
Roel Vanhout wrote:
>
> rpm -qa | grep mysql
>
> if nothing found,
>
> rm -rf /usr/local/var
> rm -rf `find /usr/local/bin/ | grep mysql`
> rm -rf /etc/my.cnf
>
> This should catch about everything.
>
> cheers,
>
> roel
>
>
Luis wrote:
>
> Good morning all, last night I installed MyODBC on my laptop. What i dont
> understand is how do i connect threw access now?
>
> I'm a little confuse, can anyone help me understand how MyODBC works.
>
> luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to th
How come nobody has mentioned that complex data manipulation can be performed
on the server without waistuful and slow transmission of unwanted data
to the client? that seems like the biggest advantage to me.
Meaning that if I have to do something to the data that SQL doesn't allow
without SPs
"Alexey V. Litvinov" wrote:
>
> Hello JCampell,
>
> Friday, December 22, 2000, 11:25:51 AM, you wrote:
>
> RTFM about SELECT and about DISTINCT option
>
> J> I want to know if it is possible to build a MySQL query which will only
> J> return the unique values of a specific column. Ie if I had
Patrick Calkins wrote:
>
> Hello all;
> Are there any known problems with storing the database files on a NAS
> (network attached storage) device??
>
> also, can you run multiple MySQL daemons pointing to one common database, so
> you could have a "cluster" of database servers and one database??
Pawan Kanda wrote:
>
> Hi , i have the following method:
>
> public Object getValueAt(int row, int column){
> // in here i want to construct a SQL query which gives the object at a
> certain
> row and column
> }
>
> Do you know how to do it?
>
> Thanks
> Pawan
>
Maybe make your sql statemen
"Jeremy D. Zawodny" wrote:
>
> On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote:
> > 2- I have to design a database for all universities of my country ,
> > Is it better to consider one database for each university or one
> > database for all universities . Note that a query
rozakdemir wrote:
>
> Hello,
>
> I am using MySQL on windows platform. How can I port mt datas from MySQL server on
>windows to MySQl server on Linux?
>
> Thanks for all.
You should search the sarchives and manual, this is a very FAQ...
tables extension is like .MY* you can just copy them, i
> gnanas wrote:
>
> Dear Sir,
>
> We are from Chennai, India.
> We are holding one site constructed using JSP pages. We couldn't connect to the
>mysql database using myodbc driver! The
> specified driver is not installed in the virtual server the hosting company!
> Do we have any otehr alternat
Randy Johnson wrote:
>
> When a text with an apostrophe in it has a \' in it. How can I fix this?
>
> example
>
> randy's is stored in the DB as randy\'s
>
> thanks
>
> Randy
If you just want to fix that one instance just do
update set = 'randy\'s' where
-
Jordan Russell wrote:
>
> > Everything I've seen on this list indicates that using LEFT JOIN negates
> > using an index. (WARNING: This is 3rd hand info and as such should be
> viewed
> > skeptically!)
> >
> > Have you tried:
> >
> > SELECT files.id, dirs.name FROM files where files.dir_id=dirs.i
"Gupta, Sanjeev" wrote:
>
> Hi,
> I have tried to create a table with two fields. One is type CHAR and other
> is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
> i need to do some setting to work properly.
> I am working on WINNT machine.
>
http://www.mysql.com/doc/S/
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Got error: 1045:
> Access denied for user: 'accp@localhost' (Using pass word: NO) "
>
> can you help?
>
> with best regards,
> Keneth
Read the manual,
[EMAIL PROTECTED] wrote:
>
> On Fri, 9 Mar 2001, Jon Haworth wrote:
>
> > Not sure exactly what you're after... MySQL isn't an Apache module, it's a
> > separate program.
> > Where can I find Apache module for mySQL ??
>
> maybe "mysql module for apache"?
>
> regards
> --
You mean mod
Roger Westin wrote:
>
> Hi,
> Have a problem with big tables,
> Cant get them over 2GB
> Using mysql 3.23.33
> and ReadHat Linux 6.0 Kernel: 2.2.5
>
> Need to biuld a table atleast 70Gb so Anyone?
>
switch to a file system that supports very large files
The problem should be with linux no mys
Andrew Staples wrote:
>
> New to list, and to mySQL. If there are archives available, please let me
> know--I'll search them.
>
> I have a client who is building a new win2k server, and wants to use
> ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it
> will work with myOD
Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table
Christian Hammers wrote:
>
> On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
> > He is doing an inner join, you are doing a left join, they (potentialy)
> > do not produce the same results.
> Hmm have to think about it... inner means fields where the right table
Tom Flanagan wrote:
>
> Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
> NT/2000 MYSql Database?
>
> Thanks,
>
> Tom Flanagan
>
If you are using MyISAM tables (3.23.x) you can simply copy them from
one computer to the other. If you are using ISAM tables like in
3.2
Steve Ruby wrote:
>
> Christian Hammers wrote:
> >
> > Hello list
> >
> > While browsing old sources by a former employee I realised that he always
> > did comma seperated joins and then a "where"
> > FROM
> > tablea
Christian Hammers wrote:
>
> Hello list
>
> While browsing old sources by a former employee I realised that he always
> did comma seperated joins and then a "where"
> FROM
> tablea a, tableb b, tablec c
> WHERE
> a.id=b.id and b.nr=c.nr
> whereas I learned to
gt;
> -----Original Message-
> From: Steve Ruby [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 8 March 2001 5:19 a.m.
> To: [EMAIL PROTECTED]
> Subject: Re: kill bad query
>
> Steve Ruby wrote:
> >
> > If I have a connection that executes a bad query shouldn't I
Kilian Looser wrote:
>
> Hi,
>
> i've the following setup:
>
> LoadBalancer -> five Webserver with Apache and mysql -> Database
>
> Now i got a problem. i've user's they insert records in the database. Now the insert
>is going throu, for example, webserver1. Now i'm doing a select throu webse
Steve Ruby wrote:
>
> If I have a connection that executes a bad query shouldn't I
> ALWAYS be able to kill it with "kill "?
>
> I have a query that keeps getting stuck, (who knows what
> it is doing) but that State is "statistics"
>
> I
[EMAIL PROTECTED] wrote:
>
> Hi! I just upgraded from 3.22.26a to 3.23.33. We've got a database
> that has a table that has a column with the name: FullText. Unfortunately,
> now with 3.23.33, any queries that explicitly refer to this column/field
> return an SQL error. So far this ha
If I have a connection that executes a bad query shouldn't I
ALWAYS be able to kill it with "kill "?
I have a query that keeps getting stuck, (who knows what
it is doing) but that State is "statistics"
I can't ever kill it without taking down the server..
-
Jonathan Dugan wrote:
> your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense.
> I am read ing here
> http://www.mysql.com/doc/D/e/Default_privileges.html
> and
> http://www.mysql.com/doc/A/d/Adding_users.html
>
> and I follow what is says:
> shell> mysql -u root m
It depends on your table type, check the manual, you will want
myisamchk or isamchk if you are using 3.23.x you can do SQL
REPAIR TABLE so long as your table is MyISAM.
Dave Loisel wrote:
>
> I have filled my hard drive by inserting data into a table (15 gigs).
>
> The table was then corrupte
"Todd A. Jacobs" wrote:
>
> I downloaded and compiled the latest version of MySQLGUI and am connecting
> to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
> following ssh tunnel:
>
> ssh -x -g -L 3306:localhost:3306 mysql
>
> I get this error message from the MySQL
RTFM... Obviously you need to pass the correct usename and password
if need with the mysqldump command,, read the manual and/or mysqldump --help
Keneth wrote:
>
> "When I try to dump sql database it gives me some errors 1.Error 1045
> mysqldump --opt database > backup-accp.sql mysqldump: Go
Cindy wrote:
>
> SELECT
>Foster_Dogs.dog_name,
>Foster_Dogs.dog_status,
>Foster_Dogs.date_resolved,
>Foster_Dogs.adopting_family,
>Foster_Dogs.foster_paperwork,
>Foster_Dogs.dog_id,
>Adoption_Applications.firstname,
>Adoption_Applic
Cindy wrote:
>
>
> SELECT
>Foster_Dogs.dog_name,
>Foster_Dogs.dog_status,
>Foster_Dogs.date_resolved,
>Foster_Dogs.adopting_family,
>Foster_Dogs.foster_paperwork,
>Foster_Dogs.dog_id,
>Adoption_Applications.firstname,
>Adoption_App
Dale Frohman wrote:
>
> Is there anyway to do a query and search for the most frequent
> word that appears in a particular field in a table?
>
> ie:
>
> ITEM DESCRIPTION
>
>
> Blue Dog
> Red Dog
> Yellow Cat
>
> I would want to spit out "Dog" as being the most reoccuring word
Depends on the situation.. Mysql will use only one index per table per query.
so if you very often query on all three you should put them in a multi-column
index.. If you also often search on only one of the three you should put
it first.. If you often search on another one of the three you shou
John Tsangaris wrote:
>
> If I turn on auto increment and let it do it's thing and then later on
> delete a few of the entries (let's say 1, 2, 3) and the current high entry
> has an id of 45.. why does mysql continue with 46 instead of using up 1, 2,
> and 3 first? Is there a way to bypass this
His balance is a running balance...
Joseph, you will have to keep the running balance in some thing
that you write to get the query.. you can't do a running sum
in SQL directly. You can only use the examples people provided
to get the net per line.
Joseph Bueno wrote:
>
> [EMAIL PROTECTED] a
Jack Dempsey wrote:
>
> Hi all,
>
> I'm wondering if it's possible to do something like that select line in
> the subject...often i want to select * but not one or two fields...i
> found something about this in the to do list for mysql4.0, but i'm
> guessing that's not exactly what i'm thinking.
"Matthew P. Marino" wrote:
>
> If you go to http://www.mysql.com/downloads/mysql-3.23.html, you will see the
> binary(tarball) distributions. They don't end in .tar.gz but I supposed that was
> a technical oversight. Of course I feel like a (_?_) (i.e dumb a**) not being
> able to track down the
"Matthew P. Marino" wrote:
>
> So, what do you do with a "tarball" anyways. Since compiling the source is
> hopless( "sql_yacc.cc"), I'm looking for a binary.
>
then download the binary.. Or at least do a better job of describing your
problem...
---
Original Message
From: "Matthew P. Marino" <[EMAIL PROTECTED]>
Subject: Re: So, what do you do with a "tarball" anyways.
To: Steve Ruby <[EMAIL PROTECTED]>
OK.
I'm trying to prove/disprove the viability of the MySQL/PHP/Apache triad
---+
>
> However Chicago is the city of the first stop off (sequence 1) not the
> value that corresponds with a sequence of 2 which would be 'Boston'.
>
> The desired result is the following:
>
> +---+
> |flight_no |sequence|City
Your question was answered already after you posted it on Saturday
by Fred van Engen...
Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg, sum, count) on columsn that do not
appear on the "GROUP BY" clause.
Richard Reina wrote:
>
> I posted t
PID is stored in a file in the datadir named
.pid
[root@georgia data]# cat /usr/local/mysql/data/georgia.pid
19805
Teddy A Jasin wrote:
>
> Hi,
> wat command to type under linux to get the PID of the mysqld that is running?
> i tried : 'ps aux | grep mysqld' but this will list the mysqld info
Does anybody know of any commercial or opensource CRM systems that
run with MySQL on Linux (and/or FreeBSD)?
Mainly I need canned responses and ticket management and some other
standard features.
-
Before posting, please check
You may be looking too far for your problem...
Your join_buffer and sort_buffer are probably a little large if you
have man concurrent users.
Must you use an old version of mysql?
You should analyize or post EXPLAIN of your query so that you/we
can see that it is properly indexed.. you should
Benjamin Pflugmann wrote:
>
> Hi.
>
> On Thu, Feb 08, 2001 at 02:48:15PM -0700, [EMAIL PROTECTED] wrote:
> [...]
> > While we are (were) on the subject.. Any thoughts why like would not be
> > using an index in this case?
> >
> > mysql> explain select * from _data where datatime like '12:00:%';
[EMAIL PROTECTED] wrote:
>
> Hello,
> When you create a query, how do you save it? Is there a special
> command to save a query?
>
> Thanks Mark
>
Query is just text... if you are in unix under mysql monitor
you can do
\e
on any line after you run the query (and before you type a new
Quickling wrote:
>
> Hi,
>
> Question 1:
> ---
> We've got a server app that does a lot of 'small' database reads and
> writes. We were originally using MS Access via DAO (Jet Engine) and we
> wanted to tighten up DB performance, so we've written a general ODBC
> database wrapper
Quentin Bennett wrote:
>
> Hi,
>
> For an indexed column, the index is used if the start of the string is used:
>
> LIKE 'a string of text%' may use an index
> LIKE '%any old string%' will not, since the start of the string is unknown.
>
> The index will only be used if the server decides th
If OPTIMIZE TABLE appears to be writting to a temporary file
while it works (.TMM).. Why must it lock readers out of the original
table file?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
select column1,column2,column3, count(*) as numlines
from table
group by column1,column2,column3
having numlines > 1
That will find them,, you'll have to write some script or something
to go through the results and remove the duplicates, I'm not
sure if a query that will do both at once.
Linse
"Carsten H. Pedersen" wrote:
>
> > Does anyone know how to find duplicates in a table and deleting
> > them. I can't figure out how to structure the query.
> >
> > Linsen
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of t
Linux is a *nix...
Your best bet would be replication which would allow you to have several
copies of the database one for writting and many for reading.
see REPLICATION in the online manual.
Alternatively if your databsae is read-only and you have some high-speed
network file system then you
Brian Reichert wrote:
>
> On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
> > When I try to do a mysqldump on the localhost, I get an out-of-memory
> > error:
> >
> > # mysqldump -uroot -proot customer audit_trail_271
> > mysqldump: Out of memory (Needed 8164 bytes)
> > mysq
"Ung, Seng" wrote:
>
> hi:
> Here is my SQL statement to select a range of number from 0-9
>
> Is there a short cut to this?
>
> id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
>like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
see R
Bob Hall wrote:
>
> >I want to do a select like
> >
> >select id from test
> >where id in (select id from test where value in (1,2,3)
> >and id in (select id from test where value in (4,6,7)
> >and id in (select id from test where value in (1,6,25)
>
> Even if MySQL supported subqueries, this qu
Kuokai Shyu wrote:
>
> Hi,
>
> Can MySQL do the queries on the databases stored in the CD-ROM?
> For example, when switching data CD-ROMs, is it necessary to shutdown
> mysql server, and restarting server after mounting another CD-ROM?
> Thanks in advance.
>
> Sincerely,
>
> Kuokai
I
Steve Ruby wrote:
>
> Does anybody know what is the fastest way to run a large multiple
> AND type query on a many-many table and the least memory hungry.
>
> For example if I have
> create table test (id int, value int);
>
> which has many-to-many on id, and v
Henrik Lebtien Mohr wrote:
>
> Hi there
>
> I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
> I get an error "Multiple-step error" when I try to update a recordset like
> the following:
>
> with rs
> .fields("date") = null 'timestamp datatype
> .fields("nOnline") = .
Does anybody know what is the fastest way to run a large multiple
AND type query on a many-many table and the least memory hungry.
For example if I have
create table test (id int, value int);
which has many-to-many on id, and value
I want to do a select like
select id from test
where id
Joel Holtzman wrote:
>
> Hello, via telnet with mysql server on linux, I try to delete a table, but it won't
>work. I'm browsing the documentation, I can't see what will work. I can do this via
>asp, but I'd love to know the command for something that should be as simple as
>
> mysql> Delete (
Aaron Williams wrote:
>
> Hello list,
>
> After searching the documentation on the site, as well as the archives, I
> have yet to find the answer to this question. If I have overlooked it
> somewhere, just point me in the right direction.
>
> The question:
>
> I have two tables, set up exactly
Geoff Coffey wrote:
>
> I am new here...
>
> I am in the process of migrating a site built with FileMaker Pro to MySQL
> and PHP mostly because filemaker's web capabilities are too limiting. In one
> situation, we have a database of about 20,000 rows that contains two text
> columns. One is the
Marko Sarunac wrote:
>
> I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
> and for database connection i use mm.mysql.jdbc-1.2c
> Here is my problem
>
> I have got MySql to run fine but when i try to interfaec it over the web i get
> te follwoing error
>
> error 50
Sanjeev Kabra wrote:
>
> Hi,
>
> I installed MyODBC and even configured it. MySQL db running on Solaris is
> running under the root user. While defining the DSN using MyODBC in the
> username I tried putting root user and the password for the same but I keep
> getting error "can't connect to MyS
Jang wrote:
>
> Hello,
>
> I'm new in this MySQL list. I only want to know what are the default
> privileges that are required, so that a normal user (wihtout any special
> priv.) can acces only to his DB, create tables, manage, insert, ..., his
> tables.
> I have try some differents config, but
1 - 100 of 123 matches
Mail list logo
