10-16-2013
Exporting 10 million records to a flat file and processing that is unlikely to be faster than just doing it in SQL, at least if the relevant columns are indexed. Have you checked your query with explain plan or similar to see if you can optimise it at all?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a file with 6 columns. First 3 columns together make unique record. I have a variable ($v) which hold a value that is obtained by a caliculaion. I have to replace value in 5th columnn with the value of the variable ($v). The value $v is caliculated from col4 and col6 values.
... (2 Replies)
Discussion started by: new_learner
2 Replies
2. Shell Programming and Scripting
i am reading an i/p file input.txt as below and want to read all filenames as in highlighted in bold below and put them in a different file output.txt. can someone help me with a shell script to do this? thanks in advance
regards
brad
input.txt
---------
START
TYPE:OPT
INIT_SEQ:01... (8 Replies)
Discussion started by: bradc
8 Replies
3. Shell Programming and Scripting
hello
please if anyone can help me make a shell script similar to the command HEAD and TAIL
THANKS (3 Replies)
Discussion started by: BELLA86
3 Replies
4. Shell Programming and Scripting
I have a text file in the following format. can any one please help me in printing the output in userfriendly format mentioned below.
Input.
1) /ss/abc/1/w/s/domainname/abc1/logname/
########error###################
########error###################
########error###################... (2 Replies)
Discussion started by: vinny81
2 Replies
5. Shell Programming and Scripting
file1
abcd
efgh
ijkl
mnop
file2
mnop
qrst
uvwx
xyza
file3
1234
4567 (8 Replies)
Discussion started by: rajivrsk
8 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a file with the lines as below:
C_10_A05_T7
C_10_A06_SP6
C_10_B05_SP6
C_10_B05_T7
C_10_B01_SP6
C_10_B01_T7
C_12_G07_SP6
C_12_G11_SP6
C_12_G11_T7
C_2_H18_T7
C_2_I02_SP6
C_2_I02_T7
C_2_I13_SP6
C_2_I17_SP6
The four segments of each line are connected by '_' symbols. I... (7 Replies)
Discussion started by: Fahmida
7 Replies
7. Shell Programming and Scripting
hi all,
i want script to print the output in the following format
filename yyyy/mm/dd count
where count= no.of records in the file
Thanks in advance
hemanthsaikumar (11 Replies)
Discussion started by: hemanthsaikumar
11 Replies
8. Shell Programming and Scripting
I am trying to Join all the lines matching similar pattern.
Example ;
I wanted to join all the lines which has sam to a single line.
In next line, i wanted to have all the lines with jones to a single line....etc
> cat sample.txt
sam 2012/11/23
sam 2012/12/5
sam 2012/12/5
jones... (2 Replies)
Discussion started by: evrurs
2 Replies
9. Shell Programming and Scripting
Hello Mates,
I would request your help in a shell script,
simply I need to delete some matching db table records (rows) to ones in a given file:
------------------------------
#!/bin/bash
SQL="delete from numberlist where msidn='';"
MYSQL_USER="<your-user>"... (4 Replies)
Discussion started by: EAGL€
4 Replies
10. Shell Programming and Scripting
Not sure if this is the correct forum for this question. I have two files. file1.zip, file2
Input:
file1.zip
col1, col2 , col3
a , b , 0:0:0:0:0:c436:9346:d40b
x, y, 0:0:0:0:0:880:39f9:c9a7
m, n , 0:0:0:0:0:80c7:9161:fe00
file2.txt
col1
c4:36:93:46:d4:0b... (1 Reply)
Discussion started by: anil.v
1 Replies
LEARN ABOUT LINUX
mysql_secure_installation
MYSQL_SECURE_INST(1) MySQL Database System MYSQL_SECURE_INST(1)
NAME
mysql_secure_installation - improve MySQL installation security
SYNOPSIS
mysql_secure_installation
DESCRIPTION
This program enables you to improve the security of your MySQL installation in the following ways:
o You can set a password for root accounts.
o You can remove root accounts that are accessible from outside the local host.
o You can remove anonymous-user accounts.
o You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit
anyone to access databases with names that start with test_.
mysql_secure_installation helps you implement security recommendations similar to those described at Section 2.10.2, "Securing the Initial
MySQL Accounts".
Invoke mysql_secure_installation without arguments:
shell> mysql_secure_installation
When executed, the script prompts you to determine which actions to perform.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_SECURE_INST(1)