How to write ai?

Question

MySQL

Good afternoon, I'm studying the issue of writing ai for the game. Where can you get information on this topic?
As I understand it, if you disassemble ai for chess, you can break your head in the code)
I would like a basic understanding of writing ai in games and applications in general.
Comrades, in which direction to dig?

Answer 1

select * from (SELECT * from products LIMIT 3 ) t
left join files f using(id)

Answer 2

select /**/ from products left join files using(id)

Answer 3

select t1.id,t1.title,t2.file_name from tovari as t1 left join files as t2 on t1.id=t2.id where t1.id in (2,3,4)

Answer 4

There is such a book:
E.N. Kornilov - Programming of chess and other logic games
and take a look at this link:
https://www.gamedev.net/forums/topic/592473-recomm...

Answer 5

There are books on the subject.