Hi,
I'm using MySQL-Max-4.0.1-alpha on WinNT4SP6 with InnoDB as default
table type.
I have a database creation script like this:
//Section A
CREATE TABLE AParents (
Id int unsigned not null auto_increment,
Parent int unsigned not null,
primary key (Id),
index Parent (Parent)
) TYPE = I
Hi, all
recently, we compiled under mdk8 , then under rh6.2
version of mysql4.01 and also mysql4.02
sources as :
./configure --prefix=/usr/local/mysql --with-vio --with-opensssl=/usr/local/ssl
with-named-curses-libs=/usr/libs/libncurses.so.5
then make , make install, etc
all seems to work
Hi,
Im just wondering why MySQL ver 3.23.51 is not supporting LOAD DATA INFILE
syntax, I downgrade my server to the older one which is MySQL ver 3.23.44,
is there any bug about using it in the latest version?
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) (088
Victoria Reznichenko wrote:
>Sameh,
>Sunday, July 14, 2002, 3:09:53 PM, you wrote:
>
>SA> Can anybody help me figuring how to control granting users
>SA> permissions to created functions in MySQL like we do for SELECT,
INSERT,
>SA> ...etc or it is not possible and every one logged in
Hello All,
Can anybody tell me the query or procedure by which i
can generate the .sql file. So that I dont need to
write the query again and again on prompt.
Just by executing the .sql file(or script language), I
will able to create table, insert the data on table,
update the data..means whate
1) Had to change column types to match (names.uid and specialdays.uid
were different types, due to my inexperience with DB setup)
2) Once I had done that, this did exactly what I wanted:
SELECT sd.day, sd.month, sd.who, names.uid, names.email
FROM specialdays as sd
INNER JOIN names
ON names.uid
Hi Ian,
Could you give this kludgish SQL query a test-drive and let me know if
it helps? For all I know this may be very silly, in which case apologies for
sticking my neck into this expert discussion...
select
titleid
,avg(rating) as avg
,count(titleid) as votes
,avg
Hi,
Do you (as user 'mysql') have the rights (ugo) to write those files and
directories in the error messages?
--Aaron Axelsen wrote
i recently compilied mysql on my redhat 7.3 machine but when try to
start the daemon i get the following errors:
020715 23:40:08 mysqld started
020715 23:40:08
i recently compilied mysql on my redhat 7.3 machine but when try to
start the daemon i get the following errors:
020715 23:40:08 mysqld started
020715 23:40:08 /usr/local/mysql/libexec/mysqld: Can't create/write to
file '/usr/local/mysql/var/Alpha.pid' (Errcode: 13)
020715 23:40:08 /usr/local
On Monday, 15. July 2002 22:46, Chris Boget wrote:
>
> Of the data? Or of the queries?
>
Not the data. Just your query, the output from explain and a create table
statement.
Regards
Georg
-
Before posting, please check:
SELECT @totalVotes:=COUNT(titleid) FROM movieratings
Thanks for the reply.
Alas, the above query syntax gives me an error 1064.
--
Ian Evans
Chairman & Executive Producer
Digital Hit Entertainment
http://www.digitalhit.com
-
Can you send me the asp page as an attachment?
Nick
:> -Original Message-
:> From: Ivan Paul [mailto:[EMAIL PROTECTED]]
:> Sent: 16 July 2002 04:53
:> To: MySQL
:> Subject: problem when try to insert into mysql db using ASP
:>
:>
:> hi all,
:>
:> i have problem when try to insert into m
hi all,
i have problem when try to insert into mysql db using ASP.
my statement seems too many character, so do you have another way to solve
my problem?
this is my SQL command in ASP:
<%
dim cd, nm, mt, addr, ct, ps_cd, st, tel, fax, eml, hm_pg, ct_prs, lc_no,
rg_no
dim objconn, objrs
dim
SELECT sd.month, sd.day, names.who, names.uid, sd.type
FROM specialdays as sd
INNER JOIN names
ON names.uid = specialdays.uid
WHERE sd.month=6 AND sd.day=5
Give that a whirl to start with. I've assumed the field on the specialdays
table that links to the names table is also called uid. Or are
I'm trying to write my first shell script using MySQL. I've checked
Welling & Thomson and Google but I think I'm searching the wrong
keywords or something.
The shell script will be non-interactive, but interactively this is what
I would do:
mysql> select * from specialdays where month="6"
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ian M. Evans wrote:
| -Original Message-
| From: Andrew K-C [mailto:[EMAIL PROTECTED]]
| you might be able to do a "ORDER BY weighted DESC" to get them to come out
| in order of weight
|
| Thanks...I'll give that a
<<<
Can you run the query from mysql interface?
>>>
Yes.
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manu
Question: is there anything I need to be aware of when writing dump
files to a local directory for my user, I'm having the following
problem.
1.
I create a directory in my own home directory (linux, red hat 7.2)
~/dumps and give it 777 permissions
2.
I run " /usr/local/mysql/bin/mysqldump -ur
Look at the GRANT documentation to see how mysql authenticates using host and user.
-Original Message-
From: Nitesh Divecha [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 5:47 PM
To: [EMAIL PROTECTED]
Subject: MyODBC Error
Sensitivity: Confidential
Hello All,
I have my MySql 3.
Hi,
i installed MySql -Max 3.23.51 on Winodows 2000, but when I try initiate
it appears the following error:
MySql service can´t be initialized
System error 1067
The process finished suddenly
Some help please?
Elby.
Brazil.
--
This seems to have not gotten through... Perhaps the spam filter ate it?
(sql, query)
-JF
> -Original Message-
> From: Jon Frisby [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 15, 2002 4:27 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.0.2 replication going bonkers?
>
>
> We recently
Hello All,
I have my MySql 3.23 running, I installed MyODBC in my Win98 PC and created a DSN for
MySql.
When I use MS Access to connect to MySql I get an Error saying "Host 192.168.1.103 is
not allowed to connect to this MySql Server".
I also tried connecting using telnet 192.168.1.109 3306 I
Hi there,
I am creating a tracking system for the consumables we give
away to our staff. It is working but I need to know if there is a better practice than
I what I did
I need to print reports via a website so I used ASP
It needs name,product, amount per item, price per item and total per
We recently set up a 4.0.2 slave, which worked fine -- we loaded our data
snapshot (taken via mysqldump) and were able to perform complex queries
without problems...
However, as soon as we tried to get this machine to act as a slave to a
4.0.1 server it crashed. Immediately upon executing "SLAVE
On Mon, Jul 15, 2002 at 10:21:25PM +0100, Nick Middleweek wrote:
> Hello,
>
> Here's what I'd like to do...
>
> * Create a new user in mysql.
See the "GRANT" command in the manual.
> * Let them login and create a new database.
Ditto.
> * I want this database to be only viewable by the
>
At 01:01 PM 7/15/2002, David yahoo wrote:
>how to retrieve the 2 last char of a string stored in db ? :
>
>SELECT LENGTH(db) as len , SUBSTRING(db from len-2 ) from nlconfig;
>
>NOT WORK .!
>
>In php by example, there is a substr with a negative pos that give char at
>end ! no in mysql !
sele
Lo all,
Can MySQL bind to two or more IP addresses?
i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y
?
Thanks,
--
me
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
-Original Message-
From: Andrew K-C [mailto:[EMAIL PROTECTED]]
you might be able to do a "ORDER BY weighted DESC" to get them to come out
in order of weight
Thanks...I'll give that a try...
Hmm, the only problem with that query is that it doesn't get it quite
InnoDB COULD help if there's an issue with table locking and intense
concurrent multi-user access. InnoDB's row level locking should help with
this. Some queries will be faster with InnoDB and some will be slower. For
instance, select count(*) from table_name will do a full table scan with
InnoDB.
Can you post your query along with the output of explain?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:45 PM
To: Cal Evans; [EMAIL PROTECTED]
Subject: Re: MyISAM v. InnoDB
> s
Hi there,
I am creating a tracking system for the consumables we give
away to our staff. It is working but I need to know if there is a better practice than
I what I did
I need to print reports via a website so I used ASP
It needs name,product, amount per item, price per item and total per o
You know, I am knew to MySQL and I was reading the docs where it talks
about my.ini file and couldn't make it heads or tales out of it.
I guess I will read it again and hope it makes sense.
Thanks for your help!
-Original Message-
From: Tam, Michael [mailto:[EMAIL PROTECTED]]
Sent: Mon
Hi David,
| how to retrieve the 2 last char of a string stored in db ? :
| SELECT LENGTH(db) as len , SUBSTRING(db from len-2 ) from
| nlconfig;
You could try,
select substring(db, length(db) - 1, 2) from nlconfig;
The SQL you wrote would perhaps not work in any database.
On Mon, Jul 15, 2002 at 04:55:18PM -0300, Alexander Burbello wrote:
> Hi,
>
> anybody have any presentation showing about mysql.
>
> For example topics: History, Phisical structure, Logic
> structure, etc.
>
> I need to make a presentation about mysql.
>
> If somebody could help me. I would ap
Hi Otoniel,
I am running w2k as well. Check if your mysql startup properly. One
thing you may want to check is whether you have specify the log_dir and
data_dir for Innodb in your my.ini file, and that you've made those dirs in
the file system.
Hope this help.
Cheers,
Michael
-O
On Sun, Jul 14, 2002 at 07:21:59PM +0200, Raymond Hamaker wrote:
> Hi all,
>
> When i use MS access 2000 with odbc to fill my MySQL db(running on linux)
> auto_increment seems not to work .
"Does not seem to work" doesn't help us help you.
What did you try to do?
What did you expect to happen?
Hi Mark,
Thank you for your speedy response. I'd appreciate if you can put this
feature the request list. Many thanks.
By the way, is there a way I can access this metadata through sql ??
Best regards,
Michael
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Se
Hello,
Here's what I'd like to do...
* Create a new user in mysql.
* Let them login and create a new database.
* I want this database to be only viewable by the
user that created it and also the mysql administrator.
* I would like that user to be able to create users as
well but they can
On Monday, 15. July 2002 20:28, Paul W. Reilly wrote:
Hello Paul,
maybe http://www.mysql.com/doc/D/a/Date_and_time_functions.html could answer
your question (Function week() )
Regards Georg
> Trying to count weeks! I am doing a personal accounting system in
> php/mysql. I have a report sect
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tam, Michael wrote:
| Hi all,
|
| I tried to use mm.mysql (2.0.14) to access the tables in mysql
| (3.23.51). I can't retrieve metadata like tables' comment through the
| following code:
|
| // get connection
| conn=ds.getConnection();
|
| // get
I believe the timestamp field needs to be nullable, but you shouldn't have
any issue selecting a char. Can you run the query from mysql interface? If
you can, than I would suspect that ADO is the culprit, try using straight
ODBC instead.
I hope this helps...
Pat...
- Original Message
Your /tmp directory is only accessible by root? What distribution are you
using? /tmp is normally world readable/writeable. I would think you'd have
problems with other software, too, if this wasn't setup correctly.
--jeff
- Original Message -
From: "Rob Lambden" <[EMAIL PROTECTED]>
To:
> switching to InnoDB won't help. Take a look at optimizing your
> queries. Are you using LIKE?
In some queries, not all.
> have you looked at the output of EXPLAIN?
Yes, but I don't understand much of what it really means.
Chris
MySQL
---
>> When dealing with a considerable number of records (10s of
>> thousands) in a particular table, which is better to use? Currently
>> we are using MyISAM and the queries on those tables are kind of
>> slow.
> Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the
>> When dealing with a considerable number of records (10s of
>> thousands) in a particular table, which is better to use? Currently
>> we are using MyISAM and the queries on those tables are kind of
>> slow.
> Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the
On Mon, Jul 15, 2002 at 01:52:46PM -0500, Chris Boget wrote:
>
> When dealing with a considerable number of records (10s of
> thousands) in a particular table, which is better to use? Currently
> we are using MyISAM and the queries on those tables are kind of
> slow.
Really? That's not a lot of
we are considering moving to a 4-way system as the load average on our
2-way system is at 2.
Does anyone have recommendations? Is the larger 1MB cache on some xeon
chips worth the extra $$$?
I'm thinking of 2 raid1 arrays, one for the os and logs, the other for
the db. The data is relatively s
switching to InnoDB won't help. Take a look at optimizing your queries. Are
you using LIKE? have you looked at the output of EXPLAIN?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15,
[snip]
I created a dummy table for this and used your select statement:
mysql> SELECT titleid, (AVG(rating) / COUNT(titleid)) AS weighted
-> FROM movieratings
-> GROUP BY titleid;
+-+--+
| titleid | weighted |
+-+--+
| 1 | 0.288000 |
| 9 | 0.0727
[snip]
What do you mean by weighted? Taking into account the number of votes for
each and then weighting them against each other?
[/snip]
Yes, essentially each individual movie will show its raw average (people
think this movie is a 7/10) while an overall top rated list will take into
affect that
Hi!
Thank you for your test case, thanks to which a bug was fixed when
--bind-address option is used.
Fix will be implemented in next MySQL versions, but this is a patch
that fixes it:
= mysqld.cc 1.321 vs edited =
*** /tmp/mysqld.cc-1.321-14677 Mon Jul 1 11:38:44 2002
--- edited/mys
I've compiled fltk and fl_editor successfully. But I can't find edfile.o to compile
mysqlgui.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
how to retrieve the 2 last char of a string stored in db ? :
SELECT LENGTH(db) as len , SUBSTRING(db from len-2 ) from nlconfig;
NOT WORK .!
In php by example, there is a substr with a negative pos that give char at
end ! no in mysql !
Hi,
anybody have any presentation showing about mysql.
For example topics: History, Phisical structure, Logic
structure, etc.
I need to make a presentation about mysql.
If somebody could help me. I would appreciate
Alexander
sql, query
___
Hi all,
I tried to use mm.mysql (2.0.14) to access the tables in mysql
(3.23.51). I can't retrieve metadata like tables' comment through the
following code:
// get connection
conn=ds.getConnection();
// get metadata
dbmd=conn.getMetaData();
//get resultset for all tables metadata
rs = dbm
Hello,
I have noticed that MySQL server almost hangs up the system while
processing a big table (perl script using fetchrow).
I didn't experienced this before - may be it's because of LinuxThreads?
MySQL launches 38 running processes, but shows only 10 mysql query
threads (they are all sleeping
Is there an upper limit on the number of indexes in InnoDB tables in MySQL?
I can't find anything about it in their documentation at www.innodb.com
I am designing a database where one table has around 70 keys so far.
yes, it's normal, and all of those keys are commonly searched on.
thanks
sean p
I am sorry. I should have paid more attention to Heikki email.
Nilesh
-Original Message-
From: Philip Molter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:43 PM
To: Nilesh Shah
Cc: [EMAIL PROTECTED]
Subject: Re: Replication from InnoDB -> MyISAM
On Mon, Jul 15, 2002 at 02:40
When dealing with a considerable number of records
(10s of thousands) in a particular table, which is better
to use? Currently we are using MyISAM and the
queries on those tables are kind of slow. I've set the
most frequently used (in a query) columns as keys and
that isn't speeding it up any.
Alternatives for creating InnoDB tables:
1) When you start mysql, you can pass a parameter to set
default-table-type=InnoDB; Then, when you create tables, InnoDB type table
is the default type, or
2) In order to create InnoDB type table, you need to create the table in the
following way:
CREATE
On Mon, Jul 15, 2002 at 02:40:14PM -0400, Nilesh Shah wrote:
: How does transaction works in this scenario?. Is rollbacked transaction
: written into bin-log files?.
To quote Heikki from below:
MySQL only writes committed transactions to the binlog, and consequently
only replicates committed
How does transaction works in this scenario?. Is rollbacked transaction
written into bin-log files?.
Nilesh
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 1:30 PM
To: Philip Molter; [EMAIL PROTECTED]
Subject: Re: Replication from InnoDB -> My
Hi,
Thanks for all the help. Appreciate it.
cheers,
Ki Mien
-Original Message-
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 8:24 PM
To: "Ki Mien" <[EMAIL PROTECTED]>, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>
Subject:Re: Innodb
Ki,
please consult
Trying to count weeks! I am doing a personal accounting system in
php/mysql. I have a report section that groups and calculates expenses into
running totals, so that I can see total amount spent in each category. I
would like to add a break down to this that will show me the average weekly
amou
Jay -
Here is the table structure. If I include the MEM_Code field, the ODBC SELECT
throws and exception, but I can understand that since CHAR is usually a one
character field. The MEM_Change_Date field is another story. When it is
included, the result is empty. Strange?!?
Todd
#
# Table st
I am looking into using the mysqlhotcopy.pl script to back-up my
databases. When I try to run it, I get the following error:
The getpwuid function is unimplemented at
C:\mysql\scripts\mysqlhotcopy.pl line 79.
I'm not familiar enough with perl to even begin debugging the script
myself.. Does a
The problem with this limit, is that the search will occur from many
different sources, each of these will not be privy to the last limit set.
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:52 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
On Sun, 2002-07-14 at 03:59, karl wrote:
> Hello,
> I need help. I am trying to insert into TABLEA records from TABLEB where the
>records do not exist in TABLEA (the primary key in TABLEA works fine). I am trying
>to limit the result set each time (as an example to 10 records from TABLEB).
> T
Hi
I want to write sql query to duplicate a row. It has a PRI key called ID.
The MySQL database looks like
IDNameAddress
345 Aman42, sb
346
347...
I want to duplicate the ID=345.
Any suggestions ?
Thanks in advance.
Aman
__
Have any of you guys come across this,
http://www.firstworks.com/sqlrelay.html, as a way of managing fault
tolerance from clients accessing mysql databases?
Richard
-
Before posting, please check:
http://www.mysql.com/manu
Hello,
I ve got mysql 4.0.1
I don't understand what happen.
I use to make replace other than insert in order to avoid error in php
scripts.
I have a table with on primary key :
CREATE TABLE `nlconfig` (
`id` tinyint(4) NOT NULL auto_increment,
`nomnews` varchar(255) NOT NULL default '',
`
Philip,
- Original Message -
From: "Philip Molter" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, July 15, 2002 5:55 PM
Subject: Replication from InnoDB -> MyISAM
> I have a 3.23.51 server with InnoDB tables. I want to replicate
> one of the databases over to some
On Fri, 2002-07-12 at 22:41, Richard Clarke wrote:
> So this works as expected,
>
> mysql> create table test_1 (id int,value char);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> create table test_2 (id int,val char);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into test_1 value
For the life of me I can not figure out why I can not create or change
my tables from MyISAM to InnoDB.
I create the table with InnoDB and MySQL creates the table as MyISAM.
I am using MySQL-max-nt. Any ideas how I can change the tables or even
create them as InnoDB for that matter?
Thanks in
[snip]
Not wanting to reinvent the wheel here, I wonder if anyone else has ever
done a rating system.
There'll be two columns: title_id for the title of the movie being rated and
then a rating from one to ten.
What would be the most efficient SQL statement to find a title's weighted
average?
[/s
Check the list. This question has been asked before many time.
You can set net_read_timeout variable to bigger value to avoid this
problem.
Still no one knows (or answered) impact of net_read_timeout and
wait_timeout. which one takes precedence.
Nilesh
-Original Message-
From: Santia
But timestamp type will change on every update. I only want the default
value to be the current time/date when the row is inserted and then not
change.
>From: Georg Richter <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED], "Shawn Poulson" <[EMAIL PROTECTED]>,
>[EMAIL PR
At 04:26 AM 7/15/2002, David Harper wrote:
> >Description:
> Every 60 seconds, the replication slave gets an error 1159 from
>the master server. Thirty seconds later, it reconnects to the master.
>Then the cycle starts all over again. I have master-connect-retry=30 in
>the config file.
>
>
Thanks for the response! Actually, we did notice the on delete null issue,
and we even found another. Basically, we have been using PostgreSQL
(yikes!), and it just wasn't as 'smart' as MySQL w/ InnoDB. We could
actually create foreign keys on tables that didn't even exist yet! But!
MySQL to the r
On Monday, 15. July 2002 16:51, Shawn Poulson wrote:
Hi,
> I'm having trouble doing this in MySQL, but it keeps complaining. All I
> have to work on is:
> create table mytable (
>createddate datetime not null default now()
> )
>
Just use timestamp instead datetime.
Regards
Georg
mysql,q
Shawn,
Monday, July 15, 2002, 5:51:01 PM, you wrote:
SP> I'm new to this list and MySQL, so I hope this question isn't too
SP> rudimentary.
SP> In SQL Server I was able to create a datetime field that used the default
SP> getdate() function so that I woudl get timestamps on all created rows
S
Bhavin,
Monday, July 15, 2002, 7:39:52 PM, you wrote:
BV> I did a select * as such:
BV> mysql> select * from Sqs;
BV> +-+-++
BV> | RecordState | Sqs | SqsKey |
BV> +-+-++
BV> | L | unknown | 1 |
BV> +-+---
Sameh,
Sunday, July 14, 2002, 3:09:53 PM, you wrote:
SA> Can anybody help me figuring how to control granting users
SA> permissions to created functions in MySQL like we do for SELECT, INSERT,
SA> ...etc or it is not possible and every one logged in to MySQL could
SA> simply use them like a
root,
Monday, July 15, 2002, 6:05:54 PM, you wrote:
r> Does Mysql support stored procedures ?
No, MySQL doesn't yet support stored procedures.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensit
Roman,
Monday, July 15, 2002, 8:07:07 AM, you wrote:
RV> When mysqld-max-nt.exe is started with options
RV> --console --standalone
RV> and after issuing "mysqladmin -u root shutdown"
RV> mysqld reports a shutdown, but does not exit.
RV> mysqld-max don't have this problem.
RV> OS Windows 2000.
Haany,
Sunday, July 14, 2002, 6:16:30 AM, you wrote:
HB> i am just installing the new mysql 3.23.51 for my
HB> linux 7.3.
HB> The problem is after unzipping the tar.gz file and
HB> running the mysql_install_db (which runs perfectly),
HB> when i tried to run the safe_mysql &, the mysqld is
HB>
Not wanting to reinvent the wheel here, I wonder if anyone else has ever
done a rating system.
There'll be two columns: title_id for the title of the movie being rated and
then a rating from one to ten.
What would be the most efficient SQL statement to find a title's weighted
average?
Many than
Yes, I have a cluster installed with 3.23.49 and I have any problem. Now, I
am installing a new cluster with 3.23.51 version and it's appearing these
problems.
Could anybody help us?
Thanks in advance.
Santiago.
- Original Message -
From: Pierre Baridon <[EMAIL PROTECTED]>
To: David Ha
On Monday, 15. July 2002 15:28, Daniel BI wrote:
> Hola listeros :)
Hola!
please write in english, or use the spanish mailing list
([EMAIL PROTECTED])
Thx
Georg
-
Before posting, please check:
http://www.mysql.com/manual.
Hello!
The regexp to match only 2 occurences of ';' would be:
regexp '^[^;]*;[^;]*;[^;]*$'
to find the number of ';' I only have an idea for something complicated:
length() - length(replace(,';',''))
StephanieTan wrote:
>Hi all,
>I am looking for a way to count the number of a character occu
> I have been trying to use the LOAD data command to load the data
instead of using the sql insert into table. It works fine but I have
got some warnings, how can I see these warnings, is there a log for
it, how can I see these warnings, is there a log for it?
---
I'm using version 3.23.53 on Win 2k.
The same things happens to me.
I've also noticed that if you don't specify a WHERE clause and you have a
Auto-incrementing ID field, it is reset to zero and the next record you
create starts at 1 again.
Surely this is wrong as well? In Other RDBMS's after DE
Hello all,
I'm new to this list and MySQL, so I hope this question isn't too
rudimentary.
In SQL Server I was able to create a datetime field that used the default
getdate() function so that I woudl get timestamps on all created rows
automatically, like:
create table mytable (
createddate
http://www.mysql.com/doc/D/E/DELETE.html
"In MySQL 3.23, DELETE without a WHERE clause will return zero as the number
of affected records."
Alain Fontaine
Consultant & developer
VAlain S.A.
http://www.valain.lu/
-Message d'origine-
De : Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Envoyé : lu
I've built a whole program with vb6 and mysql database back end. Never had
any problems. I used the mysql odbc for windows to access the database. What
are you using?
Matthew Scarrow
ComIT Solutions Inc.
www.comit.ca
Phone: 519-442-0100
Fax: 519-442-0429
-Original Message-
From: Carlo
- Original Message -
From: "Ralf Narozny" <[EMAIL PROTECTED]>
To: "Bhavin Vyas" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 9:16 AM
Subject: Re: Interesting
> Bhavin Vyas wrote:
[snip]
> Hello!
>
> Whenever deleting without a WHERE clause, there's always thi
i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51
Pierre
- Original Message -
From: "David Harper" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 1:26 PM
Subject: Replication slave repeatedly gets error 1159 from master
> >Description:
>
This is a known "problem", not a bug in mysql.
You can get the affected rows by entering this sql statement: "delete
from Sqs where 1>0"
Greetings, Richard
-Ursprüngliche Nachricht-
Von: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 15. Juli 2002 16:16
An: Bhavin Vyas
Cc:
Hi all,
I am looking for a way to count the number of a character occurrences in a
string with MySQL. For example, I have this string "1;333;72227;00;19;1;1;"
and I would like to return the number of ";" found in this string. Is this
possible?
Also, I wanted to return fields that contain EXACTLY 2
I have a 3.23.51 server with InnoDB tables. I want to replicate
one of the databases over to some 3.23.49 servers with MyISAM tables.
The tables do have some auto-increment columns. I expect that only
valid data is going to be written to the binlog, so the
1 - 100 of 134 matches
Mail list logo