Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;)
What I did was trying to use something like this which to my knowledge
doesnt work on MySQL servers.
$dbh->commit();
$dbh->rollback();
/Jonas
> - Original Message -
> From: "Joshua J. Kugler" <[EMAIL PROTECTED]
Hmm...but it *should* work. DBI::mysql should implement those calls and
transform them to BEGIN/COMMIT calls. I wonder why it doesn't.
j- k-
On Tuesday 30 March 2004 11:24 pm, Jonas Lindén said something like:
> Sorry Mike, Joshua is absolutly correct. Dont listen to my nonses ;)
>
>
jdavis <[EMAIL PROTECTED]> wrote:
> Hello,
> i have a sql file that i use to build a table. It works on my Debian
> testing box with mysql 4.0.16 but not on my woody box using mysql 3.23.
>
> The error when i try to use the source command with my sql file
> and version 3.23 of mysql is...
>
> ERR
on 03/31/2004 01:02 AM, Harald Fuchs at [EMAIL PROTECTED] wrote:
>> Where the new data to import is missing the Mname and id, so I will create
>> full complete insert statements, but how to load that in?
>
> Depending on your table structure, the following quotation from The
> F*** Manual might a
Please have a look at the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
i stored some files which containing some 0-bytes in longblob fields. If i try to
select the files of these fields, i only get the bytes before the first 0-byte.
I tried this with some clients like MySQL-CC, MySQL-Front, AquaDataStudio and own
java-clients. But it is always the same resul
I have to copy some records from one table into the same table is it
posible?
my sql is like this:
INSERT INTO equipamento_componentes (cod_equipamento_componentes, cod_tipo,
numero, data_colocacao, cod_componente)
SELECT '', 'C', 65, NOW(), EQ.cod_componente
FROM equipamento_componentes EQ
WH
Could anyone tell me if this is a bug or not.
SQL: SELECT CURDATE()+0;
RESULT: 20040331
Thats good. However consider this:
SQL: SELECT CURDATE()+1;
RESULT: 20040332
Not so good. Infact with this version any WHERE clauses you would put
this in, fails to bring back the right result.
Does
Hi,
I would like to know if functions will ever be able to issue SELECT
statements, like procedures can. I want a function which can select
multiple rows from another table, process those rows into a single
scalar, and return that as its result. I want a function to do this
so that I can use i
Hi,
- Original Message -
From: "Alan Williamson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 5:17 PM
Subject: CURDATE() bug?
> Could anyone tell me if this is a bug or not.
>
> SQL: SELECT CURDATE()+0;
> RESULT:
PROTECTED]
Sent: Wednesday, 31 March 2004 9:47 PM
To: [EMAIL PROTECTED]
Subject: CURDATE() bug?
Could anyone tell me if this is a bug or not.
SQL: SELECT CURDATE()+0;
RESULT: 20040331
Thats good. However consider this:
SQL: SELECT CURDATE()+1;
RESULT: 20040332
Not so good. Infact with this
> Could anyone tell me if this is a bug or not.
>
> SQL: SELECT CURDATE()+0;
> RESULT: 20040331
>
> Thats good. However consider this:
>
> SQL: SELECT CURDATE()+1;
> RESULT: 20040332
>
> Not so good. Infact with this version any WHERE clauses you would put
&
> Could anyone tell me if this is a bug or not.
>
> SQL: SELECT CURDATE()+0;
> RESULT: 20040331
>
> Thats good. However consider this:
>
> SQL: SELECT CURDATE()+1;
> RESULT: 20040332
>
> Not so good. Infact with this version any WHERE clauses you would put
&
> Could anyone tell me if this is a bug or not.
>
> SQL: SELECT CURDATE()+0;
> RESULT: 20040331
>
> Thats good. However consider this:
>
> SQL: SELECT CURDATE()+1;
> RESULT: 20040332
>
> Not so good. Infact with this version any WHERE clauses you would put
&
Does CURDATE() support numeric addition like this? Or is the "+0"
purely a casting-hack to get the right format. Its not meant as pure
addition.
Yes, hav a look at http://www.mysql.com/doc/en/Date_and_time_functions.html
for explaination
further for addition, use date_add(curdate(), interval 1
Hi!
simply put a pair of lines like these pointing out to the correct
location of your mysql.sock:
socket = /opt/mysql-4.0.18/mysql.sock
You'll need a line in your client and in your mysqld section of your
my.cnf (mysql config file)
Best Regards!
Sami Maisniemi wrote:
I intend to bui
Hi!
Marius Stan wrote:
Hello all,
While trying to build MySQL-4.0.18-0.src.rpm downloaded from mysql.com
on a RedHat 8 I get these:
/usr/lib/gcc-lib/i386-redhat-linux/3.2/../../../libncurses.a(lib_termcap.o):
In function `skip_zero':
8<
Are you sure you _do_ have ncurses devel pack
Hi!
[EMAIL PROTECTED] wrote:
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian
Packages Site) into my Debian v3.0r2 box! After finished installing, i had
followed the instruction here to change root's password but right after
--8<
Try to do a login without using passwor
- Original Message -
From: "Alan Williamson" <[EMAIL PROTECTED]>
To: "Jigal van Hemert" <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 2:05 PM
Subject: Re: CURDATE() bug?
> Jigal van Hemert wrote:
>
>
> > NOT A BUG!!!
> >
> > In the manual it is stated that CURDATE() returns either
RTFM!
and what was the reason for this rudeness? Can't you explain yourself
without descending into this sort of language?
I do read the manual, and it is this reason i posted to the list.
Clarity is a wonderful thing, and sadly the manual isn't clear on this
matter.
I stand by my original s
Hi,
today our mysql server 4.0.18-standard (binary) crashed.
I found a similar report (InnoDB: Assertion failure in thread), but it
was with 4.0.16 and one reply said that the bug was fixed in 4.0.17.
Here is the report from mysql.err:
InnoDB: Started
/usr/local/mysql/bin/mysqld: ready for conn
hi,i was attemping,But my problem didn't solved.
SOS SOS
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
> Did you change the mysql root password by running:
> mysqladmin -u root password 'newpassword'?
>
> If so, try:
> mysql -u root -p
>
> It will then prompt you to enter a password.
>
>
> > RTFM!
> and what was the reason for this rudeness? Can't you explain yourself
> without descending into this sort of language?
My apologies for any rudeness, English is not my first language and I'm used
to using this abbreviation to indicate that it can be found in the manual.
> I do read th
Thx's for all the responses... are coding was correct, and the database was set
up correct. The problem was the Perl DBI and DBD::mysql modules where way
out-dated and didn't support the 'rollback' and 'commit' yet... problem solved
after updating the modules.
appologizes as this was not relate
I am looking for a tool that will allow me to replicate a MySql database
to/from other database's such as PostgreSql, MSDE, MS Sql Server but I
have been able to find a product or project that could do this for me.
Does anyone have any recommendations?
I have searched around on the web and in the
Michael Scholz wrote:
Hello,
i stored some files which containing some 0-bytes in longblob fields. If i try to
select the files of these fields, i only get the bytes before the first 0-byte.
I tried this with some clients like MySQL-CC, MySQL-Front, AquaDataStudio and own
java-clients. But it
Hello, MySQL Gurus,
I am just wondering if anyone has seen this before querying an innoDB table:
select count(*) from Table where field1=3;
returned 782 rows
select count(*) from Table where field1=3 and field2 is not null;
returned 666 rows
Here comes the shocking part:
select coun
I have a database in which I have stored a lot of data, and as far as
I know nothing has been deleted from it.
Yet when I do
mysql> select * from bet;
Empty set (1.42 sec)
If I cd into the mysql data dir and do an ls -l on the tables
[EMAIL PROTECTED] poker]# ls -l
total 79600
-rw-rw1
The other thing to consider is the 50% rule. If more than 50% of the
records match, the search is consider irrelevant and no records are
returned. So if you have 120 records and 61 have DB2 in them, you won't
get a result set.
On Mar 31, 2004, at 12:28 AM, Shane Allen wrote:
apologies, I forgo
If I'm reading this correctly, a self-join might
work if you have a primary key defined:
select
t1.a as a1
,t1.b as b1
,t1.c as c1
,t2.a as d1
from
thetable as t1
,thetable as t2
where
t2.primaryid = t1.primaryid+1
John
David L. Van Brunt, Ph.D. wrote:
I have a table of data...
A1 B1 C1
A2 B2 C
Could you do a :
select count(*) from bet;
Just to be sure that there is still something in the table.
Marc.
-Message d'origine-
De : John Hunter [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 31 mars 2004 17:12
À : MySQL mailing list
Objet : select * returns nothing
I have a database i
The next step is to shutdown mysqld, delete the mysql and temp tables from
your /data/ folder, and then re-run the scripts/mysql_install_db. That will
reinstall the mysql/hosts.frm, which will basically reset your root user and
password. However, it will also kill any users you have created.
To r
Brent Baisley wrote:
The other thing to consider is the 50% rule. If more than 50% of the
records match, the search is consider irrelevant and no records are
returned. So if you have 120 records and 61 have DB2 in them, you won't
get a result set.
But the 50% rule is overridden when the search
Hello List:
I have installed and tested freeRADIUS 0.9.3 & MySQL 5.?.? (latest dev
version). Now I want to install & test freeRADIUS & MySQL with InnoDB
tables.
I have researched GOOGLE & MySQL web site for information on installing
MySQL with InnoDB tables without success. I would appreciate if
Hello Folks,
We are developing a PHP/ MySQL application and are attempting to avoid
the privilege escalation problem. Here's a solution I am thinking
about.
Our session values are stored in a database, so that multiple
applications can access it. I was thinking about creating a new field
in t
You are totally right!
"Harald Fuchs" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> In article <[EMAIL PROTECTED]>,
> "Timon Berkowitz" <[EMAIL PROTECTED]> writes:
>
> > Hi there,
> > Sorry for being a little bit confusing, but de criterias has to be AND.
>
> > So it has to be li
hi,
i want to use " Select " to get informations out of a Database ...
i tryed to write to SelectCommand in the OdbcDataReader
SELECT kdnr, auftrag
FROM standart
WHERE (KdNr = ' " & cbokundenr.text & " ')
- i use 1 OdbcDataReader, 1 DataSet and 1 OdbcConnection
i want to read d
Thorsten
Which programming language are you using ?
I believe that for VB it is cbokundenr.value for a combobox
Maybe it would help if you post more code, but I don't know if this is the
correct list to do that
You can write me off list if you want so I can try to help you
Freddie
> -Ursp
The mysqlhotcopy perl script is failing fail when I try to back up
a database containing more than about 600 tables. The script appears
to be unable to lock that many tables before making the actual copy.
Have others experienced this same problem?
Is this a limitation of DBI, or of MySQL 3.23.58?
I finally got it working like I wanted it :-)
SELECT DISTINCT t1.softid,
IF( t1.nameofcd LIKE '%test%' OR t2.nameofsoftware LIKE
'%test%', t1.nameofcd, '') AS nameofcd,
IF( t2.nameofsoftware LIKE '%test%', t2.nameofsoftware,
'') AS nameofsoftware
Ginger Cheng <[EMAIL PROTECTED]> wrote:
>I am just wondering if anyone has seen this before querying an innoDB table:
>
> select count(*) from Table where field1=3;
> returned 782 rows
>
> select count(*) from Table where field1=3 and field2 is not null;
> returned 666 rows
>
> Here come
Not as far as I know. Boolean forces all matches to have all the words
searched on, rather than relevance ranking the results based on how
many of the specified search words are in a record. Searching in
boolean mode will always return the same or less results than a regular
full text search.
Brent Baisley wrote:
Not as far as I know. Boolean forces all matches to have all the words
searched on, rather than relevance ranking the results based on how many
of the specified search words are in a record. Searching in boolean mode
will always return the same or less results than a regula
Hope you guys can help a n00b, although I just got my MCSA. I have a server at my home
network behind a router/switch. It's running Server2000 SP4. IIS is installed from the
CD itself. I already have an ftp running for practice. That went well. I found phpbb
2.0.8 and downloaded it. I didn't ins
Can you send the error message? It might be a timeout problem which is a
mySQL configuration issue. (Look at wait_timeout in my.cnf)
> -Original Message-
> From: Andrew Loughe [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 10:30 AM
> To: [EMAIL PROTECTED]
> Subject: mysqlhotc
I have this table:
mysql> select * from banners;
++-+---+
| id | user_id | title |
++-+---+
| 1 | 1 | first banner |
| 2 | 1 | second banner |
| 3 | 2 | third banner |
| 4 | 2 | forth banner |
| 5 | 2 | f
Your access permissions are not valid.
Add user pete with a password to your grant tables as configured with PHPBB
Or
Add skip-grant-tables in you're my.cnf config file.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 11:09 AM
I have 2 tables (looks best in fixed width font):
test_items
+---+--+
| name | rec_num |
+---+--+
| Book | 1|
| Game | 2|
+---+--+
test_attributes
+---++
| item_rec_num | attribute |
+---++
|
hello
i am using slackware linux and i installed mysql
server with the installation.
now i am trying to start the mysql daemon but it is
not being start.
i have run "mysql_install_db --user=mysql" .. it
runs successfully. but as i run the command
"mysqld_safe" to run daemon it gives the
Did you check in the hostname.err file to see why MySQL ended?
On Wed, 31 Mar 2004, muhammad alqama wrote:
> hello
> i am using slackware linux and i installed mysql
> server with the installation.
>
> now i am trying to start the mysql daemon but it is
> not being start.
>
> i have run
Try seeding your rand.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 12:57 PM
> To: [EMAIL PROTECTED]
> Subject: group by & order by rand() problem
>
> I have this table:
>
> mysql> select * from banners;
> ++-+
Hi
I have two tables in the same Db :
table 1:
helpdesk | CREATE TABLE `helpdesk` (
`wcalledname` varchar(50) default NULL,
`wcalledphone` varchar(50) default NULL,
`wcalledemail` varchar(50) default NULL,
`typeof` varchar(50) default NULL,
`status` varchar(25) default NULL,
`reason
Hi
I have two tables in the same Db :
table 1:
helpdesk | CREATE TABLE `helpdesk` (
`wcalledname` varchar(50) default NULL,
`wcalledphone` varchar(50) default NULL,
`wcalledemail` varchar(50) default NULL,
`typeof` varchar(50) default NULL,
`status` varchar(25) default NULL,
`reason
> Try seeding your rand.
Tried. It doesn't work. The select shows always the same records but
in different order:
SELECT * FROM banners GROUP BY user_id ORDER BY RAND();
first call
++-+---+
| id | user_id | title |
++-+---+
| 1 | 1 |
- Original Message -
From: Victor Pendleton <[EMAIL PROTECTED]>
Date: Wed, 31 Mar 2004 15:17:54 -0600
To: "muhammad alqama" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: starting mysql daemon
> Did you check in the hostname.err file to see why MySQL ended?
>
>
> On Wed, 31 Mar 200
Thanks for the reply. I was a little confussed on the exact defintion of a "line", I
thought it meant a whole row of data.
The space seperated fields worked great, but still gave me the error:
"ERROR 1054: Unknown column 'col1' in 'field list'
I could not find anywhere on how to define the "field
Daevid Vincent wrote:
Just make a symbolic link... Probably it's in /tmp
So as root,
"ln -vs /tmp/mysql.sock /var/lib/mysql/mysql.sock"
This is always an annoyance with mysql and redhat it seems. *sigh*
How exactly? I mean there cannot be a socket file in /tmp either,
because MySQL does not ev
After a bit of digging, found out that this is indeed a bug:
http://bugs.mysql.com/bug.php?id=1274
Strangely enough, it is listed as "CLOSED". Now - this is hard to
explain, but it looks like MySQL developers have no answer or interest
in dealing with this problem.
The fact is - adding an inde
Looking for some help on tuning my InnoDB settings. I received a InnoDB
deadlock.
>From analyzing show innodb status -->
* There were a ton of processes in the active status not doing anything.
* The log flushed up to was moving but the last checkpoint at was extremely
old.
Error in mysql error
I fugured out that I needed to put (name of col1, name of col2) instead of (col1,
col2).
Duhh Sorry
My question is, how can I take a log file that has 25 columns of data and tell mysql
to only load column 1, column 3, and column 7 from the raw log file?
Sorry for being so dense.
Thank
>Thanks for the reply. I was a little confussed on the exact defintion of
>a "line", I thought it meant a whole row of data.
>The space seperated fields worked great, but still gave me the error:
>"ERROR 1054: Unknown column 'col1' in 'field list'
>I could not find anywhere on how to define the "f
>My question is, how can I take a log file that has 25 columns of data and
>tell mysql to only load column 1, column 3, and column 7 from the raw log
>file?
I'm not sure mysql can do this. I'd be more inclined to use cut
on a Linux system in the following fashion:
cut -d ' ' -f 1,3,
Order by is working after the group stage.
You would need an aggregate function which chooses a random row.
Some other SQL implementations would not let you select a column that is not
also grouped (eg title) or in an aggregate function as in your select ...
group by ... example.
m
-Origin
You would need an aggregate concat() function I think its in 5.0
m
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 7:08 AM
To: MySQL
Subject: Is this possible?
I have 2 tables (looks best in fixed width font):
test_items
+---+--+
Hi,
GROUP_CONCAT() is in 4.1. :-)
Matt
- Original Message -
From: "m.pheasant"
Sent: Wednesday, March 31, 2004 5:26 PM
Subject: RE: Is this possible?
> You would need an aggregate concat() function I think its in 5.0
> m
>
> -Original Message-
> From: Chris Boget [mailto:[E
I can not seem to wrap my head around the string functions I will need to
work this issue out... MySql 4
I have a column 'tmp_date' that was imported from a messy data set, trying
to clean it up. The date is in the format of:
m/d/yy and mm/dd/yy
Somehow, I need to update a timestamp(14) column b
Hello,
Just found out that Webyog has released a RC of the
latest version of SQLyog. It includes Notification
Services that allows you to send formatted resultsets
over email.
Find more information at
http://www.webyog.com/forums/index.php?s=26b105e857a24ec61d9fb5138f17070b&act=ST&f=2&t=766&st=0#
040401 06:21:02 mysqld started
040401 6:21:03 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 10 4036416
InnoDB: Doing recovery: scanned up to log sequence number 10 4036416
0404
Hi,
I am working on mysql repliction on windows 2000.
I am trying to make the slave as master when the master goes down. When I
execute the io thread shutdown on slave after master goes down, it hangs.
Even the slave server does not stop on executing the shutdown command using
mysqladmin and
I¹ve got large data set. Each day I load in 8000 stocks, info about how they
did that day. So the primary key, an auto incrementing value, numbers them
in order.
But I¹d like to sort by Stock ticker, then pull the value from the next
day¹s price to stick at the end of a row for the current day¹s i
Hi All,
I have some questions about MySQL capability.
1. What's the max number of databases can be created in one MySQL server?
2. What's the max number of tables can be created in one database?
3. What's the best number of databases in one MySQL server?
4. What's the best number of tables in one
This is all dependent on your OS's unlimit sizes, FS INODE limit, and mySQL
table type. Generally is about 64K for databases and tables if you use
myISAM / LINUX / EXT3
--
DVP
> -Original Message-
> From: Mark.he [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 9:42 PM
> To: [E
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subject: urgent help need
Did you run out of disk space? If not what transaction model are you using?
Is it repeatable read? If so, are you allowing the transaction to finish
with a commit? If not your filling your transaction log and that's how your
getting this message. Call commit on the session OR SET AUTOCOMMIT=1 on
co
Hi,
if you are using 4.x or later you can use:
(select * from helpdesk where month(helpdesk.hdcreatedate) = 3)
UNION ALL
(select * from archived where month(archived.hdcreatedate) = 3)
LIMIT 0, 30;
/Johan
rmck wrote:
Hi
I have two tables in the same Db :
table 1:
helpdesk | CREATE TABLE `hel
Hi,
I am using release 5.
What is the release you recommend for such a scenario.
Regards,
Anup Mahansaria
"Dathan Vance
Pattishall"
> I have a column 'tmp_date' that was imported from a messy data set, trying
> to clean it up. The date is in the format of:
> m/d/yy and mm/dd/yy
>
> Somehow, I need to update a timestamp(14) column based on the tmp_date as
> the input.
Nice challenge ;-)
For MySQL 4.0.x:
SET @d='01/02/03';
SEL
77 matches
Mail list logo