In the last episode (Apr 13), Cesar Bonavides Martinez said:
> I'm working with Solaris 8, and MySQL 4.0.17-standard.
>
> I was trying to upload data into a single table database and when it
> reached 2GB it stopped uploading sending the error message:
>
> ERROR 1030 at line 2450: Got error 27 fr
I searched all over and can't seem to find out how to take an average of
every x number of rows from a result set.
I have a table with over 700,000 rows, and I want to display an x and y
graph of that data on the web. What is happening now is I'm creating 2
arrays, one for the x axis and one for
Hi All,
I am trying to perform an update:
UPDATE helpdesk_tickets ht, helpdesk_status_master hsm
SET ht.status_id = (SELECT status_id FROM helpdesk_status_master WHERE
is_closed = 'y')
WHERE ht.submit_date < DATE_ADD(curdate(), INTERVAL -7 day)
AND ht.status_id = hsm.status_id
AND hsm.is_closed =
A * by itself must come first, so
SELECT *, "A" AS SortCode FROM Jobs
will work.
[EMAIL PROTECTED] wrote:
I am not sure about MySQL but in Oracle this will NOT work: "SELECT "A" AS SortCode,
* FROM Jobs"
However, this WILL: "SELECT "A" AS SortCo
Hi,
I'm working with Solaris 8, and MySQL 4.0.17-standard.
I was trying to upload data into a single table database and when it reached
2GB it stopped uploading sending the error message:
ERROR 1030 at line 2450: Got error 27 from table handler
After more than 4 hours digging into the FAQs and
Greetings!
I have a query that I would like to refine a little more. I am using this to
send email to a directory with so many users in it that it causes my SMTP
server to clog up. I want to break up the database send module so that it
sends to only last names with the letters A - K first, do a pa
I'm doing a select where I lag across records, and would like to compute
some differences. It seems to do the calcs right if I evaluate the result in
an IF statement, but if I just want to get the calculation result stored, it
seems to default to a data type that only stores on digit. Here's the
of
In my box, mysql server version is 4.0.18.
I tried "> flush logs". Nothing happened in the mysql data directory. All the log
files were not replaced.
Does "flush logs" rename the old log files and create new log files?
Thanks.
Grace Tang
Software engineer
Computer Associates (China) Co.,
Hi,
i just created a db with around 30 tables and i need
to populate it. Is there any software or special
technic for doing that automatically (using random
characters for example)?
Thanks,
ltcmelo
__
Yahoo! Messenger - Fale com
* Peter Lovatt <[EMAIL PROTECTED]> [040413 16:27]:
> Hi
>
> select left(field, 1) from table where field = "something"
>
> http://dev.mysql.com/doc/mysql/en/String_functions.html
* Kevin Carlson <[EMAIL PROTECTED]> [040413 16:27]:
> try this:
>
> select LEFT(names, 1) from table
Thanks folks.
try this:
select LEFT(names, 1) from table
Tim Johnson wrote:
Hello:
Is it possible to use mysql to select only
the first letter of a string in a column?
IOWS "select names from table" ->
"select names from table"
another way of asking my questions would be,
Is it possible to truncate
On Tue, 2004-04-13 at 13:13, [EMAIL PROTECTED] wrote:
[snip]
> >> I could frequently poll the slave servers using SHOW SLAVE STATUS or
> SHOW
> >> PROCESS LIST and watch for their status to change.
> >>
> >> I could start each slave with "--log-slave-updates" and watch the
> slaves'
> >> binlogs fo
I have a table with four columns, the first three of which are combined
into a unique key:
create table Test {
cid int(9) NOT NULL default '0',
sid int(9) NOT NULL default '0',
uid int(9) NOT NULL default '0',
rating tinyint(1) NOT NULL default '0',
UNIQUE KEY csu1 (
Hello:
Is it possible to use mysql to select only
the first letter of a string in a column?
IOWS "select names from table" ->
"select names from table"
another way of asking my questions would be,
Is it possible to truncate columns in selection
set to a specific length (in the case: 1)
Vadim,
if I'm not mistaken, you can't set a variable then use
it in the same statement.
See http://dev.mysql.com/doc/mysql/en/Variables.html
A little ways down the page...
"The general rule is to never assign and use the same
variable in the same statement."
-- Tripp
--- "Vadim P." <[EMAIL PR
I am not sure about MySQL but in Oracle this will NOT work: "SELECT "A" AS SortCode,
* FROM Jobs"
However, this WILL: "SELECT "A" AS SortCode,
Jobs.* FROM Jobs"
Try adding the table or alias in front of the "*".
In general, however, I will repeat m
OS: suse 9
Mysql: 4.0.15
Googled: yep, but didn't find anything conclusive
I'm attempting to chroot mysql, and I'm failing [miserabaly]. I realize
that this is a mysql list, but I currently believe it's either a dependency
of mysql I forgot or something something I'm not aware of w/ mysql. I also
Sorry, the message got garbled, here is a more digestible look:
-Original Message-
Hello all,
Could anyone comment on User Variable behavior in the example below?
Thanks,
Vadim.
=
mysql> SELECT
-> LEFT(CallT
Hello all,
Could anyone comment on User Variable behavior in the example below?
Thanks,
Vadim.
=
mysql> SELECT
-> LEFT(CallTime,10) AS CallDate,
-> @a := SUM(Charge),
-> @b := SUM(Cost),
Hey gang, many thanks to all for pointing me in the right direction for
my previous "multiple selects" question. I moved to 4.1.1 and
implemented Udikarni's use of multiple sum()s instead of multiple
selects() and that stuff is all groovy now!
Of course, I'm beating my head on *another* wall n
Hi Dan,
(Sending to the General list too, since this isn't a Windows-specific
thing.)
SHOW TABLE STATUS LIKE 'tbl_name'
will show you the current Avg_row_length.
But the specific values for MAX_ROWS and AVG_ROW_LENGTH when you CREATE
or ALTER the table don't matter (except for "looking correct"
>
> From: "Gordon" <[EMAIL PROTECTED]>
> Date: 2004/04/13 Tue PM 06:45:17 GMT
> To: <[EMAIL PROTECTED]>
> Subject: MySQL function
>
>
> Has anyone out there written a Credit Card Validation routine as a
> user-definable function (UDF)?
>
> We now have a requirement to collect credit card data
Hi,
I'm trying to get replication set up on a slave, and getting the
error: "Error 1200: The server is not configured as slave, fix in
config file or with CHANGE MASTER TO".
The master machine is set up already, and there is already
one database replicating off of it (a second instance of mysql o
Backup the data folder under the mysql folder, that's it
-Original Message-
From: Alejandro C. Garrammone [mailto:[EMAIL PROTECTED]
Sent: Monday, April 12, 2004 10:11 AM
To: MySQL Mailing List
Subject: Reinstall Windows.
I need to re-install windows, so I need to re-install mysql.
As far as I know, you can't use an alias in a calculation outside of a
HAVING clause. You could work around this by adding the calculation to your
SELECT clause:
SELECT kills.PlayerID, player.DeathsPerMinute,
SUM(kills.Kills) AS Total,
SUM(kills.Kills) * (1-player.DeathsPerMi
You shouldn't be surprised. This is normal behavior. interchangeStatus is
a varchar, so
select fileName from outDocInterchange where interchangeStatus = 91;
requires that interchangeStatus be converted to an int for each row so it
can be compared to 91, rendering the index useless. On the
> On Tue, 2004-04-13 at 15:11, [EMAIL PROTECTED] wrote:
>> On Tue, 2004-04-13 at 11:21, [EMAIL PROTECTED] wrote:
[more snip]
>> Somehow, I need to detect the
>> end of my central slaves' replication cycle so that I can trigger the
>> "merge processing".
> Its not clear what you mean by 'replicat
Lucy, you've got some EXPLAINing to do... (sorry, couldn't resist)
A) select fileName from outDocInterchange where interchangeStatus = 91;
B) select fileName from outDocInterchange where interchangeStatus =
'91';
(A) Runs unindexed, (B) runs with the istat_date index. Can anyone
explain
Which distribution should I install on Mac OS X Panther? Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Leonardo : La verdad es que debes analizar lo que yo llamo "¿donde te
aprieta el zapato?" , esto quiere decir , que si requieres
procedimientos almacenados y triggers y vistas , quizas oracle haga el
trabajo. Si por otro lado la logica del negocio esta en tus
aplicacciones y no requieres de est
On Tue, 2004-04-13 at 11:21, [EMAIL PROTECTED] wrote:
> Hello List:
[snip]
> Here is where things get sticky. I would like to be able to merge the
> replicated reports into the warehouse database with the smallest practical
> delay (I have some very process-driven branch mangers and they feel they
Leonardo Javier Belén wrote:
The staff on the other hand, is thinking in using ORACLE, and I need very solid arguments to beet them. Any ideas I can borrow?
If *you* don't know any arguments, then maybe Oracle is the best
solution.
Jochem
--
I don't get it
immigrants don't work
and steal our job
Hi folks!
I am sorry to bother but I need your help. At work I need to upgrade the data
management the place is using (very old FOXPRO DOS) with something more modern. The
use is only to store data and run multiple querys in a post mortem fashion. The data
source is a Ms SQL server so manage
Has anyone out there written a Credit Card Validation routine as a
user-definable function (UDF)?
We now have a requirement to collect credit card data through our Web
Site.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hi there,
I am a bit confused. It is not clear to me that the version I am currently
running is the one I compiled last. How can I check the date of compiling?
In order to get more performance I did try to install mysql 4.0.18 with different
configure commands, now I am not sure if the make insta
Hello List:
I have been crawling the docs, the mailing lists, and the discussion groups
looking for options to my issues for several weeks and have found answers
to most of them. I have one last nut to crack and if the answer is out
there I must be blind. That's why I finally came to the list for
Ciprian Trofin writes:
>Basically I have some tables with only 2 fields (ID and name), and a
>central table, joined by a one-to-many relation. The key point here are the
>2-field tables. If I keep them separate, I can extend them (add new fields)
>without problem when need arise. But if there is no
Il giorno 13/apr/04, alle 16:01, Martijn Tonies ha scritto:
Hi,
I've found VBMySQLDirect,
go to http://vbmysql.com and look for VBMySQLDirect under the
'Projects' section.
As the author itself explains on the documentation, it is not ADO, but
very very near to it. I'm using it succesfully on som
Gowtham Jayaram <[EMAIL PROTECTED]> wrote:
>
> I understand that MySQL Replication can be configured
> to replicate selected tables in a Database. Is there
> anyway to further constrain the replicate, say based
> on a query of these tables etc..?
>
No.
--
For technical support contracts, go
>> I have a query that searches my database for people
>> with C++ on their resume .
...
>Hehe I've also had a problem with searching for something like it's ,
>anything with a single quote doesnt return anything, maybe try adding a
>slash , C\+\+ ?? heheh maybe i'm wrong, it could be a limitation.
A heap table isn't a view, it's just a table in memory, when you stop mysql the table disappear. Are usefull for speed selects; you don't need access hd.
In the other hand views are definitions from other(s) table(s) stored in the db, are permanent and can be updated
Alejandro.
--
+ is not part of the definition of a word in MySQL.
One solution is to normalize "C++" into "CPLUSPLUS"
both during index and query time.
Haitao
--- electroteque <[EMAIL PROTECTED]> wrote:
> Hehe I've also had a problem with searching for
> something like it's ,
> anything with a single quote doe
Yonah Russ writes:
>here is a sample output line:
>
>Time for alter_table_drop (91): 19 wallclock secs ( 0.02 usr 0.00 sys +
0.00 cusr 0.00 csys = 0.02 CPU)
>
>
>here is the regexp:
>
>/^(estimated |)time (to|for) ([^\s:]*)\s*\((\d*)(:\d*)*\)[^:]*:\s*([\d.]+)
.*secs \(\s*([^\s]*) usr\s*\+*\s*
Hi,
> I've found VBMySQLDirect,
>
> go to http://vbmysql.com and look for VBMySQLDirect under the
> 'Projects' section.
>
> As the author itself explains on the documentation, it is not ADO, but
> very very near to it. I'm using it succesfully on some applications on
> VB 6, without problems.
Tha
Have you tried to update an underlying heap table? The heap table will not
be updated. A view is updated when any of the underlying table(s) are
updated.
-Original Message-
From: Abiola Aluko
To: [EMAIL PROTECTED]
Sent: 4/13/04 8:01 AM
Subject: What is the difference Between the mysql HEA
>I just recompiled mysql and I am wondering if there is something like in php
>(phpinfo();) where you can see the configure command after the db is
installed.
>It would just be nice to have that in a later time, or even to make sure that
>the new version has replaced the old one.
The initial port
Carsten,
Thanks for the answer (and other thanks go to the other guys that answered
me).
I think normalization is the way to go. I think it is the right thing to
do (in theory). The problem is that theory doesn't fit all.
Basically I have some tables with only 2 fields (ID and name), and a
centr
I know this might sound like a rather funny question to many gurus out here, but I'm a
bit confused.
The example give in the mysql manual is:
mysql> CREATE TABLE test TYPE=HEAP SELECT ip,SUM(downloads) AS down
-> FROM log_table GROUP BY ip;
mysql> SELECT COUNT(ip),AVG(down
Hi all,
Is there an ADO (NOT ADO.NET) driver for MySQL?
If so, where?
Thanks in advance.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archi
Hehe I've also had a problem with searching for something like it's ,
anything with a single quote doesnt return anything, maybe try adding a
slash , C\+\+ ?? heheh maybe i'm wrong, it could be a limitation.
> -Original Message-
> From: David Taiwo [mailto:[EMAIL PROTECTED]
> Sent: Tuesday
> I just found that mysql 4.0.18 is doing binary logging. How can I
> turn this off?
> I do not see a nead for this, plus I fear that
> it might fill up the file system, plus I think it is reducing performance.
>
The binary log is primarily there to let you restore data. Say you backup
every nigh
I have a query that searches my database for people
with C++ on their resume .
Query
=
select * ,match(Res_resume) AGAINST ('C++') as
kewyordscore from member,memberprofile,resume left
join stateprovince on stateid = Res_state
where mem_id = mempf_memid and
match(Res_resume)
Hi there,
I just found that mysql 4.0.18 is doing binary logging. How can I turn this off?
I outcommented the line in my.cnf and restarted the server, but it is still creating
those binary loggs inside the data dir. I do not see a nead for this, plus I fear that
it might fill up the file system, p
On Sun, 2004-04-11 at 15:58, Saurabh Data wrote:
> Dear Users
>
> Can anyone in your own words clarify the difference between "open source"
> and "free software".
Go see the GNU.org site.
http://www.gnu.org/home.html
and also check this out
http://www.gnu.org/licenses/licenses.html
(If you d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
CFLAGS="-O3 -march=i686 -mcpu=i686 -funroll-loops -fomit-frame-pointer
- -fno-exceptions -fno-ftti -felide-constructors"
CXXFLAGS the same as above.
Check out "Securing and Optimizing Linux" in the tldp.org i think is
just what you nedd.
Best Rega
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
If the application is _NOT_ local you can restrict complete acces to one
and only one machine, host, or network mask using the "grant" statement.
Also changing mysql default port is not a bad idea, at least it make it
~ more dificult to guess
Best
Here are charcodes of full-width space (IDSP,Ideographic Space)
of sjis, ujis and utf8:
sjis 81 40
ujis A1 A1
utf8 E3 80 80
String processing functions TRIM, LTRIM, and RTRIM don't recognize
full-width space in a string. They don't trim the full-width space
and leave it in string.
I've been trying to compile a mysql server optimized for a zeon
processor and a specific application- I'm compiling with icc.
the problem is with the sql benchmarks- the perl regexp for making the
detailed report of the benchmark doesn't match the output from the
benchmarks so it doesn't create
I\'m trying to order by an alias in a multi table SELECT statement(Note I\'ve cut the
statement down a bit to make it more readable):
SELECT kills.PlayerID, player.DeathsPerMinute, SUM(kills.Kills) AS Total FROM
playerweaponkills AS kills, ETPlayerSummary AS player WHERE
kills.PlayerID=player.
There does seem to be a bug in icc- I've posted on intel's message
boards and they've confirmed a problem. There is a work around - here is
the post:
Hi Yonah,
I can see the same problem on my system.
I will create a support issue for you and will let you when
this get fixed.
I found that if you
Hi there,
I just recompiled mysql and I am wondering if there is something like in php
(phpinfo();) where you can see the configure command after the db is installed.
It would just be nice to have that in a later time, or even to make sure that the new
version has replaced the old one.
thanx fo
61 matches
Mail list logo
