Question - SELECT

How do I correct this SQL code: SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_date AS receive, # # the above statement is not correct for the # additional condition # FROM lcopen, lcreceive AND lcopen.id

strange behaviour

I run mysql on FreeBSD and it's been giving me a lot of problems. Sometimes the load shoots up and some applications cannot access mysql server anymore. During such instances, when I run top, I get something like this: last pid: 57669; load averages: 1.40, 1.52, 1.52

Re: Admin/Client GUI - Win32 and Linux

Try SQLYog at http://www.webyog.com/sqlyog/download.html Very fast, compact and intuitive. Only for Win32 :-( Regards, Karam --- Nilza Lafayette <[EMAIL PROTECTED]> wrote: > I'm running MySQL onto a Windows Advanced Server. > I´m > looking for a good and free admin/client GUI for > Win32 > and L

RE: How can we tell if we're maxing out MySQL/InnoDB capacity?

- Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. - I know how you feel. We were hitting 7700 qu

Re: Re: Trouble converting SQL from Access

we did something like this a while back. i remember we AND'ed what you basically have now with a number of less than and greater than expressions to "box" the circle that you describe in your statement. this "boxing" of the area merely provided a way to quickly limit the number of rows against

Re: How can we tell if we're maxing out MySQL/InnoDB capacity?

> > However, I can't figure out exactly why it was slow. Key efficiency > > was at 100%, and I *believe* the InnoDB buffer pool was large enough > > as the InnoDB monitor was reporting 1000 / 1000 cache hits. > > > > iostat showed the usual levels of disk I/O. > > > > What other statistics can I

MySQL Source tar.gz files

Ok, I've got gunzip and tar, and every time I try (multiple versions) of your source .tar.gz file, I get: (when running 'tar -zxf mysql-3.23.54a.tar.gz') gzip: stdin: not in gzip format (when running 'gunzip mysql-3.23.54a.tar.gz') gunzip: mysql-3.23.54a.tar.gz: not in gzip format It seem

Re: How can we tell if we're maxing out MySQL/InnoDB capacity?

On Thu, Jan 02, 2003 at 10:30:50AM -0500, Michael Bacarella wrote: > Hi, > > Yesterday happened to be one of the busiest days for us ever on our > MySQL backed web site. For the entire day MySQL was hit with up to > 1200 queries/second, and many queries were being delayed at least > 2-15 seconds.

Re: Trouble converting SQL from Access

Asendorf, John wrote: . SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS Distance FROM Dealers INNER JOIN Zips ON Dealers.Zip = Zips.Zip ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2) Any suggestions to speed this guy up? yeah, do you really need ALL the

Re: SHOW INNODB STATUS output as SHOW STATUS?

On Fri, Jan 03, 2003 at 12:04:47AM +0200, Heikki Tuuri wrote: > > I think Sinisa suggested some of the InnoDB statistics could be > included in SHOW STATUS. Of course not all, as SHOW INNODB STATUS > often prints several kilobytes of data. Right... > But, what is the problem in scanning the text

RE: How can we tell if we're maxing out MySQL/InnoDB capacity?

- Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. - I know how you feel. We were hitting 7700 qu

Part Time Programmer

Hi All! I'm looking for a part-time, work-from-home programmer. Must have knowledge in SCO Unix, Apache Server, MySql and PHP. I can be contacted directly by phone or email. [EMAIL PROTECTED] (713) 868-4348 Thanks, Gary - Bef

Re: Can Expect scripts interact with mysql ?

"Paul Choy" writes: >Hi : > >I am trying to run Expect scripts to interact with mysql. So far I cannot get > it to work here is the list of log I got.Does anyone know how to interact Ex >pect scripts with mysql. What am I missing ? I've done it, but I don't spawn directly. I spawn a regular

Re: MySQL-PHP-Apache2

Hi, I think that your problem is because you do not enter your root MySQL password in your connection to it. $db = mysql_connect("localhost", "root"); Try with this: $db = mysql_connect("localhost", "root", "your_root_mysql_password") or die("Could not connect: " . mysql_error()); Best Regards

replication only works for user x from host x, not host y

This is a repost of my previous message with a new and improved title that will hopefully catch more eyes and generate a response. :) > We have two users, lets call them test and test2. > > When we log in as test from our front end web servers, we can execute queries and >they replicate. > > Wh

Can Expect scripts interact with mysql ?

