> Am 04.09.2016 um 23:35 schrieb Reindl Harald :
>
>
>
> Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:
>>> Am 04.09.2016 um 16:29 schrieb Reindl Harald :
>>>
>>> Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
Am 04.09.2016 um 16:17 schrieb Matthias Schmidt:
Am 04.09.2016 um 16:29 schrieb Reindl Harald :
Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 -
> Am 04.09.2016 um 16:29 schrieb Reindl Harald :
>
>
>
> Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
>> 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
>> create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102
>> - Operation not supported on sock
Am 04.09.2016 um 08:40 schrieb Matthias Schmidt:
2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 -
Operation not supported on socket)
2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't cr
2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't
create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 -
Operation not supported on socket)
2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't create PID file:
Operation not suppor
Hi all,
Recently, I got the newest version of mysql-server from the github,
Bug I got some compile problem as follows:
cmake -DCMAKE_INSTALL_PREFIX=/u04/my3306 \
-DMYSQL_DATADIR=/u04/my3306/data -DMYSQL_USER=mysql \
-DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1
Thank you for answer. The problem is that I wrote in previous message
that there is no sql backup just the files for binary backup. Hardware
we are using is a simple laptop with Windows 7 that runs 5.1 server in
case the originally installed files are in use. It runs an 5.5 server
paralelly as
Am 05.08.2015 um 17:06 schrieb Csepregi Árpád:
150805 17:02:31 InnoDB: Page dump in ascii and hex (16384 bytes):
hex...
150805 17:02:31 InnoDB: Page checksum 1094951825, prior-to-4.0.14-form
checksum 1449969277
InnoDB: stored checksum 1467223489, prior-to-4.0.14-form stored checksum
87759728
Hello,
We are facing a strange innodb related problem. Our client ran mysql 5.1
on WinXP having file_per_table disabled. OS crashed after 5 years
continuous running and our client of course does not have any backup
(big company with own IT department so we do not have acces to their
system
Am 31.07.2015 um 16:23 schrieb Martin Mueller:
Dear Mr Harald,
I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical st
Dear Mr Harald,
I've learned some things from your responses and even more from shawn
green's. You might learn a lot from him about patience and courtesy, which
make life on a technical forum a lot easier. You clearly know a lot about
technical stuff, but you're short on patience, and it would hel
Am 31.07.2015 um 15:40 schrieb shawn l.green:
1. Log on to your system as the Unix user that the MySQL server runs as
(for example, mysql).
Everything that executes on a Linux/Unix/Mac machine executes in the
context of some kind of user account (the system login). By default,
mysqld (the dat
On 7/31/2015 8:40 AM, Martin Mueller wrote:
Sorry for the off-list reply. It was an oversight.
That said, the instructions for resetting a forgotten root password have a
section for Windows and a section for Unix. The Unix section begins as
follows:
1. Log on to your system as the Unix user
.
There is a lot on the Web about resetting a forgotten password. But
the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results ar
/etc/my.cnf . It doesn't have any data directory path
mention, but neither does the my.cnf file on a laptop, which works. So there
seems to be nothing wrong with the location or content of the my.cnf file.
your current problem is that you have no clue where your mysql-datadir
is *because*
ome error in the installation process.
There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed the
pro
t;>>> run the mysql command because it challenges me for a password. But I
>>>>did
>>>> not set any password, either for the root, for mysql, or for myself
>>>>as a
>>>> user.
>>>>
>>>> So the installation has somehow insta
e error in the installation process.
>
> There is a lot on the Web about resetting a forgotten password. But the
> assumption is always that you can get at the program via some other
> password. But in this case every door is shut.
>
> Does anybody recognize this problem? I'
you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I've uninstalled and re-installed
the
program, but the results are always the same
* install and uninstall *never* removes the datadir
* users and permissions are in th
.
Does anybody recognize this problem? I've uninstalled and re-installed the
program, but the results are always the same
* install and uninstall *never* removes the datadir
* users and permissions are in the DB "mysql"
* https://dev.mysql.com/doc/refman/5.0/en/resetting-p
nothing or there is some error in the installation process.
There is a lot on the Web about resetting a forgotten password. But the
assumption is always that you can get at the program via some other
password. But in this case every door is shut.
Does anybody recognize this problem? I&#x
Share error log file
-Original Message-
From: "Martin Mueller"
Sent: 29-07-2015 21:05
To: "mysql@lists.mysql.com"
Subject: installation problem of MySQL on OS Lion
I installed MySQL on a Mac Pro running OS Lion.
The installation was successful, but start
I installed MySQL on a Mac Pro running OS Lion.
The installation was successful, but starting the mysql server generated the
following error message:
Martin-Muellers-Mac-Pro:~ martin$ sudo
/usr/local/mysql/support-files/mysql.server start
Starting MySQL
... ERROR! Manager of pid-file quit w
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next t
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next time to debug the
loss of the link.
When is the
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slav
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql> show global variables like 'log_bin%';
+-+---+
On 30/08/14 09:39, william drescher wrote:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on
Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you
check what the application is doing, understand *why* the application is
violating the PK of the table information_server.audit, repair the possible
application problem and the, reconfigure the replication.
It
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
| File
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, "william dre
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
+--+--+--+---
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master,
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
t;william drescher"
> wrote:
> >
> > >
> > > Replication novice
> > >
> > > I have a master server at the office and a replication server at home.
> > > This setup has been working for a couple of years. Occasionally the
> > > replicat
escher" wrote:
>
> >
> > Replication novice
> >
> > I have a master server at the office and a replication server at home.
> > This setup has been working for a couple of years. Occasionally the
> > replication server gets out of sync (usually following a internet prob
ication server at home.
> This setup has been working for a couple of years. Occasionally the
> replication server gets out of sync (usually following a internet problem
> and the vpn going down.)
> I just stop the slave, make sure there is nothing going to the master
> (when the o
Replication novice
I have a master server at the office and a replication server at
home. This setup has been working for a couple of years.
Occasionally the replication server gets out of sync (usually
following a internet problem and the vpn going down.)
I just stop the slave, make sure
Hi list,
I have some problems with INSERT INTO and UPDATE queries on a big table.
Let me put the code and explain it ...
I have copied the create code of the table. This table has more than
1500 rows.
Create Table: CREATE TABLE `radacct` (
`RadAcctId` bigint(21) NOT NULL AUTO_INCREMENT,
Hi
Run mysql_upgrade command at OS shell
DK Sent from Phone
> On 28-May-2014, at 1:40 pm, "Lentes, Bernd"
> wrote:
>
> Hi,
>
> we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
> access one particular table.
> Automysqlback 3.0 says: mysqldump: Got error: 1142: SE
- Original Message -
> From: "Bernd Lentes"
> To: mysql@lists.mysql.com
> Sent: Wednesday, 28 May, 2014 10:10:33 AM
> Subject: access problem for a particular table
>
> we just migrated from 5.0 to 5.5. Nearly everything went well. But we can
Hi,
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one particular table.
Automysqlback 3.0 says: mysqldump: Got error: 1142: SELECT,LOCK TABL command
denied to user 'backup'@'localhost' for table 'cond_instances' when using LOCK
TABLES.
root has these rights
I don't know what you mean by "straight" mysql connection. At any rate,
the idea is to use --quick or otherwise using a connection which uses
mysql_use_result over mysql_store_result.
http://dev.mysql.com/doc/refman/5.6/en/mysql.html
Best,
/ Carsten
On 19-02-2014 12:02, Machiel Richards wrot
- Original Message -
> From: "Machiel Richards"
> Subject: Re: Mysql into outfile problem
>
> I have checked now and there is nothing in the Slow logs.
It may be turned off, then. Depending on your version you can change the
settings without having to restart th
I have checked now and there is nothing in the Slow logs.
On 19/02/2014 15:33, Johan De Meersman wrote:
- Original Message -
From: "Machiel Richards"
Subject: Mysql into outfile problem
- when we run an explain on the query it shows that it is
using index
- Original Message -
> From: "Machiel Richards"
> Subject: Mysql into outfile problem
>
> - when we run an explain on the query it shows that it is
> using indexes and the amount of rows it accesses is about 165000 rows
> out of a 90mil+ rows t
Hi,
the queries are done by connecting to the database using mysql
workbench or otherwise after ssh to server by using straight mysql
connection.
regards
On 19/02/2014 12:51, Carsten Pedersen wrote:
If you're doing this from the cmd-line client, try running it using
--quick. th
Best,
If you're doing this from the cmd-line client, try running it using --quick.
Best,
/ Carsten
On 19-02-2014 09:03, Machiel Richards wrote:
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some quer
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some queries and export the results to a
csv file.
However we seem to be experiencing the following issues:
- when we run an exp
I
Sent from my D
- Reply message -
From: "Rick James"
To: "Larry Martell" , "shawn green"
Cc: "mysql mailing list"
Subject: Problem with having
Date: Thu, Sep 26, 2013 12:11 PM
Still more to this saga
Comment 1:
... HAVING x;
The expre
; -Original Message-
> From: Larry Martell [mailto:larry.mart...@gmail.com]
> Sent: Tuesday, September 24, 2013 1:44 PM
> To: shawn green
> Cc: mysql mailing list
> Subject: Re: Problem with having
>
> On Tue, Sep 24, 2013 at 9:05 AM, shawn green
> wrote:
>
> &
t;>>>>> 1 row in set (0.01 sec)
>>>>>>
>>>>>> How can I fix this?
>>>>>>
>>>>>> Thanks!
>>>>>> -larry
>>>>>>
>>>>>>
>>>>>> You have to do a tw
time
WHERE d2.recipe_id IS NULL
As I said, there are many many ways to solve this problem. Here is one
that is going to perform much better for the generic case than what you
are doing.
CREATE TEMPORARY TABLE tmpMaxDates (key(recipe_id,maxdatetime))
SELECT recipe_id, max(date_time) max
to complete the
> condition by HAVING MIN(date_time) <, > or = something.
>
After reading this, I see what the problem is:
http://dev.mysql.com/doc/refman/5.0/en/group-by-extensions.html
Then I read this:
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
and cha
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> In your second query, you seem to have MIN(date_time), but you are
>>> talking about maximum. So
select recipe_id,max(maxdatetime) from data_csmeta group by recipe_id
having recipe_id=19166;
On Mon, Sep 23, 2013 at 4:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> I
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
talking about maximum. So your group by query is actually pulling the
minimum date for this recipe.
I pas
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> In your second query, you seem to have MIN(date_time), but you are
> talking about maximum. So your group by query is actually pulling the
> minimum date for this recipe.
>
I pasted the wrong query in. I get the same results r
I want to find the rows from a table that have the max date_time for each
recipe. I know I've done this before with group by and having, but I can't
seem to get it to work now. I get the correct row id, but not the correct
date_time. I'm sure I'm missing something simple.
For purposes of showing a
Hi,
In your second query, you seem to have MIN(date_time), but you are talking
about maximum. So your group by query is actually pulling the minimum date
for this recipe.
Regards.
On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell wrote:
> I want to find the rows from a table that have the max date
rchesatto
> > >
> > > Em 08/09/2013 16:00, "Trianon33" escreveu:
> > > Hello all,
> > >
> > > As this is my first post to this list (though reading for some time
> > yet), I maybe not complete in asking my question. Apologies for that.
gt;>> Att.
>>> Luis H. Forchesatto
>>>
>>> Em 08/09/2013 16:00, "Trianon33" escreveu:
>>> Hello all,
>>>
>>> As this is my first post to this list (though reading for some time
>> yet), I maybe not complete in asking m
et volgende geschreven:
>
> > How did you backed up the MySQL?
> >
> > Att.
> > Luis H. Forchesatto
> >
> > Em 08/09/2013 16:00, "Trianon33" escreveu:
> > Hello all,
> >
> > As this is my first post to this list (though reading for some time
. Apologies for that.
>
> On the other hand, this is not a prio 1 problem, so if it takes some mailing,
> that's ok.
>
> I have a website on my private webserver, which consist of some kind of a
> LAMP-server on a raspberry. Previously it ran on a laptop with Ubuntu and t
Hello all,As this is my first post to this list (though reading for some time yet), I maybe not complete in asking my question. Apologies for that.On the other hand, this is not a prio 1 problem, so if it takes some mailing, that's ok.I have a website on my private webserver, which consist of
: Re: InnoDB problem.
2013/7/23 Rick James mailto:rja...@yahoo-inc.com>>
Did you change innodb_log_file_size?
innodb_log_file_size error always appears in the logs...he only posted a few
lines of his log...but I guess (or I want to believe) he's gone through the
whole log before s
; > -Original Message-
> > From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> > Sent: Tuesday, July 23, 2013 9:57 AM
> > To: Luis H. Forchesatto; mysql list
> > Subject: Re: InnoDB problem.
> >
> > Eek.
> >
> > No immediate clue here, bu
Did you change innodb_log_file_size?
> -Original Message-
> From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> Sent: Tuesday, July 23, 2013 9:57 AM
> To: Luis H. Forchesatto; mysql list
> Subject: Re: InnoDB problem.
>
> Eek.
>
> No immediate clue here,
ssage -
> From: "Luis H. Forchesatto"
> To: "Johan De Meersman"
> Sent: Tuesday, 23 July, 2013 6:34:47 PM
> Subject: Re: InnoDB problem.
> The error log:
> 130723 10:04:23 [ERROR] Plugin 'InnoDB' init function returned error.
> 130723 10:04:23 [E
What's the MySQL error log have to say?
- Original Message -
> From: "Luis H. Forchesatto"
> To: "Johan De Meersman"
> Sent: Tuesday, 23 July, 2013 3:39:55 PM
> Subject: Re: InnoDB problem.
> Yep, I do backup of /home/mysql/ib* files too :D
&g
- Original Message -
> From: "Luis H. Forchesatto"
> Subject: InnoDB problem.
>
> Permission and owner of the table files (.frm files) are ok, since it
> recognizes MyISAM tables (they have the same permission).
Oops. You should always read the fine manual.
Yo
Greetings.
I've restored an MySQL backup from our MySQL server into another server.
The backup includes InnoDB tables. After the import, MySQL recognized the
innodb tables fine but when I try to do a check table ir returns that the
table doesn't exists.
Permission and owner of the table files (.f
Hi,
I've created a Trigger and want to edit it. Using MySQL Workbench, I can
Alter the table, and click Triggers and select the trigger action I want to
edit (on my local database, MySQL running on same PC)
However, if I try the exact same procedure on a Trigger on a remote
database, I don't see
independent how often you re-post it will not become magically
a MySQL problem if you have messed up your OS environment
Am 12.06.2013 15:27, schrieb Napster Cao:
>> BTW: Everytime I logged into system, I got:
>> -bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No s
Begin forwarded message:
> From: Napster Cao
> Subject: character set problem
> Date: June 11, 2013 11:04:18 PM GMT+08:00
> To: mysql@lists.mysql.com
>
> Hi Guys,
>
> I installed a new CentOS server (6.4 x86_64), and when I try to log into
> phpmyadmin, there
2013/05/29 14:51 +0100, Neil Tompkins
This is my Trigger which doesn't seem to work; but doesn't cause a error
DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType
enum('INSER
OK, the data is going into the temp table. But when I run the
command INSERT INTO AuditTrail SELECT tempHotelRateAvailability.* FROM
tempHotelRateAvailability; from the TRIGGER it does not copy the data.
However if I run this query INSERT INTO AuditTrail SELECT
tempHotelRateAvailability.* FROM
But, does it work inside the trigger. If not, then based on the logic,
there will not be any data, and data goes not get inserted from temp table
to innodb table
On Wed, May 29, 2013 at 7:29 PM, Neil Tompkins wrote:
> I took the following lines of code slightly modified and it returned some
> d
I took the following lines of code slightly modified and it returned some
data using a normal Query Editor
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType varchar(36),TableName
varchar(36),RowKey varchar(255),FieldName varchar(36),OldValue
var
did u check if data is getting inserted into tempHotelRateAvailability
On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins wrote:
> This is my Trigger which doesn't seem to work; but doesn't cause a error
>
> DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
>
> CREATE TEMPORARY TABLE te
This is my Trigger which doesn't seem to work; but doesn't cause a error
DROP TEMPORARY TABLE IF EXISTS tempHotelRateAvailability;
CREATE TEMPORARY TABLE tempHotelRateAvailability(AuditTrailId
varchar(36),UserId bigint(20),ActionType
enum('INSERT','UPDATE','DELETE'),TableName varchar(36),RowK
can you please share the code of the trigger. Any kind of error your getting
On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins wrote:
> Hi,
>
> I've a trigger that writes some data to a temporary table; and at the end
> of the trigger writes all the temporary table data in one insert to our
> norm
Hi,
I've a trigger that writes some data to a temporary table; and at the end
of the trigger writes all the temporary table data in one insert to our
normal Innodb table.
However, for some reason the trigger isn't copying the table from the
temporary table to the Innodb table. If I write in the
2013/04/30 17:17 +0200, Martin Koch
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
Try this: _binary X'36a461c81cab40169791f49ad65a3728'
SHOW CREATE VIEW is the command for the client.
--
MySQL General Mailing List
Fo
WHERE id = UNHEX('36a461c81cab40169791f49ad65a3728')
> -Original Message-
> From: Martin Koch [mailto:m...@issuu.com]
> Sent: Tuesday, April 30, 2013 8:18 AM
> To: mysql@lists.mysql.com
> Subject: Long integer constant problem in views
>
> Hi List
>
&
Hi List
I have a table with a primary key with type binary(16) and a few columns.
I'd trying to create a view that looks up all rows with a particular key,
i.e. something like
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
I use the mysq
Nope. That's just granting replication privileges so it can read updates
on all tables on all databases. It cannot select anything.
Why are you trying to connect with a replication slave user?
On 4/2/13 1:47 PM, "Richard Reina" wrote:
>I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'19
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina wrote:
> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
> RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
>
> #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
> #my $dbh =
I did a "GRANT REPLICATION SLAVE ON *.* TO 'user'@'192.168.0.23' IDENTIFIED
BY 'psswd';
on the master. Doesn't *.* mean everything? Why would it just show me to
databases?
2013/4/2 Larry Martell
> On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina
> wrote:
> > use DBI;
> > my $dbh = DBI->conn
use DBI;
my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
RaiseError => 3 } );
my $dbs = $dbh->selectcol_arrayref("show databases");
#my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
#my $dbh = DBI->connect($dsn, $usrr, $passw);
my $dbs = $dbh->selectcol_arrayr
: mysql@lists.mysql.com
主题: Re: 答复: PreparedStatement problem
- Original Message -
> From: "ZhangFangXue"
>
> well, the problem is that I used it like this:
> prep_stmt = con -> prepareStatement ("INSERT INTO City (CityNumber)
The statement in your original ma
well, the problem is that I used it like this:
prep_stmt = con -> prepareStatement ("INSERT INTO City (CityNumber) VALUES
(?)");
prep_stmt -> setInt (1, 23); //this statement didn’t act normally!!!
then when I execute the statement, the result does not appear to be correct, as
C
- Original Message -
> From: "ZhangFangXue"
>
> Hi, when I use PreparedStatement in c++ connector, I find some
> unexcepted error,
Well, first of all, you don't actually say what the error is that you're
seeing. This tends to be on the rather helpful side when trying to diagnose it.
>
- Original Message -
> From: "ZhangFangXue"
>
> well, the problem is that I used it like this:
> prep_stmt = con -> prepareStatement ("INSERT INTO City (CityNumber)
The statement in your original mail used CityName, which sounds like it should
be
> You can do:
>
>
> SELECT last_name, first_name, phone, if(pub_email="Y",email,"") as email
> FROM `mydatabasetable` WHERE `current_member` = "Y" AND `pub_name` = "Y"
> ORDER BY last_name ASC
>
Gracias, Carlos. This worked fine!
---Fritz
--
MySQL General Mailing List
For list archiv
enstag, 05. Februar 2013 um 15:49 Uhr
Von: cl
An: mysql@lists.mysql.com
Betreff: SELECT subquery problem
De-lurking here.
I am trying to figure out how to return results from a query. What I need to do
is to return 4 columns from a database. This is easy:
SELECT last_name, first_name, phone,
gt; done via the if(,,)-statement of mysql or by using a union and two selects,
> one for pub_email=n and the other for the rest.
>
>
> Gesendet: Dienstag, 05. Februar 2013 um 15:49 Uhr
> Von: cl
> An: mysql@lists.mysql.com
> Betreff: SELECT subquery problem
> De-lurking here.
De-lurking here.
I am trying to figure out how to return results from a query. What I need to do
is to return 4 columns from a database. This is easy:
SELECT last_name, first_name, phone, email FROM `mydatabasetable` WHERE
`current_member` = "Y" AND `pub_name` = "Y" ORDER BY last_name ASC
This
p routines dump, problem with lock tables.
>
> Hi All.
>
> I use:
>
> # rpm -qa | grep -i percona-server-server
> Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64
>
> My system:
>
> # uname -a;cat /etc/redhat-release
> Linux prbc01.mg.local 2.6.32-279.19.1.
Hi All.
I use:
# rpm -qa | grep -i percona-server-server
Percona-Server-server-55-5.5.28-rel29.3.388.rhel6.x86_64
My system:
# uname -a;cat /etc/redhat-release
Linux prbc01.mg.local 2.6.32-279.19.1.el6.centos.plus.x86_64 #1 SMP
Wed Dec 19 06:20:23 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux
Red Hat
1 - 100 of 8847 matches
Mail list logo
