[mysql] Forum Topics

I am unable to maintain a GET variable with this pagination script. Was hoping you all could help. I am using a GET function so the user can choose which categories are displayed. I'm using a pagination script I found online and I am now confronted with this issue, when …

hi im working on a project please have a look at the form i need to design the database but i think i will need to instered those info in mutiple tables.  hope some one can help me out with this one.the sss1 radio option corespond to the …

hello, my appreciating, if you give example code in my problem i have 1 file csv with dilimited only column A example column a name | address | phone | birthofdate deby | jersey | 123456 | 01-March-1990 my case is I want to convert to txt with delimited | …

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 …

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, …

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 …

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 been tryin to get this to work for the past week if not two >:( with no joy. Worst of all its such a trivial problem. The program asks you to choose a town name from a combo box when you choose the location you shoud be brought …

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 - 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 am using MySQL to plot data about a quiz into graphs for analysis reasons. I have created a series of queries (with the help of the members of this forum!) I am now saving them as routines so I can call them for efficiency. For some reason with a …

I am running analyses on a quiz and am trying to manipulate querys in order to produce bar charts. I am trying to display a graph which shows the percentages of candidates passing a particular quiz. The query I am trying to run is as follows: SELECT QuizName, (100*(COUNT(PassFail))/(COUNT(XXXXXX))) AS …

i basically need mySQL for learning JDBC connections. will be thankful to any information regarding this matter. didnt find anything concrete on the net...

Does anyone know how to properly install MySql Server? I am having trouble installing it. It's one of the last steps for the MySQL installer package.

Any ideas please on where should I look for help with making a site (lecaff.fr) that includes phpmyadmin, work on the remote server. It works fine on the testing server and through various browsers using Dreamweaver cs6 and phpMyAdmin 3.3.9. It also responds when I comment out the php script.

Hi all I'm trying to write a Procedure to subtract days from a data but Ignoring weekends. This is what I have so far but I have a Syntax error Unexpected END, Expecting `;` I have put a ; after the last END but still get the same error. DELIMITER …

hi everyone i have problem in my code i'm create datbase and table by write in php code but in my phpmyadmin it insert the database only the table dose noe exit here my code <?php $connect = mysql_connect("127.0.0.1","root",""); $db = mysql_select_db("login"); mysql_query("CREATE DATABASE login"); mysql_query("CREATE TABLE users ( id …

Hey Guys, So I was doin a tutorial and I incorporated it into my code and it works for the most part. The program gives you a list of town names you pick one and hit search. All good so far then the program goes into the database and pulls …

Hello Masters, Please help me, How can i display only how many days leave when i mention last date.my system just display *like **5 Days To Go*** compare/subtract current date.I want use it codeignitor. Best Regards, Rjony :)