Hi : I am trying to run Expect scripts to interact with mysql. So far I cannot get it to work here is the list of log I got.Does anyone know how to interact Expect scripts with mysql. What am I missing ? Thanks spawn mysql parent: waiting for sync byte parent: telling child to go ahead paren

Re: subselects

Ahmed, - Original Message - From: ""Ahmed Farouk"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, January 02, 2003 9:52 PM Subject: subselects > Hi All > I know that this maybe a repeated question here but I just need to know > the updates. > I am asking about

MySQL-PHP-Apache2

Hey.. I've got a wierd problem. I'm following the guide as per WebMonkey which has worked for me before, when I ran my servers on a Win32 box, but now I've got this problem (running linux)... I cant seem to do any editing to my DB from the webpage. I've used a couple different scripts, confirmed

Re: Foreign Key problem? in MySQL 4.0.7

Heikki: Do you mean the PRIMARY KEY order? Heikki Tuuri wrote: Haisam, - Original Message - From: ""Haisam K. Ido"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, January 01, 2003 10:29 PM Subject: Foreign Key problem? in MySQL 4.0.7 I was able to create the

Re: subselects

Thanks Greg for the hint but I also wanted to know when is MySQL version 4.1 to be expected to show up in binaries ? Ahmed - Original Message - From: <[EMAIL PROTECTED]> To: "Ahmed Farouk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, January 02, 2003 11:46 PM Subject: Re: subs

RE: Select Date Help

I think you could also use: WHERE YEAR(date) = 2003 AND MONTH(date) = 01 -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 5:09 PM To: [EMAIL PROTECTED] Cc: Max Clark Subject: Re: Select Date Help On 2 Jan 2003, at 14:2

Re: altering data structure

Il mar, 2002-12-31 alle 12:53, David T-G ha scritto: > Well, yeah, but I want to try to write portable code; just because I like > mysql doesn't meant that my customer (or some future contract employer) > will... Hi, I am reading a bit late, but let me suggest you Metabase. Metabase does a very

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: Select Date Help

On Thu, 2 Jan 2003 14:27:25 -0800, Max Clark wrote: >select * from table where date = '2003-01' aside from ...where (date>='2003-01-01' and date <= '2003-01-31') I think you could use ...where left(date,7) = '2003-01' http://www.mysql.com/doc/en/Date_calculations.html - Steve Yates - To know

Re: Select Date Help

On 2 Jan 2003, at 14:27, Max Clark wrote: > I have a DATE column (CCYY-MM-DD), I would like to do a query like this: > > select * from table where date = '2003-01' > > What additional information do I need to provide for this query to work > properly? You need to explain to us what result you e

Re: Select Date Help

Hi Max, You must enter this: SELECT * FROM your_table WHERE date LIKE "2003-01-%"; I think that you can more read about LIKE at http://www.mysql.org Best Regards, Boris Penchev - Original Message - From: "Max Clark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 03, 2

Text ?

quick question since I not using a front application to talk with mysql and all would be handle for now threw the terminal window how does one enter in alot of text into a field? I seen alot of db, with single line entries, but none with multi line? eg: db notes: date:1-2-2003 note:Well today, B

Select Date Help

Hi all, I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? Thanks in advance, Max -

Re: filters

On Thu, Jan 02, 2003 at 04:06:57PM -0600, Aaron Scribner wrote: > I am using Eudora and trying to filter these messages. I set it up to > "monitor" the To: field, however this is not doing anything. I also > noticed that there are no tags in the Subject lines of the messages sent to > the list

Re: filters

At 16:06 -0600 1/2/03, Aaron Scribner wrote: Ok, you guys are going to really hate me for this. I just signed up for this list and I am asking st00pid questions already. I am using Eudora and trying to filter these messages. I set it up to "monitor" the To: field, however this is not doing any

Re: Foreign Key problem? in MySQL 4.0.7

Haisam, - Original Message - From: ""Haisam K. Ido"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, January 01, 2003 10:29 PM Subject: Foreign Key problem? in MySQL 4.0.7 > I was able to create the "gid" table with no problem under mysql 4.0.7 > > CREATE TABLE gi

Newbie: MySQL + Java + web?

Hi all, I am new to MySQL and Java. A colleague has developed a solution that utilises MySQL, Java and HTML coding to produce a web based application and it is very cool. I have asked him how it all slots together and he has helped me a bit but I am still confused and he prob thinks I am too t

filters

