hello everyone

my name is alan madsen. while i am very well grounded in complex systems and database management that is archaic by today's standards, i am looking at a creating a server-side php/mysql environment for a very simple database application with only the experience of recent light readin

hello everyone

my name is alan madsen. while i am very well grounded in complex systems and database management that is archaic by today's standards, i am looking at a creating a server-side php/mysql environment for a very simple database application with only the experience of recent light readin

index change moving files to other computer?

e configs, all with the same results. Many thanks. alan -- Alan <[EMAIL PROTECTED]> - http://arcterex.net "There are only 3 real sports: bull-fighting, car racing and mountain climbing. All the others are mere games.&quo

Re: index change moving files to other computer?

t upgrade :) Sorry for being such a lamer n00b, but it's not my DB and mysql has always "just worked" for me (though I don't use many 600k row tables :) Alan -- Alan <[EMAIL PROTECTED]> - http://arcterex.net ---

procedure entry point question

Hello,   I'm working with MySql 4.0.18 on Windows2000 and have a question about the C API function mysql_real_escape_string( ).   The program I'm working on compiles and links flawlessly, but at runtime, I get a system pop-up with the error: "The procedure entry point mysql_real_escape_stri

Re: procedure entry point question

made error. Thanks. - Original Message - From: Alan To: [EMAIL PROTECTED] Sent: Saturday, February 28, 2004 5:07 PM Subject: procedure entry point question Hello, I'm working with MySql 4.0.18 on Windows2000 and have a question about the C API

Right join after inner join has wrong result

WHERE C.B IS NULL Expected Result: A3 -- 2 Actual Result: A3 -- 1 2 2 Tried in postgresql and it works like the expected result. >Fix: none >Submitter-Id: >Originator:Alan Tam >Organization: >MySQL support: none >Synopsis: Right join after inner join ha

perl, MySQL, and Lost Connection while executing error!

me type of error log that I could reference to check for more information? Thanks for any and all help!! If you need any more information, I would be more than happy to answer any questions! Alan - Before posting, please che

last_insert_id() returns 0 in windows

Okay, I've seen just about every question on last_insert_id(), except this one: I am running MySQL on Win XP and when I generate a test table (test) with an AUTO_INCREMENT column (aid) and a second column (a) then use an insert statement like: INSERT INTO test (a) values (1); then: SELECT LAST_INS

About installing MySQL on Linux 7.1

Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux! = I try to follow the instructions mentioned in manual.txt but it didn't = work. Can you help me and tell my how to install it? Thanks!

About installing MySQL on Linux 7.1

Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Thank

Installing MySQL on Linux 7.1

Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Than

full-text search problems (newbie)

sec) But when I try to match on 'exi', I get: mysql> select title from content where match (title,center_content,right_content) against ('exi'); Empty set (0.00 sec) As far as I can tell, this *should* be working. Can anyone help please? Regards and TIA. alan -- Alan &qu

Re: full-text search problems (newbie)

orning, just in case, but when I execute the query again, I still get the same results. Any other ideas? This works for others I am guessing. I've tried this on the binary 4.0.4-beta on a redhat 7.2 system and 4.0.1-alpha compiled from source on a gentoo system. -- Alan "Ar

Re: full-text search problems (newbie)

On Sun, Oct 13, 2002 at 10:58:53PM +, Sergei Golubchik wrote: > Hi! > > On Oct 13, Alan wrote: > > > > mysql> select title from content where match > > (title,center_content,right_content) against ('updates'); > &g

Re: Help downgrading

