Hi I have a file that are a list of people & their credentials i recieve frequently The issue is that whne I catnet this list that duplicat entries exists & are NOT CONSECUTIVE (i.e. uniq -1 may not weork here )
I'm trying to write a scrip that will remove duplicate entries
the script can... (5 Replies)
Hi,
I have a text file with 2000 rows and 2000 columns (number of columns might vary from row to row) and "comma" is the delimiter.
In every row, there maybe few duplicates and we need to remove those duplicates and "shift left" the consequent values.
ex:
111 222 111 555
444 999 666... (6 Replies)
Hi,
I have this large file and sometimes there are duplicates and I want to basically find them and figure how many there are.
So I have a file with multiple columns and the last column (9) has the duplicates.
eg.
yan
tar
tar
man
ban
tan
tub
tub
tub
Basically what I want to... (6 Replies)
Hi,
How to eliminate the duplicate values in unix? I have a excel file which contains duplicate values.
Need to use this in a script.
Thanks in advance. (3 Replies)
Hi All
In unix ,we have a file ,there we have to remove the duplicates by using one specific column.
Can any body tell me the command.
ex:
file1
id,name
1,ww
2,qwq
2,asas
3,asa
4,asas
4,asas
o/p:
1,ww
2,qwq
3,asa (7 Replies)
i want to remove all the duplictaes in a file.I dont want even a single entry.
For the input data:
12345|12|34
12345|13|23
3456|12|90
15670|12|13
12345|10|14
3456|12|13
i need the below data in one file
15670|12|13
and the below data in another file (9 Replies)
Hello,
I'm moving some disks from the rootvg on AIX 5.3.
# replacepv hdiskOLD hdiskNEW
I have for example hdisk12 and hdisk13 with hd5 (boot) LV and want to move hdisk13 So 1st I'm excluding it from the bootlist:
# bootlist -om normal hdisk12
then
# replacepv hdisk13... (7 Replies)
Hi guys,
I am trying to identify the number of duplicate entries in a string inputed by the user. Here is a command I use:
$ user_input="M T T"
$echo "${user_input}" | awk '{for(i=0;i<=NF;i++) print $i }'| sort | uniq -d
The above works fine for string with multiple letters. The problem is... (2 Replies)
Mac OS 10.9
Let me preface this by saying this is not for marketing or spamming purposes.
I have a script that scans all the email messages in a directory (~/Library/Mail/Mailboxes) and outputs a single column list of email addresses. This will run multiple times a day and append the output... (3 Replies)
Discussion started by: sudo
3 Replies
LEARN ABOUT PHP
mysqli_info
MYSQLI_INFO(3) 1 MYSQLI_INFO(3)mysqli::$info - Retrieves information about the most recently executed query
Object oriented style
SYNOPSIS
string$mysqli->info ()
DESCRIPTION
Procedural style
string mysqli_info (mysqli $link)
The mysqli_info(3) function returns a string providing information about the last query executed. The nature of this string is provided
below:
Possible mysqli_info return values
+---------------------------------------+----------------------------------------------+
| Query type | |
| | |
| | Example result string |
| | |
+---------------------------------------+----------------------------------------------+
| INSERT INTO...SELECT... | |
| | |
| | Records: 100 Duplicates: 0 Warnings: 0 |
| | |
|INSERT INTO...VALUES (...),(...),(...) | |
| | |
| | Records: 3 Duplicates: 0 Warnings: 0 |
| | |
| LOAD DATA INFILE ... | |
| | |
| | Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 |
| | |
| ALTER TABLE ... | |
| | |
| | Records: 3 Duplicates: 0 Warnings: 0 |
| | |
| UPDATE ... | |
| | |
| | Rows matched: 40 Changed: 40 Warnings: 0 |
| | |
+---------------------------------------+----------------------------------------------+
Note
Queries which do not fall into one of the preceding formats are not supported. In these situations, mysqli_info(3) will return an
empty string.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)RETURN VALUES
A character string representing additional information about the most recently executed query.
EXAMPLES
Example #1
$mysqli->info example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$mysqli->query("CREATE TEMPORARY TABLE t1 LIKE City");
/* INSERT INTO .. SELECT */
$mysqli->query("INSERT INTO t1 SELECT * FROM City ORDER BY ID LIMIT 150");
printf("%s
", $mysqli->info);
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
mysqli_query($link, "CREATE TEMPORARY TABLE t1 LIKE City");
/* INSERT INTO .. SELECT */
mysqli_query($link, "INSERT INTO t1 SELECT * FROM City ORDER BY ID LIMIT 150");
printf("%s
", mysqli_info($link));
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Records: 150 Duplicates: 0 Warnings: 0
SEE ALSO mysqli_affected_rows(3), mysqli_warning_count(3), mysqli_num_rows(3).
PHP Documentation Group MYSQLI_INFO(3)