UPDATE COmmand post comparing 2 columns in 2 mysql tables
my queryis :
select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;
[/CODE]But how should I update them?
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
I am comparing two table structure in different databases,Put into 2 txt files , when comparing if column sequnce and data type is not matching ,it has to display that info else Table structure is ok.
wrote shell script ,its not working .I am getting "Table structure is not ok" even if both... (1 Reply)
Hi,
I have two databases with same tables on different servers.I need to check the data content in each table and if something is missing, should print that.
I have a tool which takes the snapshot the table structure,index so on and compares with the other server tables snapshot.
Now i need... (1 Reply)
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)
Hello;
I want merge four MySQL tables to get the intersection that have a common field for all of them. Join two tables is fine to me, but my this case is different from common situations and there are not very many discussions about it. Can anybody give me some idea? Thanks a lot!
Here is part... (8 Replies)
Hello all;
I have been really frustrated with finding the correct perl code (and MySql statements) to accomplish what I thought was straight forward...I have tested I don't know how many different codes\suggestions I found on the net without any success...but anyhow let me explain my plight and... (0 Replies)
I have defined a set of global variables at the beginning of my script as below:
#ideal values
export ITEM1=SUCCESS
export ITEM2=FAILURE
export ITEM3=UNAVAILABLE
export ITEM5=FAILURE
export ITEM6=SUCCESS
now I have a shell script function which returns a value in below format.
ITEM1... (1 Reply)
Discussion started by: ctrld
1 Replies
LEARN ABOUT OSF1
xmlistreplaceitemsposunselected
XmListReplaceItemsPosUnselected(3X)XmListReplaceItemsPosUnselected(3X)NAME
XmListReplaceItemsPosUnselected - A List function that replaces items in a list without selecting the replacement items
SYNOPSIS
#include <Xm/List.h>
void XmListReplaceItemsPosUnselected (widget, new_items, item_count, position)
Widget widget;
XmString *new_items;
int item_count;
int position;
DESCRIPTION
XmListReplaceItemsPosUnselected replaces the specified number of items in the list with new items, starting at the given position. The
replacement items remain unselected, even if they currently appear in the XmNselectedItems list. Specifies the ID of the List widget to
replace items in. Specifies a pointer to the replacement items. Specifies the number of elements in new_items and the number of items in
the list to replace. This number must be non-negative. Specifies the position of the first item in the list to be replaced. A value of 1
indicates that the first item replaced is the first item in the list; a value of 2 indicates that it is the second item; and so on.
Beginning with the item specified in position, item_count items in the list are replaced with the corresponding elements from
new_items. That is, the item at position is replaced with the first element of new_items; the item after position is replaced with
the second element of new_items; and so on, until item_count is reached.
For a complete definition of List and its associated resources, see XmList(3X).
SEE ALSO XmList(3X)XmListReplaceItemsPosUnselected(3X)