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

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

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

Re: load data infile problems

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 The errorcodes in the brackets below indicate the error. You can find

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 I keep getting a whole heap of warnings

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

[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

[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

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 29, 2002 7:34 PM Subject: Re: [newbie post] linked

Re: [newbie post] linked lists..

have the elements that you want. if you say, the purpose of the list, may be that will help - Original Message - From: Daniel Jarrett [EMAIL PROTECTED] To: Joseph Jude [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 29, 2002 9:57 AM Subject: Re: [newbie post] linked