[mysql] Forum Topics

actually i dont know where this post is suitable.anyway i need to know how can i set textarea lenth by annotation in the entity class to be stored in the MYSQL(actually 255 < characters).i used JPA.

Hi, I'm wondering if someone can help me with a problem I've been trying to solve for almost a week now which concerns shared ranking (i.e. whilst I am trying to rank things in order of one field, if two or more entries share the same value then they receive …

I'm trying to create a checkbox where the user will select their 'diseases affected: heartdisease, cancer, diabetes' and hit the submit button and will be saved into the database respective columns as as either '1' for yes or '0' for no. I've tried googling for the answer but I can't …

How do i collapse data i pulled out of mysql? I have a messaging system that shows all messegse between you and another member. <table border='1' width='100%'> <?php $ID = $_COOKIE['idCookie']; $memberid = $_GET['id']; $query = mysql_query("SELECT * FROM `private_messages` WHERE to_id='$ID' AND To_Deleted='0' AND from_id='$memberid' OR to_id='$memberid' AND from_id='$ID' …

Hi, I have a php file that contains the queries as strings. I have wrote the following query: SELECT message_no, sender, destination, time_received, type, reference_no, message FROM messages WHERE message LIKE '%:substring%'; :substring is then assigned a value from $substring. The query works when i run it directly in cmd …

Hi I have a single search field ' agent_name' in a form which is a dropdown field of data based on the concatonation of 2 fields: reg_fname and reg_lname When I do the SELECT Query though I'm getting a bit mixed up..... The data from reg_fname & reg_lname does not …

Hi, I would like to know how to set a character set once and permanently, since when i alter the character_set% variables that are shown on 'show varables like 'character_set%', when i alter them the next day they are back with the old values? Thank you very much

This is a dumb question, but I have honestly spent a long time today trying to figure it out, and I'm sure I'm not the only one who has trouble with this. How do you import a CSV directly into a MYSQL DB? I've tried using [CODE]LOAD DATA LOCAL INFILE …

i created a dll file using vb.net then it has a shared function that will execute a stored procedure of mysql but my code is something long and when accessing it, it has a big risk that it can produce an error if there is an incorrect string input, i …

Hi, I'm passing through hard times in d hands of this. I have created my database and i'm having issues replacing the content of my database table with the values i.v posted from my form. Please someone shld help Moi.

So let me start by saying that I am a complete beginner when coding in C++ windows/forms program. I was able to get my SQL database connection up with my program. I've ran some simple tests and it looks like my program is able to do simple queries such as …

Hi guys, I'm quite unsure of what i'm doing here and could use some guidance. I've searched but haven't found any links that were focused enough. My objective is to connect my application to a database for the first time. I've never done this before so it's essentially a learning …

Hello, I've built a timekeeping aplication from a fingerprint machine with automatic import to db and I'm getting some reports. One report is that I'm getting the employees time if they are late from work. But my table is small with 20.000 entries, but with the following query, the results …

Hey Everyone. Im using jquery's Validation plugin to check post values before I submit a form. Im trying to check a mysql table column to match user name to check for a duplicate name before submitting. This snippet of code below works as expected.. [CODE]<?php $request = trim(strtolower($_REQUEST['login'])); //sleep(2); usleep(150000); …

I'm not very good with php or mysql so I can't figure out what I'm doing wrong. I get this error: Failed You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tests,'20120508,'5.5,'20120508)' at line …

halo guys, I having problem executing the SQL statement in the visual studio but when in the MySQL it work fine. Here are my code. Dim sql As String = "SELECT * FROM (SELECT @row:= @row + 1 AS rowNum, std.* FROM Student std ,(SELECT @row:= 0) r) AS t …

I know there are multiple variations of this question here, but not in this form. My Ledger table, in a basic form have the following columns. TransactionID | DateOfEntrydate | TransactionDate | ClientID | TrIsDebit | OpeningBalance | Amount | ClosingBalance DateOfEntry is a colums which stores time of insert …

Hi there, I am looking for help to code a php mysql search form with 4 dropdown list. I want the user to search for accommodation establishments by using a citytown, tourism route, accommodation profile and accommodation tariffs. All this will be in the dropdown list which reflects the fields …

Hey guys. Can you have a look at my queries? I can't spot the error with my foreign key linking. As of now, the table staff has already existed: StaffID char(7) Staff_Name varchar(50) Position varchar(50) And now I'm trying to create a new table called SalesInvoice: create table SalesInvoice( SalesInvoiceID …

I need a really good tutorial on how to alter MySQL databases, and to know how far you can alter a database without loosing or changing the information in the database. Thanx in advance for any help

Hi, I have a query that I would like to be able to decide what fields to select based on the value of the fields in the database... Here is the query I have SELECT mem_id, company, fname, lname, addr1, addr2, city, state, zip, country FROM dc_order WHERE STATUS='W' What …

I think I have a relatively simple problem, but forgive me, I'm new at this. I'm trying to take output from a dynamically created checkbox in php to a foreach statement to make a new string that I can use to request an update from mysql. In the foreach loop, …

I got this error on my page when I tried to login, I don't know what happened please someone help me. What do I need to do? Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'steve_wff'@'208.113.246.18' (using password: YES) in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 6 Error: Could not make a database connection …

Hi all, I created a database for my web application in VB and I'm trying to insert data in my login table but its keep giving me error i have login table which contains loginID UserId Acctype Password My PK is LoginID MyFK is User Id which connected to three …

I am new to PHP/MySQL and currently working on a project to learn it a little better. I have a bit of PHP code and it has a problem that I'm having a little trouble figuring out. Basically, it is taking session data and writing it to a MySQL database. …

Ok I am not getting any other errors in php or mysql but I keep getting returned Query was empty in my table. Any help is appreciated, if anybody needs more info on the code just let me know. This is basically a multi search tool for a huge database …

create trigger ins_notification after insert on transaction_detail for each row Begin insert into sell_notifications(user_id, product_id, quantity) values(new.transaction_id , new.product_id, new.quantity); End; Can any one see where's the problem? :(

Hi I have never done this before and am having some trouble. Could someone tell me where I am going wrong: $sql = mysql_query("UPDATE `gigs` (txnid, payment_amount, payment_status, itemid, createdtime) VALUES ( '".$data['txn_id']."' , '".$data['payment_amount']."' , '".$data['payment_status']."' , '".$data['item_number']."' , '".date("Y-m-d H:i:s")."' )WHERE (gigname)=".$data['item_number']."'" , $link); In case I have …

i have a table with day_date and price each record is displayed as below: Day_date Price Allotment 2012-05-20 500 2 2012-05-21 500 2 2012-05-22 500 2 2012-05-23 600 4 2012-05-24 600 4 2012-05-25 500 7 2012-05-26 500 7 2012-05-27 700 2 2012-05-28 700 2 what i want to do is …

I want to pass my all database from windows to ubuntu on my computer. I think passing all releated data files will be enough so I need to find the files in my windows. Do you know what isthe directory path for these files? Also is it enough to carry …