Tagged Questions
0
votes
0answers
99 views
error in creating trigger in phpmyadmin
I have 4 tables:
event:
event_id(p.k) | uid | circle_id(f.k)
activity:
uid | performed_activity_id(f.k->event_id) | activity_type_id
follow:
follower_id | circle_id(f.k)
noiticication:
...
2
votes
2answers
120 views
What is the difference between using varchar(100) and varchar(255)?
I want to know difference between varchar(100) and varchar(255) in terms of memory usage and programming problems of using more memory.
1
vote
1answer
269 views
How to import big sql file in Phpmyadmin
I am having a big sql file( 16mb) and all i need is to upload it to the Phpmyadmin to work with it in my localhost. I'm a newbie here in Php/MySql and i want to know about the details regarding the ...
1
vote
1answer
354 views
ON DELETE cascade alternate
I am trying to create a database for 2 Tables like:
Table1 : tb1-id(pk) | tb2-id | other
Table2 : tb2-id(pk) | other
FOREIGN KEY Table2(tb2-id) REFERENCES Table1(tb1-id) ON DELETE ...
1
vote
1answer
181 views
How to get a unique highscore per user
I have the following tables: users, highscores
I would like to get the top ten best results in highscore. The scores should be unique, meaning one score per user. I tried using INNER JOIN and GROUP ...
1
vote
1answer
227 views
Visually create a join using PHPMyAdmin
I recently started using SQL Server 2008 express and it has a really nice joins interface, whereby you can visually create a join. Is this possible on PHPMyAdmin?
