I'm trying to dump all the columns of a table but one in a
restructuring of my schema. I found this post:
http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html
which seems to indicate that this isn't possible, but I was wondering
if anyone had any suggestions. My current solution
At 11:52 PM -0800 3/7/08, J. Todd Slack wrote:
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
-Jaso
At 12:23a -0500 on Sat, 08 Mar 2008, obed wrote:
> Use \ to escape.
>
> mysql> insert into table1 values ('algo\,otra');
As an aside, I'm curious why the parser doesn't understand that the
comma is part of the string in this context? It's already between two
single quotes ... ? Shouldn't that b
Use \ to escape.
mysql> insert into table1 values ('algo\,otra');
Query OK, 1 row affected (0.00 sec)
mysql> select * from table1;
+---+
| a |
+---+
| algo |
| algo,otra |
+---+
2 rows in set (0.00 sec)
On Sat, Mar 8, 2008 at 1:52 AM, J. Todd Slack
<[EMAIL P
Hi All,
We've got a database (legacy, running MySQL 4.1.22 Standard) of
constituents. We want to search through it for duplicates, and I've found
that a good way to generate a list of potential duplicate addresses is to
look for addresses that have matching street numbers, zipcodes, and last
nam
This problem actually started after I moved the datadir to another
folder, so that's quite possible. We stopped everything, rsynced the
folders over, then restarted mysql. But I do notice a permissions
problem, since the owner currently is root. I'll chown it to mysql
then see what happens.
I'll p
Hi,
On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> SHOW DATABASES; shows that I have a database called "test", but when I
> call "DROP DATABASE test", I get
>
> ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
>
> When I run any queries on that data
Waynn:
What user are you using to execute mysql from the command line? Perhaps run
mysql (from command line) as root then execute the desired actions (such as
drop). This will make sure you can drop the table and avoid any further
problems.
Sincerely,
Craig Huffstetler
On Sat, Mar 8, 2008 at 6:
Waynn-
does the OS user you use to execute mysql have create/write/read/execute
rights to the ./test folder?
Martin-
- Original Message -
From: "Waynn Lue" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 08, 2008 6:58 AM
Subject: Can't drop database that shows up in show databases
> SHOW
look at this:
http://forums.mysql.com/read.php?113,27031,39226#msg-39226
--
arman p.
Sinapsis Peru
http://www.sinapsisperu.com
http://armandfp.blogspot.com/
SHOW DATABASES; shows that I have a database called "test", but when I
call "DROP DATABASE test", I get
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
When I run any queries on that database, I get errors like:
mysql> select * from Users;
ERROR 1017 (HY000): Can't find fi
11 matches
Mail list logo
