When you make changes to the mysql database (the database which controls
how MySQL works), does MySQL automatically load the updates? When
adding users or changing security permissions for hosts or users or
databases, it seems like some updates take affect immediately and some
don't. Are you
On Fri, 2003-10-17 at 20:16, Mike Bailey wrote:
I desperately need everyone's help.
I normally build database driven websites on NT Servers with an MS Access database,
using perl 5 to read/write the database.
Now I need to build a website that can handle a database with almost a
I have MySQL running on a Linux box with two network interfaces - one is
a routable IP that connects to my DSL bridge and the other is a
non-routable IP (192.168.1.*) that connects to my internal LAN. I'd
like MySQL to be available on the internal interface but not to be
available on the
On Thu, 2003-08-21 at 20:21, Taylor Sittler wrote:
Is there any way to update table values based on values in another table?
For instance, given:
table (column1,column2..)
Table 1 (jobid, jobname)
Table 2 (person, jobid, jobname)
could I update Table 2, setting jobname=Table1.jobname
On Sat, 2003-08-23 at 22:19, Rajesh Kumar wrote:
Dan Jones unknowingly asked us:
UPDATE table1 SET table2ID = NULL WHERE table1.table2ID NOT FOUND IN
table2.ID;
The NOT FOUND IN isn't SQL, of course, but I'm not sure what should go
there.
In MySql, its
How do I update a table to remove orphaned references to a second
table? I've deleted rows in the second table, which has a unique
auto_increment key. The first table now has references to keys that no
longer exist. I need to update the first table, setting the value to
NULL where the
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT data from another table for
insertion, and UPDATE
On Thu, 2003-08-21 at 20:09, Dan Jones wrote:
I'm attempting to normalize a database that was originally created as a
flat file. I want to extract distinct values from a table and insert
them as new entries into a new table. Unless I'm missing something,
INSERT doesn't allow you to SELECT
On Fri, 2003-08-08 at 21:14, Matthew McNicol wrote:
I have a database of books that was originally created as a flat file.
Each record has a number of fields, including the authors name. I'm
trying to convert the database to something a little more efficient.
I've created a new table
I have a database of books that was originally created as a flat file.
Each record has a number of fields, including the authors name. I'm
trying to convert the database to something a little more efficient.
I've created a new table (called Authors) of unique authors names and
assigned each one
10 matches
Mail list logo