I am trying to install eGroupWare on a Windows 2000 Pro machine running Apache 2.0.52/PHP 4.3/MySQL 4.1 with only limited success.
PHP is running fine on Apache but when I try to follow the...
Hello, I know you can use this statement:
DELETE FROM Table1 WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2)
The only problem is, I need just the opposite of this!
I need to kno...
Hello folks! Hope somebody can help.
I have a table that looks kind of like this:
Table RECEIPTS:
ID Purchased
1 hot dog
2 banana
3 milk shake
4 hot dog...
Example:In the same MySQL 3.x, User1 have full control of DataBase-1, how to grant a full control permission when I create a new DataBase-2.
I have read a lot of the suggestions online but am still having trouble. Hope someone can help. Error when loading PHPmyadmin:
"cannot load mysql extension, please check PHP Configuration D...
Greetings All;
I am having a problem with a server crashing. One client notified me of a warning that the application could not access the database it needed. So I looked in the mysql log...
What I'm looking for is a good explanation of this odd behavior. Heck, all I need is a plausable explanation that I can tell my boss.
I am using a databse table as a queue. I had everythi...
Hello,
I am trying to figure out how to wildcard a variable. For instance if I have the query,
SELECT * FROM foo_Table as f, goo_Table as g where g.Id LIKE %f.Id%;
Obviously this does...
HI Everybody,
I dont know about TimesTen.
Our application is there in TimesTen, now i need to Migrate it to MySQL.
can any one tell me the steps to migrate from TimesTen to MySQL.
i wou...
The situation is this... I have some mySQL function I use all the time but I have run into an interesting snag.
The desire is to insert a row into the USERS table and return the auto_incre...
I am creating a simple webpage that requires me to make users for everyone who needs to login. And they have there own small database that they have god rights to, but nothign else.
Everyth...
Hi,
I'm trying to update one table where a field in another table is a certain value, but I'm not sure if it's possible in v3.23 and if so, what the syntax would look like.
With an examp...
When the tableformat datetime are loaded into a form (..input type="text"..), it loads as "1/1/2007".
I checked within the mysql table, the dates are stored with the format "2007-01-01", whi...
suppose i have 20 columns in mt database
and i want to select column 2 to 10
is there a way to select only those columns using SELECT or ?
Mysql replication with one master and several slaves but replication has suddently stopped working on a few slaves.
Version 4.0.22-standard
The table status on the slaves not working is show...
I have a MySQL table with four columns: id, value1, value2, and name. I need to select all duplicate rows with the same name in the name field. Once selected I need to average the value1 and v...
Hello,
How do I write a SELECT statement to show the time difference between two columns.
I want to show the difference in Double type, not in Time.
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...
Hi
I do a little bit with databases but I'm a beginner really and I need help with a query please.
My database stores information for a gps tracking system. A Journey can have multiple GPS...
MySQL uses backslash as the default escape character.
I have a tab delimited text file. Some of the fields contain a backslash as the last character of the field.
mysqlimport escapes th...
Hi experts,
I am trying to install this from the source but can't seem to get it working properly. I probably missed some steps from the install manual:
cd /usr/local/mysql-3.23.49
gro...
I want to use mySQL for the data source for a vb .net
project I am doing. I set up mySQL & myODBC on D:\
where I have WinNT 2000 (dual booted with 98 on C:).
Using the mySQL tools I can cr...
HI,
I tried to load data from a text file into mysql database , I realized that not all the data get loaded. IS there a maximun number of row for a table with mysql?
My file is really big...
How do u go about defining relationships btwn/among tables in a mysql database.
I know in Ms Access you link tables in a relationship panel.
Hi, I have the popular phpbb 2.02 message board software installed on my site and the table which holds the text for the private messaging system is giving me some serious problems, here's the...
