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
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 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
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 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 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
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 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
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
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 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?
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
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 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 )
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
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 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
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
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 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
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 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
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 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
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
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/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
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 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
will be able to try out some of these
concepts. I do, however, plan to "have fun" this weekend... ;^)
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template ->|
--
MySQL General Mailing List
to do as you suggest is greater than simply
upgrading the 5.1.58 server to 5.1.60 or 5.1.61 server
Thanks for the reply!
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template ->|
--
MySQL General
e notes between those versions?
I think that might be a next step, but even more expedient would be
upgrading the 5.1.58 server to 5.1.60 or 5.1.61 version and retest.
> This looks like an ugly one. I don't envy you.
Gee, thanks for those words of encouragement - NOT!
bug
this issue. At this point we were stumped and called it a day. :-(
Today, I got the less than helpful from the support folks at
DbVisualizer and then I contacted "the MySQL community". :-)
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters w
Files: mysql.jar
Reference: http://www.mysql.com
DbVis Software AB is a "MySQL Network Certified Partner"
and have the right to distribute the Connector/J driver.
So what I can't explain is why it works for one and not the other.
Regards,
web...
--
William Bulley
ed for solution.
I would be greatful for any hints or suggestions as to how I might go
about correcting this problem. Thank you in advance.
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template ->
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 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: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
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 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
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
I have three tables show below which I am querying in a number of ways. e.g.
I have a report which lists number of reports provided compaired to number
which were due over the duration of the project.
I am puzzling over how to select the reports which were due and were
delivered during a week base
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
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
Try looking in Control Panel->Administrative Tools-> Services and deleting
all the MySQL services.
I suffered the same problem, and the following worked for me:
http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
Well, if your particular problem has a well defined maximum minimum and minimum
maximum (Ie the max(q) < 4294967296, because q is a 32 bit unsigned int, and
min(q)> -1) then you can do it without any extra joins or sub selects.
select
a,
b,
min(IF(date <100, q, 4294967296)) as min_q,
max(IF
I'm guessing you are adding a semi-colon (;) to the end of the statement. Its
unnecessary with the \G
- Original Message
From: Jeff Mckeon <[EMAIL PROTECTED]>
To: MySql
Sent: Thursday, December 6, 2007 12:19:22 PM
Subject: Error: No query specified
When I run a "Show slave status \
Use smaller transactions that don't have 140 million rows. When attempting an
action with important data, make sure you can survive the actions failure. If
you can't, then you need to think of a different way of doing it that will
allow a recoverable failure.
- Original Message
From:
If you are going to rely on obfuscation to protect valuable data, you might
want to consider not posting the particular method you will use on a public
mailing list.
I think any method you implement will lower the overall security of the system.
But, if you must search for encrypted text, you
** WE ROLL BACK TRANSACTION (2)
Can
anyone explain whats going on? Is there a limit for the number of
concurrent transactions, before looking at the lock graph becomes too
expensive? Is that documented somewhere?
Thanks,
ssage
From: Baron Schwartz <[EMAIL PROTECTED]>
To: William Newton <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, October 2, 2007 12:05:41 PM
Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.
Hi William,
William Newton wrote:
> Hello List,
>
&g
/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
END OF INNODB MONITOR OUTPUT
====
Does any one know whats going on? Is this expected behavior?
Thanks in advance,
William
___
lly. If they work change the my.cnf to make
them survive the next time mysql is restarted (for example on a reboot).
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: htt
On Mon, March 12, 2007 8:04, Neil Tompkins said:
> I've been researching the best method to store credit card numbers in a
> database which are saved encrypted. My version of mysql is 3.23 therefore
> I
> think the only function I could use is
>
> ENCODE() and DECODE().
>
> I've tried these functi
On Tue, March 6, 2007 9:40, Marcus Bointon said:
> On 6 Mar 2007, at 17:12, David T. Ashley wrote:
>
>> Best practice is that all times maintained in a database (or
>> anywhere on the
>> server) are UTC, and are only converted to local timezone and/or
>> adjusted to
>> daylight savings time as requ
On Wed, February 28, 2007 14:10, Ryan Stille said:
> I am on 4.1.20-1.
>
> Maybe your OS isn't patched?
>
> Try this: "SELECT @@global.time_zone;"
Won't help if you are on debian which is still on 4.0.
> If you get back "SYSTEM", then MySQL is looking to the OS for timezone
> data. And its only l
Please post to the list not to me personnally.
Original Message
Subject: RE: [PART 2/2] InnoDB - Different EXPLAINs for same query From:
"John Anderson" <[EMAIL PROTECTED]>
Date:Thu, January 18, 2007 10:24
To:
gt; open_files_limit=8192 # Anything higher needs corresponding ulimit entry
>
>
>
> #Buffers
>
> join_buffer_size=128M
>
> key_buffer_size=512M
>
> key_buffer=512M
>
> large_pages
>
> max_heap_table_size=1024M
>
> myisam_sort_buffer_size=256M
>
> read_buffer_size=64M
>
> read_buffer=64M
>
> query_cache_size=32M
>
> query_cache_type=1
>
> record_buffer=512
>
> sort_buffer=512M
>
> table_cache=512
>
> thread_cache=4M
>
> thread_stack=512K
>
> thread_cache_size=300
>
> thread_concurrency=16
>
> tmp_table_size=1G
>
>
> #innodb
>
> innodb-table-locks=off
>
> transaction_isolation=REPEATABLE-READ
>
> innodb_buffer_pool_size=1024M
>
> innodb_log_buffer_size=8M
>
> innodb_flush_log_at_trx_commit=0
>
> innodb_log_file_size=128M
>
> innodb_additional_mem_pool_size=32M
>
> innodb_thread_concurrency=16
>
> innodb_commit_concurrency=4
>
> innodb_flush_method=O_DIRECT
>
> innodb_open_files=8192
>
> innodb_sync_spin_loops=32
>
> innodb_thread_sleep_delay=1000
>
> innodb_autoextend_increment=1024M
>
> innodb_file_per_table=TRUE
>
>
>
> [client]
>
> socket=/tmp/mysql.sock
>
>
>
>
>
> John Anderson
>
>
>
>
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Have you looked at ubuntu distribution of linux. I think they have a
'school' variant which might be close to what you need. Also, the people
there might be able to give you more help. Good luck.
On Thu, December 7, 2006 9:39, Saqib Ali said:
> Hello All,
>
> I know this is little bit off-topic
MATCH (title, description) AGAINST ('chev* \"malibu\"' IN BOOLEAN MODE)
vs
... AND MATCH (title, description) AGAINST ('chev* "malibu"' IN BOOLEAN MODE)
They both seem to be Ok, but I just want to make sure now, before
wierd problems come up later...
thanks
Sorry, but I haven't gotten any emails from the list and I'm trying to
determine if there is a blockages. Sorry to disturb the list.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing Lis
hello everybody
anybody had to deal with this?
i have a windows form created on VB.net to get a report on embbeded crystal
reports develop program
im trying to customize the fields to show by using the CR form via Sql Sintax
option for the fields
but the formula editor seems does not underst
Glenn Kawesch
Dr. Kawesch is the surgical director of Kawesch Lasik--one of Southern
California's most experienced refractive surgery facilities. We have been
specializing in refractive surgery since 1989 and have completed
approximately 25,000 procedures.
Dr. Kawesch attended medical school at
: http://www.mylasikweb.com
Boothe Lasik <http://www.mylasikweb.com/>
Dr William Boothe <http://www.mylasikweb.com/>
Dr Boothe <http://www.mylasikweb.com/>
Lasik Boothe <http://www.mylasikweb.com/>
Boothe <http://www.mylasikweb.com/>
Boothe Lasik <http://www.m
to match the
new structure), drop the old table and rename the new table to the old
tables name. So the time might be realistic. It depends on the hardware
you are using and what else is going on on the system.
Hope this helps.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.
t;
Then it is really a UNION. I hope you have the date field as an index
otherwise you are looking at a table scan which is always slow.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
it a RELATIONAL database. If the tables
don't have such a relationship you are asking for the UNION of the
separate information from table a, where it meets its WHERE conditions,
and the information from table b where it meets its WHERE conditions. The
fact that both where conditions are the
; --
> http://www.spacemarc.it
Well that's what you asked it to do, if you look closely at your query.
How are table a, b, and c related to each other?
Do you want all the information from each of the tables (which are NOT
related to each other) between the specified dates? If that is the
hello .
anybody knows how to export from excel to mysql in order to create or fill a
database table??
tanks for your help and patience
cheers
Would it not be best to have the field with the fewest repeats (i.e., the
closest to unique) first, or is that what you meant.
Bill
On Tue, October 17, 2006 10:12, Jerry Schwartz said:
> I didn't think of that (combinations). You are probably right. Due to my
> background, I tend not to think a lo
hello
i'm developing a program on visual.net 2003 where i need to extract data from a
date time format column
working with mysql.net component for extract via mysqlcommands and dataadapters
im fillin datagrills but the column displayed only presents the date but not
the time
im still analiz
A couple of comments:
- Simultaneous connections can be increased, but at some point the user
than runs the mysqld process will run out of file handles it can allocate
(each table takes 2 or 3).
- If we are talking about a database server and test server being the same
box then what are you trying
Just noticed that you said partitions. I am assuming that you meat
multiple drives in a raid array.
Bill
David Lazo said:
> Thanx again.
>
> For the time being, we will keep 4 drives with Dan's suggestion. OS and
> MySQL running from there.
>
>
>
> On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PR
ore issues, but no issue can 'belong' to
more than one customer then its 1 to many and you can put the customer ID
in the issues table.
If several customers can have the same issue (row) then you will need an
intermediate table which has two columns: customerID and issueID.
---
Wi
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 of
't be an issue, but I
am not able to change its schema.
Thank you.
- William
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server version 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.
Oops, the version numbers were 4.1.18-nt and 4.1.19-standard. I have tried
it now on the latest 4.1.20 version and still have the same problem.
Does anyone have any ideas? Is this a bug?
Cheers,
Bill
> -Original Message-
> From: William Bronsema
> Sent: Thursday, July 20, 2
Hello,
I am encountering a strange issue when using the STD function. On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:
SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY
When I test this query on m
somewhere
>> > between 1000 and 2000 rows, but you just want to see the
>> last 50. These
>> > last 50 might be the most recent entries, for example. Can
>> this be done
>> > in single query?
>> >
>> > Dirk Bremer - Senior Systems
Dear Sir,
I have a database with over 80 tables. Is there an easy way to find table
names that has PERSON_ID field using SELECT query?
Thanks in advance for any help.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has th
romyd misc said:
> Hi Everyone,
>
> I'm developing an application using C# .NET and mysql as database. It's a
> multithreaded application, we open a mysql database connection at the very
> beginning when the application is started and all the database requests
> use
> the same connection. But under
Is it possible to setup replication so you would have another server to do
backups on? Replicate the data, do whatever you want to the spare, and then
delete the data from the production server.
On 4/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I need a suggestion reg
If the ID doesn't represent anything, you can
CREATE TABLE new_table SELECT DISTINCT Row1, Row2 FROM old_table
And then recreate your index(es).
All your autoincrement IDs will be changed.
On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
>
> On 4/18/06, William Fong
Sample Data:
ID-Row1-Row2
1-A-B
2-A-B
Row1 and Row2 are duplicate, so you only want one. Which ID do you want?
-will
On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
>
> hey all,
> I have a table "mytable" that looks like this:
> id tinyint primary key auto_increment
> row1 varchar 15
ing the installation. I wasn't sure what to use
> to Default Schema so I just put in test. I keep getting a connection error
> number 2003 stating I can't connect to MYSQL server. Is there something
> that someone can suggest?
>
>
>
> Thanks,
>
>
>
> Chu
as you can see I do not select a engine type, is there some
> engine type better suited and or faster for the way I am
> trying to use the keys?
>
> Thanks for your advice and help.
Close but you need to specify that the index is UNIQUE (see changes above)
---
William R. Mussatto, Seni
Some more information can be found here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
On 12/31/05 7:29 PM, "JJ" <[EMAIL PROTECTED]> wrote:
> I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
> why MySQL Adminstrator says the table has 497 rows, while do
to disable show databases to get Lasso working properly.
Unfortunately, we also need phpMyAdmin to work properly, and it seems
to have problems if this feature is disabled.
Thanks,
-Bill
On Dec 19, 2005, at 7:34 AM, William R. Dickson wrote:
This did the trick. Many thanks. I had found tha
This did the trick. Many thanks. I had found that option, but
misinterpreted what I read; I thought it was only available in 4.x.
Thanks again!
-Bill
On Dec 14, 2005, at 6:59 PM, Michael Stassen wrote:
William R. Dickson wrote:
OK, I strongly suspect I've just done something stupid
OK, I strongly suspect I've just done something stupid here, but I'm
having trouble figuring it out. I had a disk go bad on a MySQL server
this past weekend. I did a clean system install (FreeBSD 5.4) on a
new disk, installed the MySQL 3.23 port, and restored the mysql data
directory from b
I'm trying to relocate the database files for MySQL 4.1
I've seen two primary techniques for doing this:
1) create/alter a my.cnf file with 'datadir' set to new location
2) moving the physical files and creating a symlink in the original location
Unfortunately, neither of these methods work for me
is implies, at least to me, that one doesn't need a 2nd
> database server or to do a mysqldump (your steps 5-7). Instead, we just
> tar cv /mnt/ops/dbbackup (to use the article's example name for the
> mounted snapshot), save the tape, and dispense with the snapshot.
> Wouldn&
Gleb Paharenko said:
> Hello.
>
> In my opinion, one of the causes of the problem can be the processing of
> trailing spaces in varbinary fields. See:
> http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
Thanks, you may be right since the results are too short.
>
>
I was storing some 8 bit information in a varchar binary field (encrypted
stuff) and I think its getting corrupted. I thought they were (except for
size) interchangable? I'm running debian GNU Linux and haven't moved to
sarge so I'm still on 3.23.x but will be moving shortly.
---
Hello,
I'm not sure if this question is more appropriate for general discussion
or the internals list.
I want to create a tokenizer/lexer for MySQL's dialect of SQL to use in
a JAVA application. I thought I could do this by creating a JAVA
wrapper on the lexer code for MySQL. I looked thro
1 - 100 of 437 matches
Mail list logo
