HELP MYSQL add other table
#1

hello there , i need your help, i'm trying to connect two tables to my GM MYSQL. i have my gm with this accounts systems https://sampforum.blast.hk/showthread.php?tid=435485, now i need create other table to save the info of the cars, and other for the jobs, but i don't have any idea to make it, some one can help me?, ( i have the idea how to create the table, i know it, but i don't know how connect two tables)
Reply
#2

You connect to 1 database that has multiple tables.
Reply
#3

Use PhpMyAdmin and add new tables
Reply
#4

ok i was looking for it. i am learning about the relation and the fk, pk. if i need help i reply it
Reply
#5

Quote:
Originally Posted by Darkay
Посмотреть сообщение
ok i was looking for it. i am learning about the relation and the fk, pk. if i need help i reply it
What do you mean?
Reply
#6

i tried but not succes... this is my gm dont save the coordenades, health :c just the password and things to the table 1
Reply
#7

i can't load or save dates of the others tables. please help me
Reply
#8

https://dev.mysql.com/doc/refman/5.7...ate-table.html
Reply
#9

ID: 1452 - Error: Cannot add or update a child row: a foreign key constraint fails (`tnwdb`.`users`, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id_account`) ON DELETE CASCADE ON UPDATE CASCADE) - Callback - OnQueryFinish - Query: INSERT INTO `users` (id_user) VALUES ('0')
Reply
#10

what should i do?
Reply


Forum Jump:


Users browsing this thread: 5 Guest(s)