g you may have to worry about it deleting /var/lib/mysql when you uninstall the old package, but I'd hope that package maintainers wouldn't just nuke a db directory without warning :) alan -- Alan "Arcterex" <[EMAIL PROTECTED]> -=][=- http://arcterex.net "I used to

Creating new table from distinct entries

going wrong? Alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

finding NULL records

for test_id. Is there some trick to finding null valued records in MySQL? This same sql has always worked on any other dbms I have used. thanks alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: finding NULL records

; SELECT * FROM tests WHERE test_id IS NULL Yes, that works, but I was also trying SELECT * instead of just the key field (just a typo in the example). The problem was in the equal sign versus the 'IS' operator. Any reason why MySQL does not honor =NULL? Seems kind of odd. alan

RE: backup and restore a database in a query ？

mysql_hotbackup.htm hope this helps, alan -- Alan Williamson, Technology Evangelist SpikeSource Inc. t: 650 249 4279 b: http://compiledby.spikesource.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: show master/slave status privileges ?

> I have made a user with the following command: > GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r' Silly question Morten, and I am sure you have probably done it, but you are definitely running: % mysql> FLUSH PRIVILEGES; -- Alan

RE: Performance of DB with many tables

gle table (more than one file handle since there is multiple files that describe a table under MyISAM). BTW on Linux systems you can check this using: % lsof -- Alan Williamson, Technology Evangelist SpikeSource Inc. Daily OS News @ http://compiledby.spikesource.com/ -- MySQL General Mai

RE: HTML in MySQL?

e any other character, so will have no problems. HTML is just string; treat it as such and don't give it anymore credit than that and you'll be fine. -- Alan Williamson, Technology Evangelist SpikeSource Inc. Daily OS News @ http://compiledby.spikesource.com/ -- MySQL General Mai

RE: LVM-snapshot + mysqldump -- is this a reasonable backup strategy?

abase and therefore not have to bring it down ever. I wrote a blog entry about this very thing, and had some interesting comments back on http://blog.spikesource.com/mysql_hotbackup.htm Hope this helps, alan -- Alan Williamson, Technology Evangelist SpikeSource Inc. Daily OS Ne

RE: cluster or replication

TER that has to accept all the INSERT/UPDATE/DELETE (or anything that will make the data change). All other nodes would be considered SLAVEs and be READ-ONLY. Hope this helps. a -- Alan Williamson, Technology Evangelist SpikeSource Inc. Daily OS News @ http://compiledby.spikesource.com/

RE: Major Difference in response times when using Load Infile utility

e import SET AUTOCOMMIT = 1; SET FOREIGN_KEY_CHECKS=1; -- Alan Williamson, Technology Evangelist SpikeSource Inc. Daily OS News @ http://compiledby.spikesource.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database Replication

All, I have been tasked with setting up DR between two different sites. Is there a favorite tool or GUI that someone could recommend for this task? Regards, Alan L. Fisher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

InnoiDB Backups

All, I would like to knew if anyone knows of a way to automate innoDB Hot Backups of several databases that can be set to occur at off hours. Also, is it possible to run several backups at one time. I am using MySQL 4.1.x on a Solaris system. Thanks, Alan Fisher -- MySQL General Mailing List

GUI Tools for administering and reporting

All, Is there a recommended GUI that will administer multiple MySQL 4.x databases. I need the ability to monitor connections, health, users, etc. and notify me when there is a problem with an instance. Regards, Alan L. Fisher GPI -- MySQL General Mailing List For list archives: http

C API field type values are inacurate - help

x27;standard' distribution API, but if not, how to I modify the API to provide this? thanks alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

User Security and Updating/Retrieving Values

MySQL Server v4.1.x Is there a table in any instance of mysql that I write some queries and insert/update statement against for moving databases between systems? Any assistance would be appreciated.

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

In all probability it's "(x_section.Status & 1) = 0" and "(x_instance.Status & 255) = 0" that's giving you the problem. Unfortunately this is a database schema problem not a query fix. By putting a computation on a field into the WHERE clause, you're forcing the database to do that computation

Re: Right join after inner join has wrong result

ed to submit it as bug 4893 anyway. The syntax there should be correct. -- Regards, Alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

building link error

Dear sirs, I have mysql 4.01 installed on my pc (not source,only binary)on win98 (I tried in win XP too).I downloaded myodbc source (3.51)and tryed compiled release with nmake (using makefile included in source)but aving a link error "unresolved esternal _aulldvrm in mysqlclient" (same message

Variation of SELECT DISTINCT

ompt"; (sorry if the spacing is weird) I need to drop the rows returned that have the same part_description field, like the DISTINCT clause does for rows, i need the same thing for a field value, how can I do this? Thanks for the help, Alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

With respect to this problem, I am not running on Windows, but Redhat, and seeing this problem often. Which part of: http://www.mysql.com/documentation/connector-j/index.html#id2803835 should i be looking at? thanks alan -- MySQL General Mailing List For list archives: http

Re: Using OR

huge performance gain. hope this helps, i'll let the real SQL experts jump in here and give their response. -- Alan Williamson, City Planner w: http://www.BLOG-CITY.com/ e: [EMAIL PROTECTED] b: http://alan.blog-city.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.

just the list please!

Can people please just email the list and not the person *AND* the list!!! i get duplicate emails and its very annoying to what is a great list so far. kinda puts me off from answering peoples questions! thanks! :) - Original Message - From: "Alan Williamson" <[EMAIL P

MyISAM vs. INNODB for a single blob table

table using INNODB? Should it have been created as a INNODB for better performance? Any thoughts, insights, would be listened to intensely! :) thanks -- Alan Williamson, City Planner w: http://www.BLOG-CITY.com/ e: [EMAIL PROTECTED] b: http://alan.blog-city.com/ -- MySQL General Mailing List For

Re: MyISAM vs. INNODB for a single blob table

Thanks for that Chris, interesting thoughts. For clarification, there is *NO* UPDATEs running on this table. Not a single one! :) Many more SELECTs than INSERTs Chris Nolan wrote: Alan Williamson wrote: A quick question for the hardcore MySQL experts out there. I have a simple table

