I have the following table in MySQL... CREATE TABLE `visits` ( `id` int(10) unsigned NOT NULL auto_increment, `visit` datetime NOT NULL default '0000-00-00 00:00:00', `bulletin` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) Where "visit" is the time a visit occurs, and "bulletin" is the article requested at that time. I...
I am running this mysql query: $result = mysql_query("SELECT * FROM userdetails WHERE userid= '$userid'"); $row = mysql_fetch_array($result); The result is a row of 100 variables with different names such as $row['name'], and $row['email'], etc... How can I convert all of these to just $name and $email, etc... in php? It would sav...
Hi All, I have two mysql cluster data nodes as Master and slave. But after certain number of rows there is difference between two auto_increment values from one node to another. The difference is of Node 2 is ahead than node 1 by 11. can anyone suggest any fix on this? how to resolve this. and when such type of situation comes? Than...
Summary A parent can have many children. How do you write a service such that, if after adding a parent there is an error when adding a child, the entire transaction is rolled back. For example, add parent p1, successfully add child c1, then when adding child c2 an error occurs, both p1 and c1 should be rolled back. Detailed Problem In...
I want to select 15 columns from a table of 20 columns. Is there a way to exclude those 5 columns instead of specifying other 15 columns. ...
Hi! Let's say we have a stored procedure selecting something from a table: CREATE PROCEDURE database.getExamples() SELECT * FROM examples; How can I use the result from this procedure in a later select? (I've tried SELECT * FROM (CALL database.getExamples()) but with no success.) Should I use SELECT... INTO outVariable in the ...
Did you try amazon-rds? How is it, performance-wise? ...
I have uploaded a page with the code below to my joomla root directory. <?php $value = trim($_POST['opts']); if ($value){ $db = "my_db"; $link = mysql_connect('localhost',$me,$my_password); if(!$link) die("Error 1 ".mysql_error()); mysql_select_db($db); **$query = "SELECT introtext,fulltext FROM jos_content WHERE title='$value' "...
Hi, I was always connecting to SQL which was simple, but now I would need to connect to a MySQL server. I thought System.data.odbc connection will work, but it doesnt connect. I do not udnerstand whather I really need to download and install any third party stuff like Connector or even MyODBC, I thought ODBC in .NET is enough. Could you ...
HI, I am trying to display results from a database in results.php. In the same file, after all the data has been displayed in the current webpage,I am placing a button to create a file based on this results to produce a Excel file. I am not sure how to do this. I have tried but it says you have to force excel file download before any ...
What happes when the scrip that made @mysql_connect($server, $user, $password) dies? How long does it live? Thank you! ...
I want to write a search query that search on the criteria like city, rent, area. i am new to database and sql queries. How to write query. Please help. Any suggestions will be highly appreciated. My form snapshot is here ->> ...
When in a mysql innodb transaction, I would expect a duplicate key error to cause a rollback. It doesn't, instead it simply throws an error and continues on to the next command. Once the COMMIT command is reached, the transaction will be committed, sans the duplicate key causing command. Is this the expected behaviour? If so, how would ...
Hi everyone, I've been playing around with PDO for the last few days, I'm working on a small CMS system to teach myself OOP skills, but even though it's only a small CMS, I want it to be able to handle whatever the web can throw at it. This is what I've come up with so far, I'm going to add connection pooling to the constructor to enab...
I have the following table setup: branches table: ... manager_id sales_manager_id admin_manager_id ... the above-mentioned columns contain the foreign key for the users table. to complicate things I also have a branches_extra table: branches_extra: id branch_id user_id position_id which contains user_id, branch_id foreign keys f...
As I've been looking into the differences between Postgres and MySQL, it has struck me that, if what I read is to be believed, MySQL should be (disclaimer: by reading the rest of this sentence, you agree to read the next paragraph as well) the laughingstock of the RMDB world: it doesn't enforce ACID by default, the net is rife with stori...
Hi, Using MySQL Server, I have a table structure like: (Table test) id Name 1 "test1" 2 "test2" 3 "test3" When I perform the following query: "Select name from test", the results are: "test1" "test2" "test3" How can I adjust this query so the results are columns, as such: "test1" "test2" "test3" ...
Hello all, I want to insert a row into the Database using SqlDataAdapter. I've 2 tables (Custormers & Orders) in CustomerOrders database and has more than thousand records. I want to create a GUI (TextBoxes) for adding new customer & orders into the Database to their respective tables. How should I do it? I guess the method that is...
If I plan to use MySQL on a web-development project (example.com) where my web application is a commercial product where I'm selling a service and it just so happens that MySQL, using the InnoDB engine, is the backend data storage for my web application ... do I have to purchase a commercial license to use MySQL/InnoDB? If I do have to ...
Is there a way to get the execution time of the last executed query in mysql? ...