At 1:23 -0400 6/26/03, [EMAIL PROTECTED] wrote:
I grown my db to 4 tables 8). I'm going to ask this plainly in
hopes that my "syntax" in ok:
I know how to SELECT * from 2 related tables and get all the records
listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been
I grown my db to 4 tables 8). I'm going to ask this plainly in hopes
that my "syntax" in ok:
I know how to SELECT * from 2 related tables and get all the records
listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been looking
some books!
How do get a resultset of
Hi Ted,
I believe you are looking for UPDATE . (no WHERE clause).
Warning: This will update ALL fields within a column.
INSERT... will insert a single datarecord, while UPDATE... will change a value
of a single field usually, but without WHERE clause it will update ALL fields
in a column.
I want to insert a value into a (one) field of all records in a table.
I tried:
INSERT INTO models (makeID) Values (1)
But that adds a new record, with the value filled in. I don't want a
new record, I want that value inserted into all the records of table
'models' 'makeID' field.
Thanks
hi there , i finally worked out union joines are supported in 4.0 i thought it was 4.1
, anyway what are possible examples of its uses ?
say i'm trying to join two tables the second table has 10 rows returned with the key
of the first table i would like to only get one record from the first tabl
On 25-Jun-2003 Mike Morton wrote:
> I have searched the archives and the docs - and I cannot seem to find or
> adapt an answer to this particular problem, hopefully someone out there
> either knows how or can say simply that it cannot be done.
>
> I have two tables that have the exact same schema
Hi Bruce, tlr7425 and MySQl List,
2003年 6月 26日 木曜日 10:25、Nils Valentin さんは書きました:
> Hi Bruce;
>
> I havent read Pauls book, but I will try to make an sample, also to confirm
> for myself what I stated before.
>
> I will come back to it once more. I am not sure if I should create a now
> post for t
Hi Paul,
2003年 6月 26日 木曜日 09:55、Paul DuBois さんは書きました:
> At 9:19 +0900 6/26/03, Nils Valentin wrote:
> >Hi Michael,
> >
> >you raised an interesting question.
> >
> >I created a new account (testroot) I gave him all privileges - except the
> >GRANT privilege.
> >
> >GRANT ALL ON *.* TO 'testroot'@'
This is what perror says about error 134
Error code 134: Unknown error 134
134 = Record was already deleted (or record file crashed)
Hpe that makes any sense to you.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 26日 木曜日 09:04、Ian Collins さんは書きました:
> My MySQL database just stopped. I had 47
Hi Bruce;
I havent read Pauls book, but I will try to make an sample, also to confirm
for myself what I stated before.
I will come back to it once more. I am not sure if I should create a now post
for this or continue this threat as it s kind of attached to it.
Thank you for your reply.
Best
Hi Vitcoria,
Thank you for the response. No more questions about this, all systems clear
now ;-).
Thank you so much.
Nils Valentin
Tokyo/Japan
2003年 6月 25日 水曜日 21:18、Victoria Reznichenko さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > WOW Victoria,
> >
> > thats a good explanation.
Thanks Mike for the response,
I didnt even think for a moment that CREATE... SELECT, INSERT ...SELECT etc.
wouldnt be a subselect command (also it is a nested query).
I dont know why I didnt think about that. Mike you mentioned a very good
point. Maybe I was thinking to focused to see the whol
Hi Singh,
I thought that it would be the privilege database. Nice to hear things are
sorted. ;-)
Perhaps you should use the time to explore how the privilege datbase is
working ;-). It certainly was a interesting experience for me. There are some
good articles at www.devshed.com / something "s
At 9:19 +0900 6/26/03, Nils Valentin wrote:
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql> show grants for testroot;
+---
Nils:
(B
(BNot exactly... :)
(B
(BI know for sure that there are 4 matching records - when I do:
(B(Select count(*) from orders where member_id='2') union (select count(*)
(Bfrom old_orders where member_id='2')
(B
(BI get:
(B
(B+--+
(B| count(*) |
(B+--+
(B|1 |
Hi Mike,
Just a guess. Is perhaps one of the 4 records you mention a NULL record
(meaning no entry) ?
Why I am asking is because in this case you may want to use INNER JOIN or even
LEFT JOIN which should return also the NULL entry (incomplete datarecords).
That would make it
Select count(*)
Hi
I agree the SCO action sucks but Open source software should be just that -
open to all, let the courts decide, if it ever gets that far!.
Peter
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 01:18
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Subject:
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql> show grants for testroot;
+-
On Wed, Jun 25, 2003 at 05:08:27PM -0700, Daevid Vincent wrote:
> mySQL should stop supporting SCO after their ridiculous allegations.
How does MySQL support SCO?
Or are you talking about MySQL abandoning their customers who are
using SCO for one reason or another?
Jeremy
--
Jeremy D. Zawodny
mySQL should stop supporting SCO after their ridiculous allegations.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My MySQL database just stopped. I had 47 users running on it who just
stopped being able to access the database.
The .err file in the MySQL data directory has,
Version: '4.0.11-gamma-standard-log' socket: '/tmp/mysql.sock' port: 3306
030611 10:45:45 mysql_ha_read: Got error 124 when reading ta
What I've done is insert a bogus record at ID 999, then the next one will be
1000 and upwards. You can then delete the 999 record if you wish. mySQL will
NOT fill in the 1-999 spots automatically.
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June
I didn't mean for just this instance and this specific AES option (heck, I
don't even use AES at all ;-), I'm just saying that anywhere within the
mySQL .h files that has an option that someone may wish to edit in a
practical scenario, should be changeable via the my.cnf file instead/in
addition to
hi there i was wondering if there is anyway to setup static variables in mysql , ie to
setup predefined paths in mysql . so all i can do is go select variablname as path etc
.. ??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
In a Pro C source file, a programmer uses the 'EXEC SQL ...' phrase to
execute sql statements against the Oracle data base. Is the something
comparable to this is the MySQL C API that I can use instead of
manually building sql statements for insert, select, delete, drop, etc.?
Sean Mac Millan
Sounds like your windows install process is not complete, check
http://www.mysql.com/doc/en/Windows_installation.html for more info.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Russ Guillemot [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 4:15 PM
> To:
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program for users to access
the data in the datbases. New databases will be added in later. I
want to create a user to access these databases with certain rights,
not all rights. Will I have to grant this user
The output of the greps follows. Could it be the mysqlclient that is
causing the trouble?
Kevin
[EMAIL PROTECTED] root]# rpm -qa | grep My
MySQL-python-debuginfo-0.9.1-7
Mysql-DBI-perl-bin-1.1825-1
MySQL-shared-3.23.53a-1
qt-MySQL-3.1.1-6
MySQL-python-0.9.1-7
MyODBC-2.50.39-11
perl-DBD-MySQL-
On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote:
> I want to be able to take a database running on a primary server and
> duplicate/mirror it on a secondary server. I want to be able to update
> the secondary server on a selectable interval (every 15 mins, every
> hour, etc). Wh
I use Lotus Approach on (Win XP) to open a text comma delimited file, then I save it
as a dbf4 file. But tiimes are changing and files are getting too big for dbf4, so I
want to have the unlimited power of mySQL to be able to open HUGE files..
I'm trying to get my Lotus Approach to be able to c
Hi,
I am creating a small web based program for users to access the
data in the datbases. New databases will be added in later. I want to
create a user to access these databases with certain rights, not all
rights. Will I have to grant this user right to each database as I add
them in or
Using the C API for MySQL I am trying to convert a piece of ProC code
so that I can use it in MySQL and I am having a bit of a problem. The
function prototype lloks like the following:
int write_blob(db_thread_t* dbh, OCIBlobLocator* blob_in, unsigned
char* data, uint32_t data_len)
I am not
Would there be any reason why I couldn't have MySQL running on the same box
as SQL Server 2000?
Thanks,
Steve
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
MySQL General
On June 25, 2003 09:59, PAUL MENARD wrote:
...
> > I've been considering upgrading my data , MySQL
> > 3.23.42 to 4.013 or even going to 4.1. I've read on
> > the MySQL upgrade documents that some client might be
> > affected when upgrading to 4.1. It does specifically
> > mention Perl which I use
I don't know where the error log is. I used the -l option with
safe-mysqld and this is what I got:
/usr/libexec/mysqld, Version: 3.23.56-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id CommandArgument
On Wed, 2003-06-25 at 15:40, gerald_clark
I have searched the archives and the docs - and I cannot seem to find or
adapt an answer to this particular problem, hopefully someone out there
either knows how or can say simply that it cannot be done.
I have two tables that have the exact same schema, orders and old_orders:
order_id bigint(20)
You could use replication of the occasional MySQLDump. Replication will
make your development server a slave to your production server, causing
every query done on the master to be reproduced on the slave.
See http://www.mysql.com/doc/en/Replication.html for more info.
Mysqldump will create a sc
What does the error log say?
David Shealy wrote:
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld &. Here's a copy of the shell output:
# safe_mysqld &
[1] 7549
# Starting mysqld d
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld &. Here's a copy of the shell output:
# safe_mysqld &
[1] 7549
# Starting mysqld daemon with databases from /var/lib/mysql
030626 02
At 11:51 -0700 6/25/03, Satheesh Ganapathi Subramanian wrote:
Hi
I'm trying to create an application linked with libmysqld.a to
create an embedded server. Can my application act as a client to
connect to a remote server ?
To be more precise, I would like to use
mysql_real_connect(db, "remoteser
I have two server running Appache + PHP + MySQL.
Server #1 is production and server#2 is development.
I would like to keep MySQL DB on server#2 up to date. That is any
changes happening on server#1 I would like to be reflected on server#2.
Does anyone know how to do this?
Thank you in advance.
Hi
I'm trying to create an application linked with libmysqld.a to create an embedded
server. Can my application act as a client to connect to a remote server ?
To be more precise, I would like to use
mysql_real_connect(db, "remoteserver.xxx.com", "mysql", 0, 0, 0, 0, 0).
When I do this, it s
Hi
If you log into MySQL on the command line and enter
mysql>SHOW PROCESSLIST ;
this should show you what is running. You may find a runaway query.
also check the temp disk space while the system is stalling - large joins
can use huge amounts of disk space. If MySql runs out of disk space it
t
I must add, to be honest, and everything is clear :)
I did not install 3.23.52 on Red Hat 9.0, so it may in fact be that way for all
versions of mysql on RH9
Sorry about that.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 1:04 PM
To: Luc F
Hello All
I'm desperate. Since two days my Server crashed several times.
This is what happens :
The Webserver ist not responding any more. If i'm lucky i can still log
in.
System load ist 90+(!!!) rapidly increasing.
Top shows a LOT of mysql processes all eating CPU like hell. There are
also
a lo
On 25-Jun-2003 Brent Genereux wrote:
> I have odd characters in my database that appeared after updating from a
>
> I've copied the character into a text editor that can display the
> hexidecimal value of the characters. The square character is different
> than
> a space, but for some reason wh
> Message du 23/06/03 23:23
> De : leking1 <[EMAIL PROTECTED]>
> A : jessjaffre <[EMAIL PROTECTED]>
> Copie à :
> Objet : TR: Fw:Fwd: tr:fw:apparemment ça marche!
>
>
>
>
>
> -- Entête Initiale ---
>
> De: "tiniwoopmarie" <[EMAIL PROTECTED]>
> A : "leking1" <[EMAIL PROTE
Hi,
Since i don't know what is "played for Sussex in two separate spells" --
what's a spell ? (sorry) -- i assume it's a different period of time,
but don't know how to calculate it.
Ignoring the "spell", i did this:
SELECT A.Playerid, A.Teamid, sum(if (A.Substitute=1,0,1))
not_a_substitute, sum(
Hello, all.
As of Friday the 20th, I'm running MySQL 3.23.56-1.72 on Red Hat 7.2, at
which time a consultant overwrote the existing MySQL-3.23.49a /
MySQL-Max-3.23.53a installation.
The server won't start up, and the mysqld.log file reports:
030624 17:24:25 mysqld started
/usr/libexec/mysqld:
I have odd characters in my database that appeared after updating from a
previous database. Most often the characters appear as simple squares where
spaces should be. I've been trying to make a query that will find where all
these characters appear in my table. The SQL looks like this:
SELECT * FR
At 12:41 -0400 6/25/03, Luc Foisy wrote:
Yes, I turned those runlevels on already and now it works.
The problem is that it was a practically default install, that is
the way the runlevels were set "out of the box"
3.23.56 was this way after install
mysql 0:off 1:off 2:on3:off
Hello everyone,
I am new to using MySQL and have installed a copy on my laptop which is
running Windows 2000. I am having an issue with setting up the root user
account. When I ran MySQL for the first time I was prompted to give a
generic user id and password. I did that, but when I run this SQ
Im needing help in installing the fuse server and stuff
email me please if u can help
Kevin H. Phillips wrote:
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log
I'm attempting to write one SQL statement to retrieve data in a
particular way, and don't seem to be able to do it despite dozens of
attempts (indeed maybe it cannot be done), but wondered if anyone could
suggest anything, such as a function I may have missed that can do it,
or that it simply isn't
Yes, I turned those runlevels on already and now it works.
The problem is that it was a practically default install, that is the way the
runlevels were set "out of the box"
3.23.56 was this way after install
mysql 0:off 1:off 2:on3:off4:on5:off6:off
3.23.52 was this
Do you have any sort of `shell` access to the box? SSH? Telnet?
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange "Mull" in show fields and table keeps crashing
I'm not sure what errors a
On 25-Jun-2003 Rob wrote:
> Hi all,
>
> Is there any way to do a mysql dump in which each table is dumped into a
> separate file. I know I can use the --tables option to specify a table,
> but this means I have to type out each table name (and there are a lot
> of them). Is there any way to get
Hello,
I have a MySQL server running with some users besides root, that I want to grant all
privileges for their own databases, but no rights for anything else.
So to say, I have a user web01 that shall be able to do whatever he wants with the
database db01. There are more databases, like db02 et
At 10:55 -0400 6/25/03, Luc Foisy wrote:
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0
When it installed, it started up mysql, no problems, I could do all
mysql functions
I recently rebooted the box, and mysql did not start automatically.
I can start it if I run /etc/rc.d/init.d/mys
Hi All,
Im a member of a similar PHP email list and posed the question to community about
issues anyone has experienced with being able to connect to MySQL 4.1. Below are my
email and a response. Is this reply statement correct? Why would MySQL break an
interface to clients? Read his com
Something interesting that may be my problem
This is a known working install
# mysql --version
mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
# find /etc/rc.d -name *mysql
/etc/rc.d/init.d/mysql
/etc/rc.d/rc0.d/K90mysql
/etc/rc.d/rc1.d/K90mysql
/etc/rc.d/rc2.d/S90mysql
/etc/rc.d/rc3.d/S
update is a reserved word in MySQL. Choose another username.
Lian Sebe
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Adam Lawrence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 5:10 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.0.13 GRANT syntax
I installed the RPM version of MySQL 3.23.56 on Red Hat 9.0
When it installed, it started up mysql, no problems, I could do all mysql functions
I recently rebooted the box, and mysql did not start automatically. I can start it if
I run /etc/rc.d/init.d/mysql start
Is there any know problems why
I'm not sure what errors are being reported to the server. I'm not sure how
to get those. I am not local to the box.
Is there a way to look at the log files without being at the box?
Karl
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Karl J. Stubsjoen'" <[EMAIL
Sorry the problem fixed itself, and I mistakenly sent this email
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Phil Dowson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 9:01 am
Subject: Re: CREATE TEMPORARY TABLE
> And what would that b
Does enclosing the username and host in single quotes help?
I.E. GRANT SELECT ON *.* TO 'update'@'localhost' IDENTIFIED BY 'update';
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Adam Lawrence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 8:10 AM
> To:
On Wed, Jun 25, 2003 at 10:09:58AM -0400, Adam Lawrence wrote:
> I am attempting to modify the GRANT table using the syntax specified in the
> MySQL 4.0.13 documentation, and am getting error messages claiming the
> syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
> mysqlc
The problem is that when I only define the "%" host,
then no password is required to log in... (not a
wanted feature!). I CAN log in, i just have to specify
no password.
The password checking is only done for localhost
--- [EMAIL PROTECTED] wrote:
> What about using the username only instea
> -Original Message-
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
> Actually, you can create larger files on 32bit Linux systems
> as well. It's
> just that the file system and the C library must have support for LFS
> (Large File Support):
>
> http://www.suse.de/~aj/linux_lfs.html
You may want to try disabling the index during the insert:
ALTER TABLE table1 DISABLE KEYS;
insert into table1 select * from table2;
ALTER TABLE table1 ENABLE KEYS;
And see what that does.
See: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original
You can change your charset by adding a line in your mysql configuration
file like this.
default-character-set = cp1256
Here cp1256 means that mysql will use Windows Arabic character set. I
don't know the difference between farsi and arabic charsets. And also I
don't know if mysql has a far
The TIMESTAMP column type does this for you:
See: http://www.mysql.com/doc/en/DATETIME.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: MaFai [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 11:01 AM
> To: [EMAIL PROTECTED]
> Subject: datetime column dumm
What about using the username only instead of username@"%" ?
According to manual (section 7.34) it should be identic in behaviour:
[...]
The simple form user is a synonym for user@"%".
[...]
Does it do the same?
Lian
P.S. Andy, sorry for posting by mistake to you. ;-|
> -Original Message-
You need simply add the column predefined as AUTO_INCREMENT and PRIMARY
KEY:
CREATE TABLE incrtest (
name varchar(100) NOT NULL
) TYPE=MyISAM;
INSERT INTO incrtest VALUES("ben");
INSERT INTO incrtest VALUES("bob");
INSERT INTO incrtest VALUES("bom");
INSERT INTO incrtest VALUES("gddo");
INSERT
Thanks you Nils .
(B
(B I truly appreciate how helpful you have been !! I have now got the
(Berror sorted out now.
(B
(BI re-installed MySQL on my Mac OS Jaguar 3 times. Finally the third
(Btime I got it to run. Somehow I had corrupted my User.MYI file
(BI did have to delete the /usr/loca
I am not sure that could be viewed as a subselect, as it in not a SELECT
within an SELECT, but is instead a SELECT within a CREATE. I would
imagine that the SELECT within the CREATE is easier to implement that
the actual SELECT within a SELECT.
Regards,
Mike Hillyer
www.vbmysql.com
> -Origin
I think you need the -T option, which will break out table data to
separate files. Here's a description from the manual:
-T, --tab=path-to-some-directory
Creates a table_name.sql file, that contains the SQL CREATE commands,
and a table_name.txt file, that contains the data, for each give table.
yesterday i had same problem on 4.0.13 for win
added [EMAIL PROTECTED] - and was rejected
added [EMAIL PROTECTED] - then accepted
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:54 PM
To: Roman Neuhauser; Riaan Oberholzer
Cc: [EMAIL PROTE
I am attempting to modify the GRANT table using the syntax specified in the
MySQL 4.0.13 documentation, and am getting error messages claiming the
syntax is incorrect. (I'm running MySQL on Windows 98, by the way.) I used
mysqlc with root access.
mysql> USE mysql;
Database changed
mysql> GRANT SEL
MyISAM tables do not support row-level locking, only table locking.
See http://www.mysql.com/doc/en/Table_locking.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Cedric Gavage [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 2:14 AM
> To: [EMAIL PROTEC
"Phil Dowson" <[EMAIL PROTECTED]> wrote:
>
> I am running two identical systems, the only difference between the two are
> the database name and username. The problem I am getting only occurs on one
> of the systems. I am running
What exactly problem do you have?
--
For technical support cont
Riaan Oberholzer <[EMAIL PROTECTED]> wrote:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the password authentication to kick
> in. Only supplying no password (empty string)
> succeeded. Even after
In a situation with many concurrent reads and writes an InnoDB table
would be preferable.
See http://www.mysql.com/doc/en/Table_types.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 2:
And what would that be?
Phil Dowson wrote:
Hi,
I am running two identical systems, the only difference between the two are
the database name and username. The problem I am getting only occurs on one
of the systems. I am running
--
MySQL General Mailing List
For list archives: http://lists.m
I simply followed the directions listed here:
http://www.mysql.com/doc/en/SCO_UnixWare.html
And I had no problems.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Sudhipan Sharma [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 25, 2003 3:08 AM
> To: [EMAIL PROTECTED
[snip]
Please excuse the cross-post again, but this is still dealing with how
PHP and MySQL together handle memory allocation.
[/snip]
One final note...it came to pass this morning that we looked closely at
many issues concerning this. Once of the things discovered was some
"bad" RAM in the serve
On Wed, 25 Jun 2003, Sudhipan Sharma wrote:
> Hi !
> Just wanted to know if there is any installation procedure available on =
> UnixWare 7.1.x. There is patch available for SCO UnixWare libz.so, which =
> I have downloaded but Iam not able to initialize ./Configure script. =
> Any help/support wi
Maybe it does, or maybe it doesn't; but if you're connecting to your
server on the localhost, you're probably connecting through a pipe/UNIX
type socket instead of over the network. This might be the distinction
that matters in this case; does @localhost in this context mean through a
non-network
> I believe "%" doesn't include "localhost", but I could be wrong.
"%" Does indeed include localhost. At least it does on 4.0.13.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
PAUL MENARD <[EMAIL PROTECTED]> wrote:
>
> I'm having an intermittent problem with a MySQL server that I have running on a
> Windows 2000 Advance server systems. This issue occurs every few days depending on
> the load of the system.
>
> Here are the details.
>
> MySQL version 3.23.42-nt (I k
"mohammad kh.tajer" <[EMAIL PROTECTED]> wrote:
>
> I use unicode to store farsi data in mysql database but I have problems sorting it
> using ORDERBY command...(ORDER BY does'nt work properly)
> I don't know what to do .
> 1---)pleases help me if there is any solution for me to define a char
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> WOW Victoria,
>
> thats a good explanation. That makes many things clearer now.
> Thank you very much.
>
> However, when not having the set the tmpdir variable were are the temporary
> tables stored ? (I searched the whole harddisc) I assume in thi
To also add priviliges on the local machine
GRANT ALL ON *.* TO username@"localhost" IDENTIFIED BY
"password"
Riaan Oberholzer wrote:
Hi,
I am created a user by using:
GRANT ALL ON *.* TO username@"%" IDENTIFIED BY
"password"
I did this from the mysql command line tool, logged in
as root. Th
In the second query, the server may switch the order of the join,
producing the same output in different order.
Try adding an ORDER BY to both and see what happens.
[EMAIL PROTECTED] wrote:
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
your MUA doesn't properly represent quotation marks, breaking them
in other MUAs.
# [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the passwor
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100:
> Im altering a number of table from MyISAM to innoDb and adding foreign
> keys.
>
> The alteration of the table type works.
> Adding the row as an index works.
> Adding the foreign key fails, generating the error:
>
> alter table project add FORE
I think we need more info: Table definition, MySQL version etc..
Med venlig hilsen
Lars Geisler
>
> -Original Message-
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> To: "Amit Lonkar" <[EMAIL PROTECTED]>
> CC: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Subject: Re: Query Execution Time
Nils Valentin wrote:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Inludes NULL records
I meant the first statement returns also empty record fields or should I say
incomplete data records ?
Is not producing the same results as this
Hi All,
Im altering a number of table from MyISAM to innoDb and adding foreign keys.
The alteration of the table type works.
Adding the row as an index works.
Adding the foreign key fails, generating the error:
alter table project add FOREIGN KEY (company_id) references company (id)
[mySQL] E
1 - 100 of 149 matches
Mail list logo