muhammad subair wrote:
On Mon, Jul 27, 2009 at 9:25 PM, Ken D'Ambrosio wrote:
Hey, all. I'm trying to "get" indexing -- like, when do you specify an
index name during index creation, is index use implicit or explicit, and,
honestly, how exactly does it work, anyway? I've been RTFM'ing, but
h
I have two tables:
PtActive
ptNum // the patient's number
user // the user who made this patient "active"
expires// when the patient becomes inactive again
primary index: PtNum
PtName
ptNum
sequence
lname
fname
primary index: ptNum, sequence
The table PtName may have multiple
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP. Default DATE(TIME) columns with Triggers.
PB
When I try
ALTER TABLE `ptInfo` CHANGE
On 1/27/2012 6:00 PM, Peter Brawley wrote:
On 1/27/2012 2:24 PM, william drescher wrote:
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP
I want to update a date field in a record. if the date in the
field is -00-00 I want to change it to the current date. I
would appreciate suggestions or links on how to do this.
Yup, tried reading the manual, but need a bit of help.
I will be updating another field at the same time.
bill
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
Thanks
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On 2/9/2012 8:18 AM, Michael Dykman wrote:
untested:
update set mydate = IF(mydate = '-00-00', now(), mydate)
- michael dykman
Thank you very much !
bill
On Thu, Feb 9, 2012 at 8:14 AM, william drescher
wrote:
I want to update a date field in a record. if the d
On 2/9/2012 8:58 AM, Reindl Harald wrote:
Am 09.02.2012 14:55, schrieb william drescher:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
On 4/16/2012 3:04 PM, Haluk Karamete wrote:
What's the right built in php date function formatting would be to take a
simple date, that's in a format like 05/16/1960 and turn it into a mysql
datetime datatype friendly format?
I don't mind H M S to be as 00:00:00/
wrote my own:
function US2ISODa
I have a table ("tasks") with:
task_id mediumint(9)
status char(1)
priority char(1)
and more fields
when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it d
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the
ug 19, 2012 11:19 AM, "william drescher"
wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'
On 8/19/2012 5:56 PM, william drescher wrote:
mysql> select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
mysql> update tasks set status= 'H';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysq
On 8/20/2012 10:09 AM, Mogens Melander wrote:
On Sun, August 19, 2012 18:19, william drescher wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more w
I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned NOT NULL,
`standing_script` mediumint(9) DEFAULT NULL,
On 3/31/2013 7:32 AM, william drescher wrote:
I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned NOT
of course, "Group By"
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 7/26/2013 6:58 PM, Chris Knipe wrote:
The issue that we have identified is caused by seek time - hundreds of
clients simultaneously searching for a single file. The only real way
to explain this is to run 100 concurrent instances of bonnie++ doing
random read/writes... Your disk utilization a
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`icd10` char(6) NOT NULL,
PRIMARY KEY (`id`),
U
On 3/29/2014 2:26 PM, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL
On 8/29/2014 5:51 AM, Johan De Meersman wrote:
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
yes.
I welcome help from anyone willing. Expertise and willingness
both are important.
--bill
--
MySQL General Mailing Li
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 th
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
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 )
after a more complex transaction;
+--+--+--+---
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
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%';
+-+---+
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/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 equ
On 9/19/2014 10:59 AM, Don Wieland wrote:
On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
the target folder don't matter
that is clearly a *MySQL error* that your *MYSQL user* lack the needed
permissions
Yes i figured that - so the question is, how do I give full permissions to that
user?
Ubuntu 14.04 LTS, MySQL 5.5.38
I have a setup with multiple tables in one database. One is a
memory table. I have replication running to a remote computer
for a hot backup.
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in
On 10/15/2014 11:30 AM, a.sm...@ukgrid.net wrote:
Quoting william drescher :
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in memory
table.
Is this what you are after?
http://dev.mysql.com/doc/refman/5.5/en/replic
On 6/18/2015 1:25 PM, AZ 9901 wrote:
Hello,
I only get SPAM answers when I try to post to this list so here is a simple
message…
Sorry…
Marc.
your message came through on gmane.comp.db.mysql.general just fine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list dedicated to replication, but when
you have a look in the archive it's nearly complete empty. Really
not busy.
So i hope it's ok if i
On 3/22/2016 7:49 AM, Lentes, Bernd wrote:
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up the programms on the slave by hand and then they ar
On 4/30/2016 3:22 AM, Thomas wrote:
Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher:
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the
On 7/8/2016 9:15 AM, Johan De Meersman wrote:
As a clear example of what it is useful for, imagine a situation where you're
performing an inventory on an existing warehouse. You have the
list of all the
products they've ever sold, but you need to differentiate between
'this product is
not in s
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How can I see the warnings earlier in the load ?
-bill
--
MySQL General Mailing List
On 3/25/2017 10:03 AM, Hal.sz S.ndor wrote:
2017/03/24 15:19 ... william drescher:
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed
40 matches
Mail list logo