Re: Documenting and visualizing a database

You will love this. http://www.fabforce.net/dbdesigner4/ Josh --- Jeffrey Goldberg [EMAIL PROTECTED] wrote: This is probably a FAQ, but I haven't been able to find the answer. Briefly, I am looking for tools that will help me document a database. Visualization would be nice too, so

Re: Removing a specific set of duplicates

would use INSERT INTO http://dev.mysql.com/doc/mysql/en/REPLACE.html olinux __ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ -- MySQL General Mailing List

Re: oscommerce online offline replication

to the *other* server and do the following shell mysqladmin drop db_name shell mysqladmin create db_name shell mysql db_name backup-file.sql see also: http://dev.mysql.com/doc/mysql/en/mysqldump.html olinux --- Business A2Z [EMAIL PROTECTED] wrote: Hi All This may be a longshot or it could

RE: oscommerce online offline replication

. olinux --- Business A2Z [EMAIL PROTECTED] wrote: Thanks for the response well i guess a backup is just copying the DB records from one pace to another and is a solution however I need something more precise, could someone point to a good reference on mapping tables and a good programming

RE: Parent-Child Relationship Question

Try these: http://www.sitepoint.com/article/1105 http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/ olinux -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: 02 July 2004 03:13 To: [EMAIL PROTECTED] Subject: Re: Parent-Child

Re: Search for relationships that aren't present

a LEFT JOIN should do the trick something like this: SELECT users.user_id FROM users LEFT JOIN comps_users_link ON (users.user_id=comps_users_link.user_id) WHERE comps_users_link.computer_id IS NULL olinux --- Brad Tilley wrote: Three tables: computers (Describes computers) users

Re: Storing App Settiings

/Config olinux __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Storing App Settiings

/parse-ini-file olinux __ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Large lists of SQL commands choking PHPmyAdmin?

More info here: http://www.mysql.com/doc/en/mysqldump.html olinux __ Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Hierarchical list...

check this thread - lots of links for more info. http://lists.mysql.com/mysql/157588 olinux --- Richard Carlier wrote: Hi ! There is any way to have hierarchical list with Mysql, like the Oracle START WITH and CONNECT BY ? __ Do you Yahoo!? Yahoo

Need a better index on this multiple join?

| where used | z2 | eq_ref | PRIMARY | PRIMARY | 2 | z1.parent_id | 1 | --- Thanks much, olinux __ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- MySQL General

Re: Select on indexed columns

char(1) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; You might also try setting 'sex' to ENUM('F','M') and also try NOT NULL as well if needed you could use 'U' for unknown sex ENUM('F','M','U') NOT NULL default 'U' olinux --- Balazs Rauznitz [EMAIL PROTECTED] wrote: While doing some

Re: MySql database design.

will find something ready to use). olinux --- Brian Duke [EMAIL PROTECTED] wrote: I need a little help in constructing an order tracking database. We've decided to use MySQL mostly because it's the best supported database out in the wild. Does anyone have an example of an order tracking

Re: Where to find advice on database structure/design?

logic. With a strong understanding of normalization you'll be able to structure your forms to get the info you want. Here's a great site with examples of different data models. Not all are complete, but a great start and a great source for ideas. http://www.databaseanswers.com/ olinux --- Apollo

Re: Selecting on timestamp(14)

UPDATE table SET active = 0 WHERE updated DATE_SUB(NOW(),INTERVAL 48 HOUR) see the manual for more info http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1322 olinux --- Scott Haneda [EMAIL PROTECTED] wrote: I have a timestamp(14) column, I need to expire/decay certain records

Re: Updating a nested set

efficiently. olinux --- Knepley, Jim [EMAIL PROTECTED] wrote: I'm basing some work on Joe Celko's excellent idea of using nested sets to represent an organizational structure as opposed to an adjacency list. By and large it's a great idea, but not without its pitfalls. I'm writing now to ask

RE: DB Design

Check this http://www.fabforce.net/dbdesigner4 olinux --- Andrew [EMAIL PROTECTED] wrote: this is exactly what I am looking for :) Is there a free one of these guys hanging around somewhere? Andrew -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: 19

Re: order of table joins or where clauses relevant?

The order of the WHERE clause does make a difference. The same is true of table joins. I don't think that the order of tables in the FROM clause makes a difference. olinux --- [EMAIL PROTECTED] wrote: As we're on this topic in another thread right now: Say I have a SELECT query from more

Re: [PHP-DB] Compiling 4.2.3 with MySQL ... what does it look for?

try --with-mysql=/usr --- -{ Rene Brehmer }- [EMAIL PROTECTED] wrote: X-posted to PHP General, PHP DB, and MySQL Hi gang Attempting to get my Linux test-server working, but ran into a problem when making PHP... System is RedHat 8, Apache 1.3.27 (compiled myself, tested OK), MySQL

Re: About database design

/mysql be sure to check out phpmyadmin. incredible olinux --- [EMAIL PROTECTED] wrote: Where can a newbie go to learn how design and build a database quick. Thanks David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http

Re: [mysql] Counting rows

SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson [EMAIL PROTECTED] wrote: Hello All: Let's suppose I want to count the rows in set for a match to a value in a column. I don't need to read the selection set, I just need to know the number of matches. What

