All Questions
7 questions
0
votes
1
answer
2k
views
Get all childs by parent id using JOIN
I have a table representing the family tree. It has fields ID, NAME, LEVEL, PARENT_ID.
And the column PARENT_ID is the foreign key and refers to column ID of this table. How can I get a list of ...
- 211
0
votes
1
answer
42
views
Sql Query For my case
I Have table in format mentioned below
USER_ID ORDER
1 0
1 1
1 2
1 3
2 0
2 1
2 3
3 0
3 2
I want to find list of user id whose ordering ...
- 246
3
votes
4
answers
871
views
Handling Deletes/Inserts/Select in a huge table
I have a dating website. In this website I used to send daily 10 photo matches to a user and store them in the structure as
SENDER RECEIVER
11 1
12 1
13 1
14 1
I maintain two ...
- 1,087
0
votes
1
answer
223
views
Formatting 11/16/2002 12:00:00 PM to date time stamp in MySQL
How do I change this format "11/16/2002 12:00:00 PM" to something that MySQL will understand without using PHP?
I've tried SELECT CONVERT('11/03/2002 02:45:33 PM', DATETIME) AS datetime; and I ...
- 2,237
5
votes
2
answers
2k
views
How to Import database, update products that have changed, delete products that have been removed
I'm "ok" at basic MySQL, but this is "WAY OVER MY HEAD"!
Objectives:
Import database
update products that have changed
delete products that have been removed
Quickly and efficiently
The database ...
- 2,237
0
votes
1
answer
253
views
how to get row when change in column data
I have following table
Id | Status | date
-------------------
1 | Onsite |2007
2 | Onsite |2008
3 | Onsite |2009
4 | Abroad |2010
5 | Abroad |2011
6 | Onsite |2012
7 | Abroad |2013
8 ...
- 836
0
votes
1
answer
145
views
GROUP BY date with no leaks SQL on MySQL 5.1 [duplicate]
Possible Duplicate:
What is the most straightforward way to pad empty dates in sql results (on either mysql or perl end)?
Create Table:
CREATE TABLE `trb3` (
`value` varchar(50) default NULL,
...
- 59.2k