Justin Burger wrote:
Good Afternoon, In Oracle there is a keyword called RETURNING, where
I can do an insert and specify what row to return, this helps with
autoincrement fields;
How can I achieve this in MySQL?
If you only want to know the value of the last inserted autoinc field,
use LAST_INSERT_
Your problem seems to be one of spaces.
This query tries to set the SET to TWO values, "family" and " money"
(notice the space before money"
INSERT into my_table (name, subjects) VALUES ("Joyce", "family, money")
Try it without the space:
INSERT into my_table (name, subjects) VALUES ("Joyce", "fa
Well, I think I'll just stick with the story that I wuz jes' tryin' to
keep everbody on their toes
It's the only way out I can see.
Thank-you.
:)
Jeremy Cole wrote:
Hi,
I'd like to do a dual order by. First, I want to order by City, then
I want to order name. That way, the names within the c
Hi,
I'd like to do a dual order by. First, I want to order by City, then I
want to order name. That way, the names within the city are alphabetized.
I can easily do an order by City into a temp table, then order by name
from within the temp table. Is this the best way? Is this the only way?
ORDE
Does order by City,name help?
- Original Message -
From: "Robert Pruitt" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 10, 2005 10:11 AM
Subject: Compound Order By
> I'd like to do a dual order by. First, I want to order by City, then I
> want to order name. That way, the names wit
Hi Tobias,
On Wed, 9 Feb 2005 14:48:16 +0100 (CET)
Tobias Asplund <[EMAIL PROTECTED]> wrote:
> > I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
> > is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL
> > won't start if I set innodb_buffer_pool_size to >= 2G
I'd like to do a dual order by. First, I want to order by City, then I
want to order name. That way, the names within the city are alphabetized.
I can easily do an order by City into a temp table, then order by name
from within the temp table. Is this the best way? Is this the only way?
Just wo
Hi,
I'm new to MySQL and at this point, I'm just trying to insert rows
of data into a table.
When I insert a row of data that includes a field of type "set"
(corresponding to an HTML set of checkbox answers), only the first
item in the list gets inserted into the row.
For example, I have a table
Jerry Swanson wrote:
Is it possible to do "daily incremental backups" on mysql?
Thanks
Yes.
mysqldump will give you a starting point, and the binary transaction
logs give you your incremental backups - copy these somewhere each day -
onto a backup tape or something. Read the documentation fo
Is it possible to do "daily incremental backups" on mysql?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dear member,
My problem is name of those.When i wish to apply a function,I don't know name
of that's header file.I need to a document for it.
--Mohsen
On Thursday 10 February 2005 02:06, Logan, David (SST - Adelaide) wrote:
> Hi Mohsen,
>
> If you install the client libraries from http://www.mys
Hi Mohsen,
If you install the client libraries from http://www.mysql.com for the
version you wish, this will install the header files in the
mysql/include directory.
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+
Dears,
I have started Linux-programming with C++.
I need to header files's name of MySQL.
Please give that's URL.
Yours,Mohsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It work with php too (at least with phpMyAdmin)
Martin ha scritto:
I've been running it for a while. Admittedly, I don't do anything
truly heavy with it -- it is part of my non-critical dev stuff.
I've had no issues with it, reliability wise, running it as the
backend to a Tomcat 5 install and
Hi all. Sorry if you get this twice -- it was posted to
mysql-replication earlier, but it doesn't look like that list is
really used.
I'm having a problem with my replication setup. This is my first time
setting up replication, so this may be a simple problem. I'm using
one master and one slave
I've been running it for a while. Admittedly, I don't do anything truly
heavy with it -- it is part of my non-critical dev stuff.
I've had no issues with it, reliability wise, running it as the backend
to a Tomcat 5 install and about to switch it over to a Tomcat 5.5.
Basically, on that box, I
Ah, I see. So the tables that are represented by all
three files are presumably MyISAM files, right?
--- Victor Pendleton <[EMAIL PROTECTED]> wrote:
> InnoDB files can not be copied from one machine to
> another like the
> MyISAM files. If you did not dump the data or you do
> not have an
> a
Hello,
Does anyone has experience with MySQL 5.x?
How reliable is it?
Is it compatible with JDBC, PHP and other drivers and connectors?
Thank you,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Good Afternoon,
In Oracle there is a keyword called RETURNING, where I can do an insert
and specify what row to return, this helps with autoincrement fields;
How can I achieve this in MySQL?
Thanks a bunch!!
-- Justin W. Burger
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
Hi all,
We use MySQL as a database backend on a portal site. We have a two
database server setup (one master, one slave). The master is a PIV 3,2 GHz.,
2 GB Ram and a 80GB Raid-1 system. The slave is a PIV 3.2 GHz., 4 GB Ram and
a 80GB Raid-0 system. Both run on MySQL 4.1.9 and only use In
"Steve Grosz" <[EMAIL PROTECTED]> wrote on 02/09/2005 03:43:22 PM:
> I downloaded the MySql Administrator and simply run that. and
> dragged the icon to the startup menu so it loads MySql on startup.
> Not entirely sure how to load MySql as a 'service' on Win2003 Server.
>
> The only message I
InnoDB files can not be copied from one machine to another like the
MyISAM files. If you did not dump the data or you do not have an
archived backup you will more than likely have to recreate the table
structures.
David Blomstrom wrote:
Yikes...I've been replying to myself! I forgot that
when I
Yikes...I've been replying to myself! I forgot that
when I reply to messages from the MySQL newsgroup on
this e-mail account, it doesn't include
mysql@lists.mysql.com, for some odd reason.
At any rate, I wanted to say that I have just ONE file
type left - FRM. My MYD and MYI files have both
vanish
>> reconstituted from a munged response
(original post)
Steve Grosz <[EMAIL PROTECTED]> wrote on 02/08/2005 06:04:48 PM:
> I already have a version of MySql 4.1.17 running on a different server,
but
> am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
>
When I RPM upgrade MySQL on Fedora Core 3 from the installed version
3.23 to version 4.1.9, the rpm command yeilds the following warning:
Warning: VMySQL-server-4.1.9-0.i386.rpm: 3 DSA signature: NOKEY, key
ID 5072e1f5
What does this mean?
Should I ignore this warning?
Should I expect problem
Well I know about it and I am working on MySQL
Replication, the point is that you dont have control
over replicatation when your MySQL server is installed
by your ISP on shared server,
In that case it is simply not possible :)
Moreover, the simple setup I have, I prefer this then
the nittygrittie
At 19:52 +0300 2/9/05, George Chelidze wrote:
Hello,
I have the following problem: I have a table with a blob field and
turned on query logging. I'd like to log every query except inserts
into table with a blob field because my log files grow very fast and
I don't like to see binary data in my l
unni krishnan napisaÅ(a):
hi,
I want to connect to mysql using borland c. The version is bcc5.0 and for mysql it is mysql4.0.13
The compilation is ok... but its showing linker error like
"unresolved external mysql_init referenced from module ... "
what is the problem??? How to speci
Cron hack?
have a console running:
tail -f hostname.log | grep "tablename" > filter.log
-or-
tail -f hostname.log | grep -v "insert into blobtablename" > filter.log
> then have a cronjob every X minutes running: echo "" > hostname.log
To truncate the full querylog from getting too big?
No
Remember, a low cardinality index will possibly be ignored by the optimizer
and an index on month will never have a cardinality of more than 12. For
testing purposes, you might try added a column for month and populating it
off your current data.
update the_table set the_field=MONTH(the_field)
Dean Karres <[EMAIL PROTECTED]> wrote on 02/09/2005 12:46:46 PM:
> Hi,
>
> I have a table full of activity records. Each record has a DATETIME
> field for when the activity started and one for when it ended.
> I want to post process this table and produce billing records from it.
>
> Billing re
It is very easier with mysql replication concipt, this automatic
replication from Master server to Slave server and real time. I wonder
how you do not know about this.
http://dev.mysql.com/doc/mysql/en/replication.html
Love kumar ..
[EMAIL PROTECTED] wrote:
SQLyog Enterprise's Database Sync Tool
SQLyog Enterprise's Database Sync Tool is the answer
for your queries.
www.webyog.com
Rgds,
Karam
--- Paul Godard <[EMAIL PROTECTED]> wrote:
> Hi
>
> I use mysql/php on several client web sites (each
> client has its own
> db). For development purpose, I have a local web
> server with
> php/
Our mail server has been stopping emails to the list.
This is a test message to see if it bounces again.
Please ignore (and accept my apology for generating noise).
David.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Wed, 9 Feb 2005 15:17:36 -0200, Gabriel B. <[EMAIL PROTECTED]> wrote:
> It is not too slow this way since i started the WHERE with lots of
> checks that cuts down to a medium of 200 rows that actualy gets to
> this check, but i feel uncorfotable to not use a index.
Isn't there a limit of 1 ind
Hi,
I have a table full of activity records. Each record has a DATETIME
field for when the activity started and one for when it ended.
I want to post process this table and produce billing records from it.
Billing records will have a link back to the activity record that
produces them; i.e. ther
At 15:37 -0200 2/9/05, Gabriel B. wrote:
On Wed, 09 Feb 2005 17:24:10 +, love <[EMAIL PROTECTED]> wrote:
alter table table_name add index (birthday);
But would that index improve this kind of query? the docs talk about
only direct matchs, like "birthday < now()" or" birthday between x and
y"
On Wed, 09 Feb 2005 17:24:10 +, love <[EMAIL PROTECTED]> wrote:
> alter table table_name add index (birthday);
But would that index improve this kind of query? the docs talk about
only direct matchs, like "birthday < now()" or" birthday between x and
y". They're all full date values.
--
My
use below:
alter table table_name add index (birthday);
Love Kumar ..
[EMAIL PROTECTED] wrote:
Short Version:
is there any way to make an index for a date field that appears in the
WHERE as a MONTH() argument?
I have a table with some hundreds of thousands of rows already, and
now i have the need t
Short Version:
is there any way to make an index for a date field that appears in the
WHERE as a MONTH() argument?
I have a table with some hundreds of thousands of rows already, and
now i have the need to show upcoming birthdays to some users.
the query uses WHERE MONTH(birthday).. the `birthda
Hi,
Aes Encryption requires a password (key) to access data, now where do
we store this key? with the source code ? or in seperate database ?
because any body who has the access to souce code can view the critical
info or even if you store passwords in another database then it is not a
big deal
Hello,
I have the following problem: I have a table with a blob field and
turned on query logging. I'd like to log every query except inserts into
table with a blob field because my log files grow very fast and I don't
like to see binary data in my log files, while other logs are very
informati
The mySQL command should read :
mysql -u username -p[password] db_name < dumpfile
Note that you can give the password on the command line but it is best
to get into the habit of just providing -p and typing in the password
when prompted.
BTW, when doing the mysqldump for tables that already exis
Shailendra Soni <[EMAIL PROTECTED]> wrote on 02/09/2005 08:28:36
AM:
> Hi,
>
> I have a question regarding speed of the query.
> In my application i am useing Mysql 4.0.20a-nt.
> I have 10 tables and each table contains 400 records
> and also 61 columns. I already created indexs on six colum
E SA <[EMAIL PROTECTED]> wrote on 02/08/2005 06:40:40 PM:
>
> All,
>
> I have done some reading and research; however, I
> seem to be at a loss...
>
> And this time, I am not sure how to ask Google...
>
> Here is the problem:
>
> Table A: id INT
>valuevarchar (10)
>
>
Steve Grosz <[EMAIL PROTECTED]> wrote on 02/08/2005 06:04:48 PM:
> I already have a version of MySql 4.1.17 running on a different server,
but
> am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
> software.
>
> I'm finding that 4.0.23 isn't as easy to set up as the later vers
Marcin Lewandowski <[EMAIL PROTECTED]> wrote on 02/08/2005 05:29:39 PM:
> Chuck Herrick napisał(a):
> > 200 - 400 tables is too many.
>
> Is it too many for merge, innodb or both?
>
> > Try having one CUSTOMERS table. You know who is logged in, so you can
> > use that information in a WHERE clau
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> >On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> >> Hi
> >>
> > > I use mysql/php on several client web sites (each client has its own
> >> db). For development purpose, I have a local web se
On Wed, 9 Feb 2005, Batara Kesuma wrote:
> Hi,
>
> I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
> is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL
> won't start if I set innodb_buffer_pool_size to >= 2GB. Here is my
> ulimit.
Are you trying this on a 3
[snip]
I have a question regarding speed of the query.
In my application i am useing Mysql 4.0.20a-nt.
I have 10 tables and each table contains 400 records
and also 61 columns. I already created indexs on six column which are
important for me.
i fired the query on tables through servlet(thread
"Lasse Laursen" <[EMAIL PROTECTED]> wrote on 09/02/2005 13:24:27:
> Hi all!
>
> Simple question: What is fastest when doing a connection to a local
machine?
> TCP/IP or connecting via the socket? the application is a ACL helper
program
> under Squid which makes a persistent connection to the
Hi,
I have a question regarding speed of the query.
In my application i am useing Mysql 4.0.20a-nt.
I have 10 tables and each table contains 400 records
and also 61 columns. I already created indexs on six column which are
important for me.
i fired the query on tables through servlet(thread).
I believe it may be because the tables in the Query cache have been
modified causing the cached results to become invalid.
Olivier Kaloudoff wrote:
Hi,
I noticed the following behaviour on mysql 4.1.8
and two servers;
to setup replication, I did the required grant on
the master, and choo
Hi all!
Simple question: What is fastest when doing a connection to a local machine?
TCP/IP or connecting via the socket? the application is a ACL helper program
under Squid which makes a persistent connection to the database (100
parallel programs runs on the machine each connecting to the MySQ
Hi,
I noticed the following behaviour on mysql 4.1.8
and two servers;
to setup replication, I did the required grant on
the master, and choose to use "LOAD DATA FROM MASTER" on the
slave.
As we monitor the Qcache usage on the master, it
happend that Qcache was reset to 0 Queries
Hi,
I try to install MySQL 4.1.9 (official RPM from mysql.com). My machine
is running linux 2.6.9, and it has 4GB of RAM. The problem is MySQL
won't start if I set innodb_buffer_pool_size to >= 2GB. Here is my
ulimit.
[EMAIL PROTECTED] mysql]# ulimit -a
core file size (blocks, -c) 0
data
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard <[EMAIL PROTECTED]> wrote:
> Hi
>
> I use mysql/php on several client web sites (each client has its own
> db). For development purpose, I have a local web server with
> php/mysql. When a web site is still in development, this is the
> master db, ev
People, including me, often expect the wrong thing from SELECT DISTINCT,
May suggest you do the following:
Create table temp_tb_spots as
Select * from tb_spots where aired_station = '??'
;
select distinct Date from temp_tb_spots group
;
In a different window run
Select Date from temp_tb_spot
Hi
I use mysql/php on several client web sites (each client has its own
db). For development purpose, I have a local web server with
php/mysql. When a web site is still in development, this is the
master db, even if a copy has been uploaded on the live web server at
my isp. When a site is co
hi,
I want to connect to mysql using borland c. The version is bcc5.0 and for
mysql it is mysql4.0.13
The compilation is ok... but its showing linker error like
"unresolved external mysql_init referenced from module ... "
what is the problem??? How to specify the correct library...
Здравствуйте
After upgrading mysql server from 4.1.3beta to 4.1.9 (FreeBSD 4.8,
mysql is installed from ports) I sometimes have the following problem:
when some perl client tries to execute INSERT or UPDATE query via
DBD::mysql it from time to time (but NOT always ) gets error 1036
(
On Tuesday 08 February 2005 21:11, Stephane Pinel wrote:
> Hello,
>
> When I try to insert decimal numbers like 12857.59, 13858.58 or
> 14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?!
>
> DataType is DECIMAL 10,2
>
> Any idea of a way to avoid this annoying issue ?
>
> Thanks.
>
>
On Tuesday 08 February 2005 17:03, Coz Web wrote:
>
> This will (as I believe Daniel suggested) keep things relatively
> simple, avoiding an overly complex query that you cannot maintain in
> the future.
Well, my solution was, as you'll have observed, vastly over-complicated. I
think I'd misunder
> I am trying to get mysql working on my Windows ME machine. When trying
> Server\bin\mysqld unknown option '--enable-named-pipe'
> MySQL version 4.1.9.
> Any help greatly appreciated.
> Dick
WinME does not support named pipes... so neither mysqld...
so you should remove from my.cnf or my.i
> | But I have a question: is there any difference between the following?
> | SELECT lname, fname FROM contacts WHERE lname = 'smith';
> | SELECT lname, fname FROM contacts WHERE lname LIKE 'smith';
> | Sincerely,
> | -Josh
> My
> gut hunch is that if your LIKE expression is going to contain no
w
On Wed, 9 Feb 2005, Mark Sargent wrote:
Hi All,
using Fedora2 and trying to install from a .tar file. Extracted to this dir,
mysql-standard-4.1.9-pc-linux-gnu-i686 where I see the INSTALL-BINARY file.
Using this cmd, ./INSTALL-BINARY gives the following error,
[EMAIL PROTECTED] mysql-standard-4.
66 matches
Mail list logo
