Tagged Questions
MySQL is an open-source, relational database management system.
0
votes
0answers
8 views
Unable to populate chained dropdown list with AJAX and Javascript
I'm new to ajax, and programming in general and am currently in the midst of learning as i go.
My Goal
I am currently trying to create a chained dropdown list with the first dropdown populating ...
0
votes
3answers
13 views
Mysql LIKE Order Bu Exact Match
I have a query that gets information using the LIKE
SELECT * FROM table WHERE column LIKE '%$search%'
Now if i search for "Hello there" it will return something like
Oh hello there
Hello there
...
0
votes
1answer
13 views
MySQL query caching of inner query
I have a large query with many nested SELECT statements. A simplified version might look like this:
SELECT * FROM tableA WHERE x IN(
SELECT * FROM tableB WHERE x IN(
SELECT * FROM tableC ...
0
votes
0answers
6 views
mySQL cross table field linking
Basically I have two tables A and B. These are linked by unique ID's where the entries in B point to one entry in A. The entries in A and B also have a 'status' field denoting if the entry is active ...
0
votes
1answer
16 views
securely delete entry from database with link in email
What are some safe ways of deleting an entry from the mysql database with a link in the email? I have a case where an entry can be created by a logged in user on the site. He or she will then receive ...
0
votes
3answers
19 views
Query on multiple tables?
I need to create a single query that reads from three tables in the same db.
Tables:
1. cm_players
player_id
card_no
club_id
surname
name
birthdate
2. cm_clubs
club_id
prefix
name
address
place
...
0
votes
2answers
32 views
MySQL fields in URL
Is there a way to call field rows in a URL without using the column name??
So I currently have a posting site where users can select category or subcategories of choice from drop downs, how it's ...
0
votes
0answers
33 views
One record 27 times
I have a big problem with MySQL. I want to write script like facebook newsfeed.
My query return me 27 the same records. I don't know why.
How it works?
Script displaying posts written by me, my ...
-1
votes
1answer
12 views
group by and sort by biggest groups
Suppose I have a blog where users can make a comment. If the comment is spam, people can vote it deleted.
When that happens, a row is inserted in this table:
SPAM_REPORTS
comment_id - ip
The table ...
1
vote
1answer
18 views
How to select one row with max(select field) and another (specific field)?
How to select one row with max(select field) and another (specific field)?
Below is my code
1. Get to know max(select field) first
2. Then select all field within the row.
but step 2 doesn't return ...
0
votes
1answer
14 views
MySQL search single and multiple subselects
I've got a large table (10m rows approx, all fake test data at the moment.).
id user and action are both not unique, but a user can perform an action only once.
(Meaning there will only ever be one ...
0
votes
0answers
14 views
Java JDBC MySQL inserting into tpye TIMESTAMP fails - why?
I'm having troubles to insert into a TIMESTAMP field correctly.
The method looks like this:
private static void addPickup(Connection conn, boolean debug, String
logfileName, String ...
0
votes
3answers
41 views
truncate table taking very long time, is it normal?
I am using truncate table table_name; on a table with around 1 million rows, but it's been taking too long, running since last 3 hours.
Is it normal? Can you suggest some other way to delete ...
0
votes
0answers
8 views
send “database connect error” stanza in ejabberd
In ejabberd, when a connection to the database fails, the error is logged in the ejabberd.log file as following
I(<0.292.0>:ejabberd_odbc:226) : mysql connection failed:
I want the server to ...
-4
votes
0answers
35 views
how to get sum of column values from multiple tables [on hold]
I had created following three tables:
CREATE TABLE Table1
(Nameid int, name varchar(5), amount int);
INSERT INTO Table1
(`Nameid`, `name`, `amount`)
VALUES
(1, 'chan', 2000.00),
...
