atements such as creates/inserts/updates/deletes/selects will
work using the test DB
(you must do the same for Testdb Database)
HTH
M-
- Original Message -----
From: "Kerry Frater" <[EMAIL PROTECTED]>
To: "'Sebastian Mendel'" <[EMAIL PROTECTED]>; &quo
ata and putting into other table
Kerry,
Post the error you get.
First select the database you are going to use in the right panel.
execute the create table statement.
update the table.
execute the select statement as last.
Saravanan
--- On Sat, 1/19/08, Kerry Frater <[EMAIL PROTECTED]&
7;; [EMAIL PROTECTED]
Subject: RE: creating temp file, modifying data and putting into other table
Hi,
Are you using mysql browser? If yes. It will run only the current line
statement. It will not execute all the three statements. So try one after
the other.
Saravanan
--- On Fri, 1/18/08, Kerry Frat
nd I
should be testing in another way?
Kerry
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: 18 January 2008 13:24
To: [EMAIL PROTECTED]; 'MySql'
Subject: Re: creating temp file, modifying data and putting into other table
Kerry Frater schrieb:
> Can
rom: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 17 January 2008 19:34
To: MySql
Subject: Re: creating temp file, modifying data and putting into other table
On Jan 17, 2008 2:22 PM, Kerry Frater wrote:
> Can someone please advise. I am looking to create a "multiuser" friendly
way
Can someone please advise. I am looking to create a "multiuser" friendly way
of getting a subset number of rows from a table into another whilst making a
modification.
I thought that this could be done using a temporary table in a batch script
that is unique to that session e.g.
create temporary
I have a query to extract some data. Two columns include a setup date
(setupdt) and a completed data (compdt).
I would like the data grouped to get sub-totals but shown in different
orders/ I would like the compdt with the newest first i.e. desc order and
setup date with the oldest first i.e. asc
all rows of the left of the conditional even if
there is no right column to match." but t1.lookup='Z' constrains this to
only the one row of table one with lookup equal to 'ZZZZZ'.
Enjoy
Peter
On 2/17/07, Kerry Frater <[EMAIL PROTECTED]> wrote:
I am
I am trying to select a particular row from a table and include a column for
aq second table but I cannot get the result I am after.
I have "table1" with 1000 rows and "table2" with 12 rows. The relationship
between the tables is a column "linkedfield". Table1 has a unique key called
"lookup"
If
calculations, you need to use the DECIMAL data type. See this
section in the manual for the reasons why:
http://dev.mysql.com/doc/refman/5.1/en/precision-math-examples.html
Cheers,
Jay
Kerry Frater wrote:
> I am running a small procedure for set jobs that calculates a running
total
> for me to d
I am running a small procedure for set jobs that calculates a running total
for me to display. It works fine in most cases but the math concerns me.
I am using 5.0.18 on my Windows PC and the latest 5.x on my Linux server
(both test machines).
The finance table is an InnoDb table.
CreditAmount and
Donna,
Just to say thanks.
Played a bit more with the code and options and got most of what I wanted. A
little procedure gives me the rest.
Many thanks for pointing me in the right direction.
Kerry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 28 November 2
P modifier:
select district, town, street, surname, count(surname)
from test5
group by district asc, town asc, street asc, surname asc WITH ROLLUP
Here's a link to the MySQL documentation on WITH ROLLUP
http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
Donna
"K
Hope I have the right group.
I am working out how to get groups within groups. e.g.
I have a table with 4 columns C1,C2,C3 & C4
I am looking to select data so that I can get
C1 group item
C2 Group item
C3 Group Item
C4 detail
End of C3 Group Item
count/totals of
Thanks Phil
It gives me a solution and some reading.
Kerry
-Original Message-
From: Philip Mather [mailto:[EMAIL PROTECTED]
Sent: 11 October 2006 10:02
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: How to build a single temporary table from 3 tables on the
fly
Can someone help point me in the right direction for this. This isnt
exactly what I want but once I have the solution to this I can work out the
permutations I need.
How do I select from 3 tables into a single table (consequtive rows not
joined ones) and include a two new columns which is the nam
mysql_real_escape_string to your BLOB variable first?
See:
http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html
I do not see the quotes around mystring$ as well.
Kerry Frater wrote:
> I am importing data from a non MySQL table into MySQL.
>
> In the table there is a text field of up
I am importing data from a non MySQL table into MySQL.
In the table there is a text field of up to length 4000 chars. I have
defined the column as "blob" in the MySQL table.
I can read the text field of the source table into a variable e.g.
mystring$. The MySQL table has been set, except for this
I am trying to test some code on the new 5.0 version and am getting
problems.
I currently have two MYSQL's running on two differing machines. Both have
the same schema set up by the my own program. The difference is that Machine
1 was set up on version 4.1 and then upgraded to 5. Machine 2 was a f
I have seen the problem with the INSERT syntax. The new version doesn't like
the use of "'s to surround text and prefers single quotes.
I still don't see where the dbname.1 error is from
Kerry
-Original Message-
From: Kerry Frater [mailto:[EMAIL PROTECTED]
Sent: 02
Can someone point me in the right direction.
I had 4.1 running and all was well with my little program. I decided to test
the code with the newer 5.0.18. I updated my DB and then tried to access it
using the MYSQl Control Centre - 0.9.4-Beta and query browser 1.0.4 alpha.
The Administrator allows
bug. MySQL Administrator should not assign character
set to integer columns. See:
http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html
Kerry Frater wrote:
> Can someone help me.
>
> I was running v4 and just upgraded the version to v5.0.
>
> Most of my tables are MyISAM with some
Sorry I should have said. I get error 1064 whenever I am working with an
integer or real column. char's are fine.
Kerry
Can someone help me.
I was running v4.1 and just upgraded the version to v5.0.
Most of my tables are MyISAM with some InnoDb. Most of the My
Can someone help me.
I was running v4 and just upgraded the version to v5.0.
Most of my tables are MyISAM with some InnoDb. Most of the MyISAM tables are
char fields but a few have integer columns. When trying to create a new
table using the Administrator 1.1 program it is fine creating columns w
nference:
http://www.mysql.com/news-and-events/press-release/release_2005_10.html
I hope this helps.
Scott Pippin
[EMAIL PROTECTED]
>>> "Kerry Frater" <[EMAIL PROTECTED]> 04/28/05 6:09 AM >>>
I have MySQL & the downloaded ODBC drivers.
I am looking to use
I have MySQL & the downloaded ODBC drivers.
I am looking to use Crystal Reports to design & run my own reports on my
tables.
Can anyone tell me if the V11 Standard will happily work with MySQL or do I
need a different version?
Kerry
Perhaps someone can provide me with some of his or her experiences if
looking at MySQL to implement a secure from structure manipulation in a
commercial application using MySQL.
I am currently evaluating the possible migration of my app to MySQL as the
basis. I already have tested the creatio
Can someone tell me if this is possible using the UPDATE command
I have a table MASTER and a table called MASTERNOTES. Masternotes contains
the blobs of data linked to MASTER that is stored separately for efficiency.
Not all rows in MASTER has a note and therefore MASTERNOTES is a subset of
MASTER
Hi,
I don'e know if this will help as I am probably only one step ahead of you
here, but if it does great. If not you can just delete it.
How are you going to access the data? Via a program, PHP, using queries?
I am a newbie to this area myself, and use Delphi.
I know that using Delphi with the
Many thanks for your reply Tom.
I will read it more closely over the week-end, but wanted to say thanks
straight away.
Kerry
-Original Message-
From: Tom Horstmann [mailto:[EMAIL PROTECTED]
Sent: 20 August 2004 15:52
To: 'Kerry Frater'; '"MySQL List"'
S
Hi all,
I don't think this is the right list for the question but I am hoping
someone in the list will be able to point me in the right direction.
I am testing the use of Delphi with MySQL (using Micoolap's DAC) to access
and manipulate a number of tables in a databse. Some of the more complex
str
Thanks Mike,
your recommendations are very much noted.
Kerry
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: 15 August 2004 17:22
To: [EMAIL PROTECTED]
Subject: Re: recommended books for web app.
Kerry,
At 08:09 AM 8/12/2004, you wrote:
>I am looking to port an app from a
Peter,
If you put any in your email reply - none came through.
Kerry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 15 August 2004 05:21
To: [EMAIL PROTECTED]
Subject: Re: recommended books for web app.
--
MySQL General Mailing List
For list archives:
Thanks for your recommendation Peter
Kerry
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 14:23
To: Kerry Frater; "MySQL List"
Subject: Re: recommended books for web app.
Welling & Thomson is terrific.
- Or
I am looking to port an app from an existing web environment to MySQL. The
requirement is relatively easy. The Tables are read only and the data is to
be only accessed via login & password. The login will give a limited view of
records based on a master/detail table relationship. I need to be aware
Many thanks Paul,
I will read and digest tomorrow in normat daylight hours.
Kerry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 20:55
To: Kerry Frater; "MySQL List"
Subject: Re: Creating a New User - What am I doing wrong?
At 20:25 +0
I am using 4.0.20a Windows version downloaded as the binary file with
Installer built in.
The system was installed with the "defaults". Nothing was run and the
default mysqld was allowed to run at start up. I have tried this using
Windows XP, Windows 2000 Pro & Windows 98.
I am testing the system
Oops,
used wrong email address
-Original Message-
Sent: 08 August 2004 12:23
To: [EMAIL PROTECTED]
Subject: creating a new user with "mysql" on 4.0.20a
I am just going through some taching docs and it says that I can create a
new user with all authority on a new DB using the command
GR
I am just going through some taching docs and it says that I can create a
new user with all authority on a new DB using the command
GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword';
yet when I try and run 'mysql' using
mysql -uauser -pthepassword
I get the error
ERROR 1045: Access deni
I have installed 4.0.20a binary on my own PC to work with MySQL. I take my
PC home with me. The only thing I change at home is my IP address as my home
n/w is different from my work n/w IP range and I have a VPN link between the
office & home.
Since using this version (.17 was there before) everyt
Anyone know of some decent docs on how CR works with MySQL using ODBC 3.51.
Just installed it today to see what it's like and am finding it cumbersome.
This is most likely due to ignorance rather than the product.
I was expecting to see a list of tables available for reporting when using a
link t
41 matches
Mail list logo
