All Questions
10 questions
2
votes
1
answer
2k
views
Sqlbuddy login not working with PHP 7.0
I have searched for an answer to this, but haven't found anything. I was wondering if anyone had come across the same issue and had any insight. I have PHP 7.0 installed on an nginx web server with ...
- 305
0
votes
1
answer
103
views
SQL statement in php will not insert onto database
I have this SQL statement that i'm trying to get to save new students to a table of students, however it simply isn't doing it, I don't get any error messages when I run error reporting and I ran the ...
1
vote
0
answers
292
views
Sqlbuddy show very slow responsetimes
i don't know if this is the right place to ask a question but i'm going to try anyway...
I was looking for a leightweight alternative of phpmyadmin and found sqlbuddy. Very good performance at first ...
- 91
0
votes
1
answer
245
views
SQL Buddy , mySQL Error for LOAD DATA LOCAL INFILE
I am trying to import a CSV file into mysql database. but the query is giving error. The query is :
LOAD DATA LOCAL INFILE ‘/last.csv’ INTO TABLE punjab FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES ...
- 668
0
votes
1
answer
458
views
Creating a password for the mysql root account has caused problems in WAMP
I have created a new password for the root account using:
mysqladmin -u root password "[newpassword]"
This caused problems with connecting to phpmyadmin which I solved by changing the config.inc....
- 1,767
0
votes
1
answer
2k
views
sqlBuddy doesn't accept this .sql file to import
I would like to know why is this: backup.sql file not being accepted by sqlBuddy, I already created a database named youhand with utf8
sqlBuddy message:
0 statements were executed from the file.
...
- 20.2k
0
votes
1
answer
1k
views
sQl buddy: you have an error in your SQL syntax;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'charset utf8 not null auto_increment index key, toId int(11) ...
- 20.2k
6
votes
2
answers
1k
views
How to use foreign keys in SQL Buddy?
I need to use foreign keys for update and cascade, etc.
ALTER TABLE topics
ADD FOREIGN KEY(topic_by) REFERENCES users(user_id)
ON DELETE RESTRICT ON UPDATE CASCADE;
but I am not able to make ...
0
votes
3
answers
3k
views
SQLBuddy: How to select database?
I have the following sql which I want to import with SQLBuddy.
However I get an error telling that no database selected.
Could anyone tell me what line I need to add please?
CREATE TABLE IF NOT ...
- 32.8k
0
votes
1
answer
3k
views
What database field type do you use for yes/no entries in SQL Buddy?
I am new to all this so looking for some help. Sorry if the question is really novice. I am learning all of the char, varchar, etc.
- 6,493