Drop the index and recreate it
alter table you-table drop index your-index;
alter table you-table create index your-index(fieldlist);
- Carsten
- Original Message -
From: "Rory O'Connor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 7:55 AM
Subject: re-inde
Hi
-mm-dd is how it is stored in the db, you have to pass the date like
that, and that is how it will be returned.
Regards
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 7
Is there a default format for Date ?
/mm/dd or
mm/dd/ or
dd/mm/ ?
I am not sure which format I should use in SQL.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
I'm a bit of a mysql newbie...excuse if this is rudimentary.
I imported about 5000 records and realized that the index is a bit scewy
since i deleted alot of records while it was in access. rather than fix
it in access and re-import it, is there an easy way to re-index the
records in mysql?
tha
On Wed, Jul 18, 2001 at 11:40:15AM +0530, Chandrashekhar wrote:
> Are transactions supported in mysql.Please guide me.
They are. See the manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-
Hi
Are transactions supported in mysql.Please guide me.
Thanks in advance
Chandra
Hi,
I am trying to connect mysql database to java program, I am using
org.gjt.mm JDBC driver.
I have username and password in USER table and host is that "%" , connect
from anywhere.Driver is loading but
its saying "access denied,@uable" something like this
could anyone help me.
regards
ragha
Hello,
I am trying to build mysql-3.23.39
my configure options are: './configure --prefix=/home/mysql'
when I run make I get this output:
Making all in client
make[2]: Entering directory `/home/SOURCE/mysql-3.23.39/client'
gcc -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I..
Hi,
I hope you are able to help me, or at least point me in the right
direction. I have recently install PHP & MySql but get the following
messages. How do I un-install the package?
Err messages when trying to display a URL, index.php file
I do know the root password but it doesn't recognise
Hai,
i want to create database in mysql with user permission,pls. help me out.
Regards
sakthi.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Hi everyone,
I'm wondering how I should configure my.cnf if I have a master-slave
scenario where I would like to declare the slave master if the master goes
down.
What I mean is, let's say I have 2 database servers:
server1 = master
server2 = slave
so normally my.cnf for server2 would have se
I think you are overestimating the compute needs,
100,000 customers generating 1k on average a day of data(I suspect that is a
high number) for 1 year,36 gig of data. Not that Much. using a IO subsystem
that can do 100 meg/sec read access(3ware comes to mind as a cheap way, you
can get it above 2
At 9:03 AM +0545 7/18/01, Deependra B. Tandukar wrote:
>Greetings !
>
>I have following tables in MySQL:
>
>TableItem
>idlist
>1 Banana
>2 Orange
>3 Mango
>
>Other tables are:
>Banana, Orange, Mango
>
>Instead of selecting Table Banana directly I need to select it as "select
>$Tabl
I've been trying to get mysql to install from the openBSD ports tree on an
i386 OpenBSD 2.9 system. I keep getting the error:
/* start error */
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You
Greetings !
I have following tables in MySQL:
TableItem
idlist
1 Banana
2 Orange
3 Mango
Other tables are:
Banana, Orange, Mango
Instead of selecting Table Banana directly I need to select it as "select
$TableItem.list where id=1" or something like that for editing or deleting
>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:
[permission to come aboard, sql database query table]
"Gerald R. Jensen" wrote:
>
> I wouldn't be concerned about this being discussed here on the list. After
> all, we are talking about Open Source.
>
> Gerald Jensen
-
Right, Mr. Jensen. My historical bent takes me further.
Hi List,
I think the Joey question is a good topic. However, is very important know very
well where can Bewoulf model help in this case. The Bewoulf cluster concept is
based on a software framework (e.g. PVM, MPI, etc.) which allow the development
of application which can execute, using these
At 4:58 PM -0700 7/17/01, Bryan Coon wrote:
>Hi, I am experiencing some really bizzare behaviour in MySQL v3.23.36...
>
>I have a perl script that takes some html form based user input, parses
>it into an array and then loops throught the array inserting each
>element into a table. This table is
Britt:
I've read all of the posts regarding the controversy between MySQL AB and
NuSphere.
Not being a participant, I can't know all the details of your relationship
with MySQL AB, so I can only judge this in light of my own dealings with
them. Michael Widenius and David Axmark have always condu
... or should that be "FreeBSD loves MySQL"?
I finally caved in after a year of increasing (and unexplained) MySQL
crashes, despite numerous updates to more recent versions of NetBSD and
MySQL, and dozens of experiments with different configuration options.
MySQL would die (and restart automatica
Oy weh. I thought I had said enough on this subject, but I feel
like I have to jump in here again in an appeal for, er, that very
difficult state of mind of calm and neutral judgement. The release
by Mr. Britt Johnson was not condescending. Just about everything
in it can be taken in good faith
Gary,
Thanks for your response.
Basically, what we are doing is buidling a huge database that will
hold a lot of different info on each of our customers. I can't tell you
what we do for a living, but basically we want to find out (for
instance)
how many of our customers used our product (the g
>Description:
After installing MySQL-3.23.39-1.i386.rpm, /usr/bin/mysqladmin
cannot be found.
>How-To-Repeat:
Don't know.
>Fix:
Don't know.
>Submitter-Id:
>Originator:Patrick Linstruth
>Organization:
>MySQL support: none
>Synopsis: /usr/bin/mysqladmin
Hi, I am experiencing some really bizzare behaviour in MySQL v3.23.36...
I have a perl script that takes some html form based user input, parses
it into an array and then loops throught the array inserting each
element into a table. This table is then left outer joined with others
for a quick qu
Again, Mr. Johnston,
NuSphere shows very poor public relations abilities. Adopting such a
condescending tone toward MySQL AB, to which, Sir, you must understand, you
are completely indebted for everything that you have and are, will further
alienate you from the supporters of MySQL. NuSphere's e
Hi all,
Why is it that some times in mySQL error logs the error
number is reported as Zero? Is this a common error or does it have
something to do with PHP.
Drew
Andrew Toussaint
Richardson-Shaw Pty Ltd
[EMAIL PROTECTED]
---
Hi,
My meager little mysql server is now hosting about 5000 databases.
They typically seem to be web based chat BBS's like phpNuke, phpBB and
vbulletin. Typical tables are small, and typical queries are simple
"select * from table where id=somevalue". The users seem to be happy, but
of co
Some RDBMS allow you set a 'seed' value for auto-incrementing columns. I
haven't looked at this in awhile, but I know of a couple of work-arounds:
- Set the first record in your INSERT to an explicit value (4711, etc.),
then put NULLs in subsequent rows.
- Insert a bogus record with a number one
Re: Open Invitation to NuSphere and Progress
NuSphere accepts MySQL AB's invitation to discuss resolution of
our business issues. NuSphere and MySQL AB have already spoken via
phone and confirmed discussions will commence on Friday, July 20th.
NuSphere would welcome a fresh approach by MySQL A
On Tue, Jul 17, 2001 at 04:11:44PM -0500, doug wrote:
> > MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/sec. avg)
>
> Ok Jeremy I have to ask: How do you get your MySQL stats in your
> signature like that?:->
It's a bit of a hack, but you're not the first to ask... So here goes.
Hi Fred
I have had the exac same problem, seems to be associated with 'SpeedDial',
what I do it left click once on the file so that it is selected, then hold
down the shift button and right click on the file, then gives you the option
'Open With', and use choose open width Notepad, or wordpad. Wo
Hi all,
My OutLook express some how got rib most of the mails I received from the mailing
list for no reason. I have to say most of the mails are very good reference/resource
and I would like to keep them for reference. I wonder if there is any way I can
obtain an archive of the mailing
At 11:03 PM +0200 7/17/01, Alexander Skwar wrote:
>So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
>> in my plain language there it is, but the pro's may give a more detailed
>> approach.
>
>Yeah, that's sorta how I understand it as well. Also auto_increments
>BREAK when you
Aha! that's what I need to know, thanks a bunch.
Pete
Heikki Tuuri wrote:
>
> Pete,
>
> no, below you have a path:
>
> innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
>
> ibdata is a directory name, not a file name. InnoDB will add the
> extra backslash after it. But InnoDB does not cre
Pete,
no, below you have a path:
innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
ibdata is a directory name, not a file name. InnoDB will add the
extra backslash after it. But InnoDB does not create directories.
You must manually create the directories you use.
Regards,
Heikki
http://www
> I am quite new to programming in Linux although I am no stranger to
> programming in Windows.
> This is my problem:
> I downloaded the mysql++ API and extracted it to /root/mysql++-1.7.9/
> I browsed to /examples/ and thought I would try and compile simple1.cc.
> This is what I did from the term
database,sql,query,table
Just to the record: I've written a small program too, and it reports
correct sizes for normal disk devices under both linux 2.2 and 2.4,
as long as the partition sizes don't exceed the 2GB limit (I don't
have large file support, since I use debian potato with just the
Hi,
Actually both (ibdata and iblogs) are folders in ibdata. The files are
written by InnoDB in these folders automatically. Just create yourself the
folders:
/some_dir/innodb/ibdata
/some_dir/innodb/iblogs
and it should work fine
[]s
Crercio O. Silva
-Original Message-
From: Pete
> MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/sec. avg)
Ok Jeremy I have to ask: How do you get your MySQL stats in your signature
like that?:->
Doug Henry
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Ben Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
> in my plain language there it is, but the pro's may give a more detailed
> approach.
Yeah, that's sorta how I understand it as well. Also auto_increments
BREAK when you manually insert a row and set the column with the
auto_inc
Mike -
Actually, your procedure below doesn't work for this extension.
I always reset my system to show all extensions, including
systems and hidden files, and this extension still doesn't appear.
Haven't tried to unassociate the extension, as that's more invasive
than I want to do. Anyway, th
On Tue, Jul 17, 2001 at 03:34:01PM -0500, John Hunter wrote:
> > "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes:
>
>
> Paul> ALTER IGNORE this_table ADD PRIMARY KEY (name,time)
>
> They are not null so this works well with a slight modification:
>
> ALTER IGNORE TABLE this_table ADD
Hi
I am no pro with Mysql, but had similar results when first starting out. My
understanding is that the Auto Increment value is held in a file other than
the actual data file, so when it uses the auto-increment it is not reading
the last value from the actual DB and then adding one, but rather l
Hi All:
I am running 3.23.39 and I compiled it using gcc 2.95.3.
I am having a very difficult time getting *ANY* of the client progs to work (mysql,
mysqladmin etc) ... they immediately seg faults and core dumps without any message.
mysqld is running fine ... with debug on it says waiting to c
Just go (in windows explorer) to view->optoins, and uncheck hide extensions
of known file types, and the extensions will show up. You can also
un-associate it through this.
On Tuesday 17 July 2001 15:47, Dinkler, Fred wrote:
> Problem under Win2000 with any file having a .cnf extension.
>
> Th
> "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes:
Paul> ALTER IGNORE this_table ADD PRIMARY KEY (name,time)
They are not null so this works well with a slight modification:
ALTER IGNORE TABLE this_table ADD PRIMARY KEY (name,time)
^
One further question. Will this au
On 17-Jul-01 Chris Aitken wrote:
> Hi Guys,
>
> What im looking at doing is working out the best way to safely shut down
> mysql so I can do a full backup of the system, then restart it back. (im
> running on a FreeBSD box)
>
> I know I can kill the PID and other drastic measures but I dont w
On Tue, Jul 17, 2001 at 03:44:29PM -0400, Colin TMC wrote:
>
> I am moving from MS SQL to mySQL, Can anybody know how to create and
> grant rights for a new user except of root?
Search for "GRANT" in the manual
http://www.mysql.com/doc/
and you'll find just what you need.
Jeremy
--
Jeremy D
On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote:
>
> We are looking to replicate a couple of databases on to a second
> server. Having looked through the manual it says we need to add
> various commands to my.cnf.
>
> It turns out that we do not have a my.cnf (so apprently MySQL just
On Tuesday 17 July 2001 15:44, Colin TMC wrote:
> I am moving from MS SQL to mySQL, Can anybody know how to create and grant
> rights for a new user except of root?
>
> Thanks!
>
>
> -
I know a lot of you don't believe it, but thi
On Thu, Jul 12, 2001 at 04:02:23PM -0700, Joe Taraba wrote:
> Jeremy;
>
> I've been following this thread, and what I am unclear about is why
> would I want to use replication?
Sorry for the late reply.
> Forgive me, I am very new to MySQL, and my point of reference at
> this juncture of unders
I am using MySQL 3.22, and need to know how to randomly select a record, therefore I
can't just use the ORDER BY RAND() clause, because of my version. so i do this:
SELECT field1,field2*0+RAND() as rand_col FROM TableName WHERE field3=5 ORDER BY
rand_col;
--according to paul dubois' book I have
At 2:42 PM -0500 7/17/01, John Hunter wrote:
>I have a table in which I want to eliminate duplicates, where I define
>a duplicate to be any two rows with the same values on field1 and
>field2
>
>This gives me the sort I want
>SELECT * FROM this_table ORDER BY name, time;
>
>But in addition I would
Hi,
have a question about the inno_data_home_dir line on mysql-max3.23
do I create a file called "ibdata" cause it's not in any directory by
default by default.
innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata
Pete
Crercio Osmaildo da Silva wrote:
>
> Hi,
>
> For windows systems, you can
So sprach »John Hunter« am 2001-07-17 um 14:42:13 -0500 :
>
> I have a table in which I want to eliminate duplicates, where I define
> a duplicate to be any two rows with the same values on field1 and
> field2
>
> This gives me the sort I want
> SELECT * FROM this_table ORDER BY name, time;
Unt
Problem under Win2000 with any file having a .cnf extension.
That extension is reserved by Win2000 as a system (Speed Dial) file
and will automatically hide the extension from you.
You can't search for it and it will not show it. IF you create a my.cnf
file, it appears as "my"
I use 'WINNT\my
Hello.
I've just created a table with a auto_increment column. I then did
ALTER TABLE tbl AUTO_INCREMENT=4711;
Now, when I insert one row into this table, it get's 4711 as the
auto_increment column's value. However, dumping this table with
mysqldump --opt DB tbl
loses the auto_increment va
I am moving from MS SQL to mySQL, Can anybody know how to create and grant
rights for a new user except of root?
Thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
Bonjour Jocelyn,
Avez vous installé automake, autoconf, autoheader et aclocal?
Also you can try updating I noticed several manual commits today use
this to update your source:
cd mysql-4.0
bk pull
bk -r edit
Which build script did you use? j'utile quelque chose comme ceci:
bash-2.04$ cat build
I have a table in which I want to eliminate duplicates, where I define
a duplicate to be any two rows with the same values on field1 and
field2
This gives me the sort I want
SELECT * FROM this_table ORDER BY name, time;
But in addition I would like to drop duplicates.
Is there a way to modif
Hi!
> "Pete" == Pete Kuczynski <[EMAIL PROTECTED]> writes:
Pete> Thanks Monty!
Pete> will this work on NT as well? or do I need to move to Linux.
Yes; We have MySQL-Max for both NT and Linux.
Pete> I don't much care if the tables are BDB or InnoDB, just that I have
Pete> transaction supp
Hi Michael,
As another FreeBSD user that has posted many times on FreeBSD
topics realted to MySQL it only took me a few minutes to find
resolutions, the problem is that some of the thread topics are
related and the answers were posted in a different thread from the
ones that orginally started
Hello,
I'm contacting you because we have recently released a new web development platform,
EO, that I would like for you to try out for use in building dynamic sites.
EO is a portable, flexible yet robust system that you can use to quickly build
interactive sites, plus it has features that p
Anybody:
I've installed (and got working!) MySQL on my Windows 2000 pc and am trying
to use the "my.cnf" file.
1) The manual says that my.cnf is included in the installation and that I
should copy it to c:\my.cnf. ("Copy the file `\mysql\my-x.cnf' to
`C:\my.cnf' and edit it to suit your s
Hi Chris,
mysqladmin shutdown
This is the best way to shutdown the server.
As for startup if you have a startup script you could run that (Ie
/usr/local/etc/mysql/mysq-server.sh)' or just invoke safe_mysqld Ie
( /usr/local/bin/safe_mysqld --user=username& )
Ken
- Original Message -
Fro
Hi!
Ok, I will add a special 'raw' keyword to 3.23.40, like:
innodb_data_file_path = hdd1:2000Mraw
Then it is enough that the raw disk partition is bigger than
2000 x 1024 x 1024 bytes. InnoDB will only use the specified
amount of the partition from the low end, and will also skip the
size chec
Can not start mysql
nor run mysqladmin
like:
[root@MrTamada data]# more MrTamada.err
010717 23:26:58 mysqld started
010717 23:26:58
/usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld:
Ca
n't create/write to file
'/usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/data/
MrTamada.pid' (Errc
I am quite new to programming in Linux although I am no stranger to
programming in Windows.
This is my problem:
I downloaded the mysql++ API and extracted it to /root/mysql++-1.7.9/
I browsed to /examples/ and thought I would try and compile simple1.cc.
This is what I did from the terminal:
term
Brian, Sorry for the late post, I would also recommend an upgrade to
3.23.39 this did help me on FreeBSD with a similar problem (that did
not happen very often).
Also if you are compiling from source make sure you use flags similar
to this to configure:
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-
I have a web page form that writes to a database and it has been working
just fine for a couple
weeks now, and all of a sudden it's not working today. The fail to connect
message doesn't even
come up.
Can't connect to database\n");
else:
mysql_select_db("todaysnews", $db);
endif;
$date = date(
Date |Tue, 17 Jul 2001 13:45:06 +0100
>From |Martin <[EMAIL PROTECTED]>
Hello!
M> Dear support,
M> I would like to use your GUI with my already installed and running
M> mysql-3.23.39 on my Linux 7.1 ppc susie installation.
M> As a real beginner to using Linux I quickly get stuck! I have downlo
On Tue, 17 Jul 2001, ken wrote:
> When I follow the binary install inst. I get the following messages.
> 161# ./bin/safe_mysqld
> dynamic linker : ./bin/my_print_defaults : error opening
> /usr/lib/libsocket.so.2
> ./bin/safe_mysqld: 24215 Killed
> Starting mysqld daemon with databases from
> /usr
Pete Kuczynski wrote:
> Hi,
> I understand mysql supported InnoDB and BDB table types for the purposes
> of transaction logging, which I need to use.
>
> Which is recommended by you folks for NT4 boxes.
Test both if you need to know :)
I believe that InnoDB is better now but this depends of
Jeff S Wheeler wrote:
> [This is an email copy of a Usenet post to "mailing.database.mysql"]
>
> Just insert a row with the initial value you want minus one, and then
> delete it. That will make the table do what you want.
>
> mysql> INSERT INTO Orders VALUES (-1, "", NOW(), -1, 125478);
>
That is exactly what I want, Thanks Rafal
PS: does anybody know if there are plans to support nested queries in mySQL?
> Hi,
> maybe something like this:
> select a.PersonId from PersonProject a left join PersonProject b
> on(a.PersonID=b.PersonID and b.ProjectID=2) where b.PersonID
> is null g
Well, you have to tell MySQL somehow how to connect those two
tables. You may want to check the syntax for JOINS to understand
what's going on.
> I have two tables:
> whenever I tried doing this select, mysql would hang
> indefinitely trying to resolve it or at least took
> t long I would r
Mr Alain KABUIKA wrote:
> I have made a script in PHP which creates a table in my MySQL database on Linux
>environment.
> When I run the script and give the name of table to create, there isn't problem if
>I'm using ASCII; but if I use a Japanese Charater encoded (JIS), I'm getting error
>mes
Hello.
On Mon, Jul 16, 2001 at 05:51:34PM -0700, [EMAIL PROTECTED] wrote:
> Question:
>
> given data in a table such as
>
> id, value, date
> 0, value1, 1999-01-25
> 1, value2, 1999-01-02
> 2, value2, 1999-01-04
> 3, value1, 1999-01-22
> 4, value2, 2000-01-01
>
> how can i select the latest 'i
'm install mysql on SCO 5.05 with apache.
When I follow the binary install inst. I get the following messages.
161# ./bin/safe_mysqld
dynamic linker : ./bin/my_print_defaults : error opening
/usr/lib/libsocket.so.2
./bin/safe_mysqld: 24215 Killed
Starting mysqld daemon with databases from
/usr/l
I am hoping the someone may be able to help me. I re-compiled mysql with debug on. The
server starts ok .. reports that mysqld is ready for connections. However I cannot use
ANY of the client tools .. mysql , mysqladmin etc ... as soon as I try to run any of
them it dumps with a seg fault ... s
You need to specify an initial record and limit number. Try this:
This will give you the first 10 results, starting at record 0 and moving up.
>From this page you can add something like this:
clickable text
//yadda, yadda, yadda...
?>
That link will transfer in the next initial record as n
Read all about Join in the manual -- it includes hints like this query:
SELECT DISTINCT(PersonID) FROM PersonProject AS P1
LEFT JOIN PersonProject AS P2 ON P2.PersonID=P1.PersonID AND
P2.ProjectID=2
WHERE P2.PersonID IS NULL;
Cheers,
Kent
TYPE=PACKED does not seem to be documented in Chapter 7.7 in the online
documentation. Where can I find a description of the PACKED option?
Also, can it be noted in the documentation that CREATE ... SELECT * FROM ...
does not create an exact copy of the table? Had I not been paying attention
I wo
Hi,
For windows systems, you can install mysql-max-3.23.39, that has support for
both BDB and InnoDB. For InnoDB you need to change my.cnf and include these
lines:
# For Innodb Databases
# change D:\WebApp\mysql\innodb and the other parameters to fit your
# needs
innodb_data_home_dir = D:\Webap
Pete Kuczynski writes:
> Thanks Monty!
>
> will this work on NT as well? or do I need to move to Linux.
>
> I don't much care if the tables are BDB or InnoDB, just that I have
> transaction support.
>
> Good luch with the Nusphere thing!
>
> Pete
>
>
> --
> _
> select distinct PersonID
> from PersonProject
> where ProjectID != '2';
>
> Is this what you are looking for?
No, what I'm looking for is...
SELECT PersonID
FROM PersonProject
AND PersonID NOT IN (SELECT PersonID
FROM PersonProjectID
Thanks Monty!
will this work on NT as well? or do I need to move to Linux.
I don't much care if the tables are BDB or InnoDB, just that I have
transaction support.
Good luch with the Nusphere thing!
Pete
Michael Widenius wrote:
>
> hi!
>
> > "Pete" == Pete Kuczynski <[EMAIL PROTECTED]>
Hi,
I have two tables:
whenever I tried doing this select, mysql would hang
indefinitely trying to resolve it or at least took
t long I would rather shutdown the whole machine.
SELECT m.username, m.class, u.password
FROM masterlist m, user u
WHERE m.class <> '' LIMIT 20;
However, when I in
Check the misc. functions section in the users manual 7.4.12 or thereabouts.
Specifically INET_NTOA() and INET_ATON().
[EMAIL PROTECTED] wrote:
> Hi,
>
> I have some large tables, which contain also IP-Adresses as strings.
> Is there any workaround (which uses MySQL-functions) to sort strings a
Greetings MySQL Aficionados,
The announcement below may interest some of you exploring new options
for connecting MySQL to the Web.
Also, we're looking for more MySQL experts to participate in our
pre-release software testing of Lasso Professional 5 with its
embedded MySQL database. If any of
user() is a function.
[EMAIL PROTECTED] wrote:
>> Description:
>
> I try to run mysql in conjunction with Apple WebObjects5 (the
>EnterpriseObjects Framework).
> This framework generates certain SQL Statements which fail (see How-To-Repeat).
>
>
>> How-To-Repeat:
>
>
Ok, tried to update existing table(s) to InnoDB [from MYISAM] using
"alter table da_table type=InnoDB;, but show variables still shows
table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it
installs with MYISAM only, not InnoDB options.
I cannot find any documentation on instali
Hi!
You should make an unformatted partition whose size is
divisible by 1 MB. If fseek does not understand the partition size,
we can disable the size check from InnoDB code.
Please report if you succeed. If not, I change InnoDB-3.23.40
so that you can disable the file size check.
I haver not t
Hi,
I have some large tables, which contain also IP-Adresses as strings.
Is there any workaround (which uses MySQL-functions) to sort strings as
numbers ?
Because, when i sort the records, the order is always 1.1.1.1; 1.1.1.10;
1.1.1.2. (which is correct if i'm sorting strings...)
But i need the
Hi again,
I've been given a better solution (wow you guys are speedy!), which is to
use an application_os junction table, which is the thing I was missing . .
. I was thinking of the junction table wrong, Thanks! If anyone has any
other suggestions, they will be appreciated, it's just that onc
Greets-
Newbie to the MySql gig, and I hope I don't come off sounding like an idiot.
I checked the manual, archives etc. and did not find anything about this: My
user dB seems to have nothing in it - no tables no columns no nothing. I'm
logged in as root and have full grants to all dB's. I know i
Hello,
We are looking to replicate a couple of databases on to a second server.
Having looked through the manual it says we need to add various commands to
my.cnf.
It turns out that we do not have a my.cnf (so apprently MySQL just
defaults), so can we just create this file with the replication c
fdisk /dev/hdd and set up partition 1.
Then try using hdd1.
Peter Duffy wrote:
> Hi,
>
> In the InnoDB section of the MySQL manual, it mentions that InnoDB can
> be used with raw disks, rather than data files. I've been trying to get
> this to work under Linux (RedHat 6.2), but so far without
select distinct PersonID
from PersonProject
where ProjectID != '2';
Is this what you are looking for?
Simon
-Original Message-
From: Glenn Wearen [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 14:18
To: '[EMAIL PROTECTED]'
Subject: Simple SQL Query?
How can I get a list of all PersonI
1 - 100 of 131 matches
Mail list logo
