MYSQL
#6

Quote:
Originally Posted by Calisthenics
Посмотреть сообщение
3 threads for the same issue.

https://sampforum.blast.hk/showthread.php?tid=659322
https://stackoverflow.com/questions/...-a-mysql-table

What Dennis12 pointed out is floating-point numbers that are set as `VARCHAR` when mysql provides the datatype (both float and double). You need to design your database structure more effectively.

Why is there everywhere 128?
Why are there no unique keys?
Most importantly, why 17 columns for components that a vehicle may not even have?
A mistake commonly found in most gamemodes. Actually, in most databases.
Instead of using just a VARCHAR ..


With, the code I posted above has to go to create the table without problems (it was tested).
Reply


Messages In This Thread
MYSQL - by RayanIbrahim - 06.10.2018, 12:31
Re: MYSQL - by Dennis12 - 06.10.2018, 12:51
Re: MYSQL - by v1k1nG - 06.10.2018, 12:59
Re: MYSQL - by RayanIbrahim - 06.10.2018, 18:36
Re: MYSQL - by Calisthenics - 06.10.2018, 18:54
Re: MYSQL - by Dennis12 - 06.10.2018, 20:40
Re: MYSQL - by RayanIbrahim - 07.10.2018, 04:51
Re: MYSQL - by Calisthenics - 07.10.2018, 07:06
Re: MYSQL - by RayanIbrahim - 10.10.2018, 11:16

Forum Jump:


Users browsing this thread: 1 Guest(s)