CURDATE() bug?

CURDATE() support numeric addition like this? Or is the "+0" purely a casting-hack to get the right format. Its not meant as pure addition. Thoughts? thanks alan -- Alan Williamson, City Planner w: http://www.BLOG-CITY.com/ e: [EMAIL PROTECTED] b: http://alan.blog-city.com/ -- MyS

Re: CURDATE() bug?

Does CURDATE() support numeric addition like this? Or is the "+0" purely a casting-hack to get the right format. Its not meant as pure addition. Yes, hav a look at http://www.mysql.com/doc/en/Date_and_time_functions.html for explaination further for addition, use date_add(curdate(), interval 1

Re: CURDATE() bug?

RTFM! and what was the reason for this rudeness? Can't you explain yourself without descending into this sort of language? I do read the manual, and it is this reason i posted to the list. Clarity is a wonderful thing, and sadly the manual isn't clear on this matter. I stand by my original s

Re: MySQL on Linux

dan wrote: the most popular would have been Red Hat, which doesn't have this limit you speak of, even plain vanilla install (no twiddling needed). Not to spoil a perfectly good pontification ... but i have to say that we have a Redhat8 distribution running on a Dell PowerEdge Server and when A

Re: MySQL on Linux

Thank you, a much reasoned and sensible reply. This is information people can use, as oppose to the posts that 'say well its okay for me, you must be stupid' types. ;) Dan Nelson wrote: In the last episode (Apr 06), Alan Williamson said: the most popular would have been Red

MySQL testing programs

our results. thanks alan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: date conversion problem

this might give you some ideas select CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV E)) DATEGOLIVEF from my table p > -Original Message- > From: Alex Behrens [mailto:[EMAIL PROTECTED]] > Sent: Friday, 22 November 2002 13:01 > To: MYSQL > Subject: date convers

RE: Embarrassing: can't log in

it only takes a few minutes to uninstall and install... > -Original Message- > From: Amittai Aviram [mailto:[EMAIL PROTECTED]] > Sent: Monday, 2 December 2002 9:37 > To: Mysql > Subject: Embarrassing: can't log in > > > I've got an embarrassing problem. I installed MySQL on my WinXP machi

Extracting foreign key info via ODBC (via JDBC)

-InnoDB tables), as of version 3.32.50. I don't want to do an upgrade unless I'm certain that I will get the feature. Can anyone enlighten me? Many thanks in advance, Alan. - Before posting, please chec

Re: Extracting foreign key info via ODBC (via JDBC)

> Mark Matthews wrote: > > > Alan Hodgkinson wrote: > > > > I would like to extract the meta data describing foreign key > > relationships using ODBC (actually in Java using JDBC). > > > > My current version of mySQl 3.23.49 does not s

RE: How long is my piece of string?

