Mark,
You're killing me because I can't visualize the source tables. A query
like this is bread and butter, it shouldn't take to long to execute.
Give me a better idea of the table structure and relationships between
them. I try to help.
Regards,
Adam
On Feb 4, 2004, at 11:04
nt to achieve?
(2) What are the details of the tables in the join
(column names & data types)?
Regards,
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---+
Hope this helps some.
Cheers,
Adam
Kevin Barry>
> I've installed ver 4.1.7 on a brand new Fedora Core 3 server but cannot
> connect remotely from a Mac OSX machine running Navicat or a Win XP machine
> running MySQL Admin. I can ping the machine with no problem and have op
tudio/index.html)
There are many other some are probably free. Look around! I hope you find
something you like.
Cheers,
Adam
Ferguson, Michael>
> G'Day All,
>
> Can anyone recommend an application that will read/probe a MySQL
> database on a Linux server and gener
mma
delimited file.
Good luck!
Regards,
Adam
Eve Atley>
>
> I'm not sure how best to proceed in dumping data from 1 database and getting
> a copy of the export, in order to transfer it to another server. I usually
> use phpmyadmin to do an export, which nicely creates a .zip f
Ziggy,
I'm not sure what you need help with.
If you want to get data into MySQL from Excel, consider saving the data (I
assume it is a table) as a CSV then using the LOAD DATA command to bring the
data into a temporary table in MySQL. Take a look at the command in the help
pages.
Regards,
Hello.
My company is using mysql as a backed to Bugzilla.
However, recently, as the number of users that are logging bugs increased we
are experiencing frequent table corruption and loss of data.
The actual error message we get is:
" SELECT query FROM namedqueries WHERE userid = 4 AND n
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: frecvent table corruption
"adam" <[EMAIL PROTECTED]> wrote:
> The actual error message we get is:
>
> " SELECT
Is there any way to log all the activity in a mysql database?
I would like to know every single delete insert or select on all tables for
my database.
Regards, Alex
email, or hitting a
url or some sort of automagical device to tell me things are stopped, or
is the best way to write a quick script to pull show slave status and
check the vars?
Thank you,
Adam
###
This message has been scanned by F-Secure Ant
string' is used as a type, but is not defined as a
type.
dictionary.h: In constructor `Unique_dictionary::Unique_dictionary()':
dictionary.h:65: class `Unique_dictionary' does not have any field named
`templ
'
Thanks,
Adam
--
MySQL General Mailing List
For list archives: ht
Wow! Great timing.
Thanks Jeremy
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 11:13 PM
To: Adam
Cc: [EMAIL PROTECTED]
Subject: Re: SuperSmack on x86_64 / gcc 3.2.2
On Tue, Sep 02, 2003 at 10:23:42PM -0400, Adam wrote:
> Any
If I wanted to make a dictionary entry that would just provide a
sequential # starting at X and every time its used, it adds one... Is
this possible? How?
I do not quite understand the docs, but it seems like unique and
template has this ability.
Thanks,
Adam
avior when executing DDL queries to MySQL.
Regards,
Adam
On Apr 1, 2004, at 4:14 AM, Patrick Kirk wrote:
Hi all,
My setup is windoes 2000, Access 2000 and Mysql built from source on
Debian.
Some tables can be seen but all new entries are marked "#Deleted". If
I close the table in Access
Daevid,
SELECT *
FROM wifi_table
WHERE active = 1
HAVING unix_timestamp()-unix_timestamp(last_seen) < 600;
Regards,
Adam
On Apr 5, 2004, at 8:29 PM, Daevid Vincent wrote:
I'm curious when will I be able to do something like this:
SELECT *, IF(( (unix_timestamp()-unix_timestamp(l
t move the expression
in the `IF` to the HAVING clause?
So take my old statement and ditch the where clause. You'll get:
SELECT *
FROM wifi_table
HAVING unix_timestamp()-unix_timestamp(last_seen) < 600;
A little easier on the eyes no?
Cheers,
Adam
On Apr 6, 2004, at 9:42 PM, Michael St
MIchael, Point well taken.
Cheers,
Adam
On Apr 8, 2004, at 2:47 PM, Michael Stassen wrote:
Good point. I was focused on the question of using the alias to
restrict results, so I left the function in the SELECT part. As you
say, in this query, that would just give a useless column of '1&
All,
I've got data listing people's identification details including first
and last name, social, and status in the application. Given this data,
I want to know how many duplicate socials I have. Normally I'd write a
query with a sub select to get that information - something like this:
SELECT
This is a great question! I also work on SQL Server (2k) databases as
well as Access and MySQL. I run into the same problem. So far, I've
just changed the SQL in my applications, but I also would like to know
if a default can be set.
Regards,
Adam
On Apr 18, 2004, at 12:01 AM, Stormblade
, I'd reference the message, and if that doesn't help bring
the message to the group.
Regards,
Adam
On Apr 22, 2004, at 9:29 AM, Tom Brown wrote:
Hi,
I'm trying to create a table with the following syntax
CREATE TABLE TNSession
(
SessionID int(11) NOT NULL auto_increment,
IPAdd
Hello.
I have installed MySql on RH Linux, however since I have installed in the
wrong location I would like to uninstall.
Basically I have installed the binary version from the
"mysql-standard-4.0.18-pc-linux-i686.tar.gz" and
I have followed the instructions in the INSTALL-BINARY, in partic
Hello.
I am using mysql 4.0.18 on rh3, and I would like to daily save db state. I
have this small script
under the cron directory that when executed from the prompt works fine.
Basically the dump is done by:
mysqldump --user=root --password= --opt bugs >
$BACKUPDIR$BACKUPSQLFILE
My
Hello.
I have compiled/rebuilt the MySQL 3.23.49 Source RPM under kernel
2.4.17, and glibc 2.1.
Using gcc version 2.95.4 20010319 (prerelease). I had 2.96 on there and
headed the warnings and downgraded to 2.95.
Randomly I get the Lost Connection using PHP 4.1.2... Any idea why?
Thanks
Adam
has a gig of ram. Very little traffic.
adam
-Original Message-
From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 3:52 PM
To: Adam Helfgott
Subject: Re: MySQL 3.23 Lost Connection
Hi,
Perhaps a mysql thread which runs out of memory ?
Regards
I was the one having issues getting Lost Connection and whatnot for no
reason.
I have recompiled under glibc2.2.5 with 2.95 and 3.04.
I just tried 4.0.2 from the source tree.
Sometimes from the command line of doing mysql -uroot -p I get this:
ERROR:
And that's it.
I run it again, and it go
startup, and my own options that works well on another
production server of a similar configuration.
Apache/PHP and Qmail work flawlessly on this machine.
Thanks for everyones help on this matter!
-adam
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March
I'm assuming your users arnt using a MySQL client directly to perform
the queries... And your using middleware like PHP or something.
So your PHP code can parse the users responses and then design your SQL
queries around your parsed data.
-Original Message-
From: BadgerBay [mailto:[EMAI
Perhaps you can create a function to serialize the array into text and
dump it into a blob in the DB, and have another field(s) with the data
you want to search on.. Then unserialize the array when you take it out.
-Original Message-
From: Hresko, Christian A. [mailto:[EMAIL PROTECTED]]
$sql="select * from table where blah=$blah";
$x=mysql_query($sql);
while ($data=mysql_fetch_array($x)) {
echo "$data[columnName]";
}
I think is what your trying to do...
On Thu, 7 Mar 2002, Gavin Philips-Page wrote:
|Could anybody please help:
|
|In the query I have includ
Yep.. this is very feasible.. And there are some packages to do this
already.
http://www.firstworks.com/sqlrelay.html
Is a good package and library/API to implement what you want to do. We
have done this in the past for a large community based website.
-Original Message-
From: John Ma
There is a point that if you buy APC-Cache and the encoder you are
spending a lot of cache.
However there is APC, PHPCache and others that do the job.. but not as
well. PHP is mildly flawed in the sense that it is somewhat
intentionally crippled so Zend can make a profit from sites that adopt
it
What they need is a PHP->Lasso converter, or offer a dev person to
convert your application.
Similar to ASP2PHP
MYSQL CONTENT: And does Lasso offer MySQL connection pooling?
-Original Message-
From: John Dean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:59 PM
To: [EMAI
That's probably your problem. You don't want to read "fucking the
manual", you want to read "the fucking manual"!
Sorry. I couldn't resist!
:)
Your best bet isn't gonna come from a mysql doc. But from a SQL design
theory book/resource.
-Original Message-
From: Matthew Walker [mailto:[
te. However, it
still hasn't provided me with a mysql.sock file. How do I reinstate this
file?
advTHANKSance
Adam
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find an
>>archived version of the mailing list, or a fix to my problem. Using
>>Linux
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a basic query, but I couldn't find an
>>archived version of the mailing list, or a fix to my problem. Using
>>Linux
Egor Egorov wrote:
> adam,
>
> Tuesday, June 04, 2002, 12:05:30 PM, you wrote:
>
>>>the mysql.sock file is automatically created when mysqld is started.
>>>please check your configuration (/etc/my.cnf) and your mysql daemon ... :D
>>>
>>
>
OK got this sorted in the end, by putting a soft link in to the /tmp
folder pointing to the /var/lib - thanks one and all.
Adam
Dicky Wahyu Purnomo wrote:
> On Tue, 04 Jun 2002 08:04:01 +0100
> adam <[EMAIL PROTECTED]> wrote:
>
>
>>Apologies for posting such a bas
I took a look at mysql.sock and that file is empty
>
> any ideas how to fix that?
*nix?
Is mysql.sock in /etc? Mine wasn't, so I put in a soft link from the
location and it worked fine after that.
Adam
--
-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.0.4 (GNU/Linux)
Oscar Mena wrote:
> is not in /etc
> how do I put that soft link?
>
> - Original Message -----
> From: "adam" <[EMAIL PROTECTED]>
> To: "Oscar Mena" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Saturday, June 08, 2002
JR wrote:
> To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
> I do not believe that mysql will read the foxpro db format. Dump your
> foxpro table data into a text file and use mysqlimport to pull the data
> into your mysql table. See:
> http://www.mysql.com/doc/m/y/mysq
>Description:
Replication stopped on our MySQL 4.0.1-alpha distribution with the error:
Error executing query '%': got error 127 from table handler.
(This may not be the exact text).
Note the '%', which is what this bug report is referring to. Presumably the text of
the query should be there.
I am having trouble with mysql... i keep getting
"ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)"
I uninstalled and reinstalled MySQL rpm (RH 7.1). I originally I was
able to connect to MySQL server via command line client, but could not
connect v
Thank you everyone who helped :o)
I got MySQL up and running... as it turned out it was a permissions
problem... go figure.. i hoped i left that all behind with NT :o)
-Adam
-
Before posting, please check:
http
i had the same problem
chown -R mysql.mysql /var/lib/mysql
and i created a symlink from /tmp to the /var/lib/mysql/mysql.sock
and restarted mysql and wammo it worked.. I used this on one computer on
the advice for Error 2002: ... ... mysql.sock(2) error.
On Tue, 2001-09-11 at 08:53, Mi
i got a really good book on MySQL, it does not have much in the way of
troubleshooting, but a lot on use.
Title: MySQL
Author: Paul DuBois
ISBN: 0-7357-0921-1
Publisher: New Riders
-
Before posting, please check:
http://w
In web development PHP is very easy to use and best of all very well
documented. I have to aggress with Lezz Giles on using PHP over perl for
MySQL backed webpages.. The learning curve on PHP is far easier than
perl.. I use both for various reasons..I tend to use perl of CGI apps
that php cant do
I got an idea and thought i would ask around about a recovery plan about
databases? Currently all i do is dump the databases on to a share on an
NT box thru a SMB share from the RH 7.1 Linux DB server. The NT box is a
Compaq CL1850 which is 2 Compaq 1850 server with a shared SCSI array.
The NT box
the sock file is in the /usr/lib/mysql dir i created a symlink of the
file from there to /tmp
On Thu, 2001-09-13 at 14:32, Nick Torenvliet wrote:
>
> I'm trying to start my first ever installation of mysql, so I've installed
> the tar.gz (3.23.42 on Linux) and I've run ./configure from /my
About 95% of the records of in the table have user_id=1
Any insight will be greatly appreciated.
Thanks,
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lly have 3! combinations of filters and sort
orders.
Adam
On Apr 20, Alexey Polyakov wrote:
> On 4/20/06, Adam Wolff <[EMAIL PROTECTED]> wrote:
>
> > How can I optimize the case where I filter on one key but sort on another?
> > This is fast:
> >SELECT * FROM co
CT contacts.*, (SELECT COUNT(*) FROM contacts AS c2 ...
but that's conceptually what I'm looking for.
Thanks!
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey! I figured out this one myself:
On Apr 19, Adam Wolff wrote:
> * Question 2:
> Why does introducing an extra WHERE clause make things slower?
> If I do this:
> SELECT * FROM contacts WHERE fullname LIKE "j%" AND user_id=1
> ORDER BY fullname LIMIT 10;
>
On Apr 22, Philippe Poelvoorde wrote:
> alter table s add index(login_name);
> alter table c add index(recordID);
To make this much faster, I think you may want:
alter table s add index(recordID, login_name);
alter table c add index(recordID);
Because after the join, the engine can use the
I didn't look through your code very carefully. Have you confirmed (using
EXPLAIN) that your select query is using the index?
I don't much about the mysql optimizer, but it's possible that this query:
> $query1="SELECT lat,lon from integer_test WHERE lat>$lat1 and lat<$lat2
> and lon>$lon1 and l
Actually I think this should be an INNER JOIN -- not a LEFT JOIN.
A
On Apr 23, Adam Wolff wrote:
> I didn't look through your code very carefully. Have you confirmed (using
> EXPLAIN) that your select query is using the index?
>
> I don't much about the mysql optimizer,
Well, I hadn't known about the spatial features of MySQL. If you're ok
using vendor extensions then that definitely looks like the way to go:
http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html
A
On Apr 24, Nick Hill wrote:
> Hello Adam
>
> Adam Wolff wrote:
> &
| SIMPLE | contacts | ref | user_id,user_id_2 | user_id_2 |
4 | const | 506222 | Using where |
++-+--+--+---+---+-+---++-+
In other words, it *is* using an index for this query. Anyone have any
advi
column:
> http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
> Also note that as you add or delete rows the table does not stay in order.
>
> Hope this helps!
>
> Dan
>
>
> Adam Wolff wrote:
> > I have a very simple table that looks like this:
> > CREATE
You could you use UNION to make this all execute in a single query.
On 5/10/06, Rhino <[EMAIL PROTECTED]> wrote:
Hi Chris, Joerg, and everyone else following this discussion,
Joerg, you are correct; the best way to sum the tables is individually and
then add the sums together with program logic
have experience of this? Upgrading commercial licences?
What's the story?
Thanks - Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Checking. I don't think the customer bought the "network" version.
Apparently its MySQL Pro Licence V4.
It's a bit rich not to offer upgrades at a discount IMO.
Adam
-Original Message-
From: David Logan [mailto:[EMAIL PROTECTED]
Sent: 12 May 2006 11:52
T
Folks,
Does this work in MYSQL 5?
I tried "DROP INDEX [NAME] IF EXISTS;" and got an error "check your syntax".
Thanks - Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks
What I am getting at is: does the "IF EXISTS" qualifier work in this context?
I have an index that is present in some DB's but not in others. I want to run a generic script to
upgrade them all. I don't want the script to stop if the index is not present.
Thanks
k you,
Adam
JSP:
User ID
First Name
Last Name
User Name
Phone Number
phone_name
login Status
Number of Con
n the sql statement with error
> $DBI::errstr");
>
>How can I debug or fix this problem, please?
>
>
Instead of doing this, you might want to try setting RaiseError (see man
DBI) which would cause DBI to detect errors and throw exceptions.
Alternatively, you migh
Description:
We have distributed applications which make extensive use of the
get_lock() function
to acquire a system-wide lock. Occasionally, all copies of a given
application
block attempting to acquire a lock on the same lock string. Using
is_used_lock() reports
Did you drag it from a network drive, or copy in some other way? If
so, that may be the problem.
I haven't used the MySQL Administrator, but am pretty well versed in
application troubleshooting. Send me an email privately if you need
some direct help.
Adam.
--
Adam Randall &l
rt ''
to 1, '\0' to 0.
Does anyone know a way around this?
TIA - Adam Lipscombe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
persuade mysqldump to produce one file (with "insert
into" statements) and also use Windows style line endings?
TIA - Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ne
on a separate line?
E.g. :
INSERT INTO t1
VALUES
(1,2,3),
(1,4,5),
(1,6,7);
TIA - Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
There's a mysqld startup option --datadir=/path/to/data which you can
use to alter your data directory. Simply adjust your startup scripts
to suite.
Regards,
-Adam
On 1/31/06, Scott Johnson <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am trying to find out how to change
vely.
I have tried forcing the encoding by using "mysql
--default-character-set=latin1 -u -p < datadump.sql"
but this produces the same results.
Any ideas?
TIA - Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Description:
running mysql_install_db does not correctly fill grant tables
>How-To-Repeat:
run mysql_install_db; attempt to connect, fail.
>Fix:
Edit #!/bin/sh to use **ANY OTHER SOLARIS SHELL**
>Submitter-Id: [EMAIL PROTECTED]
>Originator:Adam Thompso
rior to the reinstall:
mysql -u adam -px
ERROR 1045 (28000): Access denied for user 'adam'@'localhost' (using
password: YES)
but in the mysql.user table, adam exists and has his password set from
the dump file:
mysql> select User,Password
you're a genius! I had old_passwords=1 in my.cnf, changed it to 0,
restarted mysql, and then the users worked like a charm. thanks!
Little, Timothy wrote:
My theory would be that it's an OLD-PASSWORDS issue. It would seem that
you might have used the
old_passwords=1 in your original configur
I've written a helpdesk ticket problem and am working on the statistics
module. I'm having problems with group by. For instance, I want to get
the count of the number of different problem types, by how many were
solved by each person. This is my statement:
mysql> select distinct accepted_by
works perfectly, i didn't know you could use multiple columns in the
group by. thanks a bunch!
Michael Dykman wrote:
try this:
select accepted_by, problem_type, count(*) from form
where problem_type is not NULL
AND problem_type != 'Test'
AND accepted_by is not null
group by accepted_by, probl
only SELECT privileges to a specific table for a specific user.
--
Adam Alkins || http://www.rasadam.com
On 16 June 2010 14:17, Don Cohen wrote:
>
> This seems like a topic that must have been studied, but I'm having
> trouble figuring out what to search for in Google, since the
.
--
Adam Alkins || http://www.rasadam.com
On 14 June 2010 16:02, MadTh wrote:
> Hi,
>
>
> I ran a update command on around 2700 rows inside a mysql database table
> which has around 3000 table rows to change the ( say) price of each item (
> with unique ID. unique product code).
&
in the PHP script itself (which would be rather weak
security imho).
--
Adam Alkins || http://www.rasadam.com
On 16 June 2010 14:48, Don Cohen wrote:
> Adam Alkins writes:
> > Sounds like you just want to GRANT access to specific tables (and with
> > limited commands), which is ex
RA | 65 |
+++
| RP |2 |
+++
etc
Could this be done in MySQL? I want to do something along the lines of set
class2 = SUBSTRING_INDEX(class,'[A-Z]',-1) but I understand this is not
possible.
Any ideas?
Regards
Adam
--
MySQL General Mailin
Dear:
I would like to share with you my recently shopping experience: I
found a very excellent e-site, the above is the latest and most
popular products. By their staff, understanding that they have stable
supply channel, so the price of products is shock your eyeballs burst.
Certainly I will not m
I accidentally drop the database mysql. I now cannot restore tables to the
database or do much of anything some details can be found here
http://serverfault.com/questions/234321/i-accidently-dropped-the-mysql-db/234340#234340
after a few unsuccessful uninstalled/reinstalls i wrote whereis mysql an
73 Sep 4 18:38 master.info
but the date is:
[root@tungsten /var/db/mysql]# date
Sun Sep 4 19:11:13 CEST 2011
And it's delayed 1 hour. No data is transferred to the slave. It says:
Secords behind master 0.
What the hell is going on here?
--
Adam PAPAI
Grapes Communication
eft the
old ones there).
Thanks again.
--
Adam PAPAI
Grapes Communication Kft.
http://www.grapes.hu
E-mail: papai.a...@grapes.hu
Phone: +36 30 33-55-735 (Hungary)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
n;
while v_counter <= v_max do
SET TABLENAME = CONCAT('wp_',v_counter, '_options');
INSERT INTO TABLENAME VALUES ('309', '0', 'statpress_mincap',
'edit_posts', 'yes');
set v_counter=v_counter+1;
end while;
commit
aph', '31', 'yes'), ('310', '0',
'statpress_donotcollectspider', 'checked', 'yes'), ('311', '0',
'statpress_autodelete_spider', '1 day', 'yes'), ('312', '0'
ittle project. github forks are of course welcome too ;-)
Cheers,
Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I'm involved with a project that is migrating data from sql server to
mysql. The project will take up to a year to complete. During that
period of time, we will need to synchronize data from sql server to
mysql as we migrate windows based functionality to linux based servers.
What is the rec
id=123;
> This probably will (if foo is not indexed):
> SELECT myblob FROM mytable ORDER BY foo;
>
> > -Original Message-
> > From: Adam Ilardi [mailto:mastaskill...@gmail.com]
> > Sent: Wednesday, March 13, 2013 9:16 AM
> > To: mysql
> > Subject: Blob
d locate( '.', name ) > 0,
replace( replace( substr( name, locate( ' ', name ) + 1 ), '(',
'' ), ')', '' ),
if(
locate( '.', name ) = 0,
name,
2.7.0 |
+---+-+
20 rows in set (0.00 sec)
Adam.
On Oct 12, 2007, at 3:56 PM, Adam Randall wrote:
Here's my full test solution:
use test;
drop table if exists releases;
create temporary table releases
(
releaseid int(10) unsigned not null auto_increment primary key,
name varchar(25
Folks
How can one conditionally drop an index in MySQL?
Googling shows that the "drop index" does not support an "if exists" qualifier - apparently a bug
has been raised but as far as I know its not fixed yet.
Does anyone know of a work-around?
TIA - Adam
--
MySQL
Fantastic, thanks very much!
Adam
Rob Wultsch wrote:
On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote:
Folks
How can one conditionally drop an index in MySQL?
Googling shows that the "drop index" does not support an "if exists" qualifier
-
.
ALTER IGNORE TABLE table_name DROP INDEX index_name;
ALTER IGNORE TABLE table_name ADD INDEX UNIQUE index_name(column_1,column_2);
Thanks - Ada
Rob Wultsch wrote:
On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote:
Folks
How can one conditionally drop an index in
I set up a user and entered % for the host. I am not able to connect.
However, if I change the host value to my FQDN it works fine. Shouldn't
the wildcard allow me to connect from any host?
Thanks,
Adam
--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administ
Yes, I did "FLUSH PRIVILEGES" and I think I only have one username/host
entry for this user.
Adam
Erik Giberti wrote:
Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwor
Hello,
When I run a DELETE FROM table_name, my primary key field is reset
back to 1. Is there any way for it to not do this? Preferably, if
there were 1000 records in table_name, and I ran DELETE FROM
table_name, that the primary key field would start at 1001.
This is an InnoDB table if
Thanks for the reply but that didn't do it.
I believe I've got this to work by performing the following steps:
DELETE FROM table_name (1000 rows)
INSERT INTO table_name(column) VALUES(value)
DELETE FROM table_name
Now when I perform another INSERT, the primary key starts at 1001.
A
1 - 100 of 486 matches
Mail list logo
