[mythtv-users] Storage groups: How to set 'SGweightLocalStarting' to 0?

[Jonathan Larson]

> On Oct 8, 2008, at 2:43 PM, Jonathan Larson wrote:
>
> >> I'm new to the SQL CLI, so I didn't even realize there was a
> >> functional difference between "" and NULL. Should the insert
> >> command look like this?:
> >
> > INSERT settings (value, data, hostname) VALUES
> > ("SGweightLocalStarting", 0, NULL);
>
> Since you already have an entry in your database for
> SGweightLocalStarting your command should now look like this:
>
> UPDATE settings SET hostname = NULL WHERE value =
> 'SGweightLocalStarting';

Thanks Brad,

I was just asking about the initial INSERT command because I wanted to add this to the wiki and I wanted to make sure it would be accurate.

Jon