Re: How to Archive and restore the data in MySQL database.

-file.sql You can read this back into MySQL with: mysql database backup-file.sql [/snip] here's a recent thread that may help http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:129215:aflndljbbfiablpcodgj olinux --- Prasad Budim Ram [EMAIL PROTECTED] wrote: Hi, Can any of you give me links about

Re: whats the best way to imput text and formated text into a mysql database

http://www.php.net/addslashes http://www.php.net/stripslashes --- ahimsa [EMAIL PROTECTED] wrote: Thank you so much everyone for all of your support! I asked a question re: a mysql post error when the text containd apostrophe and commas. I got feedback re: delimiting and putting a / before

Re: Designing Categories

Check this and ask more if needed http://www.webreference.com/perl/xhoo/php1/ also might want to check out perlHoo based on your language preference http://www.webreference.com/perl/xhoo/ olinux --- Will K. [EMAIL PROTECTED] wrote: Greets Folks, I cant tell if this is a dumb question

Re: Book recomendations

This is an excellent little quick reference book. Sams Teach Yourself SQL in 10 Minutes http://www.amazon.com/exec/obidos/tg/detail/-/0672321289/104-3843919-3475903 olinux --- Charles Mabbott [EMAIL PROTECTED] wrote: I got a gift certificate for book store. I am looking for good MySql books

Re: query optimization with CONCAT query

Mysql 4.0.1+ supports searches IN BOOLEAN MODE So if mysql 4 is an option, I think that would work for you. http://www.mysql.com/doc/en/Fulltext_Search.html olinux --- Andy Ingham [EMAIL PROTECTED] wrote: Folks -- We have built a table with bibliographic information that contains

Re: content design / database design help

| company | address | phone | description and whatever other fields you like... olinux --- Randy Hammons [EMAIL PROTECTED] wrote: I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My office currently keeps track of our projects via an excel spreadsheet. We keep such info

Re: Query using the same table twice

No time to figure out what you are doing, but I think you will find your answer here - if not send the table structure for the table you store the team id of the home and visitor in: http://www.wdvl.com/Authoring/DB/SQL/Joins/ olinux --- Michael J. Mitchell [EMAIL PROTECTED] wrote: I am

Why must I quote fields now?

Thanks, olinux __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php

Re: Select all with an excpetion

http://www.amazon.com/exec/obidos/tg/detail/-/0672321289/102-8456958-9824163 olinux --- David Dillon [EMAIL PROTECTED] wrote: Hello, I am sorry if this is a painfully easy question, but I have been looking everywhere, and I cannot find out how to do what I need. My query is simply

Return results in groups - CNET style

few from each category - similar to the way cnet does. Table structure (simplified) I am working with is id | category | date | title | article Thanks much, olinux __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com

Re: creating a relational database: how to plan?

check out this article and try a google search for database normalization. http://www.phpbuilder.com/columns/barry2731.php3 when you have a better idea - try the list with your questions. These 4-5 page articles will definitely help you out. olinux --- David T-G [EMAIL PROTECTED] wrote

RE: Building a Shopping Cart with MySQL

You might find this article helpful Building an E-Commerce Site Part 1: Building a Product Catalog http://www.devshed.com/Server_Side/PHP/Commerce/Commerce1/page1.html olinux --- Jay Blanchard [EMAIL PROTECTED] wrote: [snip] Is it possible to create your own shopping cart program

Re: Indexing words

Is this approach still of use if many more tables are added? so basically you create a lot of 'relations' tables to store key relations rather than store the relation in each table? olinux --- Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. If FULLTEXT indexes are out of question, what

Re: building tree view in mysql?

windshields tires detailing olinux --- hassan [EMAIL PROTECTED] wrote: HI, For trees you need self joins. Could You please explain that ? Regards, At 19:11 23/05/02, Georg Richter wrote: On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, snip How

RE: How to Count(*) with LIMIT

it. olinux __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual

Select Past 7 days

of month. Thanks much, olinux __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posting, please check: http://www.mysql.com

Re: MySQL - PHP - Banner ad click through tracker

Check out phpADs http://sourceforge.net/projects/phpadsnew/ olinux --- Craig Westerman [EMAIL PROTECTED] wrote: Does anyone here have a PHP script that will store banner ad click throughs in a MySQL database? If not, is anyone here interested in doing this project? Thanks Craig

Re: joins vs excess fields

| keywords | article_content Since most frequent request will be on the date field, that will be first, but I need to put learn more of fulltext indexes and probably index keywords, title, article content. Thanks much, olinux --- Toomas Vendelin [EMAIL PROTECTED] wrote: Hello olinux, If I were in your

mysql optimizations - tips/resources

Anyone have a good resource for mysql optimization tips? or just standard db optimization. Thanks, olinux __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com

joins vs excess fields

a table to hold image path names and require a JOIN in order to retrieve. I am thinking that the join query will be best. Thanks for any help. olinux Table setup is: CREATE TABLE articles ( id int(12) NOT NULL auto_increment, type varchar(15) NOT NULL default '', region smallint(1) NOT NULL