unique index means that two rows cannot have the same index value. unique index creates using the keyword unique. For example: Simple index: create index myindex on tablefirst(cloumn1); Unique index: create unique index myindex2 on tablesecond(column2);
# Indexing increase speed of operations in the mysql database. # If Apply indexing for a particular column.it will search the data fastly other than searching the entire table # if we done indexing, update and insert will be slow compared to select query because at the time of insert and update index file also… Read More »
mysql>LOAD DATA LOCAL INFILE’dump.txt’ INTO TABLE mytbl; $mysqlimport -u root -p –local database_name dump.txt password***
Export data into the outfile using select statement. mysql>Select * from tutorials_tbl into OUTFILE ‘/tmp/tutorials.txt’; ‘mysqldump’ is used to copy or back up tables and databases $mysqldump -u root -p TUTORIALS tutorials_tbl>dump.txt password $mysqldump -u root -p TUTORIALS > database_dump.txt password **** $mysqldump -u root -p –all-databases>database_dump.txt password**
Injection usually occurs when you ask a user input,like their name and instead of a name given you a mysql statement that you will unknowingly run on your database. For Examples $name=”mydoubts.in’;Delete from users;”; mysql_query(“Select * from useres where name='{$name}’”); if you use mysql,the mysql_query() function does not permit query stacking,or executing multiple queries in… Read More »
You can control the behavior of transaction by setting the session variable called AUTOCOMMIT. if AUTOCOMMIT is set to 1(the default),then each SQL statment(within a transaction or not) is considered to be a complete transaction and committed by default finishes. When AUTOCOMMIT is set to 0,by issuing the SET AUTOCOMMIT=0 command, the subsequent series of… Read More »
usually package will display only one item(First settings variable- subservice field/variable in the package) into the ccp But we can display all variable into the subservice in ccp. for this use the following steps 1)go to applications tab. 2)click on the application 3)click on Resource Types tab. 4)select the main resource type created. 5)Click on… Read More »
1.tar 2.grep 3.find 4.ssh 5.sed 6.awk 7.vim 8.diff 9.sort 10.export 11.xargs 12.ls 13.pwd 14.cd 15.gzip 16.unzip 17.ps 18.top 19.kill 20.rm 21.cp 22.mv 23.cat 24.chmod 25.chown 26.passwd 27.mkdir 28.ifconfig 29.whereis 30.locate 31.man 32.head 33.mysql 34.su 35.yum 36.rpm