I have a column that has comma separated data:
1,2,3
3,2,1
4,5,6
5,5,5
I'm trying to run a search that would query each value of the CSV string individually.
0<first<5 and 1<second<...
Im attempting to install Moodle LMS and when I get to a certain page the error message displayed is "PHP has not been properly configured with the MySQL extension so that it can communicate wi...
Hello,
I have created a Streets table: with int idStreet ; int idRegion ; String street name as columns.
I have a jsp page with 2 comboboxes that I would like filled with all the streets...
Can you create a user and grant privileges using CREATE USER and GRANT in a stored procedure using variables from a web page? I have code in my stored procedure to insert into the USER and DB ...
I am using a shared hosting service. My application is ASP.NET and I am using MySQL DB V5.0.23-c-nt
I get the error "SELECT command denied to user 'user'@'ip' for table "municipio" when I t...
I have the following oracle SQL statement. I need it translated into MySQL sql.
Code attached below. Specifically, I don't know the NVL function, Decode and (+) sign in the where clause.
T...
What's the easiest way to change column order in a mysql table?
Thanks
The script -www.nihaorr1.com/1.js is getting inserted into every record of my organizations SQL db. I'm the accidental techie in my office, and I'm clueless as to the vulnerability in our cod...
Hello,
I have a MySQL table with a column containing text (multiple words). I'm trying to SELECT rows from the table based on the number of words in the text column.
The cases are: exactly...
Im trying to merge data from 4 different tables (2 really). I want to try to do this using MySQL so that I get a list of unique costcodes, with the various values in the next two columns. Here...
I wanna do:
$today = date("Y-m-d H:i:s");
$result = mysql_query("SELECT sent_date FROM invitations WHERE email='$email' AND uid='$session_uid' AND '$today' - `sent_date` < 24 hours from ...
Hi,
I have two possibly related problems ,
1. I am having problems when displaying data with PHP from my mysql database, which includes apostraphes and or double quotes.
Interting a sent...
Hi,
I have a piece of software which takes SMS's from a mobile phone and puts that message straight in to a MySQL database table. The software creates the timestamp of the SMS in UNIX forma...
I've combined many different table views of MySQL database information resulting in a Public 'search' all locations application for site visitors and a Private 'manage my location data' for th...
I have 2 Windows 2003 servers each running PHP5 & MySQL5.
Server 1 [Platinum] handles a large amount of transactions on a daily basis so in order to help increase reporting speeds I have se...
Hi All,
We had a phpBB running on FreeBSD using MySQL (I don't know the version) and we had the hard drive crash and had to send the drive out to be repaired sector by sector. The director...
hi there;
I have a problem with phpmyadmin bundled in XAMPP 1.6.7...
Before i install XAMPP, i have installed mysql 5.0.67 and he works perfectly...(he still woking perfectly)
When i ...
Due to a HD crash on a long-term hardware issue (RAM) on an old machine, some active MySQL tables crashed regularly. I've transfered these tables to another MySQL 5 install and have been chec...
I am looking for a query to run (not a script )to convert a particular field called
title to Proper Case in MYSQL. I would like to run the query directly from the command line in MYSQL.
...
I am in the process of converting my site from using MS Access to MySQL. (pats self on back :)
However I'm running into some issues with some of my queries that I'm hoping to convert to wor...
How to write a query in mysql which is equivalent to Oracle query
Select X from Table1 where ColumnA = ?
Intersect
Select X from Table1 where ColumnA = ? AND ColumnB = ?
Intersect
Selec...
Hi Experts,
I have written an application in c#.net using mysql as backend(remote db) am using mysql.data.dll for conencting my remote server, am facing problem at the time of deploymen...
How do I iterate through every record of one table to create record in another table?
I want to run an insert statement for every user in the users table. The new data will be inserted in...
I'm trying to import a mySQL dump file into my mySQL db on a windows server.
I usually go to the mySQL command line and enter \. c:\dump.sql
This pulls the data in fine.
But I want to...
Dear Masters,
I'm new to MySQL and are trying to get through with it. Need help from u masters...
Following is my network configuration...
I've installed MySQL 5.0 on machine A (192.1...