Ok, you guys are going to really hate me for this. I just signed up for this list and I am asking st00pid questions already. I am using Eudora and trying to filter these messages. I set it up to "monitor" the To: field, however this is not doing anything. I also noticed that there are no ta

Re: SHOW INNODB STATUS output as SHOW STATUS?

Jean-Luc, - Original Message - From: "Jean-Luc Fontaine" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, January 02, 2003 2:14 PM Subject: SHOW INNODB STATUS output as SHOW STATUS? > Hello, > > I was wondering whether it would be possible, in a future release, to >

Re: Newbie - Where do I look for answers?

B. van Ouwerkerk wrote: www.google.com www.mysql.com (the manual) www.devshed.com -->server side --> mysql Also see http://www.webmonkey.com ... they had a MySQL + PHP tutorial on there at one point, specifically targetted to running an Apache + PHP + MySQL Linux box for Windows users. That

Re: An Idea

R. Hannes Niedner wrote: Isn't that funny: if I have a mysql related question and search google I end up in the mysql online documentation in 90% of cases. I find if I just use the word 'mysql' in my query on Google, I get fairly appropriate results too. Not using the word mysql often give

Re: subselects

How's your application written? i.e. J2EE? We've managed to put a layer in between the application and MySql that translates subselects on the fly into inner joins. This allowed us to quite painlessly move from MS SQL to MySql. "EXISTS" can be refactored into an inner join. "NOT EXISTS" can be

Re: host.frm

Check to see the existence/permissions of this file in the data directory. Regards, Bhavin. - Original Message - From: "Jason Steig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 01, 2003 11:43 PM Subject: host.frm > > > ./myqld: Can't find file : './mysql/host.frm

Re: Newbie - Where do I look for answers?

If you are familiar with MS-SQL and SQL in general then reading the manual should be no problem. Likewise, using a command line interface should be second nature. The MySQL manual is very complete. See chapter 4. In particular see 4.3, it very clearly explains how to setup the root password

RE: Admin/Client GUI - Win32 and Linux

I like SQLyog http://www.webyog.com/ JFercan ** sql ** -Original Message- From: Nilza Lafayette [mailto:[EMAIL PROTECTED]] Sent: January 2, 2003 14:59 To: [EMAIL PROTECTED] Subject: Admin/Client GUI - Win32 and Linux I'm running MySQL onto a Windows Advanced Server. I4m looking for a go

Re: Admin/Client GUI - Win32 and Linux

Nilza Lafayette wrote: I'm running MySQL onto a Windows Advanced Server. I´m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? There's at least one linked to from the mysql site and several mentionned

Re: mysql_use_result

Hi, Strange...you should be able to find the number of fields from resultset with mysql_num_fields.You use MYSQL_RES like parameter for mysql_fetch_fields ? How do you use mysql_fetch_fields? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-ma

Re: Newbie - Where do I look for answers?

Hi, www.google.com www.mysql.com (the manual) www.devshed.com -->server side --> mysql devshed has some very good articles.. Not sure if you think those are easy. Have fun, --B. At 12:20 02-01-2003 -0600, DIetrich Speer wrote: I am a complete newbie to mysql and Linux. I completed the inst

Re: Desperate - failed: Lost connection to MySQL server during query

Hi, You right.RH8 have a problem with glibc.All people from the list recommende to make a downgrade to version 2.x or download binary distribution from MySQL site which is compiled with the right version of glibc. Are and other ways to solve your problems but i think you need to a stable solution.

Re: host.frm

Dave, Please trace the author (Jason) of the problem correctly, but I am sure you just tried to be helpful - no harm done. :-)/h On 1/2/03 11:37 AM, "Christensen, Dave" <[EMAIL PROTECTED]> wrote: > Again, this specific problem is mentioned in the reference guide. From that > and my experiences

Admin/Client GUI - Win32 and Linux

I'm running MySQL onto a Windows Advanced Server. I´m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? Thanks. Janine. = Janine __ Do you Yahoo!? Yahoo!

Re: FAQ hosting site (was "Re: An Idea")

Why not try Tek-Tips? Maybe they will sponsor something for free. They may have everything you need. Just a thought. [EMAIL PROTECTED] <[EMAIL PROTECTED]> Bruce - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Peter Lovatt" <[EMAIL PROTECTED]> Cc: "Stefan Hinz, iC

Re: FAQ hosting site (was "Re: An Idea")

Yes, you need to specify the IP address that you plan on using for this process instead of the computer name. If you use Windows, chances are your using MYODBC or some other similar driver. Case #1: You setup a DSN in the ODBC area of the OS Case #2" You setup a DSN-less connection to your db. C

