of features and fixes: http://www.upscene.com/news/20060327.htm
Database Workbench supports:
- Borland InterBase ( 4.x - 7.x )
- Firebird ( 1.x, 2.0 )
- MS SQL Server/MSDE ( v6.5, 7, 2000, 2005, MSDE 1 2, SQL Express )
- MySQL 4, 4.1, 5.0
- Oracle Database ( 8i, 9i, 10g )
- NexusDB ( 2.05 )
If you
Michael Stassen wrote:
So, take a look at yarn_date.txt and let us know.
Yes, you're right . . . there was an extra tab stop. When I deleted the
extra tab, the date field were retained successfully. Thanks!
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at
Thank you.
The INET_ATON() function works fine. :D
I hope this solution save me.
Thanks.
Take a look at the MySQL function INET_ATON and it's counterpart (I don't
remember what it's counterpart is but it should be easy to find once you
find INET_ATON).
I know in PHP there is a function that
Hi,
I have a table that looks somthing like this:
ID timestampcampusIDS ePOinbound
outbound statinfo
2289411143430287MA0 0424526713
284590944 0 NULL
2289401143430002ST 2 0
Hello,
again, I'm having problems with InnoDB tables. A certain table cannot be
dropped. If I'm issueing the drop table statement, the connection is
lost and I get the following in the logfile:
060327 14:38:11 InnoDB: error: space object of table db15670/mw_pagelinks,
InnoDB: space id 12
Thanks for the help,
but this isn't my problem. When you start the server as shown below, the
SYSTEM Timezone is used for the MySQL server. This could be seen when
executing the query select @@global.time_zone on the server. Than you
must get a SYSTEM in your data. The problem is that I
The starting of the Server with the timezone settings works fine after
setting the TZ variable. I always looked at the output from select
@@global.time_zone. This was SYSTEM and so I beliefed the timezone
wasn't set right on the server.
Thanks and Regards
Michael
Thanks for the help,
but
Hi i am emiling you hoping you can help me urgently,
I have a football tipping script which works fine now except i want to update a
field from one table to another.
At the moment there is a table (leaderboard) which is updated weekly via the
updateleaderboard.php
It shows USERNAME ,SCORE ,and
Hello Everyone!
Probably somone can help me out.
I have 2 databases and it looks like:
db1 Project 1
db2 Subproject 1
db2 Subproject 2
db1 Project 2
db2 Subproject 1
db1 Project 3
db2 Subproject 1
db2 Subproject 2
db2 Subproject 3
What kind of a query would give me the first
About the first problem I think you need to give us more data !
As for the seccond... I haven't sen such loops yet...
But you can go arround them and do something like:
SELECT * FROM db WHERE (id BETWEEN 5 AND 50) AND id%5=0
--
Gabriel PREDA
Senior Web Developer
Barry,
Hello Everyone!
Probably somone can help me out.
I have 2 databases and it looks like:
(Wayne Ratliff is dead but his mistake lives on :-) ). You mean tables,
right?
db1 Project 1
db2 Subproject 1
db2 Subproject 2
db1 Project 2
db2 Subproject 1
db1 Project 3
db2 Subproject 1
Mark,
here is my script that doesnt work (also there is no
session involved, makes it harder)
What doesn't work?
What stops you from using $_SESSION[]?
PB
Mark wrote:
Hi i am emiling you hoping you can help me urgently,
I have a football tipping script which works fine now except i
What happens if you try to connect to the database on the commandline?
-Sheeri
On 3/24/06, Luke Vanderfluit [EMAIL PROTECTED] wrote:
Hi.
I'm getting the following error running apache2 with modperl, mysql
4.1.18 and RT 3.4.5
*error:*DBD::mysql::st execute failed: MySQL server has
What does it look like on the commandline? If it looks OK on the
commandline, then it's an application/web server problem.
-Sheeri
On 3/24/06, Grzegorz Smith [EMAIL PROTECTED] wrote:
Hi all. In my apps I use two languages: english and my national polish.
Translates i keep in MySQL 5.0 in text
can someone post a snippit on Summing tables together of a feild of the
entire Database ? why does everyone Have such a problem with this
question? everyone i ask says the same thing,, let me show what i'm
needing by Visual representation
MySQL databaseworkorders
Your question seems to have been answered already, so let me add one
cautionary note -- use a LIMIT clause when testing out a new query!
Especially with a join. A simple mistake can lead to a Cartesian
product of 2 tables -- I always do limit 100 or something so that I
can then check to see that
Brian,
can someone post
a snippit
on Summing tables together of a feild of the
entire Database ?
Do you mean summing
all row
values of a column in a table, grouped by the value of another column?
If so, for example to
retrieve all electprojcost, electprojbilling values and their
differences
-- Forwarded message --
From: sheeri kritzer [EMAIL PROTECTED]
Date: Mar 27, 2006 1:18 PM
Subject: Re: Insuring select returns the last record for a given day.
To: Paul Halliday [EMAIL PROTECTED]
I have a similar table, so I tried out your query on the table I have:
select
Michael, group;
Thanks much for the directionsI followed them and solved my problem!!!
Now I've got this issue and I'm not sure what syntax to use to get this
script to run:
[EMAIL PROTECTED]:~/ZoneMinder-1.22.0/db vi zm_create.sql.in
[EMAIL PROTECTED]:~/ZoneMinder-1.22.0/db mysql mysql
I had to shut down my MySQL server (5.0.18) because of an error while
editing a table (Table is full). I restarted it fine, but in order to do
so I had to delete all my ibdata and ib_logfile files. Now, I am getting
ERROR 1146: Table 'dbname.tablename' doesn't exist. Obviously it does
exist,
Are the permissions corectly to that file???
Chown mysql:mysql /mysql/data/dbname/tablename.*
-Mensaje original-
De: Sara Woglom [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 27 de Marzo de 2006 01:47 p.m.
Para: mysql@lists.mysql.com
Asunto: Table doesn't exist?
I had to shut down
On 3/27/06, Lucas Vendramin [EMAIL PROTECTED] wrote:
Thank you.
The INET_ATON() function works fine. :D
I hope this solution save me.
Thanks.
Take a look at the MySQL function INET_ATON and it's counterpart (I
don't
remember what it's counterpart is but it should be easy to find once
Hello,
I'm alittle unclear on how too update multiple tables. We have two tables with
the same column name:
account.state
account_service.state
when we update the account table, we also need to update the account_service
table with the same value for the 'state' column. Can this be done with
Hi,
I'm trying to start mysql with mysql IM, by following the steps as bellow:
1. change the use_mysqld_safe = 0 in the mysql.server
2.set /etc/my.cnf as:
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follows entries for some specific
I can't run the chown command. I'm on a Windows 2003 Server machine.
-Original Message-
From: Ing. Edwin Cruz [mailto:[EMAIL PROTECTED]
Sent: Monday, March 27, 2006 3:01 PM
To: 'Sara Woglom'
Subject: RE: Table doesn't exist?
Are the permissions corectly to that file???
Chown
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Monday, March 27, 2006 3:39 PM
Subject: Update multiple tables
Hello,
I'm alittle unclear on how too update multiple tables. We have two tables
with the same column name:
On 3/27/06, Martijn Tonies [EMAIL PROTECTED] wrote:
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular database development tool:
Database Workbench 2.8.5 has been released today!
I'd like to hear more about the stored procedure debugger -- does
Hi folks,
I have MySQL 5.0.18 running like a charm on Win2K as a service. I've
been connecting to it willy-nilly, creating databases and querying the
daylights out of it. Working just dandy.
I'm trying to run the MySQL monitor in a DOS box and having no luck. I
open a DOS box, and no matter
Hi Sheeri.
sheeri kritzer wrote:
What happens if you try to connect to the database on the commandline?
Yup. Basically if I do a particular query from the command line,
I get the following error:
===
InnoDB: Error: tried to read 16384 bytes at offset 1
I'm trying to run the MySQL monitor in a DOS box and having no luck. I
open a DOS box, and no matter what command I run, I do not get the nifty
mysql prompt that I can get on my Linux machine. Here are some
permutations and the results (or lack thereof):
c:\mysql\bin mysql -u root -p
mysql:
Grzegorz Smith wrote:
Hi all. In my apps I use two languages: english and my national polish.
Translates i keep in MySQL 5.0 in text field (MyISAM engine) with utf8
encodings. I don't know why but i can get polish translates from databes
properly, my national character are seen from webb like
I've looked around the web and found very diffreing ideas about how
this should be handled.
Basically, I want to have a content row that has two times, the time
that an insert was done and the time that it was last updated if any.
I keep getting an error when I try to create a table with
Mark [EMAIL PROTECTED] wrote on 03/27/2006 09:45:57 AM:
Hi i am emiling you hoping you can help me urgently,
I have a football tipping script which works fine now except i want
to update a field from one table to another.
At the moment there is a table (leaderboard) which is updated weekly
Mike Blezien [EMAIL PROTECTED] wrote on 03/27/2006 03:39:15 PM:
Hello,
I'm alittle unclear on how too update multiple tables. We have two
tables with
the same column name:
account.state
account_service.state
when we update the account table, we also need to update the
Luke,
Yup. Basically if I do a particular query from the command line,
I get the following error:
===
InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904.
InnoDB: Was only able to read -1.
060327 8:25:41 InnoDB: Operating system error number 5 in a
hi,
I met the MySQL restart error today.
First, I stopped the running mysql server using
/usr/local/mysql/bin/mysqladmin -uroot shutdown.
After the server shutdowned, I restarted it using
/usr/local/mysql/bin/mysqld_safe .
Then, I got this error: [ERROR] Can't start server: Bind on TCP/IP
I am using the .net connector for mono in my application to connect to MySql
servers. Application is open-source and can be found here:
http://fileuniverse.com/?p=showitemID=2746
The program searches some text files for info to store in a database.
- In both my Linux boxes, with MySql 4.1,
hi, Lakshmi
The mysql process had ended. I get it from both mysql err log and ps
output.
regards,
Leo Huang
2006/3/28, Lakshmi M P [EMAIL PROTECTED]:
Run ps -ef | grep mysql and see any mysql process is running and if so
kill the same and try to start mysql.It may help.
leo huang
Hello Nick,
Upscene Productions is proud to announce the next
version of the popular database development tool:
Database Workbench 2.8.5 has been released today!
I'd like to hear more about the stored procedure debugger -- does all the
functionality in the documentation work with MySQL?
Gordon,
what does mysqld write to the .err log?
InnoDB should be included in all 5.1 binaries.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
Marten,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously corrupt, since the log sequence number in the
log files is only 14 MB, while it is = 153 MB in a data
You can make the first timestamp without autoupdating and a default value
with no importance... and the second with
DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
When you insert a new row.. .you'll use:
Asuming the table has columns: col1, ., colN, col_timestamp1,
col_timestamp2
42 matches
Mail list logo