On Fri, 19 Jan 2018 11:25:42 -0500, shawn l.green wrote:
> Hello Chris,
>
> On 1/19/2018 12:50 AM, Chris Roy-Smith wrote:
>> Hi I am running mysql 5.7.20 in ubuntu linux 17.10
>>
>> I have 2 tables, member and status with contents like
>>
>> member:
>&
selected year.
select details.ident, given, surname from details left join status on
details.ident = status.ident where NOT EXISTS (select year from status
where (status.year = 2018) and (details.ident = status.ident) )
Thank you for looking at this.
regards, Chris Roy-Smith
--
MySQL General
I've got a bunch of files which contain packed fixed-field-width
records. The records are pretty long; depending on the file, as long
as 1000 characters and 10's of fields. Fields are a mix of numeric and
alphanumeric types.
What's the best way to load these into mysql? Mysqlimport looks lik
On Friday, September 12, 2003, at 10:24 PM, Paul DuBois wrote:
FILE is a global privilege (it's recorded only in the user table)
and must be granted at that level:
GRANT FILE ON *.* TO 'roy'@'localhost';
Ah. That makes sense. Thanks.
I'm not sure why you're trying to grant to just "roy". That'
I'm running mysql-standard-4.0.14-pc-linux-i686.
I've got a database netscore which I want to be able to bulk load. The
database already exists and I can do inserts into tables:
[EMAIL PROTECTED] schema]$ mysql -s
mysql> use netscore
mysql> insert into boat values (100, 'foo', 'foo', 'foo', 10