| | |
thread by: Bill |
last post Jul 19 '05 by: Bill
I was under the impression from the manual that if you added a field to a
table of type timestamp this would automatically be updated after each
insert/update of a new record, but all I get is 00000000.
Is there something else I should set?
Thanks.
|
thread by: Extraordinaire |
last post Jul 19 '05 by: Extraordinaire
Hi
I builded a little propert database. I added a search function to the site
but have the following problem:
I used "SELECT *
FROM table1 WHERE area ='province' and type like'%type_1%' and town
like'%town_1%' and descr like '%descr_1%' and suburb like '%sub_1%'"
But it do not do the like thing. If I search for 3 bed and the actual data...
|
thread by: Greg |
last post Jul 19 '05 by: Greg
I have just started my first big project and I am having trouble predicting
the system specs that will be required. At present during trials the site
has around 15 users, although this will go to 350 when it is launched.
Most of the pages execution time should not scale with the increase in users
but there are a few report pages which...
|
thread by: Info-maroz |
last post Jul 19 '05 by: Info-maroz
<html>
<head>
<title>cleanactpro</title>
</head>
<body>
<div style="text-align: center;"><span style="font-weight: bold;"><span
style="color: rgb(255, 0, 0);">Keep Your Job</span> - <span
style="color: rgb(0, 153, 0);">Keep Your Marriage</span> - <span
style="color: rgb(51, 51, 255);">Keep Out Of Trouble</span></span><br>
<br>
|
thread by: gondor |
last post Jul 20 '05 by: gondor
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 | 0 | 21 | 22 | 23
2 | 0000-00-00 00:00:00 | 1 | 21 | 22 | 23
3 | 0000-00-00 00:00:00 | 3 | 21 | 22 | 23
4 | 0000-00-00 00:00:00 | 5 | 21 | 22 | 23
|
thread by: Michael Russell |
last post Jul 19 '05 by: Michael Russell
I'm working on a Windows client program in C++, using Qt and OleDbPro (for
database access). Everything was working great until I had to use a query
for the first time in the code that pulled data from two tables. The query
executes, but returns 0 rows. I verified that the query should return rows
by running the query both through another...
|
thread by: Jay |
last post Jul 20 '05 by: Jay
Is there a definitive list of characters that must be escaped in order to
insert them into a text field in mysql?
TIA,
Jay
|
| | |
thread by: Mike |
last post Jul 20 '05 by: Aggro
I am not a sql person and could use some help with a delete...here is
what I want:
I have the following tables/fields (only including necessary fields)
answers
result_id
results
result_id
|
thread by: Ola Ogunneye |
last post Jul 19 '05 by: Ola Ogunneye
--=_9EC08B1B.CCADE08C
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Hello gang,
This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie.... I still cannot execute certain
commands from my...
|
thread by: Dathan Vance Pattishall |
last post Jul 19 '05 by: Dathan Vance Pattishall
------=_NextPart_000_000C_01C36344.47734B10
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Replicating queries where re-written to fix various bugs, most notably
time and auto-increment bugs. Why doesn't replication also enforce
rewriting INSERT INTO into INSERT DELAYED / etc. I've notice that the
|
thread by: Jon Miller |
last post Jul 19 '05 by: Jon Miller
We've run out of disk space and would like to move either the entire MySQL =
system or if possible move the databases. Can this be done without any =
difficulties?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
|
thread by: blucados |
last post Jul 19 '05 by: blucados
Here are 3 questions about extended-status
and server parameters.
I have a server with 1G of Ram Dual Cpu running
mysql 3.23.41.
1/ to know if table_cache need to be increased,
what is the maximum rate of opened_table that
must be seen. I read somewhere that 1 or 2
|
thread by: Denis Labon |
last post Jul 20 '05 by: Denis Labon
I can't connect to mysql server using the mysql-connector-java-3.0.11.
I was able to run the same program when I was running Suse 9.0 but
since I install Suse 9.1, I can't connect.
The error message is:
java.sql.SQLException: Unable to connect to any hosts due to
exception: java.net.ConnectException: Connection refused
I'm using...
|
thread by: Hoang Do |
last post Jul 20 '05 by: NDS Ltd
I have a yahoo web-php-mysql account and they place their mysql database
behind a firewall that can only be accessed via PHP code running on their
machine. Does anyone know of a proxy package that can allow you to access
mysql from a PHP script running on another machine, for example? This
scenario is becoming very common in today's webhosts...
|
thread by: Karlheinz Cometto |
last post Jul 19 '05 by: Karlheinz Cometto
SWNoIGJpbiB2b20gMDUuMDguMjAwMyBiaXMgMjguMDguMjAwMyBhdd9lciBIYXVzLg0KDQpJY2gg
YmluIHZvbSAwNi4wOC4wMyBiaXMgZWluc2NobGll32xpY2ggMjguMDguMDMgYXVmIFVybGF1Yi4N
CkluIGRyaW5nZW5kZW4gRuRsbGVuIHdlbmRlbiBTaWUgc2ljaCBiaXR0ZSBhbiBtZWluZSBLb2xs
ZWdlbiBpbiBkZXIgTVBTLg0KRnJhdSBKdXJpYywgRFcgMjEyDQpGcmF1IFNvbW1lcixEVyA2MzEN...
|
| | |
thread by: Yair Sageev |
last post Jul 20 '05 by: steve
Greetings.
I was running PHP Nuke on a Win2k box using Apache2Triad. Fortunately I
backed up the drive using windows backup prior to the hard drive failure.
Now I have installed Apache2Triad on another machine and wish to reimport
the mySQL database that PHP Nuke relies upon. If anyone can tell me how to
do this I would be very...
|
thread by: Chris W |
last post Jul 23 '05 by: Bill Karwin
I have a DB of Users of my wish list site. The tables I have are
User ----> info about the users UserKey is the key
Gift ----> list of gifts each user has on thier wish list foreign key
is UserKey
Event --->gift giving events for users. foreign key is UserKey
Emails ----> email addresses users have sent a message to about their
wish...
|
thread by: Ola Ogunneye |
last post Jul 19 '05 by: Ola Ogunneye
--=_81DF9BED.E485C8BC
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Hello gang,
This may be a very simple question and possibly could have a very simple
solution to it. Since I have been using mysql for less than 2 months, I
still consider myself a newbie.... I still cannot execute certain
commands from my...
|
thread by: Paul L |
last post Jul 19 '05 by: Paul L
Hello, All
I installed mysql server on my suse box. I am trying to connect to it
through java jdbc application. The
program does connect to suse server when I run it on localhost. But when I
run this program from outside
it gives me "java.sql.SQLException: Invalid authorization specification,
message from server: "Access
denied for user:...
|
thread by: Philip Juels |
last post Jul 19 '05 by: Philip Juels
Hi all,
I'm developing a simple computer helpdesk system with MySQL as the
backend and Apache/CGI/Perl as the user interface. I've sucessfully
set up the part where a user enters an issue via HTML form and
"submits" it to the MySQL database. My question is: I have it set up
where the user posts the issue to the database, the database...
|
thread by: Jeff Harbin |
last post Jul 19 '05 by: Jeff Harbin
I've spent the last 2 days trying to begin using mysql. I've purchased 3
books and read huge chunks of the documentation provided with the mysql zip
file.
I've downloaded 'mysql-4.0.18-win.zip', unzipped it, run the WinMySqlAdmin
program, and everything seems fine. I'm trying to use it on WindowsXP on a
new machine.
I'm trying to learn...
|
thread by: Martin |
last post Jul 20 '05 by: Martin
When I open MySQL Control Center, it shows "server properties" window
when the server is selected on the left pane.
One of the property is "date created". I have not found this variable in server
and status variables .... Does anyone know how to read this variable using
MySQL SQL query or MySQL API (not file system, etc. ) ?
Martin
|
thread by: Aidan Gill |
last post Jul 19 '05 by: Aidan Gill
All=20
If you use .NET which DbProvider do you use as I am having a lot of =
performance issues with MYSQL and ASP.NET with the providers I have =
used.
Thanks in advance
Aidan Gill
--
|
| | |
thread by: Arno |
last post Jul 19 '05 by: Arno
Hello,
I have aproximately 1,000,000 rows and I would like to do some query. The
first one is to get the number of row so I do :
mysql> SELECT COUNT(*) FROM `Log`;
+----------+
| COUNT(*) |
+----------+
| 969129 |
|
thread by: Christian Freitag |
last post Jul 19 '05 by: Christian Freitag
Hello!
I have a litte problem with my sql-database!
I have to update all UA-fields in the table idrz_kennzahl with primary
key idrz, where the same idrz in the table per_verwaltung with the
field Amt=12 is.
I designed following statement but it doesn't work:
update idrz_kennzahl
set UA=1234
|
