Quick one... is this program just for Linux?
I think not. As long as you have mysql and apache/php running it can run on
any unix os i think.
Take out the word 'unix' and you'll be right. If you can get a PHP
environment (doesn't necessarily require Apache to be the web server)
and MySQL, myPHPAd
Hi,
Can anyone point me to a resource which details the process of compiling
mysql server with openssl support on windows using VC++ preferable? If not,
maybe someone has run across this problem and can provide a solution. I have
added HAVE_OPENSSL and HAVE_VIO to the preprocessor definitions
> As a minor side issue, we did some _very limited_ testing with MS SQLServer
> 2000 using unicode v ascii queries. Using unicode, queries tended to run at
> about half the speed compare to using ascii.
> This was client server, so it is likely that the increased network traffic
> is to blame, but
I have PHP, mySQL and phpMyAdmin all running with IIS on a WinXP Pro
laptop as a protable dev box.
It's more PHP & mySQl dependant than it is OS dependant.
-M
-Original Message-
From: Louie Miranda [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:52 PM
To: Michael G. Tracey; [E
> > If maximum speed is critical.
> >
> > It's easy to lose sight of the fact that speed is not the
> > only criterion
> > in choosing a DBMS. Features, stability, security, and so on can be
> > just as important or more so. No single DBMS is going to win all the
> > prizes; the trick is to
I think not. As long as you have mysql and apache/php running it can run on
any unix os i think.
--
Thank you,
Louie Miranda ([EMAIL PROTECTED])
- Original Message -
From: "Michael G. Tracey" <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Tuesday, July 15, 2003 1:5
Quick one... is this program just for Linux?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jake Johnson wrote:
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mo
No kidding. I didn't know that. Thanks a lot!
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Performance Parts.
On Mon, 14 Jul 2003, Gabr
William R. Mussatto wrote:
Hello everyone,
Im extremaly newbie with using MySQL under Linux.
Im using: mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu
(i386) - ( btw - should i uprgade this or its enough to learn ? )
My question is:
How to start mysql deamon?
When i type: mysqld
the
Sure Woody and Phil are right; just take out TOP 20 and put LIMIT 20 at
the end of your SQL. If you care for the docs, the page is at
http://www.mysql.com/doc/en/SELECT.html
Peter
Eternal Designs
Phil Bitis wrote:
Yeah, put LIMIT 20 on the end.
- Original Message -
From: "Jim McAtee" <
> What's wrong with the following query? The application used to use
> Access via ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via
> MyODBC 3.51.01.
>
> // Return last 20 searches
> SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname FROM
> history h
> INNER JOIN server
On Mon, 2003-07-14 at 17:44, Jake Johnson wrote:
> Be careful! Phil wanted the top 20 and the limit 20 will only return a
> random 20 records.
Actually, LIMIT x will return the first x rows of a query, not random
records. In fact, you can even combine ORDER BY and LIMIT if you want
to get the fi
Be careful! Phil wanted the top 20 and the limit 20 will only return a
random 20 records.
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on
Rims, Car Audio, and Per
SELECT h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers s ON h.serverid = s.serverid
WHERE h.employeeid = 9
ORDER BY h.historyid DESC limit 20;
^
You probably mean LIMIT to limit.
On Mon, 2003-07-14 at 17:12, Jim McAtee w
On Mon, 2003-07-14 at 17:16, Alex82 wrote:
> I can't use itfor example i have to create a column that accept values
> between 1 to 120...i can't enumerate all of themor i have to accept a
> value different from NULL if an other column has a certain values, otherwise
> the first must be NULL
Yeah, put LIMIT 20 on the end.
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 11:12 PM
Subject: SELECT TOP
> What's wrong with the following query? The application used to use Access
via
> ODBC, now running MySQL 3.23.xx,
I can't use itfor example i have to create a column that accept values
between 1 to 120...i can't enumerate all of themor i have to accept a
value different from NULL if an other column has a certain values, otherwise
the first must be NULL, it's impossible to use enum to do this!
- Ori
What's wrong with the following query? The application used to use Access via
ODBC, now running MySQL 3.23.xx, MyISAM table, accessed via MyODBC 3.51.01.
// Return last 20 searches
SELECT TOP 20 h.historyid, h.searchstring, h.serverid, s.shortname
FROM history h
INNER JOIN servers s ON h.server
Use an ENUM()
On Mon, 14 Jul 2003 23:57:56 +0200, "Alex82"
<[EMAIL PROTECTED]> wrote:
| so what can i do to make a column accetp only certain values...there are any
| other solutions?
| - Original Message -
| From: "Egor Egorov" <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Monday
> Hello everyone,
>
> Im extremaly newbie with using MySQL under Linux.
> Im using: mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu
> (i386) - ( btw - should i uprgade this or its enough to learn ? )
>
>
> My question is:
>
> How to start mysql deamon?
> When i type: mysqld
> then apear
so what can i do to make a column accetp only certain values...there are any
other solutions?
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 1:58 PM
Subject: Re: check
> "Alex82" <[EMAIL PROTECTED]> wrote:
> > i have a prob
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 5:13
Heikki Tuuri wrote:
>
> On September 15th, 2003 you will be able to put every InnoDB table into its
> own file. That should alleviate this kind of problem.
>
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> http://www.innodb.com
> Transactions, foreign keys, and a hot backup tool for MySQL
>
Hello everyone,
Im extremaly newbie with using MySQL under Linux.
Im using: mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu
(i386) - ( btw - should i uprgade this or its enough to learn ? )
My question is:
How to start mysql deamon?
When i type: mysqld
then apear:
ERROR 2002: Can't
Good! I do believe if you configure your MySQL like your mail server we can
feel 30 times better ;-)
http://www.barllama.demon.co.uk
http://www.barllama.demon.co.uk/images/treetops/juliet.jpg
I'm not gessing about MySQL performance, however, PostgreSQL can be better if
installed on the same envir
The documentation states that MyISAM tables can be used with more than 32
keys, but I can't get mysql to accept more than 32.
Also, is it possible (advisable) to build a version of the MyISAM tables
that exceed the 64 key limit? If so, how is this done?
Tom Sundquist
Circus Software, LLC
Minneapo
On Mon, Jul 14, 2003 at 11:11:04AM +0100, Phil Bitis wrote:
> Might it be worth looking at the mailing list manager software for this
> list? ACCU's mailing lists use Majordomo and add this line to the rfc822
> headers:
>
> Reply-To: [EMAIL PROTECTED]
>
> You can still see the sender's email addr
On Mon, Jul 14, 2003 at 03:14:33PM +0200, Sergei Golubchik wrote:
...
> You could've noticed that it tries to access different database. You
> granted access to 'myFineDb', but you weren't able to access 'myfinedb'.
>
> So, it's case sensitivity issue. On Debian everything is ok, of course,
> on M
thanx. works now.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 10:17 AM
To: [EMAIL PROTECTED]
Subject: Re: can't set variable (sort_buffer)
"arobins" <[EMAIL PROTECTED]> wrote:
> I would like to change the sort_buffer variable but
>
I am getting the following error after trying to flush the master:
mysql> flush master;
ERROR 1186: Binlog closed, cannot RESET MASTER
I am using mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.9 (sparc)
Does anyone know what this might be?
Thank you in advance,
Leo.
--
MySQL General Mailing
Gijsbert Noordam <[EMAIL PROTECTED]> wrote:
>
> As a newcomer to this mailing list -- and to the MySQL database environment
> -- my main field of interest is the use of Spatial data. Before I start
> dropping my questions (a have a few) all over this list, two quick ones to
> start with:
>
> 1) F
"arobins" <[EMAIL PROTECTED]> wrote:
> I would like to change the sort_buffer variable but
> that variable doesn't seem to be configurable.
>
> i.e.
>
> I get the following when doing mysql --help.
> Don't understand why only these variables are configurable.
> Using db version 3.23.51.
>
> Pos
"Moritz Steiner" <[EMAIL PROTECTED]> wrote:
>
> Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM
> tables... For innoDB only the structure is saved but not the data
>
mysqlhotcopy works only with ISAM/MyISAM tables.
--
For technical support contracts, goto https://order.my
When I benchmarked PostgreSql against MySql for my application, MySql was 15
times faster, so 18% wouldn't make much difference for me!
Andy
> -Original Message-
> From: Robson Oliveira [mailto:[EMAIL PROTECTED]
> Sent: 14 July 2003 15:35
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL vs. P
To perform a self-join you just have to alias one or both tables.
In your case, you want to join on ( I guess) the SLM + CUST + ITEM,
restricting the tables to, respectively, 2003 and 2002. Further, you
want to filter out any rows where there's a match in 2002.
I believe the following does it:
s
Check out http://www.fmpdev.com/fmp2mysql.html, found in Google search for
"filemaker to mysql"
David Shugarts
Steve Marquez wrote:
Does anyone know how to export a FileMaker Pro Database so that MySQL can
use it? Anyone ever do something like this?
If you want a one-time transfer, the simple and cheap way is through
some sort of text file; CVS or tab-delimited, for example.
If you want the two databases
4 5 6
-Original Message-
From: Tom Roos [mailto:[EMAIL PROTECTED]
Sent: Montag, 14. Juli 2003 11:48
To: [EMAIL PROTECTED]
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / /
Hi
Let me take a stab at it. I don't think you need a join at all. Check
the syntax but I think you can do it like this.
SELECT *,concat(slm,item,cust,year) as result1,concat(slm,item,cust,2003) as
result2 from sales where result1!=result2 AND date>2001
year would be taken from your date
Is there a step by step startup for dummies out there anywhere? Or can someone help
me with the following?
I am attempting to get started. I have run setup for MySQL 4.0.13 and MySQLCC 0.9.2
and am trying to initialize a server. I am running Windows 2000. Is there a naming
convention? I ha
Hello all,
Is it possible to LEFT JOIN a table to itself?
I want to see all records in a table where the year of the sales date is
2003 and where the salesman sold an item to a customer to which he did not
sell that item to in 2002.
The following is an example table (SALES):
++-+-
On Sun, Jul 13, 2003 at 08:51:15AM -0700, Henry Hank wrote:
>
> I have the following SQL. The source table has 8.1 million rows, and the
> resulting table will have about 7.9 million rows. I know that's not much of a
> decrease, but the logic is correct as I've tested it on smaller sets. The
> p
walt,
i get the same issue.
I see the same output when doing mysql -D as i do when doing
mysql --help.
i.e. its telling me that the variable for some reason cannot be configured.
-- anthony
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
walt
Sent: Monday,
You're describing an adjacency list model, which is the most obvious
structure but arguably not the best.
Another data structure for this kind of thing is described at:
http://groups.google.com/groups?selm=%230%23O0OiFBHA.1932%40tkmsftngp04&;
oe=UTF-8&output=gplain
Cheers,
Jim
-Original
Hello There,
I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have
installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8.
Follow the Steps.
1- Dowload from http://www.mysql.com/downloads/mysql-4.0.html in the
SOURCE DOWNLOADS >> Tarball(tar.gz)
Anthony,
Try adding this to the my.cnf file
set-variable =sort_buffer=30M
walt
arobins wrote:
>
> I would like to change the sort_buffer variable but
> that variable doesn't seem to be configurable.
>
> i.e.
>
> I get the following when doing mysql --help.
> Don't understand why only these va
Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM
tables... For innoDB only the structure is saved but not the data
Thanks for some answers,
Moritz
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
I would like to change the sort_buffer variable but
that variable doesn't seem to be configurable.
i.e.
I get the following when doing mysql --help.
Don't understand why only these variables are configurable.
Using db version 3.23.51.
Possible variables for option --set-variable (-O) are:
conne
Henry Hank <[EMAIL PROTECTED]> wrote:
>
> The explain plan isn't anything I wouldn't ordinarily expect - a full table
> scan:
>
> +---+--+---+--+-+--+-+-+
> | table | type | possible_keys | key | key_len | ref | rows| Extra
Hi!
On Jul 14, Marcin Blazowski wrote:
> >> mysql> grant all privileges on temp.* to [EMAIL PROTECTED] identified by 'haslo'
> >> with grant option;
> >> mysql> grant insert on temp.* to [EMAIL PROTECTED] identified by 'haslo';
> >> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to datab
Hi Krasimir,
I used this query and it helped me:
SHOW TABLE STATUS LIKE 'mytable'
the query that you told me is good if I want to find the number of records
in a subset of a table. I can use it in somewhere else. thanks a lot for
your help.
- Original Message -
From: "Krasimir_Slaveyk
SELECT COUNT(*) FROM table_name;
[EMAIL PROTECTED] wrote:
Hi,
Is there any command or function in MySQL to find out how many records a
table has? phpMyAdmin shows the number of records ( Rows ) when shows the
structure of a table plus Row Length more information. How can we find these
table info
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
Hello Mojtaba,
Monday, July 14, 2003, 3:57:42 PM, you wrote:
If you want you can use /with Windows OS/ MySQL-Front to see some
additionall information for tables and to use it for work area for
some jobs.
MF> Hi,
MF> Is there any command or function in MySQL to find out how many records a
MF>
Thanks for everybody's help!!
This way worked for me. Clever!
Chris
... and yes... even my example was messed up
:-P
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 4:15 AM
To: Christopher Knight; MySQL List
Subject: RE: grouping / sorting etc
Hello Mojtaba,
Monday, July 14, 2003, 3:57:42 PM, you wrote:
try this:
select count(*) from TableName
MF> Hi,
MF> Is there any command or function in MySQL to find out how many records a
MF> table has? phpMyAdmin shows the number of records ( Rows ) when shows the
MF> structure of a table pl
Hi!
On Jul 14, Andreas Reuleaux wrote:
> What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody),
> does not any more with mysql 3.23.56 of fink (current-stable,
> for fink cf. fink.sf.net) - I am not sure, if this problem is caused
> by the mysql version (some security changes between .
> >I agree with your opinion in 100%, but in my case I need DBMS with
> >features like subselectes/utf-8/stored procedures but the
> speed is also
> >very important issue.
>
> You might have to spend money!
>
>
You are saying that there is DBMS with all this features and it is as
fast as MySQL
Hi,
Is there any command or function in MySQL to find out how many records a
table has? phpMyAdmin shows the number of records ( Rows ) when shows the
structure of a table plus Row Length more information. How can we find these
table information?
Thanks
--
MySQL General Mailing List
For list a
>> If maximum speed is critical.
>>
>> It's easy to lose sight of the fact that speed is not the
>> only criterion
>> in choosing a DBMS. Features, stability, security, and so on can be
>> just as important or more so. No single DBMS is going to win all the
>> prizes; the trick is to find th
Very smart your opinion, I agree at all with you.
-Mensaje original-
De: Bruce Feist [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 14, 2003 5:37 AM
Para: MySQL List
Asunto: Re: MySQL vs. PostgreSQL -- speed test
Marek Lewczuk wrote:
>For everyone who thinks about moving from MySQL
ahh..
http://www.mysql.com/doc/en/Replication_Options.html:
replicate-wild-ignore-table=db_name.table_name
tks alec
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 14 July 2003 14:29
To: Tom Roos
Subject: Re: question: replication of tmp table.
>
> which PostgreSQL version have you testet? If you want compare
> MySQL and
> PostgreSQL, than you have to use InnoDB tables. Tests with
> MyISAM make no
> sense. Out J2EE Application is working woth PostgreSQL 7.3.3
> and MySQL
> 4.0.13 with InnoDB tables (we need transactions and
> refe
"Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
>>> I've created a database and a user with ALL PRIVILEGES and GRANT OPTIONS
> to
>>> that database. When logon with that new user and want to create a new
> user
>>> with some privileges a get an error.
> If maximum speed is critical.
>
> It's easy to lose sight of the fact that speed is not the
> only criterion
> in choosing a DBMS. Features, stability, security, and so on can be
> just as important or more so. No single DBMS is going to win all the
> prizes; the trick is to find the one
Hi!
On Jul 14, Dan wrote:
> Hi all.
>
> I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
> month, and around 1,000,000 records imported into it. The import process
> consists of a 'load data infile' operation, followed by some updates to
> extract data and dump it somewhere
Marek Lewczuk wrote:
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth.
That's a bit of an overstatement!
Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought
"Tom Roos" <[EMAIL PROTECTED]> wrote:
>
> i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now and then i
> get a error on the slave. the error is that it cannot insert data into a table that
> does not exist. the problem is that the table its complaining about is a tmp table
No success either, thank you anyway.
[mac:~] reuleaux% mysql -u root -p***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all on myFineDb.* to
Hi!
George Georgeus <[EMAIL PROTECTED]> wrote:
>
> does anybody know how to copy a record within one
> table? I am looking for some simple method similair to
> INSERT INTO orders SELECT * FROM orders WHERE
> Order_ID=256; Actually, this method does not work and
> I can not believe that MySQL does
Hello group,
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth. Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought that PostgreSQL will be as good as MySQL but
a
The MySQL manual mentions that one could specify the column and value separators and
the end of file marker explicitly in the LOAD DATA statement.
I'm looking for the syntax of this statement to import large data files (.txt)
originally exported from Microsoft SQL 7.
Example file:.
"Extra
An idea; Did you try to set user name with ip address of the computer
you are running instead of localhost? I think it is worth to try and
hope it helps.
grant all on myFineDb.* to [EMAIL PROTECTED] identified by "abcpass";
[EMAIL PROTECTED] wrote:
What works for me with mysql 3.23.49 of Debia
Thanks for taking time to read my email.
This is to announce the launch of a new Linux support forum,
Bringing the power of the Linux community to the African content.
It's free. The resourcese are there to be shared. All you have to do is
register.
Registration is a mere formality to prevent use
George Georgeus <[EMAIL PROTECTED]> wrote:
>
> does anybody know how to copy a record within one
> table? I am looking for some simple method similair to
> INSERT INTO orders SELECT * FROM orders WHERE
> Order_ID=256; Actually, this method does not work and
> I can not believe that MySQL does not
|+-->
|| Victoria Reznichenko|
|| <[EMAIL PROTECTED]|
|| sita.net>> |
|| |
|| 2003-06-05 11:31|
|+---
"Alex82" <[EMAIL PROTECTED]> wrote:
> i have a problem with the check option
> for example
> create table ex
> (
> t INT check(t<4)
> );
> but even if i use check(t<4) i can insert 5,6,7.all values!:(
> why?
> Ale
> p.s. I'm using 4.0.12 version
CHECK clause does nothing. It's just parsed.
"Yann GAUTHERON" <[EMAIL PROTECTED]> wrote:
> ID_LOGIN is an integer
>
> Can anyone say me if this :
>
> WHERE index1=ID_LOGIN OR index2=ID_LOGIN
>
> must be slower than those 2 queries :
>
> WHERE index1=ID_LOGIN
> WHERE index2=ID_LOGIN
>
> for a 20 000 rows table ?
You can rewrite the first
g'day listers
i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now and then i
get a error on the slave. the error is that it cannot insert data into a table that
does not exist. the problem is that the table its complaining about is a tmp table.
that table is created when (a
"Craig Westerman" <[EMAIL PROTECTED]> wrote:
> I'm trying to help a friend with this. When I run this everything is fine
>
> SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS
> NULL
>
> The clicks table has 31 instances of url that match 5 instances of url in
> the urls
What works for me with mysql 3.23.49 of Debian GNU/Linux (Woody),
does not any more with mysql 3.23.56 of fink (current-stable,
for fink cf. fink.sf.net) - I am not sure, if this problem is caused
by the mysql version (some security changes between .49 and .56)
or by the fink configuration - I mig
Hello George,
Monday, July 14, 2003, 11:46:06 AM, you wrote:
Read this:
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
GC> as far as i know, mysql version 4.0 and previous, do not support subqueries.
GC> Select in select doesn't work.
GC> Have a look in the manual if what u r try
Sohail Hasan <[EMAIL PROTECTED]> wrote:
>
> I want to bring back my mysql original database as well as root GRANTS
> as was during the installation because i installed an application that
> modified my root GRANTS and now I am not able to see my mysql database
> as I login from root account. I
Might it be worth looking at the mailing list manager software for this
list? ACCU's mailing lists use Majordomo and add this line to the rfc822
headers:
Reply-To: [EMAIL PROTECTED]
You can still see the sender's email address if you want to reply directly.
--
MySQL General Mailing List
For l
i have a problem with the check option
for example
create table ex
(
t INT check(t<4)
);
but even if i use check(t<4) i can insert 5,6,7.all values!:(
why?
Ale
p.s. I'm using 4.0.12 version
Hello Shazia,
Friday, July 11, 2003, 10:25:56 PM, you wrote:
This is a tipical CROSSTAB QUERY.
http://www.mysql.com/articles/wizard/print_version.html
You also can use MS Access wich automatically suports crosstab query,
to make this kind of report
SF> Hi:
SF> I have a table with one column a
Not by MySQL (or it is that high it doesn't really matter). Your OS
could put a limit on it with max file size.
Just do yourself a favor and apply "\n" after every "row" so that you
can open it with an editor. Otherwise a lot of editors will complain of
"line too long".
Cheers
/rudy
-Origina
Hi all.
I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
month, and around 1,000,000 records imported into it. The import process
consists of a 'load data infile' operation, followed by some updates to
extract data and dump it somewhere where it is easier to access ( in the
Ive searched the archives, read the books front to back, still haven't
gotten a solution, hoping someone can help here. mysqld has been running
great for me on my RH 6.2 for 6 months. I just did something and screwed
up my tables (I went in and changed a few, ok 200 tables to type BDB from
MyISAM w
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / / / \/ / /
/_ / /__ / /_ / /_ /
Cell: 083 440 2213
Ph: 021 980 4969
Hello Andrey,
Friday, July 11, 2003, 7:28:27 PM, you wrote:
http://www.mysql.com/doc/en/SELECT.html
.
The LIMIT clause can be used to constrain the number of rows returned by the SELECT
statement.
LIMIT takes one or two numeric arguments. The arguments must be integer consta
Is there a limit to the number of records I can insert in a multiple-value
insert?
- Original Message -
From: "Rudy Metzger" <[EMAIL PROTECTED]>
To: "Phil Bitis" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 10:18 AM
Subject: RE: Improving insertion performance by lo
IF the dates are limited and can be agreed upon before running the
kwiri, you can use:
SELECT no,
IF (date=d1, data, NULL) d1,
IF (date=d2, data, NULL) d2,
IF (date=d3, data, NULL) d3
FROM table
GROUP BY no;
It will also NOT work if one date can contain multiple data, e.g.
Hello Christopher,
Friday, July 11, 2003, 6:31:33 PM, you wrote:
First select:
The results are just right what you want in your SELECT.
You have 5 different values in COLUMN1 and your select returns them.
>From second column SELECT gets first value for each value of first
column.
Second select:
SELECT invoiceid,
IF(count(*)=1,sum(payment),0) pay1,
IF(count(*)=2,sum(payment),0) pay2,
IF(count(*)=3,sum(payment),0) pay3,
IF(count(*)=4,sum(payment),0) pay4,
IF(count(*)=5,sum(payment),0) pay5,
IF(count(*)=6,sum(payment),0) pay6
FROM payment
GROUP B
>From what I know is, that MySQL always locks the MyISAM table before you
insert, update or delete something from it. So the key here is not so
much if you should lock the table, but how you insert the data (single
inserts vs multi inserts). Multi inserts are the way to go. By locking
the table you
SELECT col1, IF(count(*)!=count(col2),NULL,'BAD')
FROM table1
GROUP BY col1;
This ONLY works EXACLTY for the case you submitted.
Please note that your example is wrong (I think). 3 should also return
NULL, shouldn't it?
/rudy
-Original Message-
From: Christopher Knight [mailto:[EMA
2. 3MB is no problem at all (given that your hardware has free HD space
and that you do not have a quota of say 4MB)
3. with the new version you can also change session parameters on the
mysql command line. Use the keywords GLOBAL and LOCAL for global and/or
local changes. But this implies that yo
1 - 100 of 108 matches
Mail list logo