You need indexes as soon as (or rather just before) they provide a performance difference. Alan -Original Message- From: Iain Lang [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 December 2002 11:15 AM To: [EMAIL PROTECTED] Subject: How long is my piece of string? . Dear List, I'm

Re: cannot get foreign keys to work

y.cnf file and remove the # character before the parameter that starts with innodb_ See section 4.1.2 `my.cnf' Option Files, and section 7.5.2 InnoDB Startup Options. Unfortunately, MySQL silently accepts and ignores 'innodb' type tables when innodb is dis

history of MySQL

everyone at MySQL simply forgotten? Any answers would be appreciated. Thanks. Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: Why I can not connect to mysql (using jdbc)

System.out.println("trouble to connect" + se);} Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Problem with JDBC2 driver across databases

rs.setString(2, "Fred Bloggs"); rs.insertRow(); } An SQLException is reported saying that table "sales_demo.contacts" does not exist. It should be inserting into table "sales.contacts". --Alan ---- Alan Jones, Sen

RE: Problem with JDBC2 driver across databases

Thanks Mark. I've now downloaded 2.0.13 and I'll see if the problem is still there. Meanwhile I've used a workaround involving two connections, one to each database, so the insert works. Not ideal, though. --Alan -Original Message- From: Mark Matthews [mailto:[EMAIL P

RE: Problem with JDBC2 driver across databases

offers version 2.0.4 for download. Should this be updated? --Alan -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 6:44 PM To: Alan Jones; [EMAIL PROTECTED] Subject: Re: Problem with JDBC2 driver across databases First, I would recommend upg

Internal Select statements using IN and NOT IN

d then some. But I've searched the documentation and haven't found anything. If anyone knows a way to perform an internal select similar to what is shown above, please let me know. --- Alan Coleman [EMAIL PROTECTED] -

RE: Internal Select statements using IN and NOT IN

Never mind, I figured it out by reading a previous question and I understand how to use Left join to do this. -Original Message- From: Alan Coleman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 5:22 AM To: [EMAIL PROTECTED] Subject: Internal Select statements using IN and

Re: Tables in MySQL

sold > from 13 in table 12 -> then does this with table 13 and finally creates > table 19 (because new) and inserts like in Cosumter A's way... > > now the question: is MySQL aware of being with over 1500 tables ??? - is > there a better way or more efficent way to do the sa

weblogic integration problem

I am trying to create a mysql connection pool in Weblogic 6.1 using the JConnector driver and failing. All I get is "no suitable driver" which usually means that the URL and properties aren't right for the driver I'm using. I defined the pool as: name: MysqlPool URL: jdbc:mysql//192.168.1.100:330

mysql and credit cards

Greetings: I was wondering if anyone has any ideas about the best way to store credit cards in a database ... and I'm not referring that much to the field type, but rather encrytption techniques. Thanks. Alan Cox [EMAIL PROT

up arrow using mysql client on windows

rough previous commands. Is this feature disabled in Windows? Is there a switch I can throw to enable it? Thanks, and please no heat about not being on Linux... it wasn't my choice... Alan - Before posting, please chec

NULL valule

I have a date field, how do I check if it is null or empty in sql statement. I tried : select * where fDate = NULL; and also tried where fDate = ''; Both return nothing but actually there are records with no value. __

Re: Log in problem...

> > and then issuing the password, I get the following message: > > Error 1045: Access Denied for user: 'user@localhost' (Using password: YES) > > I have tried: > > 1. restarting mysqld (several times) >

It keeps hanging it's self, so I killed it :)

ing communication packets) 010208 03:54:55 mysqld restarted Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

Restart server when it hangs?

ing communication packets) 010208 03:54:55 mysqld restarted Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

Thanks

Just wanted to say thanks to all the people that help out here. I have seen more problems solved here than anywhere and not just on mysql. It has been so much fun to be on this list and see everyone cooperate to get these problems fixed. Thanks again. Alan Halls Adoption.com Webmaster

RE: Two query issues -- need help

Here is what our company uses to do the page division on adoptablekids.com I have used it for a few other applications with minimum changes This code would give you five per page. select * from profile order by id DESC return if ({sys:num_pages} <= 1)

Is sequencing possible in Mysql?

