database design approval

i understand that this is a bit of an ask. but. I was wondering if someone could look over my database design. i've got a diagram. and text document of all my create table syntax. It's my first mysql database, and it's kind of important that i get the thing right. So if anyone could help

Re: load data infile problems

Disregard my last post.. - Original Message - From: "Daniel Jarrett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 11:44 PM Subject: Re: load data infile problems > i figured it out.. it worked when i used local. > > although

Re: load data infile problems

nual a bit cryptic dan - Original Message - From: "Melvyn Sopacua" <[EMAIL PROTECTED]> To: "Daniel Jarrett" <[EMAIL PROTECTED]> Cc: "MySQL General" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 9:48 PM Subject: Re: load data infile problems

load data infile problems

I'm having difficulties with loading values from a text file into my databse. I've tried the following and got these errors. last one is with full path === mysql> LOAD DATA INFILE "months.txt" INTO TABLE months; ERROR 1105: File './date1/months.txt' not found (Errcode: 2) mysq

functions

maybe i'm wishing on a star here. but is there any way that you can write functions for mysql to perform daily operations.. for example. at a certain time each day mysql automatically ran a query to delete records past a certain date.. ? dan

Re: mysql optimizations - tips/resources

yeah.. i've just been researching that subject myself.. it seems that db optimization is mainly about normalization.. check out this http://www.devshed.com/Server_Side/MySQL/Normal dan - Original Message - From: "olinux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22

[newbie] better practice techniques

I'm just wondering.. say i have a members table as my main table in MYSQL.. and in that table i have a field named month, that will be one of twelve options. would it be better practice to have the month field linked to another table called months and have the month table populated with the val

[newbie] efficiency issues

i'm building a table in MYSQL that has about 30 fields.. is this inefficient to have a large number of columns? if anyone can direct me to some good info on efficient design tips/ techniques i'd be grateful. thanks dan ---

Re: [newbie post] linked lists..

e" <[EMAIL PROTECTED]> To: "Daniel Jarrett" <[EMAIL PROTECTED]> Sent: Friday, March 29, 2002 8:01 PM Subject: Re: [newbie post] linked lists.. > i didn't understand you. > it is going to depend on what complexity you are going to put into the list > create

Re: [newbie post] linked lists..

i think i'm getting in over my head a bit here.. is this something thats gonna be simple to do? - Original Message - From: "Joseph Jude" <[EMAIL PROTECTED]> To: "Daniel Jarrett" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March

[newbie post] linked lists..

is there any way of doing a linked list in mysql.. ? the only alternative i've got is to have a table with a fixed number of columns liike this item1 item2 item3 item4...etc is this the only way to do what i'm trying to do. does anyone get what i'm on about? cheers dan ---