10,940 Topics
 | |
| | Hi I am not understanding , why the subquery of given query is converting into dependent subquery. Although the subquery is not dependent(not using primary query table) on main query. I know that this query can be optimized using joins,but here i just want to know the reason of this … |
| | can any body provide me with a simple example of how insert and retrieve pictures along with text from mysql, kinda like when you post something in craigslist u add information about what ever you are selling and pictures, i would appreciate it, thank you in advance. |
| | Hi, I have a very specific issue that I'm unable to work out a solution to. It's related to WordPress, but that's for context and isn't otherwise relevant. I have a table named wp_options. It's used to store various option information using 2 fields - option_name and option_value. These are, … |
 | hall guys! i have a static website that is not able to display news,music video and audio, because i want them to be displayed on page from database even allowing comments from audience. can please help me how i can do it step by step from creating a database,table retreive …  |
| | I am updating a summary table from detail table using inner join as follows drop TEMPORARY table if exists summ ; drop TEMPORARY table if exists det ; create TEMPORARY table summ (id int , val int ) ; create TEMPORARY table det (id int , val int ) ; …  |
| | The connection and setting are fine as I can insert things into the same db with different tables. Long story short below is the value that I want to insert into the db but it give me no error and nothing insert. I have use the echo and checked every …  |
| | I have these databases h1 h2 h3 Where each database has the quantity of items that are available to be sold from shop1, shop2 and shop3. I want my data to be concurent. For example 2 users may want to buy the same item the same time and the manager … |
| | i have multiple users who need to update a table into mysql with a csv file they will need to do this by pasting the csv file into a text area on the website the first row of that file contains the name of each feild and i need to … |
| | mysql query problem Sample data of my mysql. id | id2 | sender | recipient | senderread | recipientread | Title 31 | 31 | A177 | B213, A256| yes | yes | Question123 32 | 31 | A256 | A177 | yes | no | Answer456 33 | 33 … |
 | this is the problem code : import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.io.IOException; public class Prepared { public static void main(String[] args) { try { readerHelper r = readerHelper.GET_INSTANCE; System.out.print("enter username: "); String user = r.is().readLine(); System.out.print("enter password: "); String pass = r.is().readLine(); Connection con … |
| | Hi all! I'm stuck somewhere with starting a process from vb.net. I want to start a mysqldump process from my vb.net. This code works perfect if I run it from windows command prompt: "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --user=root --password=mypassword --host=localhost --port=3306 --database sakila > "C:\backup\sakilabackup.sql""" Then I took it to …  |
| | Hi, I made a page to show the information of the applications I apply and the interviews I made for selected applications and I use the inner join and left join to display data from different tables. This week I add another table to enter in it the comments. I … |
 | I have a table called vw_results which holds the result profile for a particular student: idNum |courseUnit | marks | Gpp | grade| id | semseterID | sessionName 06/021| 2 | 47 | 8 | B+ | 1 | 1 | 2010/11 06/021| 3 | 56 | 7 | C … |
| | I have two tables: Subscriber_detail SubscriberID | Merchant_ID 23 | 24 User_Detail User_ID | User_RegisteredID 23 | 1001001 24 | 1001002 Need to fetch User_RegisteredID from User_Login table for SubscriberID and Merchant_ID from Subscriber_Detail  |
| | I have an application, i'm using C# wtih asp.net I need to generate reports with my database (mysql), so I downloaded Crystal Reports. I'm trying to make the connection between Crystal Reports and my database, for that I've Add the User Data Source (MySQL ODBC 5.1 Driver) in the ODBC … |
 | |
| | hey hai eveybody help me in sql..i have three fields namely passengerGender1,passengerGender2,passengerGender3 in single table..now i want to take count for female and male separately from the three fields..it is posssible friends?can anyone help me???thanks in advance...!! |
| | Can any one guide me as I what a query in SQL that change all 'a' in string to 'b' in first_name column in name table. Here is my columns name: first_name | list_name |
 | this is the table ITEM QTY UNIT rod1 50 cm rod1 1 m rod1 50 cm rod2 25 cm rod2 75 cm rod2 1 m this is the result i want user can see ITEM QTY UNIT rod1 2 m rod2 2 m this is tricky for a newbie, please … |
| | Hi all: I'm trying to pull from a table all values of a specific row (accountids) and would like to iterate through each query result while perform a specified task with each value. Example: The following q-- $get_acctids="select accountid from company_info"; $result = mysql_query($get_acctids) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $id_num= … |
| | Hi guyz, When I click the tray icon of WAMPServer and select the phpMyAdmin option, it issues an error **Could not execute menu item (internal error)..... The system cannot find the specified path.** Previously, I could access it without any problem. Any ideas? |
| | Hi, help me to configure (hibernate + mysql + xml) in eclipse, I am getting errors while following the sites when i got them in google seach thanks for your time  |
| | Hello! I have PHP and mySQL set up on a server, and everything works fine. I am able to connect to the SQL database successfully, etc. However, I want to set it up so that a user enters their "ID" in an input box. Then, the php script will return … |
| | Hey, I've come across an error in my school project. I'm creating a college registration web app. The jsp displays a list of available classes with checkboxes to check the ones you would like to register for. I've been running it in debug mode and it throws an exception at … |
| | Hi, I need help here. I have a for with multiple text inputs. input1 is link, input2 is description. This is repeated a number of time. Each link and description is one record, but I cant igure out how to add them to mysql as such. If I fill in … |
| | Hi all - use the curdate() or current date to look at newly added awards in the last 3 months The SQL table used to store the created date when an award was added is **tbl_net_centre.reg_date** and keeps throwing up an error on the <= If anyone can advise the … |
 | I have data that is inserted into a table A. I want that before 'insert' to table A, I should capture Specific data from the array and insert it into table B. Can somebody show me how to do that ?  |
 | So our server is located in Cali and we are 2 hours ahead so When I save my time to database it does it according to the local time. I tried to figure out how to use GetDate() and GetUTCDate() but can not figure out how to use it. How … |
| | Hi friends! I have some trouble restoring a mysql database that I backed up with mysqldump. I have been trying to do this from a command prompt (Windows) This is my code: mysql -u root -pPassword databasename < C:\Backup\databaseNameToBeRestored.sql With this, I get the message that "mysql" is not recognized … |
| | I have an html form that has 10 text field for trhe user too enter dates into. When the user clicks the submit button each text field should be added as a new record to a mysql table. The way I have it now if only 2 are filled in, … |
The End.