| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello
I have my own server running with MySQL, PHP..... and asterisk(VOIP)
Sometime I have that so much visitors(search engines) that MySQL...
sjaak538
|
09-13-2004 02:22 AM
sjaak538  | 0 | 88 |
| | | Hi !
I've got a problem trying to figure out a query.
I have a table with following fields:
tool varchar(30)
last_date datetime
user_id...
Olivier
|
09-12-2004 05:57 PM
Bill Karwin | 2 | 85 |
| | | CREATE TABLE `domain` (
`domain` binary(3) NOT NULL default '',
`language` enum('english','greek','german') NOT NULL default 'english',
PRIMARY KEY... |
09-12-2004 02:40 PM | 0 | 107 |
| | | Hi !
I installed mysql on windows xp. The first time I started mysld, there
is no problem. But, now, each time I start mysqld, I must change...
Barth?l?my von Haller
|
09-10-2004 11:30 AM
Aggro | 3 | 82 |
| | | Hello!
I have developed an internet application in PHP/mySQL which is now
getting internationalised and will start to contain information...
Rasmus Rimestad
|
09-10-2004 09:34 AM
Rasmus Rimestad | 0 | 71 |
| | | Hi there,
We have just loaded 5.01 so that we can take advantage of views. One
question I have before I start experimenting is this: Can you...
ChronoFish
|
09-10-2004 06:39 AM
ChronoFish | 1 | 110 |
 | | Not sure how indexes work with ORDER BY and GROUP BY.
What index should I create which will be used on
SELECT '' As ID, `Source Presidency` As...
John
|
09-10-2004 03:01 AM
John | 0 | 192 |
| | | Is this possible!
I have a table of vehicles, there is a field called status. When a vehicle
is sold its status = sold and a field called date_sold...
YoBro
|
09-09-2004 11:59 PM
YoBro | 2 | 207 |
| | | I have the following case and need some help ... I need to select two
groups of data based on the time stamp.
Table 1
Card | Date | Time ...
Sean Cook
|
09-09-2004 09:50 PM
Sean Cook | 0 | 91 |
| | | I have a multi-statement sql script that creates two temporary tables
and then runs a query on them. The query runs fine. However, I want
to use...
goonsquad
|
09-09-2004 04:47 PM
goonsquad | 1 | 72 |
| | | Hello,
MySQL Version = 3.23.46
I am working with a table which has a date field but type is varchar.
This cannot be changed. I don't have control...
Bijoy Naick
|
09-09-2004 12:33 PM
Bijoy Naick | 0 | 106 |
| | | Hello,
I know mysql update queries can only utilize one index, making them
slow in some cases.
My update are taking about 3 hours, joining 2 tables...
Paul
|
09-09-2004 10:04 AM
Aggro | 1 | 77 |
| | | I have a very large table with book titles. How can I use Mysql to do a
fulltext search that returns rows that only contains the words that the
user...
Leif Wessman
|
09-09-2004 05:52 AM
Leif Wessman | 0 | 81 |
| | | Hi,
I would have thought that if I tried to search for "seat" using fulltext it
would return results with the word "seats" in as well. Seems like it...
Mark Jerzykowski
|
09-09-2004 02:36 AM
steve | 1 | 130 |
| | | Hi
Being new to mysql I have some queries about formatting a date column
1. Can I use dd-mm-yy, my website is Australian
2. Can I leave the date...
Patricia May
|
09-08-2004 06:35 PM
Patricia May | 2 | 78 |
| | | Hi guys -
I have a table that is approaching 4 gigs. I have optimized as much as
I can with indexes so that select statements are ok, but...
Shane Niebergall
|
09-08-2004 02:44 PM
Shane Niebergall | 0 | 76 |
| | | TABLE2 --------------
id : link : title
1) 1 : alpha : title1
2) 2 : alpha : title2
3) 3 : alpha : title3
4) 4 : alpha :...
Jason Engel
|
09-08-2004 02:16 PM
Bill Karwin | 1 | 76 |
| | | How can the mysql service be run without using the local system account?
I want to run it and give it access only the directories of its own account.
My Deja
|
09-08-2004 08:50 AM
My Deja | 0 | 66 |
| | | mysql> describe keywords;
+-------------+------------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
How do I alter...
leegold2
|
09-08-2004 03:22 AM
Bart Van der Donck | 2 | 106 |
| | | Here is a debate we have been having at work about the design of our
timeclock database application. We have built an online timeclock
system for...
Anthony
|
09-07-2004 08:55 PM
Rick Lones | 1 | 66 |
| | | hello i am a novice at database design and i'm having trouble doing a
multi join in mysql, i was able to do a inner join with
just the venues and...
Pete
|
09-07-2004 04:47 PM
Pete | 0 | 76 |
| | | How do I store graphics in mysql tables.
Cheers
Sales
|
09-07-2004 09:02 AM
Aggro | 3 | 119 |
| | | Dear mySQL community,
I have once again turned to the user groups for a problem I cannot
solve myself! Atually, I have read all I can from the...
ghasem
|
09-07-2004 05:20 AM
ghasem | 2 | 72 |
| | | Hi, I'm having a problem with one query. My database has the following
fields: id(int), time(int), and groupfield(enum - 5 possibilities). I
want to...
toocool
|
09-06-2004 06:16 AM
toocool | 2 | 100 |
| | | I have a new DB provided by my ISP don't know details of installation,
setup etc.
I can log in as anybody except root.
mysql -h localhost -u...
Adam Smith
|
09-05-2004 09:50 PM
Adam Smith | 1 | 80 |
| | | Randy Jackson wrote:
Rows which sort equal on the first field are then ordered within the
duplicates by the second sort field, i.e. the sorts are...
Rick Lones
|
09-05-2004 06:50 PM
Rick Lones | 0 | 88 |
| | | Doing the post-install on mysql :
/usr/local/bin/mysql_install_db ===>
Neither host 'econ' and 'localhost' could not be looked up...
Adam Smith
|
09-05-2004 06:26 PM
Adam Smith | 0 | 81 |
| | | I need to place the date a MySQL table was last updated into a PHP variable.
SHOW TABLE STATUS provides lots of information, including update_time,...
Ken Elder
|
09-05-2004 05:51 PM
Ken Elder | 1 | 79 |
| | | Can anyone help, I'm trying to change some code on an asp page, this
line:
mySQL="drop table snorkTable"
does not seem to close the table. Net...
Snorkerz
|
09-05-2004 01:27 PM
Aggro | 3 | 73 |
| | | Here's on for you, any help would be greatly appreaciated as it is
sending me mad...
I have three tables tbl_photo, tbl_photo_gallery and...
TomyB
|
09-05-2004 12:59 AM
Daniu | 2 | 90 |
| | | Hello there,
Does mysql work on windows or it has to be on linux only?
Just a quick Question.
Thanks you very much
Firewalker
|
09-04-2004 12:23 PM
Aggro | 1 | 79 |
| | | I have no idea what the performance will be if there are frequent
select/replace operations on this table(more than 200 columns which are
almost...
REMOVETHIS
|
09-04-2004 10:45 AM
Bart Van der Donck | 1 | 95 |
| | | What can I do to make this series run as like an executable? (I type
in the file name and it runs these 9 mysqlimport commands)
mysqlimport -df...
Dobsons
|
09-03-2004 07:58 PM
Dobsons | 0 | 65 |
| | | i need some basic help to get me started with mysql
my server is running ( mysqld as root gets it running)
in the terminal window i have typed in...
ilaboo
|
09-03-2004 02:22 PM
Shane Niebergall | 2 | 75 |
| | | This is a really, really elementary (almost dumb) question. I have a php
script I picked up elsewhere that I want to use to query my MySQL DB. ...
Charles Alexander
|
09-03-2004 02:20 PM
Shane Niebergall | 2 | 69 |
| | | After running mysqlsd --help, I got the following message:
To see what values a running MySQL server is using, type
'mysqladmin variables' instead...
espresso
|
09-03-2004 12:39 PM
espresso | 0 | 70 |
| | | Lets say I wanted to select all employees and list their occupations.
I have this query:
SELECT * FROM employees, job WHERE employees.id=job.id
Now...
YoBro
|
09-03-2004 07:27 AM
sks | 1 | 99 |
| | | I have two tables, one containing payments to a supplier and one containing
invoices issued by a supplier. I'd like to get a total from each table...
sks
|
09-03-2004 07:08 AM
sks | 0 | 83 |
| | | hi!
i have a problem with a update-query:
start-structur (column 1 index, 2 datetime, 3 time of measurement, 4-6 values):
1 | 0000-00-00 00:00:00...
gondor
|
09-03-2004 06:09 AM
gondor | 0 | 68 |
| | | Im moving a development app (MySQL 5.0) to a different server which
runs MySQL 4.0.20-standard. I am getting errors on queries that have
subqueries...
Nick
|
09-03-2004 03:33 AM
Chris Hope | 5 | 71 |
| | | Hello,
DB-structure:
=========
firmendaten
-----------------
firmendatenid <-
firmennummer
name
strasse
R. Tarazi
|
09-02-2004 11:09 PM
Peter | 2 | 70 |
| | | Hello,
I have been trying to figure this out but no luck.
Lets say I have a query that searches for people living in Colorado.
That results in a...
Frank Maestas
|
09-02-2004 10:59 PM
Peter | 1 | 77 |
| | | Hi all,
I'm pretty new to MySQL, but have some Access background. I've created
a table for which I intended the email column to be the primary...
blanch
|
09-02-2004 08:14 PM
Bill Karwin | 1 | 75 |
| | | Hi, I am currently designing a simple service orders database. I have played
around with MySQL a bit but this is the first time I'm using it in...
Chris
|
09-02-2004 05:09 PM
Chris | 0 | 79 |
| | | Hi.
I have a simple query that is similar to this one:
SELECT distinct b.username from permissions a, users b, links c where
a.user_id = b.id and...
Ferreira
|
09-02-2004 02:28 PM
Bill Karwin | 1 | 76 |
| | | Hello,
We are planning to reprogramm our search machine and website. Since we
have call agents who query the same database as the customers do,...
R. Tarazi
|
09-02-2004 03:03 AM
R. Tarazi | 0 | 84 |
| | | (MONEY TRANSACTION)
Hello,
My name is Dr.Bala Mohammed, and I work in the
international operation department in a Local Bank here in
South...
BALA MOHAMMED
|
09-02-2004 12:06 AM
BALA MOHAMMED | 0 | 110 |
| | | I've seen this question asked a couple times in this forum
but never answered, so I guess my hopes aren't too high,
but:
I'm running
on Linux with...
Aarono Brown
|
09-01-2004 06:47 PM
Aarono Brown | 1 | 97 |
| | | http://bugs.mysql.com/bug.php?id=868
Red Hat suggests the LD_ASSUME_KERNEL and the
"nosysinfo" parameter on boot as two ways to disable the
NPTL...
Scott Moseman
|
09-01-2004 02:29 PM
Scott Moseman | 0 | 84 |
| | | mySQL (4.0.20a win32), dual amd2200 machine, 4 gigs of DDR ECC memory.
I have a series of 33 tables, identical in structure : (field...
Craig Stadler
|
09-01-2004 12:02 PM
steve | 1 | 73 |