I read in the O'reilly book about sequencing but it only mentions msql. Can you do the same thing with Mysql? I have a table that has 2 fields. 1 is an auto-incrementing field the other is a profile id that is joined to some other tables to track how often a record was accessed. The way we are do

Problem installing MySQL & php

Hi all, Newbie alert, please be gentle. My system is Redhat 7.0 with glibc-2.2-12, kernel 2.2.16-22. I have started a project which involves learning php & mysql, so I bought myself a couple of big books to sit down and do some learning! Problem is, I cannot get MySQL & php installed together

RE: Random record

You have to have version 3.23 of mysql and then you can add ORDER BY RAND() to the end of your query. Alan -Original Message- From: joe [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2018 4:40 PM To: MySQL Subject: Random record Does anyone have any good ideas on how to pull a

conflict with msql

I am now using msql and wants to change to mysql. Is there any problem in install both in the same server? Regards, Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

mysql support questions

this should be the same on the server of our web site provider right?? Cheers Alan Shum Starf Ltd PO Box 283 Orewa Hibiscus Coast NEW ZEALAND Ph + 64 9 414 6172 Fax + 64 9 414 6182 Mobile 025 832 682 http://www.starf.net CAUTION: This message may contain privilaged and confidential inform

disconnecting from database

I'm developing in asp and connect to databases using something like this: (using ODBC) set db = Create.ServerObject("ADODB.Connection") db.open "databaseName;" This works fine and I can get and insert data with no trouble. However, when I do: db.close set db=nothing Nothing happens. The conn

Inserting Master and Details records

to grab a generator ID and using that (guaranteed to be unique) for both the primary key of the master and the foreign key of the detail records. Surely there is a good method for use with MySQL....? Alan McDonald http://www.m

RE: Inserting Master and Details records

? Or does insert_id() return another connections last insert? Alan > -Original Message- > From: Peter Lovatt [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 0:59 > To: Alan McDonald; [EMAIL PROTECTED] > Subject: RE: Inserting Master and Details records > &g

RE: Inserting Master and Details records

Sorry your second link makes that claim a little clearer - it's on a per-connection basis Alan > -Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 16 October 2002 23:58 > To: [EMAIL PROTECTED] > Cc: Alan McDonald > Subject: R

RE: a mysql question

I think you need to give us the SQL you are using to do the search - we'll ba ble to see what your are trying to do better Alan > -Original Message- > From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 15:37 > To: [EMAIL PROTECTED] > Subje

Import from files

Is it possible to update a field using SQL with the contents of a text file previoously written to disk? I want to update a mediumtext field with the contents of c:\data\mytext.txt file. update mytable set mymediumtext= filecontents where id=number... ? Alan

FW: Select statment

John, StudioName? GenreName? F_Name? L_Name? DatabaseName? ServerName? Alan I can't seem to figure out the select statement to get the name. Do I need the the StarID or ActorID in Titles table? Thank you. I am using PHP and MYSQL. Studios (StudioName, StudioID) Genres (GenreName, Ge

RE: timestamp bug increments by one day

isn't that the month changing? it's changing from october to january...?? Alan > -Original Message- > From: Jay X [mailto:sparqz50@;hotmail.com] > Sent: Monday, 21 October 2002 12:20 > To: [EMAIL PROTECTED] > Subject: timestamp bug increments by one day &g

error in the list?

can someone tell me why I get this error back from postings? Your message was not delivered for the following reason: E-mail Account: lists-mysql is over the limit of 31457280 bytes. Automated Postmaster Alan McDonald http://www.meta.com.au

FW: The request properties can not be supported by this ODBC Driver.

SQL ASP I can't seem to find any examples of saving text area form inputs to TEXT type fields. They all seem to be text inputs or strings being saved to varchar fields... Can someone point me to an example of saving large text quantities to a TEXT Type field in ASP? Thanks Alan McDonald

adUseClient

SQL The docs say that recordset1.RecordCount will return the correct value if adUseClient is used as the cursorlocation setting. I find that this is not correct - is there another setting which needs to be mae to make this return correctly - my return matching rows setting is also set. Alan

Altering Table errors

.. Is there another way? thanks Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

RE: Altering Table errors

But after a while it does, cause I only have to wait a while with no activity on the database, and the command executes. So it's not permissions Alan > -Original Message- > From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] > Sent: Tuesday, 29 October 2002 1

RE: Altering Table errors

Then, why..., if I wait a little longer, does the alter command work? I do not change the the permissions in the meantime. I just wait. Alan > -Original Message- > From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] > Sent: Tuesday, 29 October 2002 1:38 > To: Alan M

RE: Access2MySQL

I use MySQLFront and is creats the tables and imports the data with one click never had a problem Alan > -Original Message- > From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com] > Sent: Wednesday, 30 October 2002 9:15 > To: [EMAIL PROTECTED] > Subject: Access2MyS

