Table crashes

Hello Some one my tables have crashed (again). I had to repair them ASAP since the db is in my production enviroment. 1. How can I find the cause of the crashes? 2. I've created a my.cnf and added the following lines. Is the format correct? [mysqld] set-variable = myisam-recover=BACKUP,FORCE set-

Re: Table crashes

Hi, Jonas crashes occurs for some reasons like : - unclean tables ( tables are closed improprely), - hardware problems - something goes wrong in the system - know bugs Check that your tables are clean, before start using them. It seems that you said the REPAIR doesn't occurs after you configuring

What is 4.0.15-max-debug

Dear All I have recently reformatted my hard disk and done a clean install of 4.0.15 on Win 2k Pro SP4. I used C:\> C:\mysql\bin\ mysqld --install This created a mySQL service and it works ok. I happened look at a log in the data folder and noticed 031007 9:37:53 InnoDB: Started MySql: ready

RE: RAID, miiror OR replication?

Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem. 1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3. What

RE: [Fwd: MySQL w/dual-master replication?]

Is the system read-heavy or write-heavy? Cheers, Andrew -Original Message- From: Don MacAskill [mailto:[EMAIL PROTECTED] Sent: Monday 06 October 2003 20:47 To: [EMAIL PROTECTED] Subject: [Fwd: MySQL w/dual-master replication?] Hey all, I sent this a few days ago, but it may have got

RE: Help With a DATETIME Query

Hi, I would do this in the application layer something like this: $list_of_days_you_want_to_look_at = ('mon','tue','wed'..); Foreach ($day in $list_of_days_you_want_to_look_at) { use a similar query to below but geared to only look at $day instead; } You should get an output like this:

RE: RAID, miiror OR replication?

Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem. 1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3. What

RE: Help With a DATETIME Query

Hi, I would do this in the application layer something like this: $list_of_days_you_want_to_look_at = ('mon','tue','wed'..); Foreach ($day in $list_of_days_you_want_to_look_at) { use a similar query to below but geared to only look at $day instead; } You should get an output like this:

FW: [Fwd: MySQL w/dual-master replication?]

Is the system read-heavy or write-heavy? Cheers, Andrew -Original Message- From: Don MacAskill [mailto:[EMAIL PROTECTED] Sent: Monday 06 October 2003 20:47 To: [EMAIL PROTECTED] Subject: [Fwd: MySQL w/dual-master replication?] Hey all, I sent this a few days ago, but it may have got

Re: error messages in different languages

"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > > I have two questions about error messages in MySQL. > > 1. Section 4.6.2 talks about Non-English error messages. It says that for > recompiling the errmsg.sys file, one will issue a comp_err command at the SHELL > prompt. > Does such a

DATE / DATETIME in IF(): BUG???

Dear all,   anyone knows why the following is going wrong (I expect 1 in the columns Total and Open)? I suppose it is because MySQL is internally casting the IF expression (which is DATE vs DATE or DATE vs DATETIME) internally into a STRING before comparison, but not sure about that   (String) '20

Compression: Security or Zipping?

Hi group, I have read in the MySQL manual that the client/Server Compression protocol adds some security to the application. Does anyone have more information on this? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office

RE: Compression: Security or Zipping?

> Hi group, > > I have read in the MySQL manual that the client/Server > Compression protocol adds some security to the application. > > Does anyone have more information on this? > It adds security by compressing the network trafic, which is more security by obscurity, as this might stop a ca

SV: Table crashes

Hello > crashes occurs for some reasons like : > - unclean tables ( tables are closed improprely), > - hardware problems > - something goes wrong in the system > - know bugs > Check that your tables are clean, before start using them. MyODBC 3.51 is the only way that I access the database. (MyODB

printing reports

Greetings, In MySQL, how can I create and print reports without the help of neither a scripting language(e.g. php) nor a thrid party software tool? I just couldn't find any commands for the printing function in MySQL. Please advise. And please let me know how you print reports. cheers, feng

Re: Compression: Security or Zipping?

Hi, I think this is more of a "Security by Obscurity" approach. E.g. compressed credit card details flying down the wire are less obvious than their plaintext equivalent. I guess there may also be a case of increased difficulty when trying to decompress a single part of captured traffic, like you

Re: printing reports

> In MySQL, how can I create and print reports without the help of neither a > scripting language(e.g. php) nor a thrid party software tool? bad grammar :-( but you guys understand what i'm saying, right? :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

how to export data from multiple tables

Hi all, I've got a small problem (hope it's very small). Could any of you suggest me how to select my data into a simple text file from multiple tables (selected with union)! I've tried: select field-list into outfile filename from table1 union select field-list into outfile filename from table

Re: how to export data from multiple tables

"Nitin" <[EMAIL PROTECTED]> wrote: > > I've got a small problem (hope it's very small). Could any of you suggest me how to > select my data into a simple text file from multiple tables (selected with union)! > > I've tried: > > select field-list into outfile filename from table1 > union > selec

Re: how to export data from multiple tables

union works fine but with union 'into outfile' doesn't work anyway mysql ver is 4.0.14 thanx for ur time anyway Nitin - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 4:12 PM Subject: Re: how to export data fro

Re: ODBC Error

"Fortuno, Adam" <[EMAIL PROTECTED]> wrote: > Yo gang! Having a problem with the MySQL ODBC 3.51 driver. > > I've got a MySQL volume which has a user table (tbl_usr). I'm linking this > table to an Access database on my workstation (via ODBC link). The account > being used for the connection has se

Help and advice needed with mysqldump

Hi I need to get some data out of a table hosted for me on a webserver. I'm thinking of using the command mysqldump to grab the data, though I'm confused as to how to structure the statement. Also I'd like to automate the process on a Windows PC, how would I do that? (My perfect solution would

Re: Table crashes

Hello, > MyODBC 3.51 is the only way that I access the database. (MyODBC is used in a multithreaded server and in >InternetInformationServer (asp)) >The server is coded in c++ and got a class that acts like a odbc pool (keeps connections open during the lifetime of the server >and handles them to

Adding indexes on large tables

Greetings to all, and thanks for the excellent resource! I have a question regarding indexing large tables (150M+ rows, 2.6G). The tables in question have a format like this: word_id mediumint unsigned doc_id mediumint unsigned Our indexes are as follows: PRIMARY KEY (word_id, doc_id) INDEX (d

Re: Problem setting root password.

Rob Yale wrote: Hi folks, The following is copied exactly from my machine, except for the munged password. Setting the root password can't be completed, because the host apparently can't connect the mysql server. What am I doing wrong?: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USE

Re: mysqldump from cron > empty file

On Monday, October 6, 2003, at 05:11 PM, Paul DuBois wrote: I don't understand. Here you say that mysqldump is in the path, but above you say that you don't know if mysqldump is in the path for cron jobs. I suggest you change the crontab entry to invoke mysqldump by its full pathname and then s

Re: Multiple Join Issue

Leave off the 'WHERE e.Game_ID is NULL' Wayne Helman wrote: How would one join multiple table and selected all records from a joined table whether they exist OR not? I can get the records if they exist in a second table and I can get the records if they don't exist, but is there a way to combine

convert databases

Hi, I am using Oracle, Mysql Postgresql and ...MS-SQLserver, so i´d like to know what the best tool to convert databases... The DBTolls is a good option? does anyone use it? thanks. --- Gustavo Polillo Correa - Analista de Sistemas Insti

Re: error messages in different languages

> > Yup, there is a comp-err.exe in the bin directory. I am sorry but I asked this after not finding it. Will you please give me an URL on the MySQL website where I can download it from ? Thanks Emery - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Se

RE: Multiple Join Issue

If you want to restrict the tuples you get from 'broadcasts' use AND instead of WHERE. Cheers /rudy -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: dinsdag 7 oktober 2003 15:42 To: Wayne Helman Cc: [EMAIL PROTECTED] Subject: Re: Multiple Join Issue Leave off the 'W

Re: error messages in different languages

"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: >> >> Yup, there is a comp-err.exe in the bin directory. > > I am sorry but I asked this after not finding it. Will you please give me an > URL on the MySQL website where I can download it from ? What version of MySQL do you use? I don't exa

Re: printing reports

To get data from/into MySQL, you will always need a client software. So, the reporting thing should be implemented in your client software. Hope to be right!!! Thanks Emery - Original Message - From: "Wang Feng" <[EMAIL PROTECTED]> To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

RE: printing reports

You can use the mysql command client, it that is what you mean. You can also pass the query to the command client and then spool the output. mysql < the query > report file (or something like that, just check the manual) to do it really without any other tools, third party or not, you can always

Re: how to export data from multiple tables

"Nitin" <[EMAIL PROTECTED]> wrote: > union works fine but with union 'into outfile' doesn't work UNION with SELECT .. INTO OUTFILE works from version 4.1 mysql> SELECT * FROM t1 UNION SELECT * FROM t2 INTO OUTFILE '/tmp/tmp.txt'; Query OK, 4 rows affected (0.00 sec) > > anyway mysql ver is 4.0

Query help

I have a two tables. One has catagories, the other has articles. I need a query that deletes catagories only if not articles have that catagory. Table faqcat(cat int not null auto_increment, name varchar(20)) Table article(aid in not null auto_increment, cat int, .) Want to : delete from faq

RE: printing reports

You can, via ODBC, connect to MySQL using OpenOffice or Star Office which would give you a no-cost, or low-cost, option for producing reports from MySQL. There are a number of execellent web articles about interfacing either of these with MySQL. Try searching via Google. -Original Message---

RE: printing reports

If you're going the ODBC route, StarOffice sounds like a cheap alternative (and a good suggestion); however, there are a ton of other tools at your disposal too - MS Access if you've got access to a Win32 workstation. Regards, Adam -Original Message- From: Christensen, Dave [mailto:[EMAIL

mysql_error() returning nothing

I have been having this problem for a long time. A while ago I wrote the below functions to handle database errors. They used to display the message and email it to me. Now mysql_error() returns nothing! Any help would be greatly appreciated, as you can imagine this is causing a lot of problems

Re: Query help

you can create a temporary table (as del_temp_table) by this select command: SELECT faqcat.cat FROM faqcat LEFT JOIN article ON faqcat.cat = article.cat WHERE article.cat IS NULL; then delete them: DELETE FROM faqcat USING faqcat, del_temp_table WHERE faqcat.cat = del_temp_table.cat ; I hope it

RE: Query help

Darryl, At first blush, I would try something like: DELETE faqcat FROM faqcat LEFT JOIN article ON faqcat.cat = article.cat WHERE article.cat Is Null; I vaguley remember MySQL implementing syntax permitting users to remove data from one or more tables. I think this might be your ticket. R

Re: how to export data from multiple tables

can u suggest any workaround? anyway thanx for help Nitin - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 8:32 PM Subject: Re: how to export data from multiple tables > "Nitin" <[EMAIL PROTECTED]> wrote: > >

RE: how to export data from multiple tables

Nitin, Create a temporary table, then select each table into it in turn, then output that to the file? Andy > -Original Message- > From: Nitin [mailto:[EMAIL PROTECTED] > Sent: 07 October 2003 11:40 > To: [EMAIL PROTECTED] > Subject: how to export data from multiple tables > > > Hi all,

MySQL not null vs MSAccess required

Hello, I'm Using MSAccess as backend for my MySQL database. Tables are linked with MyODBC 3.51, so all data user enters through MSAccess forms. I need that some fields (CustName) in MySQL table (CUSTOMERS) would be required, it means, that user must fill a value into that field (Cus

Replication

Can I do a replication using: - Master with Linux and MySQL 4.1 - Slave with Windows XP and MySQL 4.0.15 Thanks! Fernando Bernardino

Re: Replication

I don't recommend using differing versions. That's a no no. Upgrade XP to 4.1 before you start replication. On Tue, 2003-10-07 at 12:45, Fernando Gomes Bernardino wrote: > Can I do a replication using: > - Master with Linux and MySQL 4.1 > - Slave with Windows XP and MySQL 4.0.15 > > Thanks! > >

Check (expr) Syntax and/or other fields checks

Title: Mensaje Hello everyones,   Did somebody know: First:     What kind of expr it is allowed on the check condition on: create table syntax?   Second:     Is it posible to force conditional FOREIGN KEY checks?      for example: We make One table who have one UNIQUE Key and one speci

Re: [Fwd: MySQL w/dual-master replication?]

Hi Andrew, Thanks for the reply. Great question. It's a very read-heavy system. Are you doing high-availability MySQL yourself? I'd love to hear how you're doing it, if so. Thanks! Don Andrew Braithwaite wrote: Is the system read-heavy or write-heavy? Cheers, Andrew -Original Messa

RE: MySQL not null vs MSAccess required

Arunas, Actually, I think you mean MySQL is the backend for MS Access. Don't assume columns that are NOT NULL must have a default value. You are welcome to define columns as NOT NULL without a default value. Doing this will force the client (the Access form's) to require a value before inserting

RE: Adding indexes on large tables

an option for A- no idea if this will work, but what if you moved your actual data file to new drive, and soft linked it from the other drive? > -Original Message- > From: Brendan J Sherar [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 07, 2003 7:27 AM > To: [EMAIL PROTECTED] > Subje

RE: Check (expr) Syntax and/or other fields checks

Miguel: First: Be more specific. Did you have an expression in mind? Second: Yes, use InnoDb tables to enforce referential integrity. See the URL (below) for information on InnoDb table usage. Regards, Adam InnoDb in MySQL -> http://www.mysql.com/doc/en/InnoDB.html

RE: Adding indexes on large tables

Brendan, We have used ext2, ext3, and reiser for testing purposes, and we have found ext3 to be terribly slow on file read/write operations. If you need a journaling file system, I would go with reiser, otherwise ext2 will be blazingly fast. The other thing I would do is move your DB to anoth

FW: MySQL not null vs MSAccess required

MSAccess as frontend :) sorry, you're right. So, I defined column without default value, but nothing changed... I still can enter empty values into field :( Now, actualy I want MySQL to rise run-time error, because there are many forms in access and DB structure is changing ... I

relay log hosed

Hi, So I set up replication and everything seemed to be going alright for a couple days until the slave server stopped responding. Any attempts to connect to the slave server hang indefinitely, and if I ssh into the machine, any attempts to access the data disk also hang. I had to hard-boot th

FW: MySQL not null vs MSAccess required

Yes it's true, when someone enter's NULL value, but when someone does not even touch that field on the form? :( In other DBMS it's like a rule to make all possible chechking on DB for any unforeseen accident... So I'm hopefully waiting for MySQL 5xx relise to realize this... As for

4.1 final

Any idea when 4.1 will be released as a final? nick marsh [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FW: MySQL not null vs MSAccess required

Of course the OT NULL is not firing, you put DEFAULT ''. This defeats the purpose of NOT NULL since every new record written has a default value that IS NOT NULL. (Whether the user entered the field or not. remove the DEFAULT form the table definition and leave the NOT NULL. This will prevent A

RE: FW: MySQL not null vs MSAccess required

No, no, no ... Dear Friends, defining column as NOT NULL and do not specifying default value does not means that there is no default value at all. MySQL defines default value for that column of his on decision (for Date it's '-00-00', for text column's it is '', for number column's it is '0' an

RE: Check (expr) Syntax and/or other fields checks

I wish this help! Tell me if it is more clear now. # PRIMARY TABLE - CREATE TABLE `sku` ( # Constants Fields `id_ts` TIMESTAMP NOT NULL, `pri_key` INT(10) UNSIGNED NOT NULL auto_increment, `SKU` VARCHAR(10), `description

Re: FW: MySQL not null vs MSAccess required

I hate to disagree with you but in the 30+ databases I've created in MySQL, not defining a default value leaves the default value as NULL. Setting that field to NOT NULL means that I have to enter something or the record won't commit. =C= p.s. I use the 3.xx series, maybe this behavior has chan

help on Index

Hi, After rebuild the following table, the Cardinality does not get updated. This table have 18 million of rows. Why this happening and how do I fix it? Should I run OPTIMIZE TABLE or CHECK TABLE? mysql> show index from UserDetail; ++++--+--

RE: FW: MySQL not null vs MSAccess required

:(, oh how I wanted it to be true in MySQL 4.1, maybe it's a bug?.. I don't know realy... Here is Copy From Console: mysql> create table `temp` ( -> col1 int(9) NOT NULL, -> col2 date NOT NULL, -> col3 Varchar(30) NOT NULL, -> col4 Varchar(30)); Query OK, 0 rows affected (0.02 sec

Re: FW: MySQL not null vs MSAccess required

I humbly submit an apology. You are correct. This is a bug (No it is NOT a feature) you should be able to define a field as NOT NULL without a default or at the very least, define the default as NULL. My bad, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take car

myadmin for mac? or?

I have php on mac and pc, but have mysql on the mac only. I heard there are GUI interfaces available for mysql but am not seeing what I am looking for. I searched for myadmin and found notes on the mysql.com site but not clear to me how I get this program and or if its available for mac. Is th

Re: myadmin for mac? or?

katherine wrote: I have php on mac and pc, but have mysql on the mac only. I heard there are GUI interfaces available for mysql but am not seeing what I am looking for. google: Mac OS X MySQL GUI finds quite a few things, including this open source offering as hit #3 :-)

MyIsam or InnoDB? (WARNING -- LONG MSG)

Apologies for the length of this post. We started off this little proof of concept project using MySQL InnoDB tables, in part because we figured we needed foreign key constraints, row locking, and all the other bells and whistles that one gets with DB2 (our production DB on a big - for us - proje

Re: MyIsam or InnoDB? (WARNING -- LONG MSG)

Randy: Tuesday, October 7, 2003, 4:49:44 PM, você escreveu: ---[inicio]-- RC> Apologies for the length of this post. RC> We started off this little proof of concept project using MySQL RC> InnoDB RC> tables, in part because we figured we needed foreign key constrain

4.0.15 FULLTEXT INDEX

I have to drop the FULLTEXT INDEX added to a set of dbs containing a TEXT field with an average of 6K of text added to each row, at a growth of 250K rows added a day to a set of 100 tables. The reason for the drop is due to table corruption and non-related query slowdown. DELETES and Frequent UPD

Re: myadmin for mac? or?

On Tuesday, October 7, 2003, at 03:15 PM, Hassan Schroeder wrote: katherine wrote: I have php on mac and pc, but have mysql on the mac only. I heard there are GUI interfaces available for mysql but am not seeing what I am looking for. google: Mac OS X MySQL GUI finds quite a few things, includ

Help With a DATETIME Query

Hi, I have a table called Bookings which has two important columns; Booking_Start_Date and Booking_End_Date. These columns are both of type DATETIME. The following query calculates how many hours are available between the hours of 09.00 and 17.30 so a user can see at a glance how many hours they h

RE: Help With a DATETIME Query

I know it's not the answer you're looking for... :( but dealing with overnights has caused me so much aggravation in past apps I've written, I've tended to make the client create two (or more) 'bookings' for the covered time... don't know if it's an option for you, but it's my $0.02. > -

Can records be moved between tables without knowing columns

Hi, I need to be able to 'delete' records from table(s) but still maintain their information for an audit trail. I'd rather not have a field for a deleted flag and have to condition all the queries on the table on the state of this flag. Is it possible to move a record from one table to another

RE: Help With a DATETIME Query

Thanks for your reply, but its not an option! From: "Dan Greene" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: RE: Help With a DATETIME Query Date: Tue, 7 Oct 2003 16:41:04 -0400 I know it's not the answer you're looking for... :( but dealing with

Re: printing reports

Hi, Rudy. You're right. I'm looking for some commands to do the report. (of couse I can solve the problem using PHP, but really just wanna play with MySQL alone for this issue). But I couldn't find any command from MySQL manual. If you can show me a link, then that would be great!!! cheers, fen

Re: Can records be moved between tables without knowing columns

In the last episode (Oct 07), Jim said: > I need to be able to 'delete' records from table(s) but still > maintain their information for an audit trail. > > I'd rather not have a field for a deleted flag and have to condition > all the queries on the table on the state of this flag. > > Is it pos

Re: printing reports

Thanks Dave That sounds good although I haven't installed them. I don't know if that works to my OfficeXP or not. Seems better for me to get a RedHat 9.0 somewhere. :-) cheers, feng - Original Message - From: "Christensen, Dave" <[EMAIL PROTECTED]> To: "Wang Feng" <[EMAIL PROTECTED]>;

RE: Help With a DATETIME Query

I've worked on applications like this one in a court scheduling application. Since trials can run several days, this was an issue I had to deal with, too. The solution I set up was to have a table like your "bookings" table, then have another table containing available time slots for each eligible

Re: FW: MySQL not null vs MSAccess required

Cal Evans wrote: I humbly submit an apology. You are correct. This is a bug (No it is NOT a feature) While you may not like it, this definitely is a feature (or an intentional design decision, at least), not a bug. See the docs at . The

RE: FW: MySQL not null vs MSAccess required

Are you serious? Its certainly a feature I can do without. Just one more idiosyncrasy to remember for another RDBMS. Regards, Adam -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 5:46 PM To: [EMAIL PROTECTED] Subject: Re: FW: MySQL not n

Strange Error

I’ve recently started getting an error: file '.\newsman\messages.MYD' not found (Errcode: 22) but when I check the database, the file is there and it is OK. I’ve repaired and optimized it, but no change. What is the root cause of this error and what should I do to fix it? Thanks, Dan C

RE: [Fwd: MySQL w/dual-master replication?]

>>Are you doing high-availability MySQL yourself? Yes. In Production we're doing extremely read-heavy, write-light MySQL database stuff. The first thing that springs to mind when you say "High Availability" is "How many 9's do you need" : read Jeremy Z's blog entry @ http://jeremy.zawodny.com/bl

Re: relay log hosed

Responding to my own message... Looks like I can't simply delete the relay binlog, since while the slave continued to run it continued to update it's place in the master binlog. So, short of copying all the data over again, what can I do? Can I just pick a random spot in the master binlog tha

Japanese display problem with mysql on Linux

Hi folks I wrote an application which uses japanese characters. I can display japanese characters, fetching from a mysql database on my WindowsXP machine. I moved the same to a Linux machine and could see only junk characters. Any suggestions? MySQL version 4.0.13 on Win XP Japanese MySQL v

Re: MySQL: Ordering Random Records

Hi Stuart, Good solution! I didn't even think of that. :-) Interestingly, and FYI, it doesn't work correctly on 4.1.0 (ignores the LIMIT). Hopefully it's a known bug that's been fixed in 4.1.1. 4.1.0 does work correctly though using derived tables as John Bonnett suggested: SELECT * FROM (SELECT

What would be an efficient way to accomplish this (Statistics/Trends in a table?) Thanks!

I would appreciate any advice on this. PHP+MySQL snippets even better :P How can I do this: For example I have a table with a field FIRST_NAME I want to produce the statistics of how many identical FIRST_NAME entries there are in the table. Yes I could hard code queries to match a list of prede

Re: Can records be moved between tables without knowing columns

On Tue, 7 Oct 2003 16:48:55 -0400, Jim wrote > Hi, > > I need to be able to 'delete' records from table(s) but still > maintain their information for an audit trail. > > I'd rather not have a field for a deleted flag and have to condition > all the queries on the table on the state of this flag