Hi there - I have a database and I am using mysqlcc to admin the mysql
server.
At anyrate - when I am connected and I am trying to create a new table, and
I get the error:
Could not load Field Types. Please select the location of the Syntax File
in 'Options->General->Sql Editor' and re-open this
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05IEV4
cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU/IDUgNiAxNDY8YnIgLz4KTGVmdG92ZXI6IOE8
YnIgLz4KQTogNSA2PGJyIC8+ClNR
On Wed, Mar 12, 2003 at 10:25:11PM -0700, Jason Brothers wrote:
>
> I apologize if this topic has been discussed in the past. I am just looking
> for feedback whether to use Datetime or Unixtime (32 bit Int) for my
> timestamps. From what I can tell here are the advantages and disavantages
> of
Hello,
I apologize if this topic has been discussed in the past. I am just looking
for feedback whether to use Datetime or Unixtime (32 bit Int) for my
timestamps. From what I can tell here are the advantages and disavantages
of each method:
Unixtime (stored as 32bit int):
advantages:
- should
In the last episode (Mar 12), Tam, Michael said:
> I am running MySQL 4.0.11a on Win2k Pro at home. The machine is
> connected to a router which redirect port 3306 to MySQL. Things seem
> to work very well. I have MySQLCC and MySQL-Front both connecting to
> MySQL locally and remotely. However,
Hi All,
I am running MySQL 4.0.11a on Win2k Pro at home. The machine is connected
to a router which redirect port 3306 to MySQL. Things seem to work very
well. I have MySQLCC and MySQL-Front both connecting to MySQL locally and
remotely. However, when I try connecting through telnet locally a
I have installed 4.0.9 from source.
After compiling it I want to start it with
/usr/local/mysql/bin/mysqld_safe --user=mysql &
and the message mysqld ended appears.
When I move the startup script to the appropriate directory and reboot
I get the following error
Can't execute @bindir@/mysqld
Hello,
I've been running mysqld-nt on W2K and WinXP for awhile now (using
MyISAM tables) and I'm a bit confused by what's in the "max" binary. Is
the biggest difference InnoDB tables?
Thank you,
Dan Cumpian
-
Before posting,
Thanks...
Currently I am doing exactly that. One data set open creating another. I
was trying to speed the process up, although I am only dealing with 20,000
records so shouldn't complain. Thanks all for the suggestions... I look
forward to 4.x
JJ
- Original Message -
From: "Andy Eas
Paul,
You have to use the results of one select to generate lots of update
statements. If you execute all these from your program, make sure you use a
different database connection for the updates, if you're keeping a results
set open.
Alternatively, if it's a one off, generate a script file wit
At 9:45 +1000 3/13/03, JJ wrote:
That explains it then D'OH
Is there a workaround?
Thanks :-)
One way is to use a script that issues a join to figure out which
records to update, then constructs the appropriate UPDATE statements.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTE
That explains it then D'OH
Is there a workaround?
Thanks :-)
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, March 13, 2003 9:02 AM
Subject: Re: UPDATE syntax help
> At 8:33 +1000 3/13/03, MySQL
http://mindforums.com/forums/showthread.php?threadid=82
Per this thread I started to set up the two way replication as stated and
reached a point where I had/have a question about binary logging. How and
what does binary logging keep track of. I know that it keeps track of
changes made to th
At 8:33 +1000 3/13/03, MySQL wrote:
Hi all, I am having a little UPDATE syntax issue. According to the manual
According to the manual, this won't work until MySQL 4.x
UPDATE EBA_USERS, IMPORT_USERS
SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_
At 14:29 -0800 3/12/03, Andrey wrote:
Hi,
I jusr downloaded the latest release of mySQL server
in RPM for Linux and when i've installed it i found
that some tools such as mysqladmin are mising...Any
suggestions?
The server RPM doesn't include them. You need to install
the client RPM as well.
Thank
Hi all, I am having a little UPDATE syntax issue. According to the manual
UPDATE EBA_USERS, IMPORT_USERS
SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_ID,
EBA_USERS.REP_FIRST_NAME = IMPORT_USERS.REP_FIRST_NAME,
EBA_USERS.REP_LAST_NAME = IMPORT_
Hi,
I jusr downloaded the latest release of mySQL server
in RPM for Linux and when i've installed it i found
that some tools such as mysqladmin are mising...Any
suggestions?
Thank you,Andrey
__
Do you Yahoo!?
Yahoo! Web Hosting - establish your busin
At 17:04 -0500 3/12/03, Slawomir Orlowski wrote:
Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/mysql.sock
and rpm packages:
perl-DBI-1.13-1,
perl-DBD-mysql-mysql-
Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/mysql.sock
and rpm packages:
perl-DBI-1.13-1,
perl-DBD-mysql-mysql-1.22.10-1
perl-5-5.0050
and binary installation
e,1,8) = '20030312' GROUP BY date, subject,
location, private, id, duration, dategroup_id, inituserid ORDER BY date
Error (MSG):
You have an error in your SQL syntax near 'DISTINCT subject) AS
appointment_count, inituserid FROM mgw_calendar WHERE useri' at line 1
--
HELP! I'm getting the following error:
--
Error (SQL):
SELECT date, subject, location, private, id, duration, dategroup_id,
COUNT(DISTINCT subject) AS appointment_count, inituserid FROM mgw_calendar
WHERE userid=1 AND SUBSTRING(date,1,8) = '20030312' GROUP BY date, su
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Adam Dzieciatko
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rel
I've recently upgraded to 4.0.11 (4.0.11-0 rpm) on RedHat 8.0. I've had
replication running before, and now it's giving me trouble.
slave start fails with the following error
Could not initialize master info structure, check permisions on
master.info
I've checked the file permissions, and they s
hi dude yeh u have to append the page query to the current query ,
here is an example of my db class
http://electroteque.dyndns.org:1023/benchmark/DB.phps
down the page is the pagination u want in particular the url function
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
S
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Garth Dahlstrom wrote:
Hi all,
I'm wondering if anyone has configured IBM Websphere 4.0 to use MySQL
as a JDBC Provider for Entity Beans (EJBs). The configuration is not
anything like servlet config where you throw the MM driver in the
WEB-INF/lib
Hi all,
I'm wondering if anyone has configured IBM Websphere 4.0 to use MySQL
as a JDBC Provider for Entity Beans (EJBs). The configuration is not
anything like servlet config where you throw the MM driver in the
WEB-INF/lib directory.
I haven't been able to find any indication that anyone
Hi! I'm trying to install mysql on a RISC-6000 box running AIX 4.3. When
I type './mysql' I get the following error:
# ./mysql
Could not load program ./mysql:
Dependent module libz.a(shr.o) could not be loaded.
Could not load module libz.a(shr.o).
Error was: No such file or directory
Does anyon
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
___
You have to show us.
Steve Holt wrote:
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered` (
`DateCourseCreated` datetime default NULL,
`Specialty` int(25) NOT NU
On Wed 2003-03-12 at 11:16:09 -0600, [EMAIL PROTECTED] wrote:
> At 11:41 -0500 3/12/03, Douglas B. Jones wrote:
> >Hi,
> >
> >I understood replace to only increment n when it matches the
> >name value.
In that case, you want a primary key on (name,n) with n being
auto_increment.
> There are 122,1
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I found a great article by Joe O'Donnell called "Building A Dynamic MySql
Paging Class with PHP" ... I created his example and it worked fine.
Then I st
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 12, 2003 11:33 AM
> To: Luc Foisy; MYSQL-List (E-mail)
> Subject: RE: Is there any way to search a whole database for a value?
>
>
> At 9:21 -0500 3/12/03, Luc Foisy wrote:
> >Perhaps one day UNI
At 12:07 -0500 3/12/03, Jonathan Li wrote:
I currently have a table that contains a timestamp(6) column. I need to
copy the data in that column to a new table with the column structure as
timestamp(14), what is the best way to do it (now that the timestamp
structure is changed)?
That doesn't matter
Hello,
I've tried to setup a replication but ...i've several problem! I've
follow the manual istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html
But the slave don't start the replica.
SHOW SLAVE STATUS on SLAVE return SLAVE:running
SHOW PROCESSLIST on SLAVE return reconnecting after
Hi!
On Mar 12, Simont Tyler wrote:
> Just saw the following code in the MySQL 2.23.55 source code.
>
> The semi-colon after the if renders the if statement useless. Could
> someone explain if it is intentional. The comment indicates that it
> is.
>
> Simon
>
>/*
> the following 'if',
On 12 Mar 2003, at 11:41, Douglas B. Jones wrote:
> INSERT INTO virus VALUES (3,'VBS/LoveLet-E');
> INSERT INTO virus VALUES (4,'VBS/LoveLet-G');
> INSERT INTO virus VALUES (5,'WM97/Myna-C');
>
> I would have expected 3,4,5 to be 3,1,1. I was expecting it to start
> from zero each time it got a n
I could not start ./safte_mysql.
Error message:
touch: /usr/local/mysql/var/gemini.err cannot create
chown: /usr/local/mysql/var/gemini.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
./safe_mysqld: /usr/local/mysql/var/gemini.err: cannot create
So I c
At 11:45 -0500 3/12/03, Keith C. Ivey wrote:
On 12 Mar 2003, at 10:22, Douglas B. Jones wrote:
INSERT INTO virus VALUES (91207,'VBS/Kakworm');
INSERT INTO virus VALUES (117623,'VBS/Redlof-A');
As you can see, the numbers (n field) are way to high? Is this a bug
in mysql or n the sql?
It's far
Hi,
If you want to get 3,1,1 instead of 3,4,5, you should declare
your table this way:
create table virus (
n int auto_increment not null,
name char(128) not null,
primary key(name,n),
unique(name(100))
);
You can find a very good example in the manual:
http://w
At 11:41 -0500 3/12/03, Douglas B. Jones wrote:
Hi,
I understood replace to only increment n when it matches the
name value. There are 122,111 statements, but when you add
up the numbers in the n column, they exceed 122,111. They should
I don't know what you're trying to say here. If you *add up*
I currently have a table that contains a timestamp(6) column. I need to
copy the data in that column to a new table with the column structure as
timestamp(14), what is the best way to do it (now that the timestamp
structure is changed)?
Thanks
Jonathan
--- ignore below
query
sql
---
---
"Tamayo, Nelson" wrote:
> Is there a way to convert an Access database into MySQL easily?
>
> I am running into problems trying to convert it through VB code using a
> recordset. I'm rather new at this stuff. I'm also tried generating an insert
> statement through VB code and then executing it, I
Hi,
I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) between 2 time
dates.
Can't seem to find any of these functions in the Mysql manual. The nearest
was Period_diff() which is calculating months elapsed.
Thanks
Nyon
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-vi
Hi,
No questions that my understanding of sql is limited. I am
not an expert. I think I have misunderstood the replace statement.
Thanks,
Cheers,
Douglas
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:46 AM
To: [EMAIL PROTECTED]
Cc: D
On Tuesday 11 March 2003 18:57, vlady wrote:
> I am trying to set up a replication ignoring a given database, but
> unfortunatly it doesn't works (for me).
> In my.cnf of my master I have at the end :
> log-bin
> server-id= 1
> binlog-ignore-db=access
>
> The line: " binlog-ignore-db=acces
On Wednesday 12 March 2003 18:25, Jonathan Li wrote:
> A few days ago I asked about how to know which database I am currently
> in, I got an answer and I also replied to thank the send but the email
> was returned. Any way I forgot to document it. I remember the answer
> listed three methods to do
On Wednesday 12 March 2003 02:30, Heo Jungsu wrote:
> > What do you mean "could not execute a query on those tables"?
> > Could you be more detailed?
>
> Ok. let me explain.
>
> When I was using MySQL 4.0.10,
>
> After I add columns with "ALTER TABLE" on foreign key referencing table so
> many tim
On Tuesday 11 March 2003 16:23, zby at post dot cz wrote:
> /usr/sbin/mysqld-max --version
> /usr/sbin/mysqld-max Ver 4.0.11-gamma-Max for pc-linux on i686
> Downloaded and installed:
> MySQL-client-4.0.11-0
> MySQL-shared-4.0.11-0
> MySQL-Max-4.0.11-0
> MySQL-devel-4.0.11-0
> MySQL-server-4.0.11
On Tuesday 11 March 2003 19:06, Luc Bui (PAC) wrote:
> when can I get the binariesfor 4.1?
Probably in 2-3 weeks ..
> do 4.0.11a support views?
Nope.
> important for my choice for my community.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spon
On 12 Mar 2003, at 10:22, Douglas B. Jones wrote:
> INSERT INTO virus VALUES (91207,'VBS/Kakworm');
> INSERT INTO virus VALUES (117623,'VBS/Redlof-A');
>
> As you can see, the numbers (n field) are way to high? Is this a bug
> in mysql or n the sql?
It's far more likely to be a bug in your appli
Hi!
thanks for your response.
I found my mistake, you pointed me to the right direction.
Although I provide different pcbLength buffers for the parameters, I did not
initialize the second one.
ODBC documentation says, that it will be ignored on integer columns if its
not SQL_NULL_DATA.
But I shou
[filter fodder = sql,query,queries,smallint ]
you haven't indicated what the column attributes are,
but you might try putting quotes around the TRUE and FALSE
values ( assuming they are being inserted into char or varchar
columns).
David
-
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE
statements from the log bin.
Because such statements are really used not for updating a DB, but for
constructing intermediary statements that eventually derive in a final
INSERT/ UPDATE. I believe only this final statement
At 11:29 -0500 3/12/03, Tamayo, Nelson wrote:
Is there a way to convert an Access database into MySQL easily?
I am running into problems trying to convert it through VB code using a
recordset. I'm rather new at this stuff. I'm also tried generating an insert
statement through VB code and then exec
Hi,
I understood replace to only increment n when it matches the
name value. There are 122,111 statements, but when you add
up the numbers in the n column, they exceed 122,111. They should
sum up (when you add all them up including the ones I did not
show) to 122,111. If you add up the ones I show
select database();
Regards,
Joseph Bueno
Jonathan Li wrote:
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any way I forgot to document it. I remember the answer
listed three methods to do
At 9:21 -0500 3/12/03, Luc Foisy wrote:
Perhaps one day UNION will be added to UPDATE
You'd still have to name every column to be updated explicitly.
There is no "update whatever column happens to contain this value"
syntax.
At 11:01 -0800 3/11/03, Keith Roberts wrote:
I need to look in several
[filter fodder = sql,query,queries,smallint]
mysql > select database();
David
**
Jonathan said:
**
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any w
Is there a way to convert an Access database into MySQL easily?
I am running into problems trying to convert it through VB code using a
recordset. I'm rather new at this stuff. I'm also tried generating an insert
statement through VB code and then executing it, I get the error "Unknown
column 'Fal
At 10:22 -0500 3/12/03, Douglas B. Jones wrote:
Hi,
I just tried the below:
create table virus (
n int auto_increment not null,
name char(128) not null,
primary key(n),
unique(name(100))
);
with a data file that has 122,111 sql commands like:
replace into virus va
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any way I forgot to document it. I remember the answer
listed three methods to do it, they are "mysql> \s", "mysql> status".
Could you (or som
Hi,
I might not have worded things the best. I did not grep the sql db,
but the output from mysqldump. I only grep'ed on plain text files:
1) mysqldump output
2) grep the input sql file that has 'replace into...' (see below)
3) the log file for mysql, which is plain text (see my follow-up email)
If I understand correctly, you are trying to grep the SQL data file. This
is emphatically not a valid thing to do. The data file is *not* a
representation of the table displayed when you SELECT * from it. For a
start, if you have deleted records and not overwritten them, the blank
space will still
extra_configs="$extra_configs --with-innodb --with-berkeley-db \
--with-embedded-server --enable-thread-safe-client \
--with-bencgh --prefix=/usr --enable-maintainer-mode \
--with-docs --with-unix-socket=/var/run/mysqld/mysqld.sock \
--with-lo-memory --with-openssl --with-vio"
It c
Bob Ramsey schrieb:
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote:
m$office (office 2000 - win xp) can not handle the "time" correct.
openoffice (win-xp or redhat-phoebe3) has no problems.
I believe that's a known problem with Microsoft products. They only
appear to be able to handle dateti
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered` (
`DateCourseCreated` datetime default NULL,
`Specialty` int(25) NOT NULL default '0',
`CourseNo` float NOT NU
Hi,
Update: I just did a grep:
grep 375707 Query c01*.log
of the log file and did a grep of VBS/LoveLet-G on the out put file
and got 123 entries, what I expected. But, the dump shows 111,009
in the 'n' field. This is starting to look like a bug in mysql 3.23.49?
Any ideas?
Thanks,
Cheers,
Dou
Just saw the following code in the MySQL 2.23.55 source code.
The semi-colon after the if renders the if statement useless. Could someone explain if
it is intentional. The comment indicates that it is.
Simon
/*
the following 'if', thought conceptually wrong,
is a useful optimizat
Hi,
I just tried the below:
create table virus (
n int auto_increment not null,
name char(128) not null,
primary key(n),
unique(name(100))
);
with a data file that has 122,111 sql commands like:
replace into virus values(NULL,"VBS/LoveLet-E");
replace into virus
>Description:
MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
when formatting error messages: the code just assumes that no message
will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH)
or MYSQL_ERRMSG_SIZE (200). This has been observed to lead to memory
corru
Hi.
On Wed 2003-03-12 at 14:39:26 +0200, [EMAIL PROTECTED] wrote:
> Hi,
> I do not know how to compile, but I sure want to try the new features of
> 4.1.
There is no date yet for the first binary release of 4.1. They will
publish such an alpha release when they consider it mature enough for
gener
Vincent Ferretti wrote:
> I need help!
>
> I'm making some testing with innodb tables and there're some issues I
> don't understand.
>
> I created a small tablespace of 10M:
>
>innodb_data_file_path = ibdata1:10M;
>
> Then I created this simple database:
>
>CREATE DATABASE trace_db;
>u
Gopalarathnam V. wrote:
Your sub-select query can be written as:
select t1id from t1 left join t2 on t1id = t2id where t2id is null
in MySQL.
Too restrictive -- the original poster, Phil Dowson, wanted to find all
t1 rows except those that have t2.t2gid = 194 (or some other t2gid value).
The a
Perhaps one day UNION will be added to UPDATE
> At 11:01 -0800 3/11/03, Keith Roberts wrote:
> I need to look in several different tables/columns in a
> database for a
> particular value. If I find it, I need to update it. Is
> there any way to
> search/update every table/column in one query
Hi List,
I'm a newby at MySql. I've setup a server for use with Bugzilla but I am
also trying to connect to an other database on that server. Each time as I
try to connect I get
ERROR 2013: Lost connection to MySQL server during query.
Is there a setting I must change to be allowed to logon from
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote:
m$office (office 2000 - win xp) can not handle the "time" correct.
openoffice (win-xp or redhat-phoebe3) has no problems.
I believe that's a known problem with Microsoft products. They only appear
to be able to handle datetime objects, not date
'Back in the day', I've run MySQL on an Intel 386 with as little as 4MB of
RAM under Linux. Base disk space can be extremely minimal as well.
Cheers,
-Dana
-Original Message-
From: Prashant [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 7:19 AM
To: MySQL (E-mail)
Cc: KUMARASA
Hi,
What is the minimum hardware requirements of MySQL Database. Apart from the
size of the database. I am looking for limitations like
- RAM,
-Installation Space (per instance).
etc.
Please do let me know at the earliest.
Thanks & Regards,
Prashant Kumar Gupta,
HP-High Availability Team,
Banga
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roland Carlsson wrote:
Thanks, that solved the problem. I thought that I could have my own
fetch-size but I has now understood that Integer.MIN_VALUE is the only size
that is accepted.
Regards
Roland Carlsson
The fetch-size setting makes sense for drive
Hi,
I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service
as a user account rather than the local system account. This worked fine in 3.23.43
but has stopped working since the upgrade.
The error I get is 2186, which seems to be "service failing to respond to con
I have a query that populates a dropdwon which then posts to another
form with a query
I don't want to diplay the dropdwon in the next form but want to keep the query.
Is it possible to justcombine the two queries . The reson for this is that the
2nd dropdown is populated by the selected value
Yba
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 2:14 PM
To: Yaron Ben-Arieh
Subject: Re: When is MySQL 4.1 going to have its binary download available?
Your message cannot be posted because it appears to be either spam or
simpl
* Peter D Bethke
> Ok, in regards to my previous dilemma, I've gotten it to:
>
> SELECT
> golf_pick_periods.id,
> golf_pick_periods.period_name,
> golf_pick_periods.period_start_date,
> golf_pick_periods.period_end_date,
>
> COUNT(DISTINCT golf_events.id) AS num_events
Hi!
On Mar 12, Mathias Berchtold wrote:
> MATCH / AGAINST fatal bug
>
>
> MySQL version: 4.0.11-gamma
> OS : Windows 2000 SP3
> RAM: 1GB Apacer
> Free Disk Space: 32GB
> HD Write Back Cache: Disabled
>
> Under some circumstances the following query does never terminat
Hi,
I need to set a variable limit on the MySQL file size (Average row
length * no of rows )
When we insert data in to the table using JDBC .i should get a
unique JDBC exception (so that i trigger an archive).
Is this posible in MySQL?
I notice that during creation of table i can give such op
There is one particular program that can dump an SQL Server database as
SQL statements much like mysqldump--its called SqlDump and it is
available from http://sqldump.sourceforge.net.
Ask your client to use it to give you the SQL file.
NOTE: the SQL stmts may be very much SQL Server specific tho
Hi Alec-
Your sub-select query can be written as:
select t1id from t1 left join t2 on t1id = t2id where t2id is null
in MySQL.
The example is actually given in the MySQL manual itself (section 1.7.4.1).
[EMAIL PROTECTED] wrote:
I am trying to check a table to see if a value doesnt exist, and
> Hi, I'm a MySQL newbie - Is there a "MySQL Web Server"
> product ? Oracle has their OWS (Oracle Web Server)
> for example.
>
As far a I know this is based on Apache.
Of course it takes Oracle weeks to update it after
a security vulnerability is exposed, whereas if you were
using Apache you'd h
to whom it may concern,
I need some help regarding transactions using innodb tables.
I am running MySQL 3.23.51-Max as database server and developing a web
front-end using ASP. Many of the tables used are of innodb format since it
is imperative for me to use transactions in most of my scripts.
I
Indexing in MySQL.
If while indexing a table I retrieve data from same table the indexing
process seems to get stuck. Mytop keeps saying something about
"repairing keycache" for days when the indexing shouldn't take more than
a couple of hours.
Can someone please explain!
--
91 matches
Mail list logo