RE: host.frm

Again, this specific problem is mentioned in the reference guide. From that and my experiences, we're looking at a permissions issue. Hannes needs to look at the permissions on his data and logging directories to make sure that they are set to the default mysql:mysql. -Original Message

Re: FAQ hosting site [FAQTS.COM]

David T-G wrote: I suppose they might. Never heard of 'em... Can I strongly suggest there be a link from the MySQL documentation page to: http://www.faqts.com/knowledge_base/index.phtml/fid/52 It is the MySQL section of FAQTS.com which, IMHO, is the best online FAQ site. It has very goo

db crash

Hi all ... our db server is attackt by a root kit, from our old db server the only thing we have are the log files knows someone a little script or app to filter all the querys out of the standard log format of the mysld.log file ..?!? thx a lot 4 all kind of support best regards andreas

ARGH! :) [OT]

Original Message Received: (qmail 24061 invoked from network); 2 Jan 2003 20:14:30 - Received: from unknown (HELO web.mysql.com) ([EMAIL PROTECTED]) by mail.fibrespeed.net with SMTP; 2 Jan 2003 20:14:30 - Received: (from lists@localhost) by web.mysql.com (8.11.6/8.11.6)

test

Since just before christmas I have not gotten any e-mails from the mysql-mailing list... so I send this to test my access, can anyone see it? Please reply in private so that I know if it works or not... /Christian Andersson -

Re: RE: FAQ hosting site (was "Re: An Idea") (fwd)

sql,query,queries,smallint On Thu, 2 Jan 2003, Peter Lovatt wrote: > I was looking for a reasonably heavyweight php application, there are some > lightweight ones and some half finished ones and some perl ones, but none > that were what I was looking for. > > Any suggestions would be appreciated,

Re: Year Lists

Actually, had I read your (second?) email properly, I would've suggested something slightly different. (I guess, to get a 0, rather than count(*) it should've been a count(startyear)). Instead of a LEFT JOIN, which will create NULL rows for any years that don't have a project, do a straight JOIN u

Re: Connect Error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jonh, You're probably forget the -p param for mysqladmin ask you your root password. merlin Escreveu John Wilkerson em Thursday 02 January 2003 04:11 am: > Hi, > > I'm a newbie with MySQL and get the following error: > > bin/mysqladmin:

subselects

Hi All I know that this maybe a repeated question here but I just need to know the updates. I am asking about the new feature of subselects which should be implemented in version 4.1 (thats what i know), when this version is expected to the light ? For me this single feature (subselect) will e

Re: Year Lists

At 13:53 + 1/2/03, Steve Vernon wrote: Thanks for the email... Brilliant idea, but it does not give 0 for rows without a project for a year. It gives 1 for these rows. COUNT(*) counts rows, not values. Try using COUNT(projects.startYear) instead, which will count only non-NULL values. (Th

RE: Desperate - failed: Lost connection to MySQL server during query

Thanks for the help John, I really don't know all the specifics of the hardware setup as it is all out at our ISP, I know its a rack mounted P4 and its going into a Cisco switch but that's about it. We have made some progress though and as strange as it sounds its really looking like its something

Re: host.frm

You could probbly run the mysql_install_db this might help. There is something on the mysql.com site that says how to deal with this. - Original Message - From: "Jason Steig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 01, 2003 11:43 PM Subject: host.frm > > > ./

mysql_use_result

Greetings... When I am using mysql_use_result API to retrieve results, I am always getting 0 value for the max_length member of MYSQL_FIELD structure which is returned by mysql_fetch_fields. But when I am using mysql_store_result, max_length has correct value. Is this normal ? Is there any way t

Newbie - Where do I look for answers?

I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end f

RE: Using files stored as blob

If you can give more info about your development environment and explain a little what you want to do, some of us may help. Tim Best <[EMAIL PROTECTED]> wrote: >OK I got files to upload to my MySQL server but now how do I retreive them >for distribution by email for instance. > >When I do a que

Re: user/root

On 1/1/03 5:46 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote: > Well it would appear that I finally have a connection Congrats. > q. since I am root, do I still need to GRANT a database to myself? > or just a to a new user. aka: bob@localhost If you are the only person using the computer that t

Re: FAQ hosting site

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % > Sure; it's the least I can do. Look for mysql.justpickone.org to be % in % > the DNS tables by tomorrow. By then the % [EMAIL PROTECTED] % > mailing list will be

RE: host.frm

I had someything similar It was all down to permissions...make sure that the permissions on the sql dbfolder allow the sql demon access. And you have run the install_db script to create it in the first place Wayne -Original Message- From: Jason Steig [mailto:[EMAIL PROTECTED]] Sent:

Re: Year Lists

Thanks for the email... Brilliant idea, but it does not give 0 for rows without a project for a year. It gives 1 for these rows. As a test idea, I removed the group by and count, and instead of count outputted the start and end year. What that gave me was say for 1953 where there was 3 projects,

Connect Error

Hi, I'm a newbie with MySQL and get the following error: bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I get this whenever I attempt to connect to MySQL. I am running Slackware 8.1, MySQL Max 3.23.54b. I have set

user updates trace

hi all, anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but they seems not to trace

Peculiar Problem

Placed At : MAATDLN Govind Raghuram@SATYAM 01/02/2003 12:23 PM Hi, I am trying to do an update query - update bb_activeamtbalance set ui_orgbalance = "+orgbalance+",ui_remainingbalance ="+rembalance+",ui_usedcurrently="+usedbal+",ui_upddatetime=n

Re: user/root

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rick -- ...and then Richard Nagle said... % ... % [MacG4a:/usr] rnagle% mysql -u root -p % Enter password: % Welcome to the MySQL monitor. Commands end with ; or \g. ... % % Well it would appear that I finally have a connection Yay! :-) % % q.

