Hello:
I would like to create a view that reads from tables that are in a MYSQL database. How can I do this? Is there a special script. In access I have a MYSQL ODBC that works fine, but I ...
I've got an excel spreadsheet with cells that have multiple email addresses. I used the code below that I found elsewhere on the Internet, but I do not know VB, so I can't fix the code to hav...
how does one fetch data from mysql, to create graphs using phplot?
thanks
Below are the results I get with this command.
mysql> SELECT mmID, pRATE, Date FROM MyTable WHERE tID=2 AND dID=4 AND mmID = bID;
+--------+---------+-----------+
| mmID | pRATE | Date ...
Hi,
I got some products in mysql. I use the names of these products also in the hyperlinks, I replaces whitespaces (%20) with dashes.
Will it affect the performance if I use everywhere:
...
Hi guys,
Got a strange error that I can't seem to work out.
Using the below code SHOULD select the last row in the 'section' col of the table. Which is '39' [39 is the data in the last ...
Hi Experts,
I've got this query that retrieves information from my database about changes that have taken place for the last 2 days.
I would like to add "DISTINCT" to the query but that does...
Hello all!
I can create several independent connections to databases by using procedural approach using "new_link".
What's the object oriented equivalent of "new_link"?
e.g. the proce...
Can someone help me with a better query? This is what I have below. any help would be appreciated
Thanks
Nick
SELECT re_students_main.studentID, re_students_main.firstName, re_student...
Query help
I have three tables users , bounce, and unsubscribe.
Two variations of a similar query, using field email for matching purposes.
1. All records from users that dont match reco...
Hi Experts,
I`m trying to build a MySQL function that saves me of 2 querys:
I want it to execute 2 select query and return the values returned by the selected queryes.
Example:
begin...
I'm trying to connect the sugarCRM database (community edition 5.0) which is running MySQL server from my PC. The reason I'm trying to connect the database is so that I can run SQL queries on ...
If a table does not have a particular column, I want to add it.
I'm trying to use the syntax at http://forums.mysql.com/read.php?98,33383,33490#msg-33490 as the IF EXISTS syntax I use all t...
A client of mine recently formatted his machine and re-installed MySQL Server and my application. He complained that deleting records from master table is not affecting the child tables. I...
I am trying to run a simple query but the time it takes to run this takes way too long.
SELECT
COUNT(DISTINCT(`emailaddress`)) AS `total`
FROM
`customers`
WHERE
`email-optin`='Y' ...
I want to remove the password of root in mySQL Server 5.0.45?
How can this be achieved?
Previously we were using mySQL 4.0, which allowed blank password for root. Recently we upgraded mySQ...
as i know there is below inventory system costing methods,
First in First Out Method (FIFO) ,Month Average moving Method ,Fixed cost Method, Moving Average Method.
is there any other costi...
Hi Experts,
Im a newbie in mySQL and php scripting.
I have a web based application running apache2.2, php5 and mysql5 on windows 2003. Please advise on how to do the following:
1. Creat...
Dear Experts,
I am having to move across a website from an old server to a new server. I think I have setup the server correctly. But what is the best way for me to copy the files from th...
using sqlyog query editor
how can I check the mysql connection
can I use the same mysql on port 3306
I am building an application where I wil be storing Date/time. Because my users will be in different time zones I am wanting o know the nest way to store these values. My users will login, so ...
I am in the process of migrating data from access to mysql. I am having a problem inserting new records into the table using an access form. The primary key field does not populate automati...
Sorry for the long post..
I have a few (20 or so) domains hosted on a shared server separate from my ecommerce store front site.
These domains contain just an index.html page and a few short...
Hello ,
Im trying to excute this php function . There is error in the mysql sytax I guess I cant insert the values in to the database .
Please correct the syntax errors . Database f...