Error Code Question

it executes. Is there something else at play here? Alan ' Keywords: ' myODBC, mySQL, ' Error: ' Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to '.\DBNAME\#sql2-61-19.MYI' ' (Errcode: 13) ' Environment: ' WkStn - Windows

RE: Removal of Primary Key in Mysql

Because a primary key is a table property and the index of the key is a property of the primary key. If you want ot drop a primary key you alter the table > -Original Message- > From: Eric Frazier [mailto:ef@;kwinternet.com] > Sent: Tuesday, 5 November 2002 15:26 > To: Paul DuBois > Cc: Um

RE: MySQL and amanda

I was under the impression that hotbackup was only available with innodb tables where do you get amanda from? Alan > -Original Message- > From: Lewis Watson [mailto:lists@;visionsix.com] > Sent: Wednesday, 6 November 2002 14:22 > To: mysql > Subject: MySQL and amanda > &

RE: Copy Records in a table...

insert into mytable(field1, field2, field3) select field1, field2, newvalue from mytable where productcode=xx > -Original Message- > From: Doug Coning [mailto:lists@;coning.com] > Sent: Friday, 8 November 2002 14:35 > To: [EMAIL PROTECTED] > Subject: Copy Records in a table... > > > Hi eve

RE: How to port MS Access to MySQL ??

MySQLfront does it all > -Original Message- > From: tmb [mailto:topmailbox@;yahoo.com] > Sent: Friday, 8 November 2002 23:18 > To: [EMAIL PROTECTED] > Subject: How to port MS Access to MySQL ?? > > > Is there a tool for doing a quick port from MS Access > to MySQL? > > Or must you manua

RE: Copy Records in a table...

maybe it doesn't then in MySQL - it does elsewhere Alan > -Original Message- > From: David Felio [mailto:david@;ark.org] > Sent: Saturday, 9 November 2002 1:59 > To: MySQL List > Subject: Re: Copy Records in a table... > > > Is the implementation of thi

RE: mysqld refuse to die

As Far As I Know > -Original Message- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: Saturday, 9 November 2002 23:37 > To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED] > Subject: Re: mysqld refuse to die > > > Yes.All processes are named "mysqld"...less one "mysqld_safe" > which

RE: mysqld refuse to die

Also In My Humble Opinion (IMHO) For What It's Worth (FWIW) > -Original Message- > From: Gelu Gogancea [mailto:ggelu@;arctic.ro] > Sent: Saturday, 9 November 2002 23:37 > To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED] > Subject: Re: mysqld refuse to die > > > Yes.All processes are name

RE: little problem, I need some help...

Every SQL database requires the ability to locate a record which is unique in some way. You can't have two records which look the same. That's why you need to define a primary KEY on a column or coumns. You need to read a primer on SQL databases Alan > -Original Messag

RE: PHP bias (Way OT)

I agree mostly,... but why is ASP worthless? Alan > -Original Message- > From: [EMAIL PROTECTED] [mailto:vanboers@;why.dedserius.com]On > Behalf Of Van > Sent: Monday, 11 November 2002 6:21 > To: Paul DuBois > Cc: MySQL > Subject: Re: PHP bias (Way OT) > > &

RE: Newbie Question - Query works in access but not MySQL

by it? you can ignore the obsolete in the main select when it's returned since it will all be the same value... put it first. Alan > -Original Message- > From: Ed Reed [mailto:ereed@;nearfield.com] > Sent: Tuesday, 12 November 2002 18:54 > To: [EMAIL PROTECTED]; [EMAIL

  1   2   >