How to access the binary log files to track the queries in Mysql database?
- by Parth
How to access the binary log files to track the queries in Mysql database?
Search Results
Search found 162 results on 7 pages for 'parth dani'.
Page 5/7 | < Previous Page | 1 2 3 4 5 6 7 | Next Page >
-
-
I need to itereate a loop to every time find the string appearing after a particular string say "if(
- by Parth
I need to itereate a loop to every time find the string appearing after a particular string say "if(OLD.", then which PHP function will be helpfull for me?Read the article
-
I am new to start the freelancing I need to buy a hostname/Domain to deploy the project What to do?
- by Parth
I am new to start the freelancing I need to buy a hostname/Domain to deploy the project.. Should I ask client to buy it? how much does it cost? for how much time is it valid? for how much time its good to buy the domain? Please help...Read the article
-
How to get the previous value from incrementing variable in for loop?
- by Parth
In My last post I asked : How to create dynamic incrementing variable using "for" loop in php? like wise: $track_1,$track_2,$track_3,$track_4..... so on.... whose answer I selected as for($i = 0; $i < 10; $i++) { $name = "track_$i"; $$name = 'hello'; } and for($i = 0; $i < 10; $i++) { ${'track_' . $i} = 'val' } Now, What If I…Read the article
-
Can auditing Log history in MySQL be done using Procedures and triggers together?
- by Parth
Can auditing Log history in MySQL be done using Procedures and triggers together?Read the article
-
I have created a PHP script and I am lacking to extract the primary key, I have given flow below, pl
- by Parth
I am using MySQL DB, working for Joomla, My requirement is tracking the activity like insert/update/delete on any table and store it in another audit table using triggers, i.e. I am doing Auditing. DB's table structure: Few tables dont have any PK nor auto increment key Flow of my script is : I fetch out all table from DB. I check whether the…Read the article
-
iPhone : How to convert CSV format into NSData or NSString?
- by PARTH
Hi Guys, I am making an iPhone app which requires the current Stock Prices. I am receiving the data in CSV format from a link given below. http://finance.yahoo.com/d/quotes.csv?s=RHT+MSFT&f=sb2b3jk Is it possible to convert the CSV format to NSData or NSString format? If Yes, how can I convert the CSV format to NSData format or NSString…Read the article
-
How can i implement a dropdown list in asp.net page which recieves values from database??
- by Parth
The data tools like gridview and formview does not have dropdown list by default. Can I insert it in formview? Does it have any thing to do with databinding?Read the article
-
Is it possible to Use cursor in triggers in MySQL?
- by Parth
Is it possible to Use cursor in triggers in MySQL? Is it recommended? as someone told me its helpfull to use cursor in triggers for auditing I need this for auditing... Please help .. Thank YouRead the article
-
How to use Binary Log file for Auditing? please do not give me hyperlinks for Mysql website
- by Parth
How to use Binary Log file for Auditing? please do not give me hyperlinks for Mysql website.. please direct me to find the solutionRead the article
-
Please explain me MySQL Joins in simple language?
- by Parth
Please explain me Joins in simple language? please do not post the weblink as i need how a developer gets it not how the author.. pls understand :)Read the article
-
What is cardinality in MySQL? PLease explain simple non technical language...
- by Parth
What is cardinality in MySQL? PLease explain simple non technical language... If a index detail of any table displays the Cardinality of a field say group_id as 11, then what does that mean?Read the article
-
What logic can be applied to create the Insert query from given Audit table?
- by Parth
i need to create a PHP script to create the insert query to insert in a table, The table from which I need to fetch out the data to create insert query is given below.. The query has to be like this INSERT INTO table_name (field1,field2, field3...) values('newvalue','newvalue','newvalue',....) Please Help... ThanksRead the article
-
I need to iterate a loop to every time find the string appearing after a particular string say "if(O
- by Parth
I need to iterate a loop to every time find the string appearing after a particular string say "if(OLD.", then which PHP function will be helpful for me? Suppose I have a variable say, $string, according to any select query say "select * friends", Now any of its value contain a string say "how are you Jack?" Now I want to iterate a loop…Read the article
-
How to iterate into a string for a word after a fixed keyword? [closed]
- by Parth
Possible Duplicate: I need to iterate a loop to every time find the string appearing after a particular string say “if(OLD.”, then which PHP function will be helpful for me? This is the string BEGIN IF (NEW.name != OLD.name) THEN INSERT INTO jos_menuaudit set menuid=OLD.id, oldvalue = OLD.name, newvalue =…Read the article
-
asp.net formview data tool
- by Parth
the formview in data tools in asp.net by default gives textbox in insert mode template. how to change this to textarea or dropdown selection list?Read the article
-
st inserted id?Joomla syntax for mysql last inserted id?
- by Parth
What is the joomla syntax for mysql last inserted id?Read the article
-
How to get an array to check in the in_array function? See description Below...
- by Parth
I am fetching the data using mysql_fetch_array like : while($row = mysql_fetch_array($select)) { $tables[] =$row; } Now i need this $tables array as one dimensional array only, so that i can use it in if(in_array($val['table_name'],$tables)) { //Some Code } to check for whether the $val['table_name']…Read the article
-
How to get the required value displayed from the given array?
- by Parth
From below array i want the value of "_sql" to be displayed or we can I want to echo the "_sql" value, so what should be the syntax to display it in PHP code? JTableMenu Object ( [lft] => [rgt] => [home] => [_tbl] => #__menu [_tbl_key] => id [_db] => JDatabaseMySQL Object ( …Read the article
-
What are minimum requirement for a novice to learn OOP?
- by Parth
What are minimum requirement for a novice to learn OOP?Read the article
-
[Edited] is it helpful to use cursor in triggers for auditing? If Yes then How?
- by Parth
Is it possible to Use cursor in triggers in MySQL? Is it recommended? as someone told me its helpfull to use cursor in triggers for auditing I need this for auditing... EDIT is it helpful to use cursor in triggers for auditing? If Yes then How? Please help .. Thank YouRead the article
-
How to make a link button visible after another button has been clicked in asp.net(vb) in button_c
- by Parth
How to make a link button visible after another button has been clicked in asp.net(vb) in button_click() it says error as "Object reference not set to an instance of an object." i've done this in my code Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim receipt As LinkButton =…Read the article
-
Is it possible to apply the Replication mechanism on single MySQL server?
- by Parth
Is it possible to apply the Replication mechanism on single MySQL server? I want to replicate the changes done in test db to Main db in the same server, so can i use this Replication mechanism on same server?Read the article
-
Please verify the trigger created below for delete is correct or not?
- by Parth
Please verify the trigger created below for delete is correct or not? Its for the insertion of every field of deleted row in audit table.. Please reply whether this trigger will work for me? delimiter // CREATE TRIGGER audit_menu BEFORE DELETE ON menu FOR EACH ROW BEGIN INSERT INTO audit (menuid, field, oldvalue,…Read the article
-
What should be the RegEx if I want to find the text between the phrases " IF (NEW." and " !"?
- by Parth
What should be the RegEx if I want to find the text between the phrases " IF (NEW." and " !"? Likewise I am thinking of the pattern as $pattern = '/(?<= IF (NEW.)[^ !]+/'; I am matching it as $input = $row4['ACTION_STATEMENT']; preg_match_all($pattern, $input, $captures); What if I want $captures as an array,…Read the article
