i have an question about ordering a set of records...
ab c d
-
1Tax 120001.33
1Tax 115002.5
1Tax 110003.25
1Tax 10 4.5
question:
I have an insert statement that has a null for the value of the
primary key, id, since that value is also a
auto-increment field. The problem i am running into is I need that Id
further down the road for map tables, but I have no idea
what the id is, since it is in fact,
Ok, I have a client that has a specific request. the ordering of data.
For example current the order by returns this:
id | Name
--
1 | #124
2 | #125
3 | #155
4 | apples
5 | bacon
but he would rather see the data as :
id | Name
--
1 | apples
2 | bacon
3 | #124
4 | #125
5
you are probably missing privileges for accessing the database remotely...
try this page:
http://dev.mysql.com/doc/mysql/en/GRANT.html
it's like: grant all priviledges on dbname.* for [EMAIL PROTECTED]
identified by 'password';
good luck
dan
shatam bhattacharya wrote:
Hi all,
I have to
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as category_id,
'' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1 + g.Desc2 +
g.Desc3 as description, g.Desc4 as price,0 as quantity, '' as
comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type, now()
as created, now()
dan orlic wrote:
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now
My final issue is inserting a currency, $500.00 for example into a field
that is a BigDecimal(10,2).
Anyone have any thoughts on how to do that within a SQL statement?
dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
i wouldn't say there is no pity, but there is probably a very low
concentration of mysql people running on macos.
Just my two cents...
dan
Kevin Jaques wrote:
A couple days ago, I posted a careful message of my troubles, but no
reply to date. Remember, after I tried to assign a password for
sounds like the difference between a windows system and a linux
system. If you are doing the
load on a linux system, a simple dos2unix filename should set you
straight.
dan
Andrea Broerman wrote:
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last
probably more then you possibly need.
dan
kavitha kutty wrote:
Sir,
I am a student currently doing my final year MCA project.My project is in JSP and MySql.I have not studied MySql before.But I got more information about this database from MySql.com.But I have a doubt
How many number of
perhaps you would get a better response from doing scp... which runs
over ssh... or doing the mysqldump in a cron job, so it will
already be complete for transport by ssh. I still think scp is the more
proper way to go.
dan orlic
Steve Williams wrote:
Hi,
We have a (pre-existing) disaster
down of the disaster recovery one isn't a problem... I may
resort to it, but I'd prefer to just figure out which timeout is causing
the problem.
Thanks,
Steve Williams
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 3:52 PM
To: Steve Williams
Cc
and that did nothing...
actually the server would not even start,
any advice on this would be great, thanks.
dan orlic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
well this is what the deal is... I have a client/server application and
the server connects to mysql
via torque, an open source software project, they are jdbc connections.
Here is the problem: If the applications is left up, let's say,
over night, and the client tries to access the database,
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 12:07 PM
To: Kirti S. Bajwa
Subject: Re: Installation Question
i never had much luck with the source distribution, let alone
using the
prefix flag. Try untarring it in /usr/local/mysql dir
is there a way to close aging sleeeping connections after they have
slept for a certain amount of time? a setting or something in mysql?
dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is anyone aware of an open source project that provides a graphical
representation of tables that can then generate a database schema in sql
statements. Something like Posiedon auto generating java beans.
Perhaps one should be started? ;-)
dan
How, in a sql script, do I gracefully fail an insert? For example, I
insert a record that has an primary key of 1, and it already exists. I
want my script to
Move down to the next record, not fail out. Thanks!
dan
Hello all,
My query is about changing the tmpdir on mysql. As stated in on the
mysql.com site it states that if it is not set it uses the default, in
my case, the default was /tmp. It also states that to change it you can
do so in the mysqld_safe startup file. It makes no mention of
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 1:20 PM
To: '[EMAIL PROTECTED]'
Subject: changing TMPDIR for tempory file location
Hello all,
My query is about changing the tmpdir on mysql. As stated in on the
mysql.com site
I have an insert that I have to get to work from the following tables
here is my query:
Select distinct t1.id, t3.id, t2.id, g.description, g.price, g.qty,
g.comments from cp.Category t1, Gifts g, cp.Manufacturer t2, cp.Pattern
t3 where t1.name = g.Category and t2.name = g.Manfacturer and
Thanks for that tip about the -opts on mysqldump. my import speed went
from 28 hours to about 11 minutes.
Thanks again!
dan
the load.
Can anyone tell me what is taking so long? Any thoughts as how to speed
it up? Thanks in advance.
Dan orlic
23 matches
Mail list logo