All Questions
4 questions
2
votes
1
answer
352
views
Will calling mysql_connect() and mysql_close() 16 times causing high DB connections?
I have a Joomla1.5 based system. I run the profiler and found that mysql_connect() and mysql_close() both functions have been used 16 times.
I know that both of these functions and Joomla 1.5 are ...
- 988
-1
votes
2
answers
417
views
Trigger syntax error in phpmyadmin version 5.1
SQL Query -
CREATE TRIGGER `trigger_insert` AFTER INSERT ON `user`
FOR EACH ROW BEGIN
INSERT INTO `credentials` (`UserId`,`Password`,`UserType`,`Status`)
VALUES (NEW.UserId,...
- 3,628
0
votes
1
answer
1k
views
mysql 5.1 signal an error to cause PDO exceptions
I know mysql 5.5 allows using SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Error: ...'; to raise a user defined error. And this error will stop an INSERT operation if it was put in the BEFORE INSERT ...
- 825
5
votes
2
answers
5k
views
INSERT INTO table VALUES.. vs INSERT INTO table SET Error
I'm trying to run the following query:
"insert into visits set source = 'http://google.com' and country = 'en' and ref = '1234567890';"
The query looks good to me and it prints a warning:
1 row(s) ...
- 3,463