Jeff,
I would use a join table, teacher_flights.
create table teacher_flights(
teacher_id int(11) not null,
flight_id int(11) not null,
primary key(teacher_id, flight_id));
Dave
>
> From: Mark Phillips
>To: Mysql List
>Sent: Friday, March 23, 2012 7:28 PM
>
select 'U02714','U02718';
insert into my_table values('U02714');
insert into my_table values('U02718');
Let me know if this is what you intended.
Dave
>
> From: "h...@tbbs.net"
>To: mysql@lists.mysql.com
>Sent: Friday, March 23, 2012 5:14 PM
>Subject: big
I guess what you mean is Unicode characters U+2714 'HEAVY CHECK MARK' and
U+2718 'HEAVY BALLOT X'
(http://www.fileformat.info/info/unicode/char/2714/index.htm and
http://www.fileformat.info/info/unicode/char/2718/index.htm).
Unicode has several encodings, of which the most used are UTF-8 and UTF
