|
|
Sponsored Content
Top Forums
Programming
mysql query multiple records for one field
Post 302636091 by radoulov on Monday 7th of May 2012 04:17:05 AM
|
|
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
I'm running a bash script query and assigning the output to a variable like this:
exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \
-e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \
AND field2 ='$b' LIMIT 0 , 30";`
which returns something like:
echo... (2 Replies)
Discussion started by: unclecameron
2 Replies
3. Web Development
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies
4. Web Development
Say I have two tables like below..
status
HId sName dName StartTime EndTime
1 E E 9:10 10:10
2 E F 9:15 10:15
3 G H 9:17 10:00
logic
Id devName capacity free Line
1 E 123 34 1
2 E 345 ... (3 Replies)
Discussion started by: ilan
3 Replies
5. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
6. Shell Programming and Scripting
Hello,
For the input file, I am trying to split those records which have multiple values seperated by '|' in the last input field, into multiple records and each record corresponds to the common input fields + one of the value from the last field.
I was trying with an example on this forum... (4 Replies)
Discussion started by: imtiaz99
4 Replies
7. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
8. UNIX for Beginners Questions & Answers
Hi I am trying to run a MYSQL query to display all records within a 12 month period. I have to use from_unixtime function to great a date object.
select call_start_time from call_detail_records
where call_start_time IN (
select from_unixtime(call_start_time) from call_detail_records
... (3 Replies)
Discussion started by: mojoman
3 Replies
LEARN ABOUT SUNOS
wnn_cvt_xim_tbl
wnn_cvt_xim_tbl(4) File Formats wnn_cvt_xim_tbl(4) NAME
wnn_cvt_xim_tbl - Key conversion table for xjsi SYNOPSIS
/usr/lib/locale/ja/wnn/cvt_xim_tbl DESCRIPTION
cvt_xim_tbl defines the conversion table for keyboard input and key code.xjsi(1) converts keyboard input (KeySym) to code (Wnn_code) by using of cvt_key_tbl. SYNTAX State-or-KeySym Wnn_code State-or-KeySym = [States]KeySym-name States = State-name | [SState-or-KeySym and Wnn_code must be separated with a space character or tab. Lines beginning with a semicolon (;) are comments. CODE DESCRIPTION Octal number 0?? Decimal number ?? Hexadecimal number 0x?? or 0X?? EXAMPLES
Example 1: Meta|Left 0x9A Meta|Up 0x99 Meta|F11 0x95 Meta|minus 0x81 Meta|asciicircum 0x82 Kanji 0x81 F1 0x91 F2 0x90 Meta|Shift|F1 0x91 SEE ALSO
xjsi(1), uumkey(4), wnn_2A_CTRL(4) NOTES
Code converted by cvt_xim_tbl is evaluated by the Automaton table 2A_CTRL (default) and then by uumkey. SunOS 5.10 10 Jan 2003 wnn_cvt_xim_tbl(4)