MySQL is an open-source, relational database management system.
-1
votes
0answers
7 views
How to loop through all the records inside a MySql event?
I did this event in MySql, but I guess I'm missing something. It works if I supply a limit = 1, which means it isn't looping thru the thing. How can I do that?
This works. (For only one record)
...
0
votes
0answers
3 views
How to get lost data to mysql replication slave
I'm having MASTER-SLAVE mysql replication setup.
suddenly slave crashed. And MASTER worked without any problem. Now I started the SLAVE again. And working fine. Data sync happening OK.
But the ...
0
votes
0answers
21 views
UL inside UL inside a foreach
what's up? I'm having some problems with a UL inside a UL. I'ts a dropdown menu, running on a foreach.
This is the HTML:
<ul>
<li class='a1'>Menu
<ul ...
0
votes
0answers
6 views
MySQL trigger before insert TRUNCATE table
I want to create a trigger that will empty the table before each insert, but it does not work
CREATE TRIGGER on_insert BEFORE INSERT ON `list`
FOR EACH ROW
BEGIN
TRUNCATE `list`;
END;
The MySQL ...
1
vote
5answers
23 views
How to include php echo within mysql update?
So I am updating my mysql database using php. Below is the end of the UPDATE, and if I have a string instead of echo $row[embedcode]"); it works fine, and this echo sets data on the page just fine ...
-1
votes
6answers
31 views
Mysql error while inserting a paragraph
I am trying to insert a Paragraph (which contains a single quote in middle) into database as below.
$rule="**Mobile's** are not allowed into the room...................soon";
mysql_query("insert ...
0
votes
0answers
7 views
Representation of a simple messager application using a database
In this application there are users, conversations and messages.
More than 2 users could participate in a conversation.
I was thinking this:(---- are relations, CAPITAL_WORDS are entities)
MESSAGE ...
0
votes
0answers
2 views
PEAR DB, moving from MySQL 4 to 5, .ini file issue?
We're running a custom made CMS that uses PEAR DB class to handle the database. The database is using MySQL 4.0. Our hosting provider is updating to MySQL 5.0 and deactivating all databases using 4.0. ...
-1
votes
1answer
13 views
Getting full join by cdbcriteria yii, mysql db?
Using Cdbcriteria class of Yii how can I get full join(db is mysql)? I know that it can be achieved through union of left join and right join.....but its syntex I am not getting
1
vote
1answer
20 views
MySQL ONLY IN() equivalent clause
I am giving a very abstract version of my question here, so please bear with me. I have a query that will check whether a particular body has certain multiple parameters of same type. Example, a boy ...
0
votes
1answer
19 views
Getting SQL error 1078 Before start of result set in Java program
I have a Java method that is supposed to get column values from one MySQL row and create a string with the values. When run, it generates a SQL error 1078 "Before start of result set."
Here is the ...
0
votes
1answer
16 views
moving from single webapp to multiple webapps connecting to same database
I have a JAVA webapp which is using DB connection pooling for Tomcat+MySQL config.
I have another JAVA webapp which i want to deploy in the same Tomcat and connect to same MySQL database (even access ...
0
votes
1answer
27 views
Retrieve the Data in Tree structure in php
Currently i am working on creating apis in symfony2.2 framework.
I have to retrieve a bunch of questions and answers from the database.
Q1
...
0
votes
1answer
16 views
how to load a variable of an module in dashboard
I am using pyroCMS and i have module A and in that i have a controller, I am getting some values in $var which i defined in function index(), How to load the controller in a different module, I have ...
0
votes
3answers
28 views
Mixing two tables together
I have two tables
db2:
id, db1id, text, count_db1
db1:
id, text
db2 above is created by
SELECT *, COUNT(`db1id`) AS count_db1 FROM `db2` GROUP BY `db1id` ORDER BY count_db1 DESC
so the last ...
