Table planning

Hi, I have posted a question here previously regarding the query of talbles that contain duplicate entries in rows with only the id being different. My question was how to display or abtain ONLY the row with the highest id value in the result set along with all the other destinct rows in the t

SQL help plz

Hi I need help with an sql string: have a table similar to this: idkeynamedate 1 123name1 date1 2 123name1 date2 3 111name2 date1 4 111name2 date2 5 123name1 date3 Now

reading field and data into a table from another

Hi, have two tables. One contains the names of ppl along with an id for each person and a date of the entry. The second table contains some added info for those ppl, and I would like to have one of the fields in the 2nd table to be in the first table in irder to make it easier to manage. The p

Error 13

Hi I have a table that I want to add a new field to while running on the server, however, when I try to add a new field, it comes up with the error13 message, saying it doesn't have permission, yet the files and folder are all chmod 777. Can it be due to the fact that there is a permanent conn

complicated select

Hi, I have a table that contains something like follows: id prop_name status action_date prop_type address 1 name1 ok 2001-12-12 1 addy1forname1 2 name2

duplicating collumn

Hi I have two tables, one contains a persons name and an ID number. The other table contains the ID number and another field. Is there a way of moving this collumn to the first table to corrlate with the ID's, ie, table 1 must now contains name, ID and another field that is specific to the per

Sorting through results

HI This is possibly very easy, but I can't seem to get it right. I have a table that hold some data about properties. The data gets updated from time to time, but each time a new "update" is done, it get's a new row. The only thing in some cases setting the different entries appart is an "actio

MySQL / ODBC BLOB problems

HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)

Problem with ODBC and BLOB

HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)

heavy load configuration

I have a Linux box running mysql and apache, and we are expecting quite a load on the 1st of June. We have an application form whose data will be written into a db on the same server and I would like to know what I can do to make sure things go smooth. The machine is an AMD 500, with 320MB RAM, 25