Re: query requiring two results from one table?

Yes, this is what i ended up doing and it works just fine. I wanted the results in one record and this does the job just fine. I don't know enough about performance issues and whether this kind of query is inefficient compared to using a different database layout, but this is not a highly int

New Member question - Training

Hello Folks - I've been lurking for a few days so I thought I would go ahead and ask... I'm in (metro) Atlanta. Is there anyone/any place here that trains on using MySQL? Ideally, I would like someone to train me on how to use MySQL with phpMyAdmin (2.3.2) on my virtual servers. I also would like

mysql@lists.mysql.com

>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: mys

Re: query requiring two results from one table?

Hi, Greg's table definitions seem fine te me. Couldn't he just use: select game.gameid, game.dateTime, home.teamID, home.name, away.teamID, away.name from Games game left join Teams home on home.teamID = game.homeID left join Teams away on away.teamID = game.awa

How can we tell if we're maxing out MySQL/InnoDB capacity?

Hi, Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. We were serving about 300% of our normal load. In my opinion MySQL scaled mo

Mysql 3.23.54a install failure

Hi all! I am trying to install Mysql 3.23.54a on my Slackware Linux machine and when I do make test it fails like this : root@southpark:/home/cartman/mysql-3.23.54a# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases ERROR: 1033

Re: host.frm

On 1/1/03 8:43 PM, "Jason Steig" <[EMAIL PROTECTED]> wrote: > > ./myqld: Can't find file : './mysql/host.frm' (errno:13) > > does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or par

Re: Accessing last_insert_id problem.

LAST_INSERT_ID is held for the database connection, not agaist the server So, as long as you do not do another insert using the same database connection, LAST_INSERT_ID will be fine. (for database connection, $dbh=DBI->connect. ) No table locking required. Regards M On Wed, 18 Dec 2002

Re: FAQ hosting site

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce -- ...and then Bruce Lewis said... % % Why not try Tek-Tips? Maybe they will sponsor something for free. They may % have everything you need. I suppose they might. Never heard of 'em... % % Just a thought. % % [EMAIL PROTECTED] <[EMAIL

Re: FAQ hosting site

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Lovatt said... % % Hi Hi! % % Like the look of the way its taking shape. Glad to hear it. Come and sign up on the new list, then :-) % % I am not sure if there is existing faq software (I've checked sourcefo

Re: user/root

On Wednesday, January 1, 2003, at 08:06 PM, R. Hannes Niedner wrote: You have a recent installation of mysql then you can just run SET PASSWORD FOR root@localhost=PASSWORD('tko'); and skip the flush privileges. All explained here: Be

RE: Connecting M. Access Forms to insert data into mysql

Have you tried Linking the MySQL tables into access? I do not know why you would still have a memo field. Also if you need it you could map the memo field in Access to a TEXT or a BLOBTEXT in MySQL. If you have access to Visual Basic it could be a bettere option. HTH JFernando ** sql ** -