MySQL Database Forum

My colleague is facing an issue with MySQL. I am asking question on behalf of him. He has created an application and they use MySQL as database. The application is in Java and they use NHibernate. When the application run continuously database connection is getting closed after 21 Hours. Error in the log file is And i suppose if we...

Hi, Please help me out..... I have created an user in the Mysql database with the password. user : san password : san when i run this query :

Hi, I have two comparisons that I need to do and they are a bit beyond my knowledge, would appreciate some help. :) I have two tables that have an identical structure, one is the incoming daily update, tableA which I want to compare to the history tableB. Both structures look like this:

hii, I have a enum field in database ,which i break up using php and make it a dropdown list in the form . i have a requirement now such that from the list the person must be able to select 2 items together which is also done.but can i store 2 values in a db column which is an enum field?

I need help on how to query this scenario Suppose i have this tables: TABLE1 +--------+-------+ | usr | value | +--------+-------+ | werty1 | 789 | | werty2 | 789 |

For example: Cat Dog Cow Rat Cat Cat Rat Cow

Hi all, I happen to propose a DBMS, the requirement is that we have 1.6million rows in DB having 15 simple columns and at worse we need to come compare 10,000 rows(trasactions) one by one with this 1.6 figure, only 5 columns are compared and filter out some transactions. and we need get back the results within two days. We are using Java on...

I have records like: abc -books acc -papers now what I wanted to to is to update the first three (3) characters into: xxx -books xxx -papers

I am struggling with how I should store this data. I get an xlm update every day which contains about 20,000 rows of data. There are some new rows, maybe 150 a week, and some of the existing rows data changes. Approximately 97 % of all the data is the same each day with just 3% changing. I am using Mysql database tables. So I was...

Good day, I dont know if this would be called a special case since this will be my first time to have an idea where i would like to insert a value from the table with a condition Is it possible? For example: I have a table 'tablename', and has a column 'values' and expected to put millions of unique values in that table. The...

hi, how to write query to select project estimated effort,actual effort spent,%usage of project effort,%completion of project,ratio of %work completion to % effort consumed FOR 1. during the period 2. Cumulative period All the differnt kind of effort comes from multiple tables thanks Eagle A,

How to insert image in mysql database via php and how to retrieve in php ?

Hi! I'm completely new to all dev and trying to put a website together using MySQLI and PHP; was running fine until I try to gather the DB content with the following script: <? $username="xxxxxx"; $password="xxxxxx"; $database="maxalien_davidloran"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable...

Hi, I have 4 columns workID, Description, work & Rework . On the basis these four columns i have to generate four more columns as total Work,%work, %Rework, %Total Work. we have some dummy data. So Now my question is how to write stored pocedure to select in case of the above scenaraio. Thnks.

please help me to write a query in which i have to genrate report on basis of given columns from different tables. am using sql server 2005 thx & regards

Is there a way to apply security at table level rather than database level. A critical table in-house mysteriously disappeared the other day. Although it shouldn't be necessary I would like only one person with the power to DROP this critical table. Can privileges be set at table level. I am working in phpmyadmin

I have a table, where it composed of several columns, but i am concerning only on a specific column with datatype varchar under that db table... Now, for example: column: links values: http://localhost/asdf/asdf.php http://localhost/ http://localhost/12312/adfdf.php

hii. i have a db tables which i am exporting to csv or other formats . i will be making it format like name and value . so i need 3 special chars which will separate the 2 . like $name*pradeep% . so which are the special chars which i can use for this purpose ,

Hello, i have this constellation on tables in my database: Table A id|content Table B table_a_id|table_c_id

hello, i'm planning to create an application. there are some software out there that can be used to automate the installation process of an application. but the application comes with a mysql database. i can include mysql in the installation process along with the application. but then how can i setup the database? the query such as the...

Hi im doing the following query SELECT * FROM networkinfo JOIN tblimage WHERE networkinfo.network LIKE '$data' && networkinfo.network = tblimage.imgdata && networkinfo.category = '$category' so I can get it to work untill I add the last && networkinfo.category = '$category' this kills the whole query what am I doing wrong? I think it...

I doubt if this is the right section to post... But, for a clarification I always use "jdbc:mysql://localhost:3306/dbname" to access the mysql database server given also the username and the password But, i would like to access that db server from another workstation, I replace "localhost" to an ip address and added a grant privileges...

I dont really have a problem, but I want to make my code faster and prettier. I have some tables with DATETIME in it. They have the std format %Y-%m-%d %H:%i:%s I need them to be in %d.%m.%Y %H:%i format. I tried to fix it with the server variable "datetime_format". After reading a lot in mysql doc I found out that: ...

hello, how to programmatically from VB .net / php. to import data from an EXCEL file? is there's no programmatic way, how to automated the process. as i search, the process is: Simply export data from excel as TXT or CSV. Than use MySQL command LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table; so,

Dear Sir Please help me i want a query which out put is: Vendor Amount Computer AA 52000 BB 20000 Total: 72000