Summary: Situation: I am trying to delete records that are in three separate tables simultaneously. The database belong to a Veterinary Clinic. I have three t...
Summary: I have the exact same problem and it has happened more than once. Each time, I have done the following: copy the old switchboard table contents into ...
Summary: A database should be designed to have a set number of tables. Having to add a table simply because you added a page to the site means that the struct...
Summary: Hi, I'm having an issue trying to match up records I have in an Access table. Each time I append the data to the table, it creates duplicates. It does...
Summary: First I would say this is something you should not do. What you have is a one to many relationship. One address with many contacts. If you have 2 t...
Summary: Can someone tell me why the following is not working? $query = file_get_contents("import_data.sql"); echo ($query); $result=mysql_query($query); ...
Summary: Hi, I want to use a populate a table using a INSERT ... [INTO] tbl_name [(col_name,...)] SELECT ... structure. The thing here is that I want t...
Summary: I want to be able to look up a customer database from 1 table and add it to a new table with all the customer info (address, point if contact, etc.) ...
Summary: There were some important websites my husband recently deleted out of the history. I know with windows you just have to go to the recycle bin, but i...
Summary: if i have a table with entries like 1 2 342 1 3 532 1 4 555 1 7 222 2 1 333 2 2 332 now i want 1 4 555 2 1 333 to be displayed how to do it ...
Summary: Can someone please tell me which system tables in Oracle have the source code of creating a table or index. That is to say, that once the table is cre...
Summary: I am getting this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/regsim.100webspace.net/index...
Summary: bought used computer to fix up for my daughters first computer, it had windows 2000 on it, i installed windows xp, hard drive is 51% used up, previous...
Summary: Hello everyone, I'd like to be able to mark one of the columns in table "table1" to be a foreign key from table "table2". Both tables are already popu...
Summary: I am the IT manager at a community organisation with about 10000 members. All members data is currently in an Access database on our file server in th...
Summary: Hi All I have a table that I regularly empty of all data, when i do this the auto index thingie resets, how do i prevent the index from resetting for...
Summary: Hi I have form for searching one of four types here is my syntax for select : $query = "SELECT * FROM '$jobs' WHERE location ='$search'"; $jobs shoul...
Summary: Hi I am new in SQL server. I am trying to find out which tables contain a specific column name in entire database. Is there any equivalent dictionary...
Summary: Hi, Is it possible to download the contents of a table into a flatfile from Oracle DB, without headings and with delimiters lmiting the column values....
Summary: This might also help: Before you begin, make sure the table is not in use. Then use the isql utility to perform these manual steps, entering go after ...