Thanks
ViSolve DB Team.
- Original Message -
From: Michael Stearne [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Jim Ginn [EMAIL PROTECTED]
Sent: Tuesday, September 19, 2006 10:11 PM
Subject: Last Inserted ID Using LOAD DATA
I have a group of updates that need to be done using LOAD DATA
: 860.674.8341
-Original Message-
From: Joe User [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 3:16 PM
To: mysql@lists.mysql.com
Subject: Questions about using mysqlimport to update a table.
I need to update a table with the contents of a CSV file regularly, I've
used mysqlimport
I need to update a table with the contents of a CSV file regularly, I've
used mysqlimport to load all the initial data, but I have a problem with
using it for updates. The data in the CSV file does not contain all of the
data in the table, there is a field that is updated by another application
I have a group of updates that need to be done using LOAD DATA INFILE.
Within this file there are some INSERTS. Is there anyway that after
an INSERT happens I can use the auto-increment ID that was just
generated in the next statement. Similar to PHP's mysql_insert_id()
function.
Thanks
Graham Anderson wrote:
Is anyone using subversion to sync live and development databases?
If so, how?
Is this desired or a best practice?
Everything except my databases are under version control.
In theory, I would like my databases to sync with the same subversion
'svn update' command
For our Ruby on Rails app, during development, we're using SVN to store and
sync a group of SQL load files,
containing all the delete, insert and update commands necessary to fully
populate the database.
After doing an SVN update we then run a shell (or batch) script to pipe the
SQL files
yep, your're right
thanks for clearing that up :)
How do most mysql folks sync live and development databases ?
As an alternative, I could use a PHP script on a late-night crontab.
g
On Sep 13, 2006, at 1:11 AM, Chris wrote:
Graham Anderson wrote:
Is anyone using subversion to sync
No, I don't generally go along with underhand political activity. :-)
(but I expect that's an old joke - I haven't been MySQLing all that
long, you see...)
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
Any inaccuracies in this index may be explained by the fact
Is anyone using subversion to sync live and development databases?
If so, how?
Is this desired or a best practice?
Everything except my databases are under version control.
In theory, I would like my databases to sync with the same subversion
'svn update' command.
That way, all web content
Hi,
Any chance i could get somebody's help on how to build MySQL from source using
the gcc compiler on Solaris (10)?
Thanks,
Charles
somebody's help on how to build MySQL from source
using the gcc compiler on Solaris (10)?
Thanks,
Charles
--
Genius might be described as a supreme capacity for getting its possessors
into trouble of all kinds.
-- Samuel Butler
--
MySQL General Mailing List
For list archives: http
--On September 1, 2006 8:38:21 AM -0600 Michael Loftis [EMAIL PROTECTED]
wrote:
Well if you'd share your specific problem I'm sure someone can help, but
more importantly why are you building from source anyway? There are
binary builds for most Solaris platforms, including 2.10.
Sorry I
Well if you'd share your specific problem I'm sure someone can help, but
more importantly why are you building from source anyway? There are
binary builds for most Solaris platforms, including 2.10.
Sorry I meant 10 theremy solaris experience comes from the 'old days'
before they went and
On Wed, 2006-08-30 at 08:31 -0700, Phantom wrote:
We have an application that stores versioned data in MySQL. Everytime a
piece of data is retrieved and written to, it is stored in the database with
a new version and all old versions are subsequently deleted. We have a
request rate of 2
I see the same type of slow downs using 5.0.18
I am using load data in file to load CSV files.
with clean tables, I see fairly quick inserts (ie instant)
2006-08-30 12:07:15 : begin import into table1
2006-08-30 12:07:15: end import into table1 records (10962)
From earlier this morning
,
SEQUENCE_NBR INT NOT NULL,
GLOBAL_GENERATION INT NOT NULL,
KEY_GENERATION INT NOT NULL,
LAST_ACCESS_TIME BIGINT NOT NULL,
PRIMARY KEY (USER_KEY, SUBKEY)
)TYPE=InnoDB;
You have a serious problem with your data types here... Using a
VARBINARY(255), VARBINARY(255) as your primary key
What type of data are you inserting? What storage engine are you
inserting into? What is the average row size?
On Wed, 2006-08-30 at 12:32 -0400, George Law wrote:
I see the same type of slow downs using 5.0.18
I am using load data in file to load CSV files.
with clean tables, I see
, 2006 1:44 PM
To: George Law
Cc: mysql@lists.mysql.com
Subject: RE: Degrading write performance using MySQL 5.0.24
What type of data are you inserting? What storage engine are you
inserting into? What is the average row size?
On Wed, 2006-08-30 at 12:32 -0400, George Law wrote:
I see the same type
Law
Cc: mysql@lists.mysql.com
Subject: RE: Degrading write performance using MySQL 5.0.24
What type of data are you inserting? What storage engine are you
inserting into? What is the average row size?
On Wed, 2006-08-30 at 12:32 -0400, George Law wrote:
I see the same type of slow downs
`,`cdr_seq_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=1;
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 3:06 PM
To: George Law
Cc: mysql@lists.mysql.com
Subject: RE: Degrading write performance using MySQL 5.0.24
Hi!
Could
=latin1 MAX_ROWS=1;
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 3:06 PM
To: George Law
Cc: mysql@lists.mysql.com
Subject: RE: Degrading write performance using MySQL 5.0.24
Hi!
Could you please post a SHOW CREATE
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
FORM method=post action=http://www.ibtec.info/resbu.php;
h1Ingrese palabra a buscar/h1
INPUT type=text name=ci
INPUT type=submit value=Buscar INPUT type=reset
= mysql_fetch_row($result); /* DELETE THIS ROW */
while ($row=mysql_fetch_row($result)){
By the way, I think I read that using WHERE is more efficient than HAVE.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
:[EMAIL PROTECTED]
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
FORM method=post action=http://www.ibtec.info/resbu.php;
h1Ingrese palabra a buscar/h1
INPUT type=text name=ci
INPUT type=submit value=Buscar
));
Marcelo Fabiani [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
Hi to all the group, I have a problem with a query using mysql
4.01+mysql+php
This is the form i use to get the data for the query:
FORM method=post action=http://www.ibtec.info/resbu.php;
h1Ingrese palabra
Hi to all,
I try to call a stored procedure using mysql_real_query and with the
CLIENT_MULTI_STATEMENTS flag on mysql_real connect() function.
When i try the statement call sp1(@myparam); the error can't return the
results in actual context is occur.
Please, if is some one which have experience
Hi again folks,
The problem is solved.Was entirely my fault because i didn't check the version
of mysqlclient library.
-Original Message-
From: Gelu Gogancea
Sent: Monday, 21 August, 2006 12:47 PM
To: mysql@lists.mysql.com
Subject: How to call stored procedures using C API
Hi to all
On 8/20/06, Ow Mun Heng [EMAIL PROTECTED] wrote:
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index
= tableA.A
whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?
If you join using the field that is indexed, this will use an index.
If you join using the field that isn't indexed, it can't use an index.
I take it that that means yes, it's
whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?
If you join using the field that is indexed, this will use an index.
If you join using the field that isn't indexed, it can't use an index.
I take it that that means yes, it's more efficient
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?
If you join using the field that is indexed, this will use an index.
If you join using the field
I'm have a query like so
select
A,
index_A
from
tableA
join tableB
on tableB.indexA = tableA.indexA
select
A,
index_A
from
tableA
join tableB
on tableB.A = tableA.A
whcih would be more efficient? using the where clause which uses the
index or the one which isn't index?
--
MySQL General
obj_act_id
from c2iedm_dev2.act_functl_assoc
where subj_act_id =24;
show?
Sorry about that, typo on my part, but I have tried it as above and I
get
the error I mentioned.
What version of mysql are you using?
select version();
subselects don't work for versions before v5.
You are right
password to be accepted. Hence the web
app still runs slow.
I can log in remotely using mysql administrator and other client
programs and it logs in as normal. It is just really slow from a shell.
The only settings I changed were
key_buffer
max_allowed_packet
no_auto_rehash
Not sure how changing
Hi all,
I am working on a problem where I need to select data from my own
database, and then post it to another website using the Get method.
After having wasted about 4 days trying http_request, $_Get and whatnot,
I stumbled upon the header command. So far, the only way I have been
able
Hi all,
I am working on a problem where I need to select data from my own
database, and then post it to another website (using the Get) method.
After having wasted about 4 days trying http_request, $_Get and whatnot,
I stumbled upon the header command. So far, the only way I have been
able
it from your sending
web server.
Search on Google for NuSOAP and you will probably find what you need, if
you like that idea.
/Peter
-Original Message-
From: Dirk Poot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 16, 2006 9:34 PM
To: mysql@lists.mysql.com
Subject: Using Header to post
At 09:34 AM 8/16/2006, you wrote:
Hi all,
I am working on a problem where I need to select data from my own
database, and then post it to another website (using the Get) method.
After having wasted about 4 days trying http_request, $_Get and whatnot, I
stumbled upon the header command. So far
It sounds as if you're using the PHP HTTP module. You probably want
the HTTP_Client module instead as it has a method for doing POSTs.
In general you should use GET for HTTP requests which only solicit
information from another server and don't request that server to
change anything
15, 2006 12:34 AM
Subject: Incrementing using Max(Field) ?
Does anyone have any ideas of how I can select the max value and insert
the
next highest value?
I want something that would do something like this:
Insert into table1 (select max(field1)+1 from table1);
This obviously doesn't work
Thank you very much!
-Original Message-
From: Visolve DB TEAM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 12:44 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Incrementing using Max(Field) ?
Hello William
Try the below Query to insert next maximum value
On 8/15/06, Visolve DB TEAM [EMAIL PROTECTED] wrote:
Hello William
Try the below Query to insert next maximum value of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Wooww it works :D ... i didn't know that... great !
--
MySQL General Mailing List
For
obed wrote:
On 8/15/06, Visolve DB TEAM [EMAIL PROTECTED] wrote:
Hello William
Try the below Query to insert next maximum value of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Wooww it works :D ... i didn't know that... great !
Wouldn't this cause
On 8/15/06, Visolve DB TEAM [EMAIL PROTECTED] wrote:
Hello William
Try the below Query to insert next maximum value of the field into same
table
INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample
Wooww it works :D ... i didn't know that... great !
Wouldn't this cause a problem if
Hello
I am running an online web shop using a MySQL (v5.0.19) backend. The web
app runs really fast whilst the MySQL database is on the local machine
(2x PIII procs, 2GB mem). However I tried moving the database onto a
dedicated database machine (2x P4 Zeon 4Gb Mem Raid5) and it runs really
slow
Rhys Johnson wrote:
Hello
I am running an online web shop using a MySQL (v5.0.19) backend. The web
app runs really fast whilst the MySQL database is on the local machine
(2x PIII procs, 2GB mem). However I tried moving the database onto a
dedicated database machine (2x P4 Zeon 4Gb Mem Raid5
Does anyone have any ideas of how I can select the max value and insert the
next highest value?
I want something that would do something like this:
Insert into table1 (select max(field1)+1 from table1);
This obviously doesn't work.
I know if the table was set to auto-increment it wouldn't be
On 8/14/06, William DeMasi [EMAIL PROTECTED] wrote:
Does anyone have any ideas of how I can select the max value and insert the
next highest value?
I want something that would do something like this:
Insert into table1 (select max(field1)+1 from table1);
This obviously doesn't work.
I know
H you're close, very close. What you have actually does
work, with a little tweaking - you have an extra set of parens. I'm
on 5.0.21, FYI.
insert into products (productsid) select max(productsid)+1 from products;
Appears to work for both auto-incrementing and non-auto-inc columns.
The reason for this is probably because the original poster inherited
a database without a primary key, and now needs to make edits to it.
That happened to me with Oracle once, and I was lucky enough to be
able to use Oracle's rowid, which is a unique reference to the row
that is independent of
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
Regards,
Ravi K
The information contained in this
At 03:43 AM 8/10/2006, you wrote:
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
Regards,
Ravi K
Ravi
] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 4:43 AM
To: mysql@lists.mysql.com
Subject: Can a row be refered using row number?
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME
Bartis, Robert M (Bob) wrote:
Why would you want to do this? As data moves around within the table the
updates will be in error. Wouldn't it be easier to assign a unique key to
each row, search for the key or unique set of information and update the
resulting row?
Bob
I don't know,
At 14:13 +0530 8/10/06, [EMAIL PROTECTED] wrote:
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
No, because
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
for the right syntax to use near 'select
obj_act_id from c2iedm_dev2.act_functl_assoc where subj_
I have looked at the documentation for MySQL and this seems to be the
correct syntax for using IN.
Could someone please let me know what is wrong?
Thank you.
William DeMasi
--
MySQL General Mailing
On Monday 07 August 2006 12:02 pm, William DeMasi wrote:
The select statement I am trying to run is:
select * from c2iedm_dev2.act where act_id =(select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
Well the problem I'm seeing is that you're not using IN anywhere
On Monday 07 August 2006 12:13 pm, William DeMasi wrote:
I meant to have it say :
select * from c2iedm_dev2.act where act_id IN (select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
What does the output of (the subselect):
select obj_act_id
from
c2iedm_dev2.act_functl_assoc
where subj_act_id =24;
show?
Sorry about that, typo on my part, but I have tried it as above and I get
the error I mentioned.
What version of mysql are you using?
select version();
subselects don't work for versions before v5.
--
MySQL General Mailing List
For list
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following message:
ERROR 1130 (0): Host
I have two databases that effect each other when triggers get excecuted.
There is a schedules database that updates registration database. The
problem I have is with the enrolled, attended, waitlisted, completed,
cancelled, etc. booleans values. The registration db has triggers on it that
enforce
Description:
I'm sorry This is long, but it's because I've tried hard to fix this
myself; please bear with me.
Last week, for unknown reason, my root password for MySQL wasn't
working. I may have changed it without updating the /root/.my.cnf
file. So, I went to the online documentation (which
I would like to withdraw my earlier bug report with the same subject
line. I discovered that an erroneous IP address for the server
machine had gotten into /etc/hosts (due to some IP changes in my
organization). Once the DNS error was resolved, I was able to connect
correctly and fix the password
Gabriel PREDA schrieb:
Try:
ALTER TABLE `tbl_name` DISABLE KEYS;
-- now insert in the TXT file
ALTER TABLE `tbl_name` ENABLE KEYS;
I think this is what you were looking for !
That would have been a possibility. I did it this way now:
...
echo set sql_log_bin=0; set foreign_key_checks=0;
mysqldump -u [user] -h [host] -p [database] [table] fixme.sql
This is for one table.
As I need it for all my tables in all my databases, I'd have to write a
script for that.
And as --tab uses less space, I prefer --tab option for mysqldump.
--
MySQL General Mailing List
For list archives:
Hello
When I re-insert dumped data with mysql file.sql, I can simply put
set foreign_key_checks=0; at the beginning of the file and this works
fine.
How can I achieve this when inserting a text file that is read with
mysqlimport?
I tried to put the mentioned sql-statement in the
On Thursday 20 July 2006 04:10 am, Dominik Klein wrote:
Hello
When I re-insert dumped data with mysql file.sql, I can simply put
set foreign_key_checks=0; at the beginning of the file and this works
fine.
So do it that way
So if there's any other well-known solution for per-table
Try:
ALTER TABLE `tbl_name` DISABLE KEYS;
-- now insert in the TXT file
ALTER TABLE `tbl_name` ENABLE KEYS;
I think this is what you were looking for !
--
Gabriel PREDA
Senior Web Developer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm using innodb_file_per_table on a version 4.1.12 server on RH linux.
At one point I got error 1114 The table 'X' is full.
Aren't these tables autoextending?
I don't think I reached a linux file size limit. A call to ulimit shows
the file size is unlimited. The file was a couple of Gig
@lists.mysql.com
Subject: Re: Using MySQL as backend
sharvan kumar wrote:
Dear Sir/Madam
I am working on a project where I am
to use PHP as front end and MYSQL as backend.MySQL
stand alone is working properly,but it is not
connecting with PHP.Please tell me solution.
Connect
Dear Sir/Madam
I am working on a project where I am
to use PHP as front end and MYSQL as backend.MySQL
stand alone is working properly,but it is not
connecting with PHP.Please tell me solution.
__
Do You Yahoo!?
Tired of spam?
sharvan kumar wrote:
Dear Sir/Madam
I am working on a project where I am
to use PHP as front end and MYSQL as backend.MySQL
stand alone is working properly,but it is not
connecting with PHP.Please tell me solution.
Connect it.
--
Daniel Kasak
IT Developer
NUS Consulting
Hi
I tried to create an index on one of my tables.
After creating this index, the queries return an empty set, instead of the
expected result.
I have a table user looks like this:
id - int(11)
username - varchar(250)
address - varchar(250)
more columns...
After creating an index:
Hi all,
I have a couple of stored procedures where SP1 is calling SP2.
SP2 has a return value which I need for SP1 to continue processing the data.
The relevant bit of SP1 looks like this:
mlCounter = 12;
call SP2(mlCounter, return_val);
Relevant bits of SP2 look like:
CREATE
Hello everyone:
I wanna connect to mysql server using PHP. My operating system is Redhat
Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started the server
using a statement like this:
#/usr/local/mysql/bin/mysqld -uroot -S/var/lib/mysql/mysql.sock
But when I call
Hi all
I have a column in a table containing strings with the '*' character. I'm
trying to use the REPLACE command on this column:
SELECT REPLACE (deviceId, '*', '.*') FROM MY_TABLE;
But I get the following error:
ERROR 1270 (HY000): Illegal mix of collations (utf8_bin,IMPLICIT),
: Tuesday, June 27, 2006 9:07 AM
To: mysql@lists.mysql.com
Subject: Using replace on columns containing *
Hi all
I have a column in a table containing strings with the '*' character. I'm
trying to use the REPLACE command on this column:
SELECT REPLACE (deviceId, '*', '.*') FROM MY_TABLE
Hi J.R.
Thanks for your response, but this did not help. If I try the same syntax on
other values (not '*') I have no problem...
-Original Message-
From: J.R. Bullington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 3:22 PM
To: mysql@lists.mysql.com
Subject: RE: Using
On Tuesday 27 June 2006 03:35 am, 战芳 wrote:
Hello everyone:
I wanna connect to mysql server using PHP. My operating system is
Redhat Fedora Core 4, and the version of mysql is 4.1.3 beta. I've started
the server using a statement like this: #/usr/local/mysql/bin/mysqld
-uroot -S/var/lib
:[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 5:27 PM
To: mysql@lists.mysql.com
Subject: RE: Using replace on columns containing *
Hi J.R.
Thanks for your response, but this did not help. If I try the same syntax on
other values (not '*') I have no problem...
-Original Message-
From: J.R
Basically it says that if you have an index let's say INDEX_1 on columns:
INDEX_1 : a, b, c, d
MySQL will act as if you had setup indexes on:
INDEX_1_1 : a, b, c
INDEX_1_2 : a, b
INDEX_1_1 : a
A query like:
SELECT a FROM table_name WHERE a 9; - will use the index
SELECT a, b, c FROM
in the indices.
Regards, Cor
- Original Message -
From: Gabriel PREDA [EMAIL PROTECTED]
To: Takanobu Kawabe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, June 21, 2006 8:47 AM
Subject: Re: About the leftmost index prefixes using nounique index
Basically it says that if you have
MySQL wil only use one index per table in a query... this is why in
most cases a composite index will do better that a single column
index.
And for the second is true... this is leftmost rule...
You have an index on:
a, b, c
You gain indexes on:
a, b
a
But you will need to set up yourself an
Thank you very much for your understandable representation, Mr.PREDA
and Mr.Vegerin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I imported the data of the table using mysqlimport.
I used the following command line.
$ mysqlimport -ukawabe -paaa -h192.168.1.92 --local kawabe
C:\index_test.txt
kawabe.index_test:
Records: 4 Deleted: 0 Skipped: 4 Warnings: 2
I want to show the contents of warning ,so I
hello,
I want to know about the leftmost index prefixes using nounique index/
About the composite index using primary key, in the reference 7.4.5,
I can understand the following
Ow Mun Heng wrote:
I have 2 table.
Zones(Z1..Z20) and Radius(R0..R4)
where
R0 is equivalent to Z1
R1 Z5
R2 Z9
R3 Z13
R4 Z17
How can I make the query to join them in such ways?
eg:
select
A,B,C,D
from
Zone
inner join radius
on R1 = Z5
on R2 = Z9
on R3 = Z13
on R4 = Z17
or do I have to
I have 2 table.
Zones(Z1..Z20) and Radius(R0..R4)
where
R0 is equivalent to Z1
R1 Z5
R2 Z9
R3 Z13
R4 Z17
How can I make the query to join them in such ways?
eg:
select
A,B,C,D
from
Zone
inner join radius
on R1 = Z5
on R2 = Z9
on R3 = Z13
on R4 = Z17
or do I have to use a subquery??
--
Hi all,
I've been using MySQL for over a year now and I didn't install
anything special recently, yet I suddenly find myself locked out of
MySQL.
I'm using version 3.23.49 and I'm running Mac OS 10.4.6 fully up-to-
date. I normally connect using the root-user but this afternoon I
first
Kevin -
You can start up the MySQL server without password protection using the
--skip-grant-tables option. Note that will leave your server wide open,
so you may also want to use the --skip-networking option and access it
through the socket on the same machine.
Something like this I think
use the same database though. Does it matter what
version phpinfo() is giving me?
Kevin Felix
Op 14-jun-06, om 05:18 heeft Dan Buettner het volgende geschreven:
Kevin -
You can start up the MySQL server without password protection using
the --skip-grant-tables option. Note
Hi
The following happened when I tried to create table. Can anyone please help?
mysql create table sfgbackup.advEmail select * from sfg.advEmail;
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is
afternoon, i am triying to connect with my company's
mysql server using a client program from shell and I keep
receiving the following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1'@'200.93.42.209
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user 'user1'@'200.93.42.209
Levy wrote:
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving the
following answer:
[EMAIL PROTECTED] ~]# mysql -u user1 -p -h serverCompany.com
Enter password:
ERROR 1045 (28000): Access denied for user
'user1
password('yourpassword'); and verify that the hash produced
matches the password field in user exactly.
-- James
On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:
Hi good afternoon, i am triying to connect with my company's mysql
server using a client program from shell and I keep receiving
On 6/7/06, Aron Levy [EMAIL PROTECTED] wrote:
Hi James i follow your recomendation and verify that the hash produced
matches the password field in user exactly.
-- Aron L.
Well, that's weird, should be working. A shot in the dark: try
starting your server with --old-passwords as an option
that the hash
produced matches the password field in user exactly.
-- James
On Jun 7, 2006, at 11:48 AM, Aron Levy wrote:
Hi good afternoon, i am triying to connect with my company's
mysql server using a client program from shell and I keep
receiving the following answer:
[EMAIL PROTECTED
601 - 700 of 3107 matches
Mail list logo