> Date: Monday, October 03, 2016 23:18:14 -0700
> From: James Moe
>
> On 10/03/2016 08:16 PM, Richard wrote:
>> If you want/need to use it I believe you need to use the
>> "backtick" to quote the name
>>
> Yes, that worked. Thank you.
> Is the
> Date: Monday, October 03, 2016 18:39:22 -0700
> From: James Moe
>
> opensuse v42.1
> linux 4.1.31-30-default x86_64
> 10.0.26-MariaDB
>
> I have a database named "sma-v4-01". The GRANT statement does not
> like that database name:
>
> MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO
> 'xxx
> Date: Wednesday, March 09, 2016 14:38:45 +
> From: lejeczek
>
> hi everybody
>
> I imagine this is theoretical rather than practical question,
> albeit I don't have much practice, so I hope experts could comment
> logical view of the procedure is: mysqldump && truncate - what are
> the ch
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
database called "library" since they are used for referen
If I insert a record into a table with an auto increment ID how can I get
that records ID value? I have read about SELECT LAST_INSERT_ID() statement,
however, do not two statements introduce the risk that another insert may
occur in the interum? Is there a full proof way of getting the ID of the
re
If I have three simple tables:
mysql> select * from customer;
+++
| ID | NAME |
+++
| 1 | Joey |
| 2 | Mike |
| 3 | Kellie |
+++
3 rows in set (0.00 sec)
mysql> select * from fruit;
++-+
| ID | NAME|
++-+
| 1 | Apples |
|
enges that have
are linked to p.PTRN_ID=1. So p.PTRN_ID!=1. Thanks nonetheless for trying.
This may be unsolvable.
2015-09-04 12:30 GMT-05:00 Peter Brawley :
> On 2015-09-04 11:39 AM, Richard Reina wrote:
>
>
> 2015-09-04 11:18 GMT-05:00 Peter Brawley :
>
>> On 2015-09-
I have a column name quarter which I need to have 5 possible inputs; 1, 2,
3, 4, or OT. Because of the OT possibility I am leaning towards ENUM.
Hence, I am also thus considering ENUM('first', 'second', 'third',
'fourth', 'overtime') as the input will primarily be used in written
descriptions. Is t
2015-09-04 11:18 GMT-05:00 Peter Brawley :
> On 2015-09-04 9:40 AM, Richard Reina wrote:
>
>> I have the following two tables;
>>
>> mysql> select * from challenge;
>> +++-++--+-+--+
>> | ID | PLR_ID
I have the following two tables;
mysql> select * from challenge;
+++-++--+-+--+
| ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID |
+++-++--+-+--+
| 1 | 1 |
I am writing a web application in perl that will create, edit, update and
delete data from a MySQL database. I have written a perl module that will
manage the connections (issue database handles ). As new users sign up for
the application should each get their own MySQL username and password or is
I am ceating a database application with two different types of users,
clients and technicians. Both types of users have to create and account in
which they become "users". From there they can become clients or
technicians or perhaps even both. Since each type describe different
attributes -- use
ls.
>
> PB
>
> Original Message ----
> From: "Richard Reina"
> Reply-To: "Richard Reina"
> Date: 07/29/15 10:19 AM
> To: "mysql@lists.mysql.com"
> Cc:
> Sub: table design question
> If I were to create a database table(s) to tract most
If I were to create a database table(s) to tract most common repairs to
different appliances I can't decide if it would be better to create one
table with a long ENUM column that contains repairs that could be
attributed to any appliance or different repair tables for each appliance.
All the tables
reliable.
Thanks for any ideas or insights.
Richard
Manuel,
Thank you very much for this information. This sounds like a very good
strategy. I think I will try switching some slaves from one relay to another to
familiarize myself and get practice and them do it to deploy a new master.
Again, thank you very much.
Richard
> El Jan 18, 2
ere a better or easier way?
Thanks for you attention.
Richard
To activate log-slave-updates do I just add "log-slave-updates" to the
my.cnf file?
2013/4/30, Manuel Arostegui :
> 2013/4/30 Richard Reina
>
>> I have a few slaves set up on my local network that get updates from
>> my main mysql database master. I was hopi
ster1.
Thanks for the help thus far.
2013/4/30, Manuel Arostegui :
> 2013/4/30 Richard Reina
>
>> I have a few slaves set up on my local network that get updates from
>> my main mysql database master. I was hoping to turn one into a master
>> while keeping it a slave so tha
2
2 | 31
3 | 29
etc...
Thanks,
Richard
Perfect! Thank you Larry et all.
Have a great weekend.
2013/4/19 Larry Martell
> On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina
> wrote:
> > Hello All,
> >
> > Happy Friday! I know how to do the following query:
> >
> >>select count(*) from sale
it's workload?
Thanks
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
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 Rei
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
, so that I get
something like this:
F_LEADS S_LEADS R_LEADS
44 122 32
Is this possible? If so can anyone help with syntax?
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I have a couple of mysql database slaves and would like to make one of them
be a master as well so that I can set another machine to replicate from it.
Can anyone tell me how I should go about it or know of any howtos for this
specific task?
Thanks,
Richard
replicating from it so I cannot understand how this is
possible. When I do the query > show master status
I get mysql_master_log.000123 | 755522343
Anyone have any idea as to what could be wrong?
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Ahhh... Thank you, that was exactly what the problem was. I will fix the
code that is setting the value of these new records to 'NULL'.
Thank you.
2012/3/9 David Lerer
> Have you tried to set city = null (i.e. without the quotes)? David.
>
>
>
> -Original Mes
When I do the following query:
SELECT * FROM geo_trivia WHERE city IS NULL;
certain columns that DO have 'NULL' value for city and not a '' (blank)
value do not show up.
I have even gone to the extent of reseting these records value as ='NULL'
with UPDATE and they are still are not selected when
will get picked
60% of the time. Is this possible in a query or do I need to write code
that will select a query?
Thanks you,
Richard Reina
Thank you very much for all the insightful advice. I will keep the
separated.
2011/9/19 Jerry Schwartz
> >-Original Message-
> >From: Richard Reina [mailto:gatorre...@gmail.com]
> >Sent: Monday, September 19, 2011 9:55 AM
> >To: mysql@lists.mysql.com
> >
e?
Thanks,
Richard
his:
>
> select * from table where field like '%needle%';
>
> it works perfectly (and as it did in 4.x).
>
> How can I get this to work in 5.5.x?
>
> Thanks,
>
> -Hank
>
--
*Richard Bensley*
*Database Administrator*
*
*
richard.bens...@photobox.com
skype: richardbensley
Mobile: 07540878285
again,
Richard
2011/2/10 Travis Ard
> Maybe some sort of logarithmic expression?
>
> select no_of_jobs, 10 * log(10, no_of_jobs) as job_weight
> from data;
>
> Of course, you'd have to tweak your coefficients to match the weighting
> system you want to use.
>
&
?
SELECT years_srvd + no_of_jobs AS EXPERIENCE
Thanks,
Richard
ty and the
number of projects done trumps distance from the project, but in the
beginning I am willing to set that somewhat arbitrary and adjust it later.
I realize that this may be beyond the scope of a MySQL query. If so I am
grateful for any ideas on where to go for info/help.
Thanks,
Richard
On 20 January 2011 19:20, Dotan Cohen wrote:
> On Thu, Jan 20, 2011 at 19:21, Richard Quadling wrote:
>>> That is terrific, at least the first half. The second half, with the
>>> Venn diagrams, is awkward!
>>
>> When you get heavily nested data, the adjacen
On 20 January 2011 16:20, Dotan Cohen wrote:
> On Thu, Jan 20, 2011 at 17:00, Richard Quadling wrote:
>> I'd have my items table, my tags table and a join table for the two.
>> My join table is really simple. UniqueID, ItemID, TagID.
>>
>
> Yes, that is the fir
t; Thanks!
>
> --
> Dotan Cohen
>
> http://gibberish.co.il
> http://what-is-what.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
I'd have my items table, my tags table and a join tabl
--
Richard Reina
Rush Logistics, Inc.
Watch our 3 minute movie:
http://www.rushlogistics.com/movie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Debian squeeze, mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu
(i486) using readline 6.1, PHP 5.3.3-2 with Suhosin-Patch (cli) (built:
Oct 21 2010 18:58:27).
I'm not sure if this group or the php one is more appropriate but
thought I would try here first as it is perhaps a mysql setting I
Thank you very much for all the insightful replies. I think I can get it to
work with a join.
Joerg Bruehe wrote:
>
> Hi!
>
>
> Jay Blanchard wrote:
> > [snip]
> > I have a table similar to this:
> >
> > -
> > |transactions |
> > |ID |DATE |
have a transaction?
Thanks for the help.
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
oes not appear as standard
output? Or is it a bad idea to do so and should I being doing a different sort
ow query altogether?
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
|498.00 |
34 |3502|767.00 |
36 |3504}754.00 |
Any help would be greatly appreciated.
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Rewrite module which is freely available via the Web
Platform Installer or via
http://learn.iis.net/page.aspx/460/using-url-rewrite-module
--
-
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer :
x27;o' GROUP BY
trans_no;
gives me a count of 3.
However, what I need is a count for how many different (unique) transactions
company number 675 got a result 'o' which would be 2 (455 & 302). I have tried
different group by columns but to no avail. Can someone help?
Th
Hello All,
I can't get trim to trim the blank space from a TEXT field in the query below
and was wondering if someone could tell what I am doing wrong?
SELECT TRIM(notes) FROM work_notes;
Thanks for any help as I am at a complete loss.
Richard
--
MySQL General Mailing List
For list arc
Sorting a varchar field alphabetically with correct numerical order help
needed
I have a varchar 50 field that contains product names, which are typically
numerical, alphabetical and punctuation thrown in. I would like to have them
returned in some sort of order that is roughly alphabetical, b
Nevermind, the problem was not with the DB :\
On Tue, Mar 3, 2009 at 10:44 AM, Richard Whitney wrote:
> Hello.
>
> I am running MySQL 5.0.45
> and have the following query and error:
>
> SQL query:
>
> SELECT SQL_CALC_FOUND_ROWS CONCAT( 'Edit Space' ) A
on Attributes Null Default Extra Action
space_id int(10) UNSIGNED No auto_increment
scheme_id int(10) UNSIGNED No 0
campaign_id int(10) UNSIGNED No 0
type enum('Text', 'Banner', 'Rich', 'Text in List') latin1_swedish_ci No Text
as you can see campaign_id cl
ctual length, lots of rows, or both, then varchar
> columns may be faster.
I still think a CHAR field would be faster than a VARCHAR because of
the fixed row length (assuming every thing else is fixed). Perhaps
someone from the MySQL list could clarify...?
--
Richard Heyes
HTML5 Graphing for
and 'user' - 'localhost' alone did not work. I did not test whether or
not 'localhost' would work on a Unix server as this was not something I
required. Would be a good test, though.
Cheers,
-Richard
Martin Gainty wrote:
Richard-
That should work..curious i
he local server.
Remote access via static IP (assuming those entries were already in 'db'
and 'user') work fine, but 'localhost' no longer works after the reboot.
Cheers,
-Richard
Moon's Father wrote:
Add skip-name-reslove in my.cnf and restart mysql immedi
Awesome! Thanks very much - exactly what I was looking for. I'm in the
field and was under the gun, otherwise would have checked the manuals first.
Again, thanks.
-Richard
Hassan Schroeder wrote:
On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods
<[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
Point to an internal dns server
We don't have one.
Is somebody with a weird hostname connecting to your server via ssh ?
Nope. This is occurring while the server's intranet is totally unmanned.
-Richard
--Original Message------
From:
4), 64 bit.
Thanks in advance,
-Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Would data files from 4.1.13 work with 5.0.x or will I have to use an SQL
> dump?
Well, not to worry, I managed to start 4.1.13 and got an SQL dump. Cheers.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
Hi,
Would data files from 4.1.13 work with 5.0.x or will I have to use an SQL dump?
Thanks.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I think what you want is "CREATE VIEW test.v AS SELECT * FROM t;"
That will do the job, thank you.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No, the net effact would be that the table would have two names.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Is there a way in MySQL to define an alias for a table, so in effect
it has two names? For migration purposes.
Thanks.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi I think you would do this :
SELECT
sf_conferences.id,
sf_conferences.name,
count(*) AS `count`
FROM
((
LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk)
LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
GROU
differentiate between rows that are new vs rows that
are updated, (date = update) => new. You can put an index on this field
and not have the performance issue to worry about.
Just a thought.
andy
Richard wrote:
Thanks,
This is for the unanswered list of questions, so the output list (not
the list sto
to have a limited number of results on one page.
Every time a question is answered the update date will change, and the
status could also change. So I don't see how to easily do this by
creating another table.
Ben Clewett a écrit :
Richard,
No problem, glad it works. But note: this i
0 | 90 | 100 |
| 2 | 10 | 60 | 70 |
| 6 | 50 || 50 |
| 4 | 30 || 30 |
| 3 | 20 || 20 |
| 1 |1 ||1 |
+-+--++--+
Richard wrote:
Thanks,
I think that your solution will be sufficient for my needs, howeve
ocess.). I hope my explanation in understadable ...
:)
Rafael Barbolo Lopes a écrit :
Can't you do Something like:
ORDER BY (update,date)
The major column of ordering would be update and the second date.
I'm not sure about this "solution"
On Tue, Apr 8, 2008 at 8:54 AM,
eated end desc;
/Kristian
On Tue, Apr 8, 2008 at 1:04 PM, Richard <[EMAIL PROTECTED]> wrote:
Hello,
I've got a table which containes two date colomns.
The first one is called `date` and the second `update`
In the first one I put the ticket creation date, and on update I add or
ch
Hello,
I've got a table which containes two date colomns.
The first one is called `date` and the second `update`
In the first one I put the ticket creation date, and on update I add or
change the update value.
So the update colomn does not contain a value until the first update has
been done.
I
number, patient and request, but I would
be most grateful for any assistance in optimising the data model so that
it returns the correct information.
--
Richard Jones
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Baron Schwartz wrote:
Hi,
This is a fine place to ask such questions.
(In general you can just ask first, and people will tell you if you're
off-topic).
OK, thanks - I've posted the details to a new subject earlier today but
it doesn't seem to have showed up yet.
-
. It is of course not a MySQL-specific question, and
would be applicable to any relational db. Thanks.
--
Richard Jones
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How very inconsistent and obnoxious.
But yet far more secure. FWIW, if you're transferring between machines
you can gzip the output of mysqldump to compress it, resulting in far
less transfer time.
Eg.
mysqldump -u username -p database_name | gzip -c > dump.sql.gz
IIRC
--
Richa
It's possible that there is an .htaccess file in phpMyAdmin that has
Magic Quotes on that is messing you up...
Other than that, it's specific to phpMyAdmin, so maybe ask those guys
what they did...
On Sat, March 1, 2008 7:38 pm, Dave M G wrote:
> PHP List, MySQL List
>
> In my PHP environment, I
also suggested a LEFT OUTER JOIN but have read that it is a
synonym to LEFT JOIN, is this the case or is there a difference between
the two?
Thanks again,
Richard
David Schneider-Joseph a écrit :
Try this one:
SELECT a.username, a.first_name, a.last_name,COALESCE(COUNT(b.username),
0) AS count
Sorry it's me again, I made a mistake, it counts the number of logins
correctly, but does not show members with 0 logins !
Any idea how to do this?
Thanks :)
Peter Brawley a écrit :
Richard,
>Can I do something like this :
>SELECT a.username, a.first_name, a.last_name,b.(S
once the result is 1 (because of the group by ...).
Thankyou
Peter Brawley a écrit :
Richard,
>Can I do something like this :
>SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS count
>FROM login_table b WHERE a.username = b.username) FROM user_list a
Try ...
SE
first_name, a.last_name,b.(SELECT COUNT(*) AS count
FROM login_table b WHERE a.username = b.username) FROM user_list a
I know that the above query can not work but It's just to give a better
idea about what I'm trying to do . :)
If I do a join, I will the username repeated for each
, might take some time) - but there's gotta be an easier way to do
it...
mysqldump has a --no-data option. Try "man mysqldump" (assuming your
MySQL server is Unix based.
--
Richard Heyes
http://www.websupportsolutions.co.uk
Knowledge Base and Helpdesk software hosted for you -
Thanks it works great ! :)
Dan Buettner wrote :
Richard, it's possible, & your syntax is pretty close.
Try this:
INSERT INTO info_stamp
(fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date)
SELECT $fav_colour, $hobby, $time, a.firstname, a.
Hello,
I need to insert one entry(one line) containing 10 values, some from a
form(ok) but some from two other tables, what is the best way to do this ?
Say for example I need to enter this information :
first_name - last_name - age - sexe - username - email - favorite_colour
- hobby - inscr
To: Richard
Cc: mysql@lists.mysql.com
Subject: Re: select unique ?
Try:
SELECT DISTINCT Colour FROM table;
Or, if you want to do it correctly:
SELECT Colour FROM table GROUP BY color;
Richard wrote:
Hello,
I don't know if it is possible to do this with mysql alone ...
Here goes :
I
don't want :
Colour
Red
Blue
Green
Red
Red
Blue
How would I achieve the first result with mysql ? Is it possible?
Thanks in advance,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bruce a écrit :
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the b
Richard a écrit :
Richard a écrit :
Hello, I'm in the process of programming a customer area with a list
of subscriptions :
Reference | Title | Type | Date of first subscription | Expires
Each item in this list will have a link to it's details with will
show a list like this :
Richard a écrit :
Hello, I'm in the process of programming a customer area with a list
of subscriptions :
Reference | Title | Type | Date of first subscription | Expires
Each item in this list will have a link to it's details with will show
a list like this :
Subscribed on : dat
Hello, I'm in the process of programming a customer area with a list of
subscriptions :
Reference | Title | Type | Date of first subscription | Expires
Each item in this list will have a link to it's details with will show a
list like this :
Subscribed on : date of first subscription
Renewed
ce just to catch
> that occasional failed update.
Use your abstraction layer to log queries that pass through it.
--
Richard Heyes
http://www.websupportsolutions.co.uk
Knowledge Base and Helpdesk software that eases your support
burden and helps increase your sales.
** NOW OFFERING FREE ACCOUN
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON
I think it's the same.
I seem to remember that a BIGINT id two INTs tacked together, so how is
that possible?
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUN
Performance wise, what is a BIGINT like in comparison to an INT on a 32
bit machine?
Thanks.
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON
Richard a écrit :
Sorry about my last email which was long and not clear.
This is what I want to do
Join two tables on "code table1" = "code table3" where messageid = for
example 28
table 1 contains :
message from
ame
---
message1 | name3
message2 | name3
message3 | name3
Of course I have simplified everything down to the minimum :)
Thanks in advance,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
why I would need to be able to combine : "SELECT
a.message,a.date,b.surname,b.name,b.title FROM messages a JOIN info b ON
a.from=b.code WHERE a.id='28'"
and "ORDER BYnum DESC LIMIT 1"
I hope I've been clear enough ... thanks in advance :)
Richard
FYI, this did not work :)
Thanks though!
Rich(ard)
On Nov 23, 2007 3:37 AM, Paul McCullagh <[EMAIL PROTECTED]> wrote:
> Maybe this will work:
>
> SHOW CREATE TABLE table_name;
>
>
> On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote:
>
> > Hey everybody,
Good call, Paul. I'll try it out!
Thanks, Rich(ard)
On Nov 23, 2007 3:37 AM, Paul McCullagh <[EMAIL PROTECTED]> wrote:
> Maybe this will work:
>
> SHOW CREATE TABLE table_name;
>
>
> On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote:
>
> > Hey everyb
all or is there more that you know that I don't?
Thanks, Rich(ard)
On Nov 22, 2007 12:43 PM, Micah Stevens <[EMAIL PROTECTED]> wrote:
> Look at the data files. The extension of the file will tell you.
>
>
>
> On 11/21/2007 12:42 PM, Richard Edward Horner wrote:
> >
me? Or I guess a broader more helpful question would
be, "What are all the ways to determine a table's storage engine
type?"
Thanks,
--
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th
--
MySQL General Mail
;
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Richard Edward Horner
Engineer / Composer / Electric Guitar Virtuoso
[EMAIL PROTECTED]
http://richhorner.com - updated June 28th
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
h thousands of tables! So there is no fast dump and
> insert of tables.
>
> Any ideas (besides from dumping everything and importing at then)?
>
> Regards
> Marten
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
1 - 100 of 836 matches
Mail list logo