Re: Mystery error in GRANT statement

> Date: Monday, October 03, 2016 23:18:14 -0700 > From: James Moe <ji...@sohnen-moe.com> > > 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 work

Re: Mystery error in GRANT statement

> 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

Re: dump then truncate - in between anything?

> 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 &&

When to create a new database

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

How to get auto Increment ID of INSERT?

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

Relational query question

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 | |

Re: Trouble with LEFT JOIN

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 <peter.braw...@earthlink.net>: > On 2015-09-04 11:39 AM, Richard Reina wrote: > > > 2015-09-04 11:18 GMT-05:00 Peter B

ENUM() vs TINYINT

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

Trouble with LEFT JOIN

I have the following two tables; mysql> select * from challenge; +++-++--+-+--+ | ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID | +++-++--+-+--+ | 1 | 1 |

Re: Trouble with LEFT JOIN

2015-09-04 11:18 GMT-05:00 Peter Brawley <peter.braw...@earthlink.net>: > On 2015-09-04 9:40 AM, Richard Reina wrote: > >> I have the following two tables; >> >> mysql> select * from challenge; >> +++-++--+---

When to create a new user?

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

table desin question

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 -- user

Re: table design question

Message From: Richard Reina gatorre...@gmail.com Reply-To: Richard Reina gatorre...@gmail.com Date: 07/29/15 10:19 AM To: mysql@lists.mysql.com mysql@lists.mysql.com Cc: Sub: table design question If I were to create a database table(s) to tract most common repairs to different appliances I

table design question

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

Specking a small MySQL server

reliable. Thanks for any ideas or insights. Richard

Re: replication question replacing the master

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, 2014

replication question replacing the master

or easier way? Thanks for you attention. Richard

Re: Chain Replication QUestion

To activate log-slave-updates do I just add log-slave-updates to the my.cnf file? 2013/4/30, Manuel Arostegui man...@tuenti.com: 2013/4/30 Richard Reina gatorre...@gmail.com I have a few slaves set up on my local network that get updates from my main mysql database master. I was hoping

Re: Chain Replication QUestion

. Thanks for the help thus far. 2013/4/30, Manuel Arostegui man...@tuenti.com: 2013/4/30 Richard Reina gatorre...@gmail.com 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

Re: Query Help

Perfect! Thank you Larry et all. Have a great weekend. 2013/4/19 Larry Martell larry.mart...@gmail.com On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina gatorre...@gmail.com wrote: Hello All, Happy Friday! I know how to do the following query: select count(*) from sales where WEEK

Query Help

| 31 3 | 29 etc... Thanks, Richard

Determing number of queries

