Creating Index in Mysql

Index

CREATE INDEX work_id(Index_name) ON table_name field_Name

Most Popular

how to delete multiple selected data in php?

sample.php <?php if($_POST['delete']=='Delete Slected'){     for($i=0;$i<$count;$i++){         $del_id = $checkbox[$i];         $sql = "delete from need_workshop where id='$del_id'";         $result = mysql_query($sql);     } } ?> <form name="frmdelete" method="post" action=""> <table width="100%"> <tr> <td colspan="8" align="Left" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete Slected"></td> </tr> <tr>  <td id="heading">Select</td>  <td id="heading">Name</td>  <td id="heading">College</td>  <td id="heading">Contact</td>  <td id="heading">E-mail</td>  <td id="heading">Worksdop Type</td>  <td id="h...
Keep reading

ReactJs Top Hooks List

 In today article we are going to show you some reactjs hooks which can help you to increase your reactjs knowledge.  What is hooks? Hooks are a new addition in React 16.8.  It allows you to use state and other React features without writing a class. Hooks are the functions which "hook into" React state and lifecycle features from function components. Following are some hooks which are most useful for you 1. useState Hook  React useState() is a built in hooks or function which comes with React library. When you want to use “useState” you need to first import in your application using following code sample.  useState() only work with functional components. This will not work with Class components in React. Visit original article here 2. useEffect Hook The useEffect() hook allows us to run side effects on your functional components. Side effects is a general concept about how functions behave which are not predictable. A function is supposed to have side effe...
Keep reading