I would like to find all instances of <this is my string> in a certain column in a specified table and replace it with <this is my new string>.
Any ideas guys? Any help greatly be apprecia...
Hi,
I have an xml file.
I like to import to the mysql database.
I have created the table.
Please tell me the syntax how to import it like csv or tab file
HI ,
as topic. how can I have a stored procedure return more than one table , and in visual studio have dataset.fill to fill with dataset with more than one table?
Select * from UserTable where SecurityLevel < '9' Order by FirstName
Select count(*) from TransactionTable where UserName = 'Aaron Moore' AND TransactionDate >= '2009-9-16' AND TransactionD...
I have setup a real estate website here http://www.raglaninternational.com/index.php
My problem is with the property details page where i need to show images of each property.
I have a M...
I'm trying to design a database for an inventory system. how to calculate costing Like (First in First Out Method,Month Average moving Method ,Fixed cost Method, Moving Average Method)
what...
Within one table I have 4 columns. I want a query to display all 4 columns and multiply columns 3 and 4. creating a fifth column i.e
Table colums (Current):
Cars Tires Qty A...
Dear sir,
I am having issue with MySQL on two of my dedicated Windows 2003 servers.I am running Voipswitch software(Voip) and Database is mysql Server 5 .The issue I am having is Some time...
Hello. I am getting this error message:
Client does not support authentication protocol requested by server; consider upgrading MySQL client
MySQL Version:
Server version: 5.0.67.d7-ou...
How do you create a forget password that checks against my mySQL database and sends the password to an e-mail address that corresponds to the user name they forgot the password for?
i am usin...
I have a MySQL table which has a date field called 'closing_date'.
I'm need to execute a query where it deletes any rows where the closing date is older than 1 months (or 31 days - whateve...
hi experts,
I wanna get total work time from mysql . i m describing my structure and need below ::
I have record table in which i have timestamp, employee id etc employee work time is 9 ...
For an application system, I have a log-in table and 3 other tables. All 3 other tables have a "closed" field which is assigned "1" when an application is completed. On a new application I ins...
I have some code which I have simplified below. Essentially, I have a simple maintenance screen that has several fields. In one of these I type something like 'Apostrophe' and "Quotes"
I th...
i have info that i stored in mysql database
now i want to get the info from database
i only want to get the info of last 2 days.
how?
Hi,
I received some help to upgrade PHP to 5.3 of my fedora core 6 os.
I have a website on a VPS.
fedora-core-6-x86_64
My website now says (joomla!)
Database Error: Unable to c...
I'm unable to run the MySQL command line client for two different fresh installations of MySQL 5.1 on WinXP. On launch it prompts for my password, then immediately closes when I enter it. I ha...
I've got the below results and I'm needing to display it like the following:
Y1, Y2, etc
Mike Dennes 55 104, etc
Where Y1 is 1969 but displays as Y1, Y2 is 197...
Dear Experts,
I am faced with a rather confusing issue as I am relatively new to MySQL and still getting familiar with SQL commands etc.
Two tables in the database
Table1 (Inflows)
T...
I've built an admin system (using Developer Toolbox) which includes a multiple file upload - On my mysql 5 test server it works fine, but on the clients hosting (mysql 4) I get the following e...
Hi,
I just have a new installation of mySql on my PC.
And I'd never thought that changing a password can be so difficult.
I found some hints with googe:
mysqladmin -u root -p password ne...
I am developing a site. It has a MYSQL backend and is developed using PHP. The site contains a forum. Is it better to keep the forum in a separate database then the rest of the site or is ther...
I recently did a mysqldump from one server and restored it to another server. This was before I learned about encoding and the problems that can occur between utf-8 and latin.
One of the m...
I dont use SQL very much. I am trying to get all the columns for all my tables in a specific schema. I can get my query to print for all my tables, in all my schemas, i just dont know how to...
I made a website where all content are stored in a mysql table "pages".
I'd like to make a search function that are somewhat "intelligent", so that when a user searches for a word or phrase...
