I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is there a way to put
something in so mysql would tell me this - 2 hours pissing around for an
oversight.
TI
Can anyone explain why this isn't working? It will not input the info into
the database.
$db = mysql_connect($serverhost, $serveruser, $serverpass);
mysql_select_db($database_name);
The variables in the above two rows are correct - I can do selects and it
works fine.
This is the data to be inser
Hi all,
Do you have any information on the time and CPU resources required
during the full sync / incremental sync between the master and slave
mysql server?
Thank you.
Best regards,
Trevor Luo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Dear Friends,
The last help I got was truly worth a zillion.
1. How can i have commit/rollback functions using
MyIsam database which is default database engine for
MySql? i am using vb
2. is there any intelligent program (not ODBC/JDBC
drivers anyway) available that can be run on a server
& provide
Do it like this:
mysql>GRANT ALL PRIVELEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'mikaela02';
You forgot the hostname which is the @hostname is for
Respectfully yours,
Sherwin T. Ang
Systems Administrator
Tridel Technologies Incorporated
7F Hanston Building
Emerald Avenue, Ortigas Center
Your spelling of PRIVILEGES is also spelled wrong =)
specifying GRANT ALL PRIVILEGES on *.* to a user will make that user a
member of the superuser group such as mysql, just without the GRANT OPTIONS,
meaning that user's login wouldn't be able to GRANT other users.
if you want to specify the data
Hello Ramanan-
First off, make sure you create tables of type InnoDB, Berkeley, or
Gemini. [My]ISAM tables don't do transactions.
The simplest way to do a transaction is
mysql> BEGIN;
mysql> # successful edit
mysql> COMMIT;
or
mysql> BEGIN;
mysql> # failed edit, or dropped connection implies
my
On Wed, Mar 26, 2003 at 06:06:02PM -0500, Keith C. Ivey wrote:
> My replication was going fine until the slave attempted to execute a
> REVOKE query referring to a user that didn't exist on the slave.
> That caused an error and brought replication to a halt.
>
> I'm using replicate-wild-do-tabl
My replication was going fine until the slave attempted to execute a
REVOKE query referring to a user that didn't exist on the slave.
That caused an error and brought replication to a halt.
I'm using replicate-wild-do-table to set the databases I want to
replicate. If I'm not replicating the
Hi all,
I want to execute a set of Insert,Update and Delete if any one of the
statement fails then I need to rollback all the statements.
How do we achieve the same in MySQL.
Thanks in advance.
Ramanan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
i got this mesage when creating a database for twig, I just followed the instruction
in twig manual on how to create a database but resulted to this
[EMAIL PROTECTED] mysql]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to g
If you had installed RedHat's RPM, then you should be able to start MySQL
with /etc/rc.d/init.d/mysql start
Regards
Richard KHOO Guan Chen
On Wed, 26 Mar 2003, Toto Gamez wrote:
> i installed mysql-3.23.41-1 on my RH7.2 box but when i run safe_mysqld, mysql
> daemon started but di
To Creators-
In my attempt to obtain 1 working example of this DB:
I am compiling all of the code. I have a request for Monty with the creators
in theit function declarations:
e.g.
int
strcasecmp(s1, s2)
const char *s1, *s2;
please enclose the const char *s1, *s2 declaration within the argument
That would grant the user select on everything in every database no matter
what host they are coming from. He wants to only grant on specific tables,
and did not mention anything about allowing from all hosts.
To answer the original question, I have tried a lot of different ways, but
the only sol
Hello
I have been use mysql ver 3.23.53, also I'm using on DELETE CASECADE. It
seems working fine.
I believe UPDATE CASECADE is working from version 4.0.8.
-
I have following problem (purchaseOrder_items::ord
Add a UNIQUE INDEX to the table you are inserting to. You will then get
an error if you try to insert a second time with the same values.
Alternativly you could use perform a select and then an insert within
the same transaction, determining whether something exists in the db
before inserting. Th
If you wanted to use MyISAM tables and peform an initial select to
determine whether you should insert, you could lock the table you would
be selecting/insert from. 'LOCK TABLES table_name WRITE' Don't forget
to unlock the table when you are done 'UNLOCK TABLES', otherwise you
will likely have de
Make sure that all the files inside your database directories are owned by
mysql:
chown -R mysql.
The dot at the end of "mysql" above sets the group to mysql also. The "-R"
means set the permissions recursively. Each time I install a binary
distribution and run the "scripts/mysql_install_db" scr
Set a primary key / unique key on a column (s) in myTable to make that
row unique.
Goto mysql.com and type primary key in the search dialog. There is a
wealth of knowledge there.
Or use google
site:mysql.com Primary Key syntax
-Original Message-
From: Wileynet [mailto:[EMAIL PROTECTED]
>From: "Jeff Kilbride" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Date: Wed, 26 Mar 2003 15:44:49 -0800
>
>Make sure that all the files inside your database directories are owned by
>mysql:
>
>chown -R mysql.
>
>The dot at the end of "mysql" above sets the group
Steve,
Hopefully I am correctly interpreting what you want to do.
While I don't have anything of this kind in operation, I did
come close to implementing it as a solution to a problem
that I eventually found another way around.
My proposed solution was to have a script set up on the web
server t
On Wed, 26 Mar 2003 14:37:33 -0800
Jennifer Goodie wrote:
> To answer the original question, I have tried a lot of different
ways, but
> the only solution I have found is granting on the entire database
or
> specifing each table in the tables_priv table. I go with the
second option
>
Is there a sql statement that would not allow the same entry twice.
Something like INSERT into myTable s WHERE s != Value(?). I dont know
if that makes sense but I thought I would give it a shot.
Basically I want to know if it is possible and if so can you point me to
a webpage or give me an exam
Is there a sql statement that would not allow the same entry twice.
Something like INSERT into myTable s WHERE s != Value(?). I dont know
if that makes sense but I thought I would give it a shot.
Basically I want to know if it is possible and if so can you point me to
a webpage or give me an exam
So I'm setting up a fancy new machine with Xeons doing hyperthreading.
What this means is that there are 2 physical processors, but as far as
linux is concerned, there are 4. Does anybody know whether
thread_concurrency should be 2*(Number of Physical Processors) or
2*(Number of Virtual Processors
[EMAIL PROTECTED] writes:
Description:
Hello,
When I run the following query:
Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10
I get the following error:
'The column 'MiCantidad' in field list is unknown'
So, Can I reference to a column by its alias
I think this might do what you want, but then you will be required to log
in with the -p syntax...
GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword";
FLUSH PRIVILEGES;
mysql -u youruserid -p -h hostname dbasename
Regards,
Kelly Black
Linux was very clearly the answer, but what
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dimitar --
...and then Dimitar Haralanov said...
%
...
% Basically, is something like the following possible?
%
% GRANT SELECT ON db.table_% TO user@'%' IDENTIFIED BY 'pass';
AFAIK it is not. See Benjamin's quite thorough response to my
>From: Jeff Kilpatrick <[EMAIL PROTECTED]>
>Cc: [EMAIL PROTECTED]
>Organization:
>Date: 26 Mar 2003 16:03:38 -0600
>
>Yes, probably. I've never used a mysql rpm, so I don't know how they're
>packaged. /var/lib/mysql is an odd place to stick that socket though.
>I'v
Yup I think that's write. I had a feeling I had something small wrong :)
On Wed, 26 Mar 2003 13:50:12 -0500
"Mark Armendariz" <[EMAIL PROTECTED]> wrote:
> I believe it's "day" without the s. Not sure if it makes a difference,
> but that's how it's listed in the manual.
>
> date_add([thedatefie
>From: Jeff Kilpatrick <[EMAIL PROTECTED]>
>Cc: [EMAIL PROTECTED]
>Organization:
>Date: 25 Mar 2003 21:08:56 -0600
>
>Does the mysql user have permission to write to /var/lib/mysql?
>-jeff
Well, it didn't. But, shouldn't it have been set that way after the rpm
package w
Is there a reason for not using tables_priv table for this purpose?
Mihail
- Original Message -
From: "Dimitar Haralanov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 2:29 PM
Subject: Re: granting privileges using wildcards
On Wed, 26 Mar 2003 13:14:09 -0
Yes, probably. I've never used a mysql rpm, so I don't know how they're
packaged. /var/lib/mysql is an odd place to stick that socket though.
I've always seen it in /tmp or someplace similar (and world readable).
errno = 13 --> "Permission denied" Make sure that directory is owned by
mysql, ie
How would I connect my Windows app to a linux MySQL DB.
Would I just modify the DSN I am using to point to the correct server?
Thanks,
Kevin
-Original Message-
From: LaBranche, Kevin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 12:18 PM
To: '[EMAIL PROTECTED]'
Subject: Que
i probably have some misconceptions about full-text search but i was
hoping that i'd be able to search for something like '*com* *tion*',
i.e., find rows containing BOTH of the partial words like 'company
duration', 'accompanying action', 'compositions'. yes, Virginia,
full-text search is not part
I believe it's "day" without the s. Not sure if it makes a difference,
but that's how it's listed in the manual.
date_add([thedatefield],Interval 15 day)
Mark
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 10:35 AM
To: [EMAIL PROTECTED]
Thanks again Serge and Don,
Don not to sound like an idiot but what would
you recommend on adding a unique key. I understand
the idea, but didn't want to corrupt tables trying to
get it right.
Serge, I knew DISTINCT operated on whole lines, I was
counting on that but as you can see, I didn't kn
Dyego,
- Original Message -
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 2:33 PM
Subject: Error: The table is full
> i'm running the command:
>
> update contratante,pessoa set
> contratante.endereco = pes
On 26-Mar-2003 BRYANT, LANCE wrote:
> Here is a copy of the php script that I'm using. I can create tables and
> query info just not add data to the database.
>
>
>
> //open the connection
> $conn = mysql_connect("onyx","doghead","dogleg");
>
> // pick the database to use
> mysql_select_db("
[EMAIL PROTECTED] writes:
> Description:
> Hello,
>
>
>When I run the following query:
>
>Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10
>
>I get the following error:
>
>'The column 'MiCantidad' in field list is unknown'
>
>So, Can I reference to a
Do a print $testField; first. I think what might be happing is that you have register
globals turned off (as you should it's a security problem).
Try:
$sql = "INSERT INTO testTable values ('', '${_REQUEST['testField']}')";
and see if that solves your problem.
Serge.
On Wed, 26 Mar 2003 14:28
On 26 Mar 2003 at 9:23, Alejandro Paz wrote:
> As you can see the colum `b' is updated, too.
> Note, you have to insert a delay of almost 1 second
> between the first select
> and the update, because the column `b' takes the
> current time!.
>
> Only happens with timestamp columns not with dateti
On Wed, 26 Mar 2003 13:14:09 -0600
Black, Kelly W [PCS] wrote:
> I think this might do what you want, but then you will be required
to log
> in with the -p syntax...
>
> GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword";
>
> FLUSH PRIVILEGES;
>
> mysql -u
LaBranche, Kevin wrote:
The following query returns 0 for sCode instead of a string like
"XXX:XX".
I am modifying an existing app from SQL Server 7 so that it can also run
with a MySQL backend
The existing query in SQL Server 7 works fine
SELECT sDAMIONCode, (sORI + ':' + sDamionCode) as
Description:
Hello,
When I run the following query:
Select Can as MiCantidad, MiCantidad * 2 from Stocks limit 10
I get the following error:
'The column 'MiCantidad' in field list is unknown'
So, Can I reference to a column by its alias in a
select statement?
Here is a copy of the php script that I'm using. I can create tables and query info
just not add data to the database.
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:11 PM
To: BRYANT, LANCE
Cc: [EMAIL PROTECTED]
Subject: RE: Data entered
On 26-Mar-2003 LaBranche, Kevin wrote:
>
> The following query returns 0 for sCode instead of a string like
> "XXX:XX".
>
> I am modifying an existing app from SQL Server 7 so that it can also run
> with a MySQL backend
>
> The existing query in SQL Server 7 works fine
> SELECT sDAMION
Does anyone know if we can use MYSQL to store CMP beans in websphere?
If It works, can you tell me how i can configure websphere 5 to use it ?
I use the regular (MysqlDataSource) from com.mysql.jdbc.jdbc2.
Within WSAD5, I have created a user-defined JDBC provider that uses
com.ibm.websphere.rsad
I am having trouble getting MySQL 3.23.51 running on macOS X 10.1.5 (Darwin)
** First it won't let me assign a root password, I think because it's
not running.
Trying to change root password error:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL
The following query returns 0 for sCode instead of a string like
"XXX:XX".
I am modifying an existing app from SQL Server 7 so that it can also run
with a MySQL backend
The existing query in SQL Server 7 works fine
SELECT sDAMIONCode, (sORI + ':' + sDamionCode) as sCode FROM tblORI
An
On 26-Mar-2003 BRYANT, LANCE wrote:
> When I enter data into my web page and active my PHP script. The page
> tells me that the data has been updated to my database, but when I check
> the database no data is entered. A row is created but no data is
> entered. Can any help?
I can't see yer co
Hi,
I have been trying to find information on the following question but
have been unable to do so:
Is it possible to grant options to a user using wildcards. For example:
let's say that I have a database named 'db', and a user 'admin' who has
full privileges. The user 'ad
GERST, MICHAEL (SBCSI) wrote:
Don't know if this has already come through to everyone, if so I apologize.
Ok, here's the deal
Table1 is a master list holding ID numbers, and related information sent by
clients
Table2 is a queue that utilizes Table1.ID numbers, and updates other
information on th
When I enter data into my web page and active my PHP script. The page tells me that
the data has been updated to my database, but when I check the database no data is
entered. A row is created but no data is entered. Can any help?
Thank you, Jim. I clearly just didn't scroll down far enough!
Jim Winstead wrote:
On Wed, Mar 26, 2003 at 10:30:32AM -0800, Paul wrote:
This may indicate incredible ignorance but all I can find there are
tar.gz files which untar into the complete distribution but no rpm's are
present.
The RPM
On Wed, Mar 26, 2003 at 10:30:32AM -0800, Paul wrote:
> This may indicate incredible ignorance but all I can find there are
> tar.gz files which untar into the complete distribution but no rpm's are
> present.
The RPM downloads for 4.0.12 can be found at
http://www.mysql.com/downloads/mysql-4.0.
I prefer the alternate form of this command. It's easier to read:
mysql --host=localhost --user=root --password=mysql < did.query > did.out
-ms
-Original Message-
From: Dobromir Velev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 4:22 AM
To: Marianadin, Didier; [EMAIL PROTE
Hi,
I am using MySQL 4.0 (with Embedded Server) on a Mac OS X
(Darwin) machine. I am using the C API of MySQL in my programs. I have a
few questions regarding this.
1) When I compile my programs with the g++ 3.1 compiler, i get the
following warnings:
ld: warning multiple definitions of
This may indicate incredible ignorance but all I can find there are
tar.gz files which untar into the complete distribution but no rpm's are
present.
Thomas Spahni wrote:
On Wed, 26 Mar 2003, Paul wrote:
Can anyone tell me where I can get 4.0.12 server and client rpm's?
www.mysql.com
Regard
Hi,
I am using MySQL 4.0 (with Embedded Server) on a Mac OS X
(Darwin) machine. I am using the C API of MySQL in my programs. I have a
few questions regarding this.
1) When I compile my programs with the g++ 3.1 compiler, i get the
following warnings:
ld: warning multiple definitions of
The DISTINCT is almost usless when done on a GROUP BY clause. Also DISTINCT operates
on the entire row and not just on the field.
ie It will give you DISTINCT measurement, sum(val), pcfver, hour, release. And not
just DISTINCT measurement results.
Serge.
On Wed, 26 Mar 2003 12:00:24 -0600 (
Hello,
I experiencing a problem I hope someone here can help with:
I have several C-coded clients running and performing inserts and
updates on a database. I would like to make sure that the -entire-
client session is atomic. i.e. if a client dies in the middle of the
computation (not uncommon)
On 26-Mar-2003 Black, Kelly W [PCS] wrote:
> Don
>
> Thanks. I will have to change them and try that.
>
> I had been bouncing back and forth between decimal and
> numeric but wasn't sure which was working better.
>
> I still think it might have to do with my sql query.
>
> Here's an example as
Don't know if this has already come through to everyone, if so I apologize.
Ok, here's the deal
Table1 is a master list holding ID numbers, and related information sent by
clients
Table2 is a queue that utilizes Table1.ID numbers, and updates other
information on the current state of a job as
You should be able to use DATE_FORMAT to format the TIMESTAMP anyway you need.
Check out DATE_FORMAT at:
http://www.mysql.com/doc/en/Date_and_time_functions.html
At 20:01 +0530 3/26/03, anirudha kukreti wrote:
hi everybody,
i would like to know, if there exists a method for getting a format like
On Wed, 26 Mar 2003, Paul wrote:
> Can anyone tell me where I can get 4.0.12 server and client rpm's?
www.mysql.com
Regards,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Mysql,
This is a bug report.
There are two cases, because the bug is quite old, I
detected it the first time
a year ago on a 3.23.44 with MyISAM, but I thought it
would be fixed soon,
sorry.
This bug happens in 4.0.8 too with MyISAM tables.
Test Case 1
---
Operating System: Linux In
Don
Thanks. I will have to change them and try that.
I had been bouncing back and forth between decimal and
numeric but wasn't sure which was working better.
I still think it might have to do with my sql query.
Here's an example as you previously mentioned...
SELECT DISTINCT measurement, sum(v
On 26-Mar-2003 anirudha kukreti wrote:
> hi everybody,
>
> i would like to know, if there exists a method for getting a format like
>
> '2003-12-31 12:00:00' for the time stamp
>
> in the text file generated using the outfile command.
>
> the normal format is '2003123112'
>
> any help wou
>Description:
Mysqld 4.0.12 crashes on Slackware 9.0 when compiled with
-all-static. I tried changing the thread stack up to 2M - no effect. When
compiled without -all-static mysqld seems stable. The crash is first
reported by mysql_install_db. Output of mysql_install_db bellow.
Good Day MYSQL helpers,
On Redhat 8 we were running a FAQman software. A few days ago, mysql was
not working, come to find out that the safe_mysql file was missing.
This is the error that we get even though we can start up the safe_mysql
» MySQL Error
There was an error connecting to the data
Can anyone tell me where I can get 4.0.12 server and client rpm's?
TIA,
Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the other thing is make sure you don't have a space after -p and before your
password
mysql -h localhost -u root -p mysql < did.query > did.out
says ask for the password and start in the database mysql
mysql -h localhost -u root -pmysql < did.query > did.out
says the password is mysql and don't s
I believe the following will work:
date_add([thedatefield],Interval 15 days)
I am almost sure I got the syntax right off the top of my head. Check mysql.com for
"date functions" if the above doesn't work.
Serge.
On Wed, 26 Mar 2003 10:16:18 -0500
"Tom Ray" <[EMAIL PROTECTED]> wrote:
> I hav
I have a small question about the DATE function. This is what I want to do:
- User enters information into form and submits it to database
- When info is added to database the current date is stored ala 2003-03-26
- Now I want to take that date 2003-03-26 and tack on either 15 or 30 days
on to it
Create a .my.cnf file in your home directory with permissions set to 600.
In that file put the lines
[mysql]
user=root
password=mysql
now you can enter:
mysql < did.query > did.out
Marianadin, Didier wrote:
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (sol
The mysql data directories and files must be owned by mysql.
Error 13 is a permission denied operating system error.
Toto Gamez wrote:
i installed mysql-3.23.41-1 on my RH7.2 box but when i run safe_mysqld, mysql daemon
started but dies i tried to check the log and says:
030326 14:35:46 mysqld
You guys probably need to start mysql with the --skip-grant option
and fix the allow tables...
See the mysql.com website or google.com for "lost password" "mysql"
Thanks for the tip about how to proceed.
Just so we don't lose track here, the point of the bug we're reporting
is that m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 25 Mar 2003, katherine bjork wrote:
> How do I remove mysql from my mac. I tried the script on the entropy
> website but it only works on version older than 4.x.
>
> I can seem to find any documentation regarding removal on the products
>
On Wednesday 26 March 2003 08:25, you wrote:
> > A programmer just asked me about a possible race condition,
> > and I didn't know what to answer:
> >
> > If I insert a line using autoincrement, then ask for last_insert_id()
> > am I guaranteed to get the same ID I just inserted?
>
> Yes
>
> > It s
Hello
In attempting to build winmysqladmin.cpp
winmysqladmin.cpp
\MySQL\mysql-4.1\VC++Files\winmysqladmin\winmysqladmin.cpp(2) : fatal error
C1083: Cannot open include file: 'vcl.h': No such file or directory
initsetup.cpp
\MySQL\mysql-4.1\VC++Files\winmysqladmin\initsetup.cpp(2) : fatal error
C1
> A programmer just asked me about a possible race condition,
> and I didn't know what to answer:
> If I insert a line using autoincrement, then ask for last_insert_id()
> am I guaranteed to get the same ID I just inserted?
Yes
> It seems that another program could be inserting at almost the
Hi,
On Wed, Mar 26, 2003 at 03:17:42PM +0100, Steve Rapaport wrote:
> A programmer just asked me about a possible race condition,
> and I didn't know what to answer:
>
> If I insert a line using autoincrement, then ask for last_insert_id()
> am I guaranteed to get the same ID I just inserted?
>
hi everybody,
i would like to know, if there exists a method for getting a format like
'2003-12-31 12:00:00' for the time stamp
in the text file generated using the outfile command.
the normal format is '2003123112'
any help would be greatly appreciated.
Thanks in advance
anirudh
Filter
A programmer just asked me about a possible race condition,
and I didn't know what to answer:
If I insert a line using autoincrement, then ask for last_insert_id()
am I guaranteed to get the same ID I just inserted?
It seems that another program could be inserting at almost the same
time, and c
Hi,
I've tried without success to set a timeout for SQL queries on a MySQL
server (version 4.0.12 - so far the latest production release) running
on a Windows XP SP1 box. The calling program is a Web site developed in
ASP (going through ADO to access MyODBC...).
I tried many different methods bu
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 6:55 AM
To: [EMAIL PROTECTED]
Subject: re: RE: load data infile question
Hi!
>On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
>
>> I was able to work around the problem by giving "
__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
i'm running the command:
update contratante,pessoa set
contratante.endereco = pessoa.endereco
,contratante.cidade = pessoa.cidade
,contratante.bairro = pessoa.bairro
,contratante.estado = pessoa.estado
,contratante.telefone = pessoa.telefone
,contratante.cep = pessoa.cep where (contratante.codpes
On Tuesday 25 March 2003 15:30, Todd Cary wrote:
> If I have a file, mydb.mbk that was created with mysqldump, how do I
> recreate/restore the DB?
>
> Do I run a command line using "mysql" with a switch and "mydb.mbk"?
Yup.
musql -uuser_name -puser_password database_name < mydb.mbk
--
On Wednesday 26 March 2003 13:12, Marianadin Didier wrote:
> I want to execute a simple query in batch mode in a mysql database.
> my OS : Unix (solaris 2.6)
>
> when I run this command :
> mysql -h localhost -u root -p mysql < did.query > did.out
>
> I'm always asked password even if I've already
On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
> I was able to work around the problem by giving "insert" privileges to the
> user for the WHOLE database. This is definitely not optimal because I only
> wish this user to be able to insert into one table in the database. But as
> soon as I
Hi,
most probably there should not be a space after -p.
Try this
mysql -h localhost -uroot -pmysql < did.query > did.out
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: "Marianadin, Didier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesd
Dnia Wed, 26 Mar 2003 12:12:44 +0100
"Marianadin, Didier" <[EMAIL PROTECTED]> zeznał/a co następuje:
> Hi,
>
> I want to execute a simple query in batch mode in a mysql database.
> my OS : Unix (solaris 2.6)
>
> when I run this command :
> mysql -h localhost -u root -p mysql < did.query > did
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql < did.query > did.out
I'm always asked password even if I've already specified it in the previous
command line (mysql)
Enter passwo
They both use 1 byte
Check this for more information
http://www.mysql.com/doc/en/Storage_requirements.html
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: "Mattias Barthel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2
Jeremy,
>> Also, is there any way to find out what records were skipped and
>> why?
> Nope. Not yet. I think that's coming in 4.1?
Yes and no: http://www.mysql.com/doc/en/SHOW_WARNINGS.html
"The MySQL server sends back the total number of warnings and errors
you got for the last command."
My
Terry,
mysql>>GRANT ALL ON Security.* to [EMAIL PROTECTED] Identified by
> 'password';
> Query OK, 0 rows affected(0,00 sec)
Try to rewrite that as follows:
GRANT ALL ON Security.* TO 'newbuddy'@'network.srv' ...
The dot in "network.srv" could otherwise cause problems. After
granting, do:
SHOW
Mattias,
> which one is the biggest datatype:
> enum('true', 'false');OR
> tinyint(1);
> I mena biggest when it comes to store them on disk.
ENUM has a storage requirement of 1 or 2 bytes. If you have up to 256
ENUM values to choose from, you need 1 byte, if you have more, it will
take 2 byte
which one is the biggest datatype:
enum('true', 'false');OR
tinyint(1);
I mena biggest when it comes to store them on disk.
Thank you,
Mattias.
1 - 100 of 105 matches
Mail list logo
