Hi All,
Just a quick question: How do I set the auto increment
for a field to start from an integer other than 1.
For example, I would like to be able to have the auto
increment counter start from 1000.
Thanks,
Javan.
Want
Hi tlr7425,
Besides what I said in my last e-mail I completely overlooked that
> > SELECT * FROM machines INNER JOIN people ON
> > machines.machinesID=people.peopleID;
should be
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Even though my first statement sho
2003年 6月 25日 水曜日 15:[EMAIL PROTECTED] さんは書きました:
> This:
>
> SELECT * FROM machines INNER JOIN people ON
> machines.machinesID=people.peopleID;
Inludes NULL records
>
> Is not producing the same results as this:
>
> SELECT lastname, model FROM people, machines WHERE machines.peopleID =
> people.pe
Erm, the first sql as i can see doesn't connect on the same field as the
second one that produces the correct result.
George Christoforakis
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 9:01 AM
Subject: Join vs. Where (he
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. The command succeeds and the new user is
created in the mysql.user table, but the password does
not work. I can only use this new user if I
Ok, should be this:
SELECT * FROM machines INNER JOIN people ON
machines.peopleID=people.peopleID;
Ted
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machine
I needed to add a new, autoincrementing, primary key column
to a table and have been struggling to figure out how to
assign an initial, unique value to each row.
I finally accomplished my task, but feel sure there's an
easier way.
Here is my solution:
1. Add the column:
alter table mytable ad
This:
SELECT * FROM machines INNER JOIN people ON
machines.machinesID=people.peopleID;
Is not producing the same results as this:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
Can someone please tell why, what's wrong?
(What happens is that the wrong p
SELECT Place.id, Place.name FROM Place
LEFT JOIN Place_link ON Place.id=Place_link.Place
WHERE Place.id!=1 AND Place_link.LinkTo!=1;
This section of the manual will probably help you further.
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
Edward Dudlik
Becoming Digital
www.becomingdig
Thank you for your response to my first post on this list. I really
appreciate your time to answer my question.
I tried every thing I could think following the manual for LOAD DATA before
I joined this list. I probably did not explain my problem clearly in my
initial post. What I try to do is t
At 16:02 +0300 6/17/03, Baris Akin wrote:
Hello,
I try to get last inserted autoincrement record ID on table with
LAST_INSERT_ID() function (SELECT LAST_INSERT_ID() FROM TABLE). Every
connection returns it's own last inserted ID not actual ID. Is this a
bug? Also it returns more than one record
>Description:
mysqlhotcopy does not read defaults from my.cnf and .my.cnf files.
>How-To-Repeat:
Run mysqlhotcopy and observe it doesn't read client defaults.
>Fix:
See below for patch, shown as a context diff
>Submitter-Id:
>Originator:Larry Stone
>Organization:
MIT
Uuups I meant 16 bytes and 45 bytes of course ;-) - otherwise anybody with a
286 could have found out ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 25日 水曜日 07:35、Nils Valentin さんは書きました:
> in Version 4.1 the passwords are 45 bits
> in Version <4.1 passwords are 16 bits
>
> Upgrade your cl
At 9:54 +0100 6/17/03, [EMAIL PROTECTED] wrote:
I am using MySQL 4.1 alpha for windows for new development. Is MyODBC
3.51.06 supposed to work for MySQL 4.1 alpha? I get message
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol
requested by server. Consider upgrading MySQL c
At 9:17 +0200 6/17/03, Laura del Cano wrote:
Hello,
I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000.
I create a new database in Mysql and a user with all the privileges on it
(using GRANT ALL privileges...).
I create a User DSN in the windows Control Panel and when I test the
connec
Hi all,
I just looked at the mysql doc and I didnt find an answer to my question.
does mysql has the minus statement ? or is there something similar ?
SELECT something FROM somewhere MINUS SELECT something_else FROM somewhere;
Or this one could do the job but mysql doesnt seems to accept it e
I am getting a list of all countries from database, and then I am
sorting by country name. However since most orders will be from US I
want the US to appear first over the rest of the countries. How can I go
about doing this?
Currently, this is my query:
SELECT countries_id, countries_name FROM T
At 13:19 -0500 6/24/03, Jay Blanchard wrote:
Other than mysql_free_result() how can I free up memory upon the
completion of a query?
Why don't you want to use the function that is provided for that
purpose?
TIA!
jay
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.my
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). What is the best way to accomplish this task? Consider that
at least one table
On Wed, 25 Jun 2003 11:29:25 +0800
"MaFai" <[EMAIL PROTECTED]> wrote:
Hello, mysql,
After create a table,it can use desc tablename to
describe the table scheme.
But it can not demonstrate that the column is unique
or not.It just simplely show the column is MUL type.
How can I get more
Hello, mysql,
A table contains a column named "mydate".
//Wrong sql statement
alter table p_asset add mydate datetime default now();
alter table p_asset add mydate datetime default time();
alter table p_asset add mydate datetime default now;
alter t
Hi All,
I have 2 tables say "table1" and "table2" in the
database. I am using the following query to copy all
the data from table2 to table1.
insert into table1 select * from table2;
Table2 has some 10,000 records while table1 has around
11,00,000 records. The time reqd. to execute the above
qu
Hello, mysql,
After create a table,it can use desc tablename to describe the table scheme.
But it can not demonstrate that the column is unique or not.It just simplely show
the column is MUL type.
How can I get more information from the table by using mysql commend?(Except use
my
Kevin H. Phillips wrote:
I changed the port in /etc/my.cnf and restarted the service but still
get a message that I can't connect to the server, etc.
I am still not seeing any "fresh" log messages. Why would there not be
any output on that? Is there someplace I should look for a log file
besi
Hi MySQL Fans ;-),
I have some questions about temporary tables. I would appreciate any replies:
I created a temporary table f.e. like this:
mysql> create temporary table temp SELECT * FROM relations;
Query OK, 4 rows affected (2.35 sec)
Records: 4 Duplicates: 0 Warnings: 0
When I do
mysql>
> If possible, what is the syntax?
It's possible, but if you can't search, I'm not sure you can handle it. ;P
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWT
in Version 4.1 the passwords are 45 bits
in Version <4.1 passwords are 16 bits
Upgrade your client will make it work again.
You sould be able to connect from any 4.1 mysql client.
Best regards
2003年 6月 25日 水曜日 03:[EMAIL PROTECTED] さんは書きました:
> Does anyone know what is different in mysql 4.1 clie
On Tue, Jun 24, 2003 at 02:54:23PM -0700, Mike wrote:
> Can anyone point me to docs on installing MySQL on Red Hat 9 on an Intel box?
I don't think it's any different from previous RedHats.
Downlaod the RPMs from www.mysql.com. Install them using "rpm -i
*.rpm"
Granted, I'm no RH expert, but I
At 12:44 2003-06-24, Janice Wright wrote:
Well, in the Managing MySQL course run by MySQL AB; they taught
us that upgrading hardware is the *last* thing you do to get the
database to run faster, not the first. Before you buy new
hardware you should:
Thanks for the info! (appreciate it)
Though I
Can anyone point me to docs on installing MySQL on Red Hat 9 on an Intel box?
Thanks,
-m
===
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Jun 24, 2003 at 03:34:48PM -0500, Todd Burke wrote:
>
> Hello
>
> 1/ I have a search engine which crawls auction sites and returns
> information which is inserted into a mysql database. This activity
> represents on average about 3 inserts per second with a combined payload
> of 450 byte
MUL indicates a that the column is part of a composite INDEX.
SHOW INDEX FROM tablename
Should let you know what columns make up the MUL column INDEX.
If this was not supposed to be indexed, your table is corrupt, best try
MyIsamChk
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Messa
On Tue, Jun 24, 2003 at 05:37:24PM -0400, Curtis Maurand wrote:
>
> Linux compiled on an opteron and targeted for it will lose the 2-gig
> process limit. the 2-gig number is based on a 32 bit integer. You now
> would a have 64 bit integer (5 Quintillion as an unsigned integer. :-)).
>
> Imagi
I changed the port in /etc/my.cnf and restarted the service but still
get a message that I can't connect to the server, etc.
I am still not seeing any "fresh" log messages. Why would there not be
any output on that? Is there someplace I should look for a log file
besides /var/log ?
Kevin
--
Linux compiled on an opteron and targeted for it will lose the 2-gig
process limit. the 2-gig number is based on a 32 bit integer. You now
would a have 64 bit integer (5 Quintillion as an unsigned integer. :-)).
Imagine the 10GB database in memory, plus the temp and heap tables and the
index
Hi,
What about upgrading to MySQL 4.0.13 ?
4.0.0 is not a "production" release, and a lot of bugs have been fixed
between 4.0.0 and 4.0.13.
Regards,
Jocelyn
- Original Message -
From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 24, 2003 11:13 P
You should find the following informative:
http://www.mysql.com/doc/en/Table_types.html
InnoDB offers transaction support, and seems to recover better from
crashes. You do sacrifice some speed and features such as FULLTEXT index
support.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Me
The `MUL` indicates that the column have multiple values. When the server
`crashes`, what errors are being reported log file?
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 4:13 PM
To: [EMAIL PROTECTED]
Subject: Strange "Mull" in show fiel
Okay I tried to set it up on the server when trying the testbench it just blinks and
doesnt do anyhting any 1 know why the site didnt help me www.sulake.com/fuselight
could it be the port the host or what ?
Hello,
I have this table:
"CLUB"
Field Type Null Key Default Extra
clubid int(11) PRI NULL auto_increment
clubusgf int(11) UNI 0
program char(3)
url varchar(75)
email varchar(75)
phone varchar(14)
fax varchar(14)
address1 varchar(75) MUL
address2 varchar(75)
city varchar(75)
notes varchar(255)
z
What I'm trying to do is as root user.
Kevin
John Nichel wrote:
Are you trying to stop the server as root, or some other user?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It would be really nice if ANY of these kinds of configuration options were
settable via the /etc/my.cnf file. I use RPM's almost exclusively for their
ease of maintenance, compatibility and stability and I certainly wouldn't
want to go and have to re-compile anything just to change a value from 12
Hi MySQL doc team,
I have was wondering if a change could be made so that when I browse
the MySQL docs in some selected language there is a search window that
searchs first the language I have currently selected. The search
always returns the english documentation page even when the page
exists
Can anyone either summarize for me a comparison between the MyISAM and InnoDB MySQL
table type?
I am getting ready to upgrade from MySQL 3.23.42 to 4.0.13 in the coming week and
started reading the upgrade documents on the www.mysql.com site. Never had even
thought about using another table t
Michael Conlen wrote:
64 bit servers have different performance characteristics and tend to
be used for different things. than PC systems. They are generally
backplanes to which are attached some number of processors and some
amount of memory, and a lot of IO. They aren't used as much for
pr
On Tue, Jun 24, 2003 at 01:25:25PM -0700, Gabriel Guzman wrote:
>
> not exactly relevant to this discussion but... Apple did just release
> the new G5, 64bit PowerMacs. Could be another alternative for the
> inexpensive 64bit market. Granted, they don't ship until august, but
> they are nice to
Funny. I was just readin about this on the www.mysql.com web site. Under the
documentation section about upgrading form 3.23 to 4.0. The exact URL is
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
Ensure that you don't have any MySQL clients that use shared libraries (like the Perl
DB
Hello
1/ I have a search engine which crawls auction sites and returns
information which is inserted into a mysql database. This activity
represents on average about 3 inserts per second with a combined payload
of 450 bytes per second added to the database. This updating occurs
continuously thr
Hi all,
I am trying to create tables and insert data into MySql Version 3.23.53-Max
database on HP 900-UX 11 - 32 bit server. For some reason a job , which is
suppose to take 45 mins, is not completing even after 2 days. It means all
jobs against mysql are running very slow on HP 900-UX 11 - 32 b
not exactly relevant to this discussion but... Apple did just release
the new G5, 64bit PowerMacs. Could be another alternative for the
inexpensive 64bit market. Granted, they don't ship until august, but
they are nice to look at:
http://www.apple.com/powermac/
from their site:
The Power Mac
Kevin H. Phillips wrote:
The output of the grep is:
[EMAIL PROTECTED] root]# ps -ax | grep mysqld
4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf
4601 ?S 0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
64 bit servers have different performance characteristics and tend to be
used for different things. than PC systems. They are generally
backplanes to which are attached some number of processors and some
amount of memory, and a lot of IO. They aren't used as much for
processor speed (you could
try to bk pull the mysql 4.0 from CVS tree...
after I run:
aclocal; autoheader; autoconf; automake
inside dir...
the error is:
autoconf: Undefined macros:
configure.in:8:AC_CONFIG_HEADERS(config.h)
configure.in: 8: `automake requires `AM_CONFIG_HEADER', not `AC_CONFIG_HEADER'
Not necessarily. People that need relatively affordable 64 bit systems
may be waiting for the Opteron to stabilize. My experience is the Wintel
solutions (like Opteron) tend to have at least a 2-1 price performance
over Sun and Dec. Also, given that HP has basically dropped Alpha, I
don't think
Hello,
Is it possible to create a foreign key that referencestwo columns, if
the referenced table uses more two colums for it's primary key?
If possible, what is the syntax?
Mikael Engdahl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
David Griffiths wrote:
> I'm surprised there is not more interest in this; is it that not many work
> with large-ish (10+ gig) databases that need high-end performance?
>
> A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor
will;
>
Excellent point. How does MySQL run on Tru64? Any familiarity with it on
Intel32?
But there are some big drawbacks to these platforms:
- they only run apps that have been specifically ported and compiled for
them. The Opteron runs the same 32-bit code that an Athalon or Pentium class
computer wil
In the last episode (Jun 24), David Griffiths said:
> I'm surprised there is not more interest in this; is it that not many
> work with large-ish (10+ gig) databases that need high-end
> performance?
I think we have a mysql database running on Tru64, and I'm sure it runs
great on Solaris. My gues
Stop the process you currently have or start up the server on a port other
than 3306.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 1:46 PM
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
The output of the grep is:
[EMAIL P
Does anyone know what is different in mysql 4.1 client authentication from mysql 4.0?
After upgrading to 4.1 my scripts can no longer connect and produce the following
message:
Client does not support authentication protocol requested by server. Consider
upgrading MySQL client
--
MySQL General
The output of the grep is:
[EMAIL PROTECTED] root]# ps -ax | grep mysqld
4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf
4601 ?S 0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr --datadir=/var/lib/mysql
--user=mysql --pid-file
check that the permissions in the data directory are correct.
If mysqld does not have write perms in that directory, it will not start.
ls -l /var/lib/mysql
mysql_install_db "used" to set the permissions to the user that ran the
script (usually root).
-Original Message-
From: John Nich
Other than mysql_free_result() how can I free up memory upon the
completion of a query?
TIA!
jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just installed mysql 4.1.
The same perl/DBIscripts which worked fine on 4.0 now failing toconnect
with the following error:
DBI connect('host=localhost;database=webdb','webdev',...) failed: Client
does not support authentication protocol requested by server. Consider
upgrading MySQL client at ./i
I'm surprised there is not more interest in this; is it that not many work
with large-ish (10+ gig) databases that need high-end performance?
A 64-bit CPU won't have the 4-gig memory limit that a 32-bit processor will;
even worse, Linux is apparently limited to about a 2-gig process.
SuSe Enterpr
Hello All,
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 know I need to upgrade. Soon).
Machine:
Wi
Nevermind...
Just read an interesting comment in the MySQL online docs.
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
First user comment pointed me in the right direction.
Thanks for your help though. Much appreciated! (Especially when I
upgrade to 4.x)
--
Greg
On Tue, Jun 24, 2003 a
On 24-Jun-2003 Fred Whipple wrote:
> Don't forget to use '-B' in order to make the output silent except for
> the results:
>
and -N to suppress column names.
> 2. you should stick your password (which shouldn't match
> your UNIX password) in a textfile readable only by you so that
If you're using Windows, you can use an application like urSQL
(http://www.urbanresearch.com/ursql) for easy viewing, adding, editing,
deleting, etc, or any of a number of available graphical clients...
You may also want to have a look around http://www.mysql.com and the list
archives for several
Jake,
Since I am running MySQL 3.23.5x, I cannot do subselects.
I am able to do the following:
SELECT * FROM Items_Pictures
LEFT JOIN Items
ON Items_Pictures.Items_ID = Items.Items_ID
WHERE Items.Items_ID IS NULL;
*BUT*, if I try to do a DELETE instead
DELETE FROM Items_Pictures
Hi there,
you can download this or download phpMyAdmin
http://www.mysql.com/downloads/mysqlcc.html
- Original Message -
From: "Deosaran Bisnath" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 24, 2003 12:01 PM
Subject: Browsing Tables
> Hi,
> New, brand new to MySQL:
Hi All,
I use MySQL 3.23.53 and mysqldump 8.22 and there is a behaviour in
mysqldump I consider a bug. Anyone agrees?
% mysql test
mysql> create table doubletest (d double not null);
mysql> insert into doubletest values("inf");
mysql> insert into doubletest values("-inf");
mysql> exit
% mysqldum
Hi,
New, brand new to MySQL:
are there software or apps to browse the TABLES?
and if possible, add/edit/delete rows??
Thanks
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http
Good morning!
(My apologies for sending to both lists, I found emalloc() info on both
PHP and MySQL that might be applicable and could not make a good call as
to where this might be more appropriate)
We are attempting to return a rather large file from a set of queries to
MySQL via PHP. Each time
Sometime recently Henrik Leghissa said:
> At 16:21 2003-06-24, gerald_clark wrote:
> >Linux shows threads.
> >BSD shows processes.
> >
> >The difference is in the way ps runs, not mysqld.
>
> *doh* I guess the sun got to me, sorry mate! :-)
>
> But do you have any good ways to get the database t
At 16:52 2003-06-24, Christopher Knight wrote:
Not a silly question... we all had to start somewhere...
you can do it during the create table ( primary key )
http://www.mysql.com/doc/en/CREATE_TABLE.html
Thanks for the explanation, I'm no sql-guru at all, so all info is welcome!
:-)
I'm running
Not a silly question... we all had to start somewhere...
you can do it during the create table ( primary key )
http://www.mysql.com/doc/en/CREATE_TABLE.html
or after
http://www.mysql.com/doc/en/CREATE_INDEX.html
what indexes do...
lets say you do ALOT of queries on column user_id in the table u
it really depends on
how big your database is
what else is running on the server (apache..)
how many connections at once
percentage of selects to updates/inserts
do you have indexes
what version are you running
what is your mom's maiden name
if you look at the sun, how long to you blink
:
At 16:21 2003-06-24, gerald_clark wrote:
Linux shows threads.
BSD shows processes.
The difference is in the way ps runs, not mysqld.
*doh* I guess the sun got to me, sorry mate! :-)
But do you have any good ways to get the database to run any faster? I am
running it on a really beat up piece of j
Kevin H. Phillips wrote:
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a "Failed" signal for the shutdown phase but
an "OK" for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
Is the mysql server currently running? You can also use eit
Linux shows threads.
BSD shows processes.
The difference is in the way ps runs, not mysqld.
Henrik Leghissa wrote:
On my server running linux several daemons opens when I run "msqld -u
mysql" or "safe_mysqld".
A listing of the process shows this:
mysql24475 0.5 2.1 83292 2012 ?S
Hello all
I am having trouble with joining tables i will explain.
I have four tables Cat - CatFile - File - User. thay are related in the
order. I need to join them around the file table. i tryed 'SELECT cat.name,
catfile.catid, file.fileid, user.name FROM cat RIGHT JOIN catfile ON
catfile.catid=
On my server running linux several daemons opens when I run "msqld -u
mysql" or "safe_mysqld".
A listing of the process shows this:
mysql24475 0.5 2.1 83292 2012 ?S15:46 0:03 mysqld -u
mysql
mysql24476 0.0 2.1 83292 2012 ?S15:46 0:00 mysqld -u
mysql
mysq
last_insert_id() returns the last auto-increment your connection. Another
connection might make an insert and the auto-increment may change between
the time you insert and get your last_insert_id();
Curtis
On Tue, 24 Jun 2003, Matt Hyne wrote:
>
> Thanks,
>
> I found it but I wasn't sure
>From the mysql monitor `show variables` to see what socket the server is
connecting on.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 8:33 AM
Cc: [EMAIL PROTECTED]
Subject: Re: mysql.sock doesn't exist
Yes, the server is running. One
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a "Failed" signal for the shutdown phase but
an "OK" for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
Is the mysql server currently running? You can also use either -S or
--socket to spe
Is the mysql server currently running? You can also use either -S or
--socket to specify the socket connection.
-Original Message-
From: Kevin H. Phillips [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2003 8:10 AM
To: [EMAIL PROTECTED]
Subject: mysql.sock doesn't exist
I apologize fo
I apologize for posting about something which has probably been covered
before but I can't remember where I have seen this dealt with. I have
been trying to upgrade/install/re-install MySQL 4.0.13 and when I try to
do any administrative work (set root password, for example) I get this
message:
Susan Ator <[EMAIL PROTECTED]> wrote:
> I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
> attempted to run mysql_fix_privileges. This is the error I get:
>
>ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> /tmp is:
>
Palaparthy <[EMAIL PROTECTED]> wrote:
> Does MYSQL support transaction concept, which includes issues
> like commiting data , rollbacking etc???
Yes.
http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ens
"MaFai" <[EMAIL PROTECTED]> wrote:
>
> After I create this table,and add foreign key tno to this table.
> If I delete "tno" in "p_program_type" table,it would alarm that some data still in
> "p_schedule".
> How can I define the "p_schedule" or "p_program_type" table to make sure that while
> del
Pushpinder Singh Garcha <[EMAIL PROTECTED]> wrote:
>
> I am installing MySQL on my Mac OS Jaguar system. I was having some
> trouble with the starting up my MySQL Server. I kpt getting "mysqld
> ended" error and my logs showed that file "user.MYI" was corrupted. So
> I decided to uninstall
Sam Evans <[EMAIL PROTECTED]> wrote:
>
> I am attempting to insert into my table a huge block of text (talking
> almost a megabyte). It seems like maybe a quarter of the way through it
> just cuts off with no errors to my import script.
>
> I've changed my max_allowed_packet to 20M as well as
I am new to MySQL and was wondering if someone could share some past
experience on timeframes from alpha to full release ? We need full
Internationalization support and since 4.1 has it in it would like to get
some guesses on when it will be "production release".
Thanks
MySQL won't write data to a file if the file already exists.
Make sure you've deleted the old file or given MySQL a new
filename to write to.
Jan
--
Janice Wright
Ingenta plc
[EMAIL PROTECTED]
http://www.ingentaselect.com/
Sometime recently Rahmat Hidayat said:
> hello my friends.. i have so
# [EMAIL PROTECTED] / 2003-06-23 11:11:28 -0400:
> I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
> attempted to run mysql_fix_privileges. This is the error I get:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> /tmp is
# [EMAIL PROTECTED] / 2003-06-23 16:16:50 -0400:
> I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ...
> but now I get this error in the log file and I am unable to still start
> the MySQL Server.
> 030623 15:59:05 Fatal error: Can't open privilege tables: Can't find file:
# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600:
> But, I need to know which rows were modified, not simply how many. So
> far this is the best that I have come up with
>
> LOCK TABLES MyTable WRITE
> SELECT * FROM MyTable WHERE SomeRecord = OldValue
> UPDATE MyTable SET SomeRecord = NewValue WHER
# [EMAIL PROTECTED] / 2003-06-24 12:29:33 +0200:
> # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
> > Does MYSQL support transaction concept, which includes issues
> > like commiting data , rollbacking etc???
>
> Did you know MySQL has documentation?
# [EMAIL PROTECTED] / 2003-06-24
Joseph Bueno wrote:
Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB << EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
But this is mor
1 - 100 of 113 matches
Mail list logo
