Let me start with a bold statement:
Database != Spreadsheet
Do not think of your database as a spreadsheet with rows and columns that you can do just anything with. All the rows of a table share the same structure and that structure is what gives Databases their power.
One of the first Rules of Data Normalisation is to take any "repeating" data fields in your record (AI001, AI002, etc.) and split them out into a
separate table.
Trying to write any sort of query that needs to look "across" 300 fields is going to be a complete nightmare to work with.
... where ai001 in ( 'fred', 'barnie' )
or ai002 in ( 'fred', 'barnie' )
. . .
or ai300 in ( 'fred', 'barnie' )
Also, any table that doesn't have a unique, Primary Key, is going to be equally difficult to work with.
So, your table
could look more like this:
create table ai_locations
( id int not null auto_increment
, ai_timestamp datetime not null
, location varchar( 25 ) not null
Regards, Phill W.