> Hi Don,
>
> No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just
> added boolean searches along with more speed overall). It doesn't need
> to be compiled in or anything, it's there by default. Unless someone
> compiled it and actually *removed* the full-text code or something
Hi Don,
No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just
added boolean searches along with more speed overall). It doesn't need
to be compiled in or anything, it's there by default. Unless someone
compiled it and actually *removed* the full-text code or something. :-)
Also
i think u have to compile it in as an option, it doesnt as default, i
wouldnt be suprised if Mysql 4 did a better job though, trying to convince
work to upgrade all machines to Mysql 4 hopefully 4.1 is a task in itself.
>
> Hi, thanks for your reply, but it looks like:
>
> > As of Version 3.23.23,
Hi, thanks for your reply, but it looks like:
> As of Version 3.23.23, MySQL has support for full-text indexing and
searching.
--according to:
http://www.mysql.com/doc/en/Fulltext_Search.html
However, I would be unsurprised (though disappointed) to find that the
answer is some variant of "thi
Paul DuBois wrote:
At 15:02 -0700 2/25/04, Colleen Dick wrote:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD("secret")
Having altered nothing regarding encryption i
Maybe i'm wrong here, someone correct me, if its just int's you are gonna
use set the field types to bigint it may search faster you are doing a
character search, to get there quicker in a text search scenerio i'd
suggest mysql4 and full text searching MATCH AGAINST
> I've got a query that I can
I've got a query that I can't seem to get optimized, so I'm
hoping someone here can spot something I've missing!
Table has three columns:
CoordID int unsigned,
Zip_Lo char(9),
Zip_Hi char(9)
Table has 3 million records
indexes:
acg_lo (Zip_Lo)
acg_hi (Zip_Hi)
acg_combined (Zip_Lo, Zip_Hi)
Say I have this query:
SELECT *
FROM topics
ORDER BY lastPostTime DESC;
How would I modify it to answer the question "How many rows would be
returned before the row that has topics.id = $x"?
I was thinking of something like this:
$xPostTime = SELECT lastPostTime FROM topics WHERE id = $x;
SELE
At 15:02 -0700 2/25/04, Colleen Dick wrote:
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD("secret")
Having altered nothing regarding encryption in the server
what is
Something like that:
SELECT - INTO OUTFILE '' FROM Table etc etc ;
Marcelo Araujo
On Wednesday 25 February 2004 21:50, Lorderon wrote:
> Hello All,
>
> How can I dump selected rows into a file (using a query or mysqldump)?
>
> i.e, I want to dump only the rows of this query:
> SELECT * FR
Tried to make the indexes separate and did an EXPLAIN and no performance
increase and this is what the explain says:
id select_type table typepossible_keys
key key_len ref rowsExtra
1 SIMPLE tb ALL PRIMARY,tb_ndx3,tb_ndx4,tb_ndx5
NULLNU
Hello Everyone,
If I run the following query in MySQL Control Center or MySQL-Front it
works correctly,
SELECT -1 AS ProductID, "Add New Part" AS PartNumber, "" AS
VendorPartNo, "" AS Description, "" AS VendorStatus
FROM Products
UNION SELECT ProductID, PartNumber, If(SubNo=1135,
VendorPart,A
At 2:50 +0200 2/26/04, Lorderon wrote:
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT * FROM tbl WHERE id>100 AND id<200;
mysqldump --help shows that it takes a --where / -w option.
So:
mysqldump -w "id>1
Hello All,
How can I dump selected rows into a file (using a query or mysqldump)?
i.e, I want to dump only the rows of this query:
SELECT * FROM tbl WHERE id>100 AND id<200;
thanks in advance,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hi Bruce,
On Thu, 2004-02-26 at 06:26, Bruce Dembecki wrote:
> Hi! One of my associates here read a report somewhere that mysqld when
> compiled under OS X 10.3 was 40%+ more efficient due to improvements in the
> compilers and the way 10.3 work. Also 10.3 is a 64 Bit Operating System and
> it wou
Bruce Dembecki wrote:
Hi! One of my associates here read a report somewhere that mysqld when
compiled under OS X 10.3 was 40%+ more efficient due to improvements in the
compilers and the way 10.3 work. Also 10.3 is a 64 Bit Operating System and
it would be a major benefit to us to set some of the m
Rogers, Dennis wrote:
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql> describe ads;
+---+---+--+-+++
Hi folks,
my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in ta
Stanton, Brian wrote:
I'm currently running mysql 4.0.13 on red hat 7.2. The following create
table query currently requires the user to use SET SQL_BIG_TABLES=1 for the
query to go through on the master successfully. However, that doesn't seem
to get set when the slave tries to replicate the cre
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040225 13:57:22 InnoDB: Log file ./ib_logfile
I think that you can just do this:
select sum(ads.col)*1.191*sum(ads.depth)/131.77 where date ='2004-02-26'
AND editionID = '13' AND ads.page = '16';
because of the disttributive property of multiplication.
(2 * 1.191) +(6*1.91) +(4*1.91)/131.77 = 12 *1.91/131.77 =
(12*1.91)/131.77 = 12*(1.91/
You might want to post this on the PHP user lists at news.php.net sub-group
php.general
Respectfully,
Ligaya Turmelle
""David Jackson"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I was wondering if I can user libmysqld with PHP.
>
> If it's possible would someone post a simple
Excuse if i'm not correct but this may be your problemo ?
MySQL 3.23.55 running on my webhost's Linux box
phpMyAdmin 2.1.0
I didnt think fulltext was in 3.23 wasnt this a Mysql 4 feature ??
> Summary: When I run a fulltext search, it always returns no results. I
> have added a fulltext index
Summary: When I run a fulltext search, it always returns no results. I have
added a fulltext index to the column being searched. Also, I am searching
for a term that is in the table, but not in more than 50% of the rows.
I notice that when I add EXPLAIN to my search, the key_len of my fulltext
I'm sure this is in the manual somewhere or in the archives, but
I'm not finding it and I bet someone easily knows the short answer:
Using 3.23
setting a varchar field to PASSWORD("secret")
Having altered nothing regarding encryption in the server
what is the default encryption type for PASSWORD?
c
Thanks so much!!
SELECT (SUM(( ads.col * 1.91) * ads.depth ) / 131.77) * 100
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 5:55 PM
To: Rogers, Dennis
Cc:
What about
SELECT (SUM( ads.col * 1.91) * ads.depth ) ) / 131.77
FROM ads
WHERE date = '2004-02-26'
AND editionID = '13'
AND ads.page = '16'
>> Original Message <<
On 2/25/04, 4:19:12 PM, "Rogers," Dennis <[EMAIL PROTECTED]> wrote
regarding Query help - add res
What is the preferred way of storing a dollar amount in the range
0.00 - 9.99?
double
decimal(11,2)
bigint (storing value*100)
...?
I'm more interested in speed of use as an indexed column (especially
for range searches) than in disk space usage.
-keith
--
MySQL General
Hello List:
I have installed MySQL Master Server from Binaries 4-5 times without
problem. Now I am installing MySQL CLIENT from source and have run into
problem, as explained below:
Download "mysql-5.0.0-alpha.tar.gz" in /usr/local
% cd /usr/local
% gunzi
I know Oracle likes the indexes separatly, but mySQL might like combinations.
> No, we tried individual indexes and then one big grouped index but not
> individual indexes on each of the fields. Adding the index actually
> added a few seconds to the query so we weren't sure if that was the way
>
No, we tried individual indexes and then one big grouped index but not
individual indexes on each of the fields. Adding the index actually added a
few seconds to the query so we weren't sure if that was the way to go.
I'll try this, though.
Eric
At 10:36 AM 2/25/2004 -0800, Daniel Clark wrote:
Good afternoon,
How can I take the 3 results below add them together then divide by
131.77?
Can it all be done in one SQL statement?
Thanks in advance.
mysql> describe ads;
+---+---+--+-+++
I'm currently running mysql 4.0.13 on red hat 7.2. The following create
table query currently requires the user to use SET SQL_BIG_TABLES=1 for the
query to go through on the master successfully. However, that doesn't seem
to get set when the slave tries to replicate the create table statement.
I
Yes.
[EMAIL PROTECTED] wrote:
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
Original Message <<
On 2/25/04, 3:28:58 PM, James Lamanna <[EMAIL PROTECTED]> wrote
regarding Re: Problem with indexes:
Found out that the p
At 02:06 PM 2/25/2004, you wrote:
Hi,
Currently our web infrastructure has one main MySQL server, to which
connections are made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application
servers on other servers (which have persistant connecti
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
>> Original Message <<
On 2/25/04, 3:28:58 PM, James Lamanna <[EMAIL PROTECTED]> wrote
regarding Re: Problem with indexes:
> Found out that the problem was act
Found out that the problem was actually a bug in 4.0.17.
Upgrading to 4.0.18 seems to have fixed the problem.
Noted here:
http://bugs.mysql.com/bug.php?id=2446
[EMAIL PROTECTED] wrote:
Can you do a show create table Table1 and see how the index is defined?
Original Message <<
I'm about to pull my hair out on this one so I thought I would see if
somebody could point me in the right direction.
I have a subquery that like like so.
SELECT *
FROM Word
INNER JOIN DomainWord
USING ( word )
INNER JOIN Domain
USING ( domain )
WHERE Domain.domain = ANY(
SELECT Domain.domain
Cliff Addy wrote:
I've got on that really has me stumped ...
I've modified tha analog web stats program before to use a mysql database
before and I'm trying to do it again on a new system. I have this
function:
void db_connect(){
printf("start connect\n");
mysql_init(&dbh);
if (!mysql_re
A Z wrote:
I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.
We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs. This
is done in the transaction context. Most of the time
it works fine but it does get into problem. W
HACKATHORN, TODD (SWBT) wrote:
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import cu
Hi! One of my associates here read a report somewhere that mysqld when
compiled under OS X 10.3 was 40%+ more efficient due to improvements in the
compilers and the way 10.3 work. Also 10.3 is a 64 Bit Operating System and
it would be a major benefit to us to set some of the memory values in excess
My bad people. The error was elsewhere in the query, but the error
happenned to describe the query as failing near where the apostrophe was.
Sorry to waste anyone's time.
Larry
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 2:25 PM
To: M
Hi,
Currently our web infrastructure has one main MySQL server, to which connections are
made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application servers on other
servers (which have persistant connections,
and do both reads and writes
>Description:
When a temp table is included twice in a query mysql fails with the
error:
ERROR 1137 at line 9: Can't reopen table: 'foo'
This happens on both 4.0.17 and 4.0.18. It did not happen on 4.0.14.
>How-To-Repeat:
create temporary table test (pk int primary key);
select * from test as
On 25 Feb 2004 at 13:09, Eric Scuccimarra wrote:
> Select*
> FROM Table1 as a
> INNER JOIN Table2 as b ON (a.ID = b.ID or (a.Field1 = b.Field1 and
> a.Field2 = b.Field2)) WHERE bla bla bla
It's hard to know without seeing the indexes and the full WHERE
clause, but part of th
Are you not able to do
SELECT *
FROM table
WHERE col = "O\'Brien"
?
>> Original Message <<
On 2/25/04, 1:25:06 PM, Larry Brown <[EMAIL PROTECTED]>
wrote regarding command line escape for apostrophe:
> I usually use php for most of my work, but I have to run a
At 14:25 -0500 2/25/04, Larry Brown wrote:
I usually use php for most of my work, but I have to run a fair percentage
of maintenance etc from the mysql shell program. I have a record that has
an apostrophe and so was inserted using php by escaping the ' with \ so that
it was put in as \' and it s
Can you do a show create table Table1 and see how the index is defined?
>> Original Message <<
On 2/25/04, 12:02:43 PM, James Lamanna <[EMAIL PROTECTED]> wrote
regarding Problem with indexes:
> So I'm having issues with indexes in mysql 4.0
> I issue the follow
Are you using the DTS to schedule replication or periodic data imports?
>> Original Message <<
On 2/25/04, 11:48:02 AM, "HACKATHORN," TODD "(SWBT)" <[EMAIL PROTECTED]> wrote
regarding updating tables in MySQL:
> Hello,
> Sorry if this is a obvious question, but
At 02:32 2/25/2004, Jonas Lindén wrote:
>Hello, Could someone help me with a tip on how I can convert my old Access
>DBs to MySQL?
>
>Regards
>/Jonas
I've had some success with Cynergi.net's ExportSQL script
http://www.Cynergi.net/exportsql/
Start Here to Find It Fast! -> http://www.US-Webmaste
I usually use php for most of my work, but I have to run a fair percentage
of maintenance etc from the mysql shell program. I have a record that has
an apostrophe and so was inserted using php by escaping the ' with \ so that
it was put in as \' and it shows up in the record as O'Brien as it shou
Jonas
Check out the free DBManager at http://www.dbtools.com.br/EN/dbmanager.php
It can not only import directly from Access but might be very handy later in
your every day work with MySQL as a front-end
Couldn't live without it !
Freddie
-Ursprüngliche Nachricht-
Von: Jonas Lindén [ma
Do you have separate indexes on:
Table1.ID
Table2.ID
Table1.Field1
Table2.Field1
Table1.Field1
Table1.Field2
> Select*
> FROM Table1 as a
> INNER JOIN Table2 as b ON (a.ID = b.ID or (a.Field1 = b.Field1 and
> a.Field2 = b.Field2))
> WHERE bla bla bla
>
> We ha
What does the explain look like?
-Original Message-
From: Eric Scuccimarra [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 1:03 PM
To: [EMAIL PROTECTED]
Subject: Query Problems
I am doing a very simple query joining two copies of tables with identical
structures but differ
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
T
I am doing a very simple query joining two copies of tables with identical
structures but different data. We are running MySQL 4.1.1.
The tables each have about 24,000 lines of data in them. For some reason
this query, which is a simple join between the two tables is taking 8
minutes to run.
T
So I'm having issues with indexes in mysql 4.0
I issue the following:
Create Index Index1 on Table1 (ParentID,ClassID,Amount,Memo(20));
That works fine. However I'm running into problems when I'm trying to
insert into this table using INSERT I'm receiving errors about duplicate
keys against this
On 25 Feb 2004 at 8:35, Tucker, Gabriel wrote:
> What values of MAX_ROWS and AVG_ROW_LENGTH would I need so that I
> could limit this table to 3 [or n] number of records?
You can't. That's not what MAX_ROWS and AVG_ROW_LENGTH are for.
They're only there to allow MySQL to decide how many bytes
Hello,
Sorry if this is a obvious question, but I am new to mySQL, and PHP. I am
used to working with MS SQL Server 2000 and coldfusion. In SQL server I can
build DTS packages and schedule them to update the data in my tables with
different queries, and to import current data from other databases
Hi,
I have a strange problem in the return types of the query:
select count(*) from table gives in MySQL Version 4.0.18 an return
type of long. In Version 4.1.1 its an char ("0").
The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see
the different return types.
Does anyone know abou
We've recently started using MySQL for customers with a large number of
records on their systems.
For the first time, one of our customers has gone over the 4 million
record mark, and we're running into some problems with the MAX_JOIN_SIZE
and the SQL_BIG_SELECTS. Using the control center, or c
That works. I knew I was missing something simple. It was the GROUP BY
and the HAVING together.
Thank you very much.
>>> Michael Stassen <[EMAIL PROTECTED]> 2/25/2004 9:05:34 AM
>>>
Jacque Scott wrote:
> My program, NCR (Non-Conformity Report), keeps track of problems
with
> items that are r
Jacque Scott wrote:
My program, NCR (Non-Conformity Report), keeps track of problems with
items that are received from vendors. I am creating a report where the
user can retrieve a list of vendors that have had a NCR written against
them a certain number of times. For example, if the user wants
My program, NCR (Non-Conformity Report), keeps track of problems with
items that are received from vendors. I am creating a report where the
user can retrieve a list of vendors that have had a NCR written against
them a certain number of times. For example, if the user wants to see
what vendors h
Thanks Victoria! I must have missed that option. Exactly what I was
looking for!
Eric
"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Eric B." <[EMAIL PROTECTED]> wrote:
> > I know that in 4.11+ you can preload your MYI index file into the key
cache
> > usi
Think that is for your script to work on, i.e.
INSERT INTO table
(field1, field2)
VALUES (UCASE('form.field1'), form.field2)
depending on the syntax of your programming language (and which MySQL
version you are using). The above works on 4.1.1.
Terry
--Original Messag
Greetings,
Our MySQL server (4.0.13) is currently running with the option
--skip-networking. We want the server to accept TCP/IP connections. If
this option were specified in the config file, perhaps I could just modify
the config file and HUP the server process. So there would be no server
dow
"Gregorio" <[EMAIL PROTECTED]> wrote on 25/02/2004 15:19:43:
> This is the query i want to run but i doesn't work.
>
> select id from c_table where users_id in (select id from users where
> locations_id=3) order by data_ora
>
> But it gives me this error:
>
> You have an error in your SQL s
What MySQL version are you running?
Original Message dated 2/25/04, 9:19:43 AM
Author: Gregorio <[EMAIL PROTECTED]>
Re: Nested queries:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
Have you changed the interactive_timeout and wait_timeout values?
>> Original Message <<
On 2/24/04, 4:54:57 PM, <[EMAIL PROTECTED]> wrote regarding inserting huge
string:
> hi,
> I am using mysql 4.0.14. I have a table where one of the fields has a
> dataty
"Gregorio" <[EMAIL PROTECTED]> wrote:
>
> This is the query i want to run but i doesn't work.
>
> select id from c_table where users_id in (select id from users where
> locations_id=3) order by data_ora
>
> But it gives me this error:
>
> You have an error in your SQL syntax. Check the manual t
Hi,
I have a question regarding to search with fulltext on table and fetch
the data from another.
Table one:
id, textid, name, number, url
Table two:
id, text
On table two there is a fulltext index.
These two tables recently was one table, but i had to split them due to
the amount of data.
tex
Hai MySQLians,
I have listed down the log details which shows the mysql servers normal shutdown and
improper
shutdown while it got trouble from C coding.
Log details from c:\mysql\data\mysql.err
MySql: ready for connections.
Version: '5.0.0-
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where locations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version fo
"Bungarz, Kai" <[EMAIL PROTECTED]> wrote:
> When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows,
> for queries or loading data, i always get an error 2013 ("lost
> connection...")=20
> after 30 seconds and the connection breaks down.
> This doesn't happen, when i use the older ve
Look into the mysql_insert_id function, that looks like what you want.
On Feb 24, 2004, at 12:02 PM, David Scott wrote:
Hi list peeps
In many of my projects I have the need to insert a new record into a
table and then later on in the script update this record, Right now I
am doing this by d
Hi!
When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows,
for queries or loading data, i always get an error 2013 ("lost
connection...")
after 30 seconds and the connection breaks down.
This doesn't happen, when i use the older version 11.16 , Distrib: 4.0.0 /
windows.
There is n
Mike Mimic <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I have a problem with logging. I am logging all
> queries to MySQL server. And I have a program which
> inserts large chunks of data. The problem is that I
> would like to log all queries except for those insert
> queries as those flood my logs (they
"Eric B." <[EMAIL PROTECTED]> wrote:
> I know that in 4.11+ you can preload your MYI index file into the key cache
> using LOAD INDEX (http://www.mysql.com/doc/en/Index_preloading.html), but is
> there a way to configure MySQL to do this whenever the MySQL service starts?
> I'm willing to write .sq
I use SQLyog - http://www.webyog.com/sqlyog
It has a pretty good ODBC Import Wizard.
Karam
--- Jonas_Lindén <[EMAIL PROTECTED]> wrote:
> Hello, Could someone help me with a tip on how I can
> convert my old Access DBs to MySQL?
>
> Regards
> /Jonas
__
Do you Yah
Ok
I think I am a bit confused on how the MAX_ROWS works...
This is the result of SHOW TABLE STATUS \G:
Name: gabe_test
Type: MyISAM
Row_format: Fixed
Rows: 33
Avg_row_length: 5
Data_length: 165
Max_data_length: 327679
Index_length: 1024
Dat
I have a 3.x database that I backed up and restored to a 4.0 server. All
worked fine, except for one issue:
One table holds addresses, and when restoring it, would fail with an
"unmatched quotes" message.
On further examination, I found that it would occur on entries where the
text was like "123
Hi,
One of our enterprise database servers (MySQL 4.0.16-max on Solaris 9)
recently refused connections with a 1203 error, "User [username] has
already more than 'max_user_connections' active connections".
Show variables like '%conn%' displayed:
+--+---+
| Variable_name
Hi!
I have a problem with logging. I am logging all
queries to MySQL server. And I have a program which
inserts large chunks of data. The problem is that I
would like to log all queries except for those insert
queries as those flood my logs (they get really very
big). The program is written in Per
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>
>> >> What replication options do you use?
>> >> Check if queries are present in the master binary logs and in the rela=
> y l=3D
>> > ogs on the slave.
>> >
>> > I research the problem and have got some details.
>> > Now we have this theme of mysqld r
> > >> What replication options do you use?
> > >> Check if queries are present in the master binary logs and in the relay l=
> > > ogs on the slave.
> > >
> > > I research the problem and have got some details.
> > > Now we have this theme of mysqld replication (with server ids)
> > >
I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.
We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs. This
is done in the transaction context. Most of the time
it works fine but it does get into problem. We have
tes
Hi Ricardo,
> can i create a constraint to a field so that every data entered to that
> field (string) be stored in uppercase, if is posible can anybody give me
an
> example or point me to a link with documentation.
MySQL doesn't support check constraints.
With regards,
Martijn Tonies
Database
can i create a constraint to a field so that every data entered to that
field (string) be stored in uppercase, if is posible can anybody give me an
example or point me to a link with documentation.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Добрый день.
> >> What replication options do you use?
> >> Check if queries are present in the master binary logs and in the relay l=
> > ogs on the slave.
> >
> > I research the problem and have got some details.
> > Now we have this theme of mysqld replication (with server ids)
> >
Hi,
I have an application working in Windows, developed in VB5 using RDO method
to access data.
I use a parametrised query that is correctly working on e PC with Office97
installed.
When is installed Office2000 I receive the error:
07002:[MYSQL][ODBC 3.51 Driver]
[mysqld-3.23.53 max] SQLBindParame
I think that
print "\n";
or
print "\n";
should be enough...
Jiri Matejka
==>Wednesday, February 25, 2004 11:26 AM [EMAIL PROTECTED] wrote:
> hi ,
>
> Can somebody help me to center this table ?
>
> /* Connecting, selecting database */
> $link = mysql_connect("localhost", "root", "z")
>
hi ,
Can somebody help me to center this table
?
/* Connecting, selecting database
*/$link = mysql_connect("localhost", "root", "z")
or die("Could not connect : " . mysql_error());#echo "Connected
successfully";mysql_select_db("abcd") or die("Could not select
database");
/* Pe
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>
>> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
>> > SQL
>> > Hi, All!
>> > Is 4.1.1 replication compatible with 4.0.x?
>> >
>> > I have problem to replicate data from 4.0.17 to 4.1.1
>> > show slave status show all are OK
>> > perlicate position and t
SQL
Hi!
> Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> > SQL
> > Hi, All!
> > Is 4.1.1 replication compatible with 4.0.x?
> >
> > I have problem to replicate data from 4.0.17 to 4.1.1
> > show slave status show all are OK
> > perlicate position and the exec position are the same.
> > But if I u
I was wondering if I can user libmysqld with PHP.
If it's possible would someone post a simple exampe.
TIA,
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Andrey Kotrekhov <[EMAIL PROTECTED]> wrote:
> SQL
> Hi, All!
> Is 4.1.1 replication compatible with 4.0.x?
>
> I have problem to replicate data from 4.0.17 to 4.1.1
> show slave status show all are OK
> perlicate position and the exec position are the same.
> But if I update data on master, slave
Jonas Lindén wrote:
Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL?
Hello Jonas, I managed to do this out of Access by exporting the tables
to a MyODBC DSN.
Please check the column types later - don't know if they are all
converted correctly.
Regards,
Fr
1 - 100 of 104 matches
Mail list logo