it's workload? Thanks Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Please Help. selectcol_arrayref problem

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_arrayref('show

Re: Please Help. selectcol_arrayref problem

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 larry.mart...@gmail.com On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina gatorre...@gmail.com

query help

is, 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

Replication question: How to make a slave a master?

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

Strange Replication Behavior

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

query problem with null

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

Re: query problem with null

- From: Richard Reina [mailto:gatorre...@gmail.com] Sent: Friday, March 09, 2012 4:24 PM To: mysql@lists.mysql.com Subject: query problem with null When I do the following query: SELECT * FROM geo_trivia WHERE city IS NULL; certain columns that DO have 'NULL' value for city

query question

to write code that will select a query? Thanks you, Richard Reina

table design question

, Richard

Re: table design question

Thank you very much for all the insightful advice. I will keep the separated. 2011/9/19 Jerry Schwartz je...@gii.co.jp -Original Message- From: Richard Reina [mailto:gatorre...@gmail.com] Sent: Monday, September 19, 2011 9:55 AM To: mysql@lists.mysql.com Subject: table design

Re: Using @ variables with LIKE,CONCAT

(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

Re: function to limit value of integer

, Richard 2011/2/10 Travis Ard travis_...@hotmail.com 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. -Travis -Original

function to limit value of integer

+ no_of_jobs AS EXPERIENCE Thanks, Richard

Help with ORDER BY

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

Re: [PHP] Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

On 20 January 2011 19:20, Dotan Cohen dotanco...@gmail.com wrote: On Thu, Jan 20, 2011 at 19:21, Richard Quadling rquadl...@gmail.com 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 adjacent list

Re: [PHP] Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

using a nested set approach for the tags (http://dev.mysql.com/tech-resources/articles/hierarchical-data.html gives a good explanation on the issues and methodology of nested sets). -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- MySQL General Mailing

Re: [PHP] Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

On 20 January 2011 16:20, Dotan Cohen dotanco...@gmail.com wrote: On Thu, Jan 20, 2011 at 17:00, Richard Quadling rquadl...@gmail.com 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 first

replication question

-- 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

Problems storing a blob using php.

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

Re: query help

Thank you very much for all the insightful replies. I think I can get it to work with a join. Joerg Bruehe joerg.bru...@sun.com wrote: Hi! Jay Blanchard wrote: [snip] I have a table similar to this: - |transactions | |ID |DATE

query help

not 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

redirecting query output?

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

query help

|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

Re: [PHP] Instll php on Window 2003 64Bit questions

mod_rewrite, which I believe you'd have to pay for on an IIS server. Thanks, Ash http://www.ashleysheridan.co.uk IIS7 has a URLRewrite module which is freely available via the Web Platform Installer or via http://learn.iis.net/page.aspx/460/using-url-rewrite-module -- - Richard

Query help

' 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? Thanks, Richard -- MySQL General

Cant get TRIM to work?

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 archives

MySQL General Discussion question

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,

column exists but unknown

', 'Rich', 'Text in List') latin1_swedish_ci No Text as you can see campaign_id clearly exists in the table Is my table corrupt? Any ideas? Thank you for your help. Richard -- Richard Whitney phpmy...@gmail.com http://phpmydev.com Ofc. 602-288-5340 Ofc. 877-624-6302 Fax. 480-704-4559 You come up

Re: column exists but unknown

Nevermind, the problem was not with the DB :\ On Tue, Mar 3, 2009 at 10:44 AM, Richard Whitney phpmy...@gmail.com 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' ) AS '', CONCAT( 'Edit Status

Re: [PHP] Because you guys/gals/girls/women/insert pc term here are a smart lot

, 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 FF, Chrome, Opera and Safari: http

Re: Stopping DNS Lookups

(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 immediately. On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods [EMAIL PROTECTED

Re: Stopping DNS Lookups

' - '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 if localhost is mapped elsewhere? Martin

Stopping DNS Lookups

. Thanks in advance, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stopping DNS Lookups

[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: Richard S

Re: Stopping DNS Lookups

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: Recently I

Re: Data files from 4.1.13 with 5.0.x

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 unsubscribe

Data files from 4.1.13 with 5.0.x

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]

Table aliasing

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

Re: Table aliasing

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]

Re: Table aliasing

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]

Re: select count(). Help-a-newb

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

Help with ORDER BY using two colomns

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

Re: Help with ORDER BY using two colomns

, 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 change the update value. So the update colomn does not contain a value until

Re: Help with ORDER BY using two colomns

.). 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, Richard [EMAIL PROTECTED

Re: Help with ORDER BY using two colomns [ solved thankyou :) ]

| 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, however I would

Re: Help with ORDER BY using two colomns [ solved thankyou :) ]

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

Re: Help with ORDER BY using two colomns [ solved thankyou :) ]

to 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 stored

Re: Help with db design

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. -- Richard Jones

Help with a complex data model

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]

Help with db design

. 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]

Re: Migrate HUGE Database

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 -- Richard Heyes

Re: [PHP] Importing and exporting from MySQL, escape slash problem

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

Re: group a select * and a select COUNT from 2 different [... ] (solved thankyou !)

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 FROM

group a select * and a select COUNT from 2 different tables using result of first table to do the COUNT ... is it possible ?

.(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 login. Thanks in advance, Richard

Re: group a select * and a select COUNT from 2 different tables using result of first table to do the COUNT ... is it possible ?

(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 ... SELECT a.username, a.first_name

Re: group a select * and a select COUNT from 2 different tables using result of first table to do the COUNT ... is it possible ?

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.(SELECT COUNT

Re: Backup table structure, not data

, 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 - no installation

insert new records from other tables

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 -

Re: insert new records from other tables [ solved, thankyou :) ]

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.last_name

Re: select unique ? (solved thankyou :))

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've got

select unique ?

: 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]

Re: memory usage - mysql tuning!!

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

Re: Looking for a more efficient way to achieve the same result

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 : date of first

Re: Looking for a more efficient way to achieve the same result - Found solution but would still like some advice :)

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 : Subscribed

Looking for a more efficient way to achieve the same result.

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

Re: failed queries

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 ACCOUNTS TO CHARITIES

Bigint

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

Re: Bigint

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 ACCOUNTS

Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject

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

Re: Help with query, (question simplified as last mail was very complicated to understand :))

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 messageid

help with a query...

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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help with query, (question simplified as last mail was very complicated to understand :))

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]

Re: Determining Table Storage Engine Type on Crashed Table

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, Hopefully some of you are already

Re: Determining Table Storage Engine Type on Crashed Table

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 everybody, Hopefully some of you are already

Re: Determining Table Storage Engine Type on Crashed Table

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: Hey everybody, Hopefully some of you are already enjoying time off. I am

Determining Table Storage Engine Type on Crashed Table

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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: innodb mysql crash

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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Richard Edward Horner Engineer

Re: mysql connection problems

. Download your gamecard now at Yahoo!7 TV. http://au.blogs.yahoo.com/national-bingo-night/ -- 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

  1   2   3   4   5   6   7   8   >