On Thursday 06 June 2002 9:51 am, Greg D. wrote:
> I was wondering if there was a better way to speed up
> my update statement in my perl script. It goes through all the
> entries in the database , which is around 800, 000, and then updates the
> email field. The problem is that it takes t
On Wednesday 05 June 2002 4:54 pm, Jeremy P. McKay wrote:
> I do not really think MS Access is for Mission-Critical databases...but I
> guess that depends on ther definition of mission critical. Most MCP will
> agree that MS Access does not scale well and offers little advantages for
> Mission-Cr
On Wednesday 05 June 2002 4:28 pm, Jay Liew wrote:
> Hello everyone,
>
> I am new to database operations, and I was wondering if there were any
> advantages or using MS Access to MySQL. Don't get me wrong, but I would
> prefer Open Source over proprietary, but this is a mission-critical
> com
Please stop reposting your question.
You should be able to get this information from Delphi. Set up a time object
before you execute the query.
On Thursday 16 May 2002 10:19 am, Alexander Burbello wrote:
> I made a program with delphi and I would like to get the message when is
> execute any q
On Monday 13 May 2002 1:49 pm, Taylor Lewick wrote:
> Hi All, I am fairly new to mysql..
> I am using perl, mysql, and apache to do a little development, and to learn
> quickly I am trying to do some real dbase transactions...
>
> I have a program whcih gets a bunch of stock quotes from the intern
Look up the ALTER TABLE statement.
On Friday 10 May 2002 12:52 pm, Tang Ngo wrote:
> I am beginning to learn mysql.
> How to add a column to table in mysql database.
> Thanks
> Tang
-
Before posting, please check:
http://www.
http://www.mysql.com/doc/S/E/SET.html
On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
> I couldn't find this in the documentation. What is the propoer sql to
> insert into a field with a data type of set? My field has the following set
> of acceptable values:
>
> GA, TN, SC, NC, AL
>
> Assum
On Tuesday 23 April 2002 1:10 pm, destr0 wrote:
> query, table
>
> When I run the query:
>
> SELECT LAST_INSERT_ID() as id FROM myTable;
This query really makes no sense. It is almost the same as:
SELECT LAST_INSERT_ID() as id;
> It returns the last inserted Id, but why does it return that val
Do you have g++ installed? It doesn't look like you do.
On Friday 19 April 2002 1:45 pm, Ricky Sun wrote:
> I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1
> workstation... Encountered the following gcc C++ compiler executable
> creation problem
>
> when ./configure check
tcome without actually having some specification of
> the behavior.
>
> //Anders
>
> > -Original Message-
> > From: Christopher Thompson
> > Sent: Tuesday, April 16, 2002 6:24 PM
> > To: Svensson, B.A.T. (HKG); Mysql List
> > Subject
I'm not sure what you are asking. Everything is working correctly as far as
I can see.
On Tuesday 16 April 2002 10:19 am, Svensson, B.A.T. (HKG) wrote:
> Is this a documented behavior of MySQL(?):
>
> mysql> create table test (a int);
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> insert int
tion, I'd appreciate
> it (slow modem connection, etc).
>
> Christopher Thompson wrote:
> > Read the manual. MySQL doesn't support subselects but offers you
> > alternatives.
> >
> > On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote:
> >>I'
Read the manual. MySQL doesn't support subselects but offers you
alternatives.
On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote:
> I'm trying to do a fairly simple select of a
> column from a table where the date of that column
> happens to be the highest value. I tried this:
>
> SELECT name
On Saturday 13 April 2002 4:34 pm, Samwise Gamgee wrote:
> I am trying to update a table with information from that same table and
> another table. I have two tables, player and goalie, for a hockey pool.
> The field pool_points is total points for forwards, goals * 2 for
> defencemen and point
On Friday 12 April 2002 8:10 pm, Carl Schmidt wrote:
> I have a form where a user enters some numbers into text boxes. Some of
> the text boxes can be left blank. The business logic receives all
> variables to all text boxes. Should I :
I'm assuming that you are using an executable file and NO
Sure, just don't include it in the list of columns to bring back.
SELECT column1, column2 FROM ...
instead of
SELECT * FROM...
or
SELECT columnIDoNotWant, column1, column2 FROM ...
On Friday 12 April 2002 3:29 pm, Thi Cao wrote:
> Can I hide the auto_increment field?
>
> -Original Messag
You shouldn't be storing the questio number at all. You have denormalised
your database and this is why you are experiencing this problem.
Instead, store a unique identifier with each one (an 'id' field,
autonumbering) and then, when you pull back all the questions, order it by
this ID field.
On Friday 12 April 2002 2:26 pm, BJ Phillips wrote:
> I can load files from '/home/mysql' but when trying to do it from any other
> user ('/home/user/directory'), I get an error 13 about cannot get stat on
> file such and such. The files are located on the server and are owned by
> the user, both
On Thursday 11 April 2002 4:09 pm, Thi Cao wrote:
> All,
>
> When I insert records into a database, the records will be inserted in the
> order that I have them listed in my insert statement. So my question is,
> will the MySQL database always return the records in the order of insertion
> when I
On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
> Hello,
>
> I wondered if there is a way to create a mysql
> database using Visual C++ 6.0. I don't want the
> database to be registered, I want the program to
> create the database for me.
Certainly. If by no other way, execute a ba
On Tuesday 09 April 2002 2:13 pm, Andrew Hazen wrote:
> Hi,
> Can I use the MD5 function in the where clause, as in:
>
> Select * from table where md5(column)=value
>
I see no reason why not but note that you are likely MUCH better off storing
column as an MD5 hash, computing the MD5 of val
On Tuesday 09 April 2002 11:47 am, Alain Del Giust wrote:
> I am just testing mySQL so I will be able to use it instead of Oracle
> Sybase ...
>
> I am not saying a PK can be NULL wich is impossible
> But a FK can be NULL and I'd like to know how to do that with mySQL
I do not see this as being a
On Tuesday 09 April 2002 11:07 am, Alain Del Giust wrote:
> "if you have a foreign key constraint, that field must be one of the values
> of the referenced column and that column, being an index, is never NULL"
>
> OK so my understanding is that it is impossible with mySQL to do such
> things wich
On Monday 08 April 2002 10:09 pm, Daniel Jarrett wrote:
> i'm building a table in MYSQL that has about 30 fields..
>
> is this inefficient to have a large number of columns?
Not necessarily, no. Often, it is more efficient.
> if anyone can direct me to some good info on efficient design tips
On Monday 08 April 2002 9:49 am, Chuck \"PUP\" Payne wrote:
> Ok, I know I am going to get yell about this but how can I do an SQL and
> only show to fields from a table. For example I only like to see the names
> and birthday? Or will as so all fields for a given table.
SELECT field1, field2 FRO
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote:
> Thanks Todd and Tyler for the encouragement,
>
> When I searched on Mysql column types, I did not find any obviously
> suitable for images. I do not suppose I can use VARCHAR, can I?
Use one of the BLOB types.
Note that if you are running
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote:
> We are writing a book about MySQL. There will be emphasis on using MySQL
> with perl/php, .net & java. The publisher needs lots of emphasis on SPs and
> nested subqueries. We need to be able to write about implementing biz rules
> using
On Friday 05 April 2002 10:16 am, john wrote:
>
> Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
> "1";
>
> that is the command that I am attempting to issue, but states the where...
> is wrong. What's wrong with that?
It isn't valid SQL. You are, I think, trying to
On Thursday 04 April 2002 2:21 pm, Guy-Maurice Lepoutre wrote:
> Hello,
>
> I would like to create a MySQL database using DAO and
> Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
> know there is a Create() method on CDaoDatabase but I
> cannot figure out how to use it to create a mysql
> datab
On Wednesday 03 April 2002 3:23 pm, ktt wrote:
> hello,
>
> i have plans to create a complex SQL database.
> before that i'd like to draw a scheme of it.
> could you please advice which
> program(freeware/shareware)
> would fit for that purpose?
> any links to pages, tutorials about graphical
> da
On Wednesday 03 April 2002 2:02 pm, Lori Thompson wrote:
> Does MySQL have the capability for the user to specify their own
> delimiters for the command:
>
> INSERT into (database) values ("value1, value2,...,valuen");
>
> The values that I am inserting contain both "" and '' and I am receiving
On Wednesday 03 April 2002 12:35 pm, Leo Przybylski wrote:
> Hello all,
>
> Does anyone know if MySQL can do subqueries?
Not the current version, no.
>
> I am trying to provide a SELECT subquery to an IN clause and I am getting
> errors. Is this possible?
Read the manual and follow the example
Note also that by doing this, your database will be denormalised. This may
not be a big deal, however.
On Wednesday 03 April 2002 9:55 am, you wrote:
> UPDATE mytable SET field1=field2;
>
>
> -Original Message-
> From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03
On Monday 01 April 2002 10:56 am, IvanLatysh wrote:
> Hi.
> I am running MySQL 3.23.44-Max
>
> I have 2 tables.
>
> Table "A"
> +---++
> IDName
> +---++
> 1 string 1
> 2 string 2
> +---++
>
> Table "B"
>
> +---++
> IDName
> +---++
> 2
On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote:
> I thought Mysql was a server that could be used as a online database?
Yes
> If it is, is there some material I have not read that tells me how to do
> this?
What are you trying to do? You have not been at all clear in y
On Tuesday 26 March 2002 3:26 pm, Steven Hajducko wrote:
>
> I'm trying to take a string ( In this case, a password ), and encrypt it
> with RSA encryption via the perl module, Crypt::RSA. Later on, I want
> to be able to pull the encrypted string back out and decrypt it.
Note that if you do thi
On Tuesday 26 March 2002 3:30 pm, adam nelson wrote:
> It's been a while since I've done this, does anybody remember:
>
>
> If I have 2 tables:
>
> tblPerson (
> iPersonID int
> szPersonDesc varchar
> iPersonType int
> )
>
> tblPersonType (
> iPersonType int
> szPersonType varchar
> )
>
> iPersonT
On Tuesday 26 March 2002 2:56 pm, Harpreet Kaur wrote:
> I am using
> C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa P sapwd -c
> -t \t -r \n
>
> to create a text file from a sqlserver table . Th text file shows a tab
> after every field except the last field. How can i get it to
[For the spam-bot: Go away, you annoying little beast. You know I'm not
posting spam so stop querying me about it and let's get back to the topic at
hand; sql]
On Sunday 03 February 2002 1:27 pm, Chuck Barnett wrote:
> > Hi, I have a db field that holds the first and last name of a person. I
What percentage of your database contains rows where status = 200? It looks
to me like MySQL is estimating that perhaps 1/3 or more of the rows have that
status and therefore, it is faster to simply do a table scan rather than
using an index.
On Monday 25 March 2002 1:08 pm, Michael C. Neel w
On Thursday 21 March 2002 11:28 am, Klym wrote:
> Is it possible to have your web server and your MySQL server running at
> different geographic locations? I'm wondering if I can run my own MySQL
> server here at home on Linux and have my web site use PHP to connect to it
> and extract data. Is
Have you looked at:
http://www.mysql.com/information/benchmarks.html
On Tuesday 19 March 2002 11:50 am, Kathy Reyes wrote:
> Hello all its me again
> Does any one now of any database benchmarking utility that I can use on
> mysql database???
--
On Monday 18 March 2002 4:22 pm, [EMAIL PROTECTED] wrote:
> Everyone,
>
> What's the differences with MySQLD and MySQL-max?
MySQL-max supports more table types.
-
Before posting, please check:
http://www.mysql.com/manual.php
What error message do you get? Have you tried fully spelling out your join
condition's table names? Have you tried specifying that you are doing a LEFT
join? Have you tried using USING instead of ON?
On Monday 18 March 2002 4:15 pm, John Burns wrote:
> I've looked throught the MySQL document
Your problem, I _think_, is that your query works as follows:
for i = 0 to table_name.rows {
row <-- table_name.row[i]
if row.count = ROUND(rand() * 10) then result += row
}
NOTE: ROUND(rand() * 10) is performed FOR EACH ROW in your table. You
actually mean for it to b
On Thursday 14 March 2002 9:32 am, BD wrote:
>
> Why or why couldn't MySQL have used case insensitive names in the first
> place? Store everything in lower case internally, but allow the user to use
> "Invoice_Number" or "invoice_number" or "INVOICE_NUMBER" in the SQL
> statement and it should ref
http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#MySQL_server_licenses
On Wednesday 06 March 2002 1:17 pm, Zengfa Gao wrote:
> Hi,:
>
> I heard that when we use MySQL on windows, we need to
> pay fees. But I can't find anything on MySQL document
> to talk about this.
>
mysql_row_seek().
On Wednesday 06 March 2002 10:26 am, JOUANNET, Rodolphe wrote:
> Can someone tell me how to find the previous record in C (with mySQL API
> function). I do a SELECT statement, read it with mysql_store_result(), read
> the first record with mysql_fetch_row(), the next record with
This is not a MySQL question, it's a Solaris question. :) But anyway, you
need to get and install ncurses (version 5). You can find more information
at:
http://www.gnu.org/software/ncurses/ncurses.html
On Wednesday 06 March 2002 8:57 am, Atif Faruqui wrote:
> Hello,
>
> I feel i am dea
On Tuesday 05 March 2002 10:15 pm, Amit Lonkar wrote:
> hi
> Does Mysql support Transat SQL???
Assuming you mean Transact SQL, no. 'Transact SQL' is Microsoft's name for
their proprietary extensions to SQL. Only Microsoft SQL Server supports it.
But then again, MS SQL doesn't support MySQL's
No need to get all snarky. People are confused because there's a whole
section in the manual that covers the installation, step-by-step, with no
cryptic mumbo jumbo. This is at
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM
and basically tells you to down
On Tuesday 05 March 2002 11:11 am, Edward Peloke wrote:
> I asked yesterday but got no responses...anyone have any ideas how I can
> use one odbc connection but have access to all databases on the MSSQL
> server???
I have not tried this but have you considered using the use command? Or even
per
On Monday 04 March 2002 10:50 am, Richard Clarke wrote:
>
> create table mytable (id int, val char(255), hits int);
> insert some data...
>
> select max(5,hits) from mytable group by id;
>
> This would allow selecting of the top 5 rows for each id according to the
> hit column.
>
> Without this fu
This has nothing to do with MySQL. Check out freesql.org and talk to them
about your problems.
On Monday 04 March 2002 1:31 am, Zandona Marcello BGV wrote:
> sql-problem!
>
> hello,
> please could you help me? after you made some
> work on your server.. the side of
>
> www.fcliestal.chdoes
For what it is worth, this does NOT cause 3.23.41 to crash.
On Friday 01 March 2002 3:47 pm, Tony J. White wrote:
> Using versions 3.23.47 or 3.23.49a on linux i386 precompiled binaries.
>
> Using ORDER BY on a column that is type text causes a crash.
>
> The following MySQL Query crashes it's My
On Friday 01 March 2002 2:51 pm, Thomas LaCicero wrote:
> I am not sure if this is going to sound like a stupid question but here it
> goes...
>
> If I have a table with a Float field and, an entry in that field that has
> at least one decimal place, and I try to do a SELECT * FROM some_table
>
What is your query? What error message do you get?
On Friday 01 March 2002 2:46 pm, Alexander Shaw wrote:
> Hi,
>
> I have an application running under Access 2000 with linked MySQL tables.
>
> At the moment I m trying to run a query to populate a second table. Some of
> the data in the query is
On Friday 01 March 2002 9:21 am, BLANCHET wrote:
> Hi,
> Is it possible to make simultaneous 2 SQL queries in a MySQL database(
> update, insert and the other) on only 1 table. Because my DB is on a server
> and i I've 5 clients who works on the same table. Samuel
For reasonable definitions of
On Thursday 28 February 2002 3:47 pm, Eric Colley wrote:
> I have a MySQL table of basic user information including email address as
> one of the fields. The table is about at the 10,000 record mark. I have a
> list of bad email addresses that another program found for me (around 2,000
> records
On Thursday 28 February 2002 3:47 pm, Eric Colley wrote:
> I have a MySQL table of basic user information including email address as
> one of the fields. The table is about at the 10,000 record mark. I have a
> list of bad email addresses that another program found for me (around 2,000
> records
On Tuesday 26 February 2002 4:00 pm, Scott Broderick wrote:
> Hello group! I am a newbe to this listing.
>
> What I am attempting to do is pass a number like "0123456" to a field in
> the mysql database which is setup as int(11) but for some reason, the zero
> is not
> written into the database bu
On Friday 22 February 2002 5:03 pm, Luie wrote:
> hello all,
>
> anybody know where to find a quick reference guide for mysql
> commands/functions?
If you are looking for an SQL quick reference guide, check out SQL Instant
Reference (2nd Edition) by Martin Gruber, published by Sybex. Very good
On Thursday 21 February 2002 3:29 pm, Rick Emery wrote:
> try:
> select * from MapConfig mc LEFT JOIN ConfigString USING (id)
> LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = "Roads";
Heh. It's been too long since I worked with SQL.
Thanks, that worked perfectly.
---
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt
USING (id) WHERE MapConfig.layername = "Roads";
What I am trying to do is to pull back all rows from MapConfig associated
with matchi
On Tuesday 19 February 2002 4:56 pm, Peng Zhao wrote:
> Thanks for your reply. But You can find something from
> http://www.mysql.com/doc/I/B/IBM-AIX.html :
Thanks, I hadn't noticed that.
> "If you are using gcc or egcs to compile MySQL, you must use the
> -fno-exceptions flag, as the exception
On Tuesday 19 February 2002 4:31 pm, Peng Zhao wrote:
> Can somebody tell me why these 3 flags must be added when I
> compile mysql from source code? I am trying to use another compiler
I see no reason that these should be required.
-fno-implicit-templates simply requires all templates to be exp
Prefix it with the path:
/usr/local/mysql/mysqld start
or whatever.
On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
> Hi,
>I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
> I try to run it to finish installation and set up users, i get the
> following er
On Wednesday 13 February 2002 12:10 pm, Trond Eivind Glomsrød wrote:
>
> Our kernel people love them - Athlon goodness, no VIA chipset. Good
> performance, good stability.
Note that the Via kt266a (_not_ SMP chipset) is quite good these days.
If I was building a dual-processor machine, there's n
On Wednesday 13 February 2002 10:51 am, Shih-Hao Li wrote:
>
> Does anybody know what's the minimum memory requirement
> for mysql running on Redhat Linux and Sun Solaris?
> Please reply or cc to my email address.
I have run MySQL with 32 megs of RAM quite happily. Note that this was NOT
partic
On Thursday 07 February 2002 12:56 pm, Rutledge, Aaron wrote:
> I am trying to query the database for records that have the same
> sequence of starting characters--such as banana1 and banana2 and have a
> result set returned that contains everything that starts with banana.
> Any way to do this?
On Wednesday 06 February 2002 3:35 pm, Claire Forchheimer wrote:
> I want to select all entries in my table that in a column with given
> dates findes all dates inbetween $from_date - $to_date. (These are
> vars that the user supplies from the HTML-page). I don't know how to set
> up the SELECT
On Tuesday 05 February 2002 9:59 am, Barry J. Wiegan wrote:
> Hi,
>
> I'm trying to build a query to solve a fairly simple problem.
> I have two tables (A and B) linked by a common ID. I want to
> locate a specific record in A that is linked to two or more
> records in B based on second field in B
At 02:34 PM 1/30/2002 -0600, Emily Kelley wrote:
>In the process of searching for a dynamic database solution for a work
>project I have just begun reading about MySQL. So far this looks like a
>very promising choice for us but I have one extremely basic question that I
>hope someone will kindly a
At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote:
>Is there a database size limitation with MySQl in the Windows NT and Windows
>2000 enviroment? Like some databases have size limitation of 2GB.
Yes. Read the manual. In a Windows environment, table sizes are limited
to 2 gigabytes if memory s
Nathan:
I suspect you are trying to solve the wrong problem. Why don't you tell us
_why_ you think you need this value, what you are trying to accomplish.
At 04:23 PM 1/29/2002 -0700, Nathan wrote:
>But if this is the MyISAM table type, and you performed an insert, then a
>delete, your MAX +
Not _necessarily_ true, surely, if there's another transaction active at
the moment (assuming you are using a table that supports transactions)...?
At 03:16 PM 1/29/2002 -0800, James Montebello wrote:
>SELECT MAX(id) FROM table;
>
>will get you the highest value for 'id', that +1 will be the 'n
At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote:
>Given this example:
>
>table CARS
>has got an entity "Labourghini" with car_id=5
>
>table NEWS
>has got an entity "Lambourghini displays new super model" with
>date=2002-05-02, news_id=735 and car_id=5
>
>Now:
>
>I want this output:
>
>NEWS HEADL
At 03:15 PM 1/29/2002 -0500, Douglas Brantz wrote:
>Hello,
>
>I have a big problem! I need to match all patterns in schdays from a
>variable schdays and if schdays = mwf it only turns up mwf and not all
>entries containing M, W or F. Is there a way to do this?
>
>mysql> select schdays from course
At 05:27 PM 1/28/2002 -0800, Lance Prais wrote:
>Why when I use the following SQL it get a
>ORA-00937: not a single-group group function
>
>What could I be doing wrong?
>
>I am only trying to group on Time_stamp.
>
>Thank you in advance
>
>SELECT
> ROUND(AVG(COUNT(Time_stamp))),
>
At 03:24 PM 1/28/2002 -0500, [EMAIL PROTECTED] wrote:
>Does anyone have a good example of accessing and displaying data in a MySQL
>database using ASP and displaying it on a web page? I'm a VB programmer and
>I'm new to accessing databases from the web and just need one good example
>to tie ever
At 05:58 PM 1/24/2002 -0500, Michael Stearne wrote:
>The problem is, this query really hurts (I don't know if it finishes) for
>unindexed field for 2.9 million rows. But I'm sure it will finish eventually.
Yes, it will really hurt. After all, there's no way for MySQL to do this
other than pul
IL PROTECTED]]
>Sent: Thursday, January 24, 2002 4:38 PM
>To: Christopher Thompson
>Cc: [EMAIL PROTECTED]
>Subject: Re: Tighly packed table
>
>
>Christopher Thompson wrote:
>
> > At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
> >
> >> We have a somewh
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
>We have a somewhat large read-only table (2.9 million recs). I am wonder
>if there is a utility that will look at each row of each columns and come
>up with a summary of the largest field (in character length) for each
>column. For example,
At 05:19 PM 1/24/2002 +, [EMAIL PROTECTED] wrote:
>I've installed Mysql on my machine, two of my machines, one on win98 and
>other on windows 2000. But for some reason when the developer is trying to
>run any query from a VB applications, it tends to slow and hang both the
>machines. I 'm try
e but
eliminating them didn't fix the problem.
I ended up finding MySQL++, though, which seems to do a good enough job for me.
At 09:38 AM 1/24/2002 +1000, you wrote:
>Hi,
>
>It is quite easy to write your own wrapper class.
>
>Sid
>
>-----Original Message-----
>From: C
not real familar with MYSQL syntax yet but I think you'll
>be able to translate.
>
>
>select
> m.magazinename
>from
> s,m,b
>where
> s.name = 'fred'
>and
> s.id=b.subscriberid
>and
> m.id=b.magazineid
>;
>
>
>On Wed, Jan 23,
At 02:45 PM 1/23/2002 -0800, Eric Mayers wrote:
>I'm designing a system that will parse and store log files in a
>MySQL-Max-2.23 database (the log table will be innodb). I have a
>requirement that as the database fills towards maximum capacity that it
>writes over the oldest records rather than d
At 02:51 PM 1/23/2002 -0800, you wrote:
>i understand that creating a M:N relationship in mysql involves 3 tables,
>one of which being a bridge, but how do i join the first and third tables
>by way of a bridge?
>
> example: a table of subscribers and a table of magazines with a bridge
> in th
At 10:23 PM 1/23/2002 +, you wrote:
>Hi,
>
>I have a blank table for some testing.
>
>1 of the fields (the primary key) is an auto_increment and not null.
>
>how and what do I insert into this field to start off the recordsets. also
>once I have set the records going say to 1, what do I then i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
For various reasons, I need a C++ API to MySQL for use in Windows (and
possibly Linux as well). I know I can find one or two in the
downloads/contrib section but I'm looking for suggestions.
I'm quite happy with the way the C API is set up. But
At 02:41 PM 1/21/2002 -0600, jon-david schlough wrote:
> >>yep. perl is all good - got activestate perl fer windoze and the
>dbi and the dbd - everything went fine as i went thru the tutorial in the
>manual...i was able to: perl -v and get the version info...
Great. So perl is in yo
Have you installed perl? You need it (and the Perl MySQL drivers)
installed before you can benchmark. Also, you'll want to modify the batch
files such that it uses a different user (possibly the root user if you
haven't changed the password on that yet).
Note that running the benchmark takes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At 03:44 PM 1/18/2002 -0500, you wrote:
>We use mysql heavily in production with tables over 30GB. We are going
>to purchase a new db server soon and the decision to be made now is
>whether we should go with a 4 cpu 700-900MHz system or a 2 cpu 1.4G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a problem compiling an app that uses the MySQL C API. My program
itself is C++ using Visual C++ 6.0 in Windows 2000, but the C api is plenty
sufficient for me. I suspect the problem comes because when I include C++
streams, I use the ANSI
94 matches
Mail list logo
