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 > to

Re: Select on indexed columns

ncrement, sex 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

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 any

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

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 SEL

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

RE: oscom table structure

There is a diagram of the database included in the milestone releases. it's in the top directory named tep_database_2.2CVS.pdf or something like that. olinux --- Andrew <[EMAIL PROTECTED]> wrote: > Thanks Nils, I will just add a little to the > original question, I am famil

Re: Updating a nested set

h about working with them 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 larg

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

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

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 o

Re: Removing a specific set of duplicates

coming in > handy in the future a > whole lot. I think REPLACE INTO will work well for you. Use it the same as you would use INSERT INTO http://dev.mysql.com/doc/mysql/en/REPLACE.html olinux __ Do you Yahoo!? Vote for the stars of Y

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 > expir

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

mming 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/ olinu

Need a better index on this multiple join?

eq_ref | PRIMARY,parent_id | PRIMARY | 2 | stats.zone_id | 1 | where used | z2 | eq_ref | PRIMARY | PRIMARY | 2 | z1.parent_id | 1 | ------- Thanks much, olinux __ Do you Yahoo!? Yahoo! Search - Find what you’

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 ? > _

Re: Large lists of SQL commands choking PHPmyAdmin?

ame < backup-file.sql Or: shell> mysql -e "source /path-to-backup/backup-file.sql" db_name 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.co

Re: Storing App Settiings

take a look at parse_ini_file() http://www.php.net/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 ar

Re: Storing App Settiings

y etc .. > Take a look at PEAR::Config http://pear.php.net/package/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 archi

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

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 fo

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 ca

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

kup-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 a

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 /

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 kno

Re: About database design

if you are doing php/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 ar

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

R 2) add 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

Re: joins vs excess fields

title | 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, >

Select Past 7 days

the first 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

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 &

RE: How to Count(*) with LIMIT

s only 100 - I would think there's a better way to do it. olinux __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posti

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 in

Re: building tree view in mysql?

body 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 Thurs

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 ca

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 PROTEC

Re: "INSERT INTO" vs. "REPLACE INTO"

You'll have much less overhead checking with a select first and then insert if not exists olinux --- Sebastian Bergmann <[EMAIL PROTECTED]> wrote: > [resent; original posting didn't make it (through > the spam protection)] > > With phpOpenTracker I have for in

Return results in groups - CNET style

irst 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

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 >

Why must I quote fields now?

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

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]&g

Re: content design / database design help

ntacts to the project table 'project_contacts' project_id | name | 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 hel

Re: data modeling question

. Getting items for a 'browse' category feature is as simple ass selecting all items where parent_id = 'whatever' Using a recursive loop you can build a tree structure olinux --- Wellington Fan <[EMAIL PROTECTED]> wrote: > Hello all, > > I have an 'items&

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 &g