Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 1 of 128

101

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
DELETE from table1, table2 WHERE id=12345 I have two tables that I join together for SELECT queries. One lists 3 columns (id, type, and expiration) where 'id' and 'type' are UNIQUE, then the... Jason C	02-02-2012 04:44 AM Brian Cryer	2	8
create table from describe table? Can a table be created using data from the DESCRIBE TABLE command? SpreadTooThin	02-01-2012 05:32 PM Denis McMahon	2	4
From table to table.... I want to create a new table containing only the results from a select statement of another table. How is that done? select a, b, c into destTable... SpreadTooThin	02-01-2012 03:50 PM Peter H. Coffin	1	3
insert results of select from one table into another table. I want to create a new table containing only the results from a select statement of another table. How is that done? select a, b, c into destTable... SpreadTooThin	02-01-2012 01:54 PM Hans Castorp	3	4
A Question about DISTINCT. Assuming you have a table like: X Y Z ------- A, B, C A, B, C A, A, C A, A, A A, A, A SpreadTooThin	02-01-2012 11:04 AM Denis McMahon	3	4
My MySQL DB is unable to process 4+ requests at a time! Hi, Yesterday I was in the process of convincing one of my clients to use MySQL than SQL Server. I had a long fight with the technical team there... mahesh	02-01-2012 09:45 AM The Natural Philosopher	6	7
about DISTINCT I have a select statement that needs some refinement. select PatientName, PatientID, PatientDOB from MyTable; now this works but there is a row... SpreadTooThin	01-31-2012 09:20 PM Gordon Burditt	8	9
Speed of LEFT JOIN This is my first time delving in to the use of JOIN, so please bear with me if this is a stupid question. I'm splitting a table into two tables... Jason C	01-30-2012 09:16 PM Jason C	2	3
Error 1436 - Thread Stack Overflow I am getting the following error when trying to run any stored procedure: ERROR 1436 (HY000): Thread stack overrun: 11456 bytes used of a... William Colls	01-30-2012 05:52 PM Thomas 'PointedEars' Lahn	4	5
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 23 Jan... me	01-23-2012 03:15 AM me	0	2
Did handling of NULL in LOAD DATA LOCAL change recently? I'm bringing up a new server which runs CentOS 6 with MySQL 5.1.52. Something seems to have changed between that version and "5.1.47community"... John Nagle	01-23-2012 01:48 AM John Nagle	7	8
mysql - can't connect through apache ( 1 2 ) Hi, I have a LAMP installation. I can properly access my db from the shell but am not able to get in via apache, with phpmyadmin or Joomla e.g. Any... cerr	01-19-2012 02:09 PM Luuk	16	17
Intermediate values in insert statement ( 1 2 ) Is there a way inside an insert select statement to re-use an intermediate value that is required in the computation of several columns? Or mus it be... Dvd Avins	01-19-2012 08:02 AM Captain Paralytic	12	13
data concatenation I have a table of IP addresses, names associated with them, and the total times they visit a site and when they last did. Due to concurrency issues,... The Natural Philosopher	01-18-2012 04:04 PM Luuk	3	4
how to distribute database from servers to remote another servers. hello, everyone! I need your helps to distribute my current database to another remote servers. let me figure out the situation I have. I have 2... Jun Young Kim	01-17-2012 11:00 AM Captain Paralytic	1	2
Replication - Can't connect to replication server Master machine running Kubuntu 10.04, MySQL 5.1.41 Replication machine running Kubuntu 10.04, MySQL 5.1.41 Learning replication. Attempting to set... William Colls	01-16-2012 10:17 AM Captain Paralytic	6	7
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 16 Jan... me	01-16-2012 03:17 AM me	0	1
Mobile Business Intelligence whitepaper Global Business Intelligence (BI) software vendor, Yellowfin, has released a new white paper that explores the need for, drivers and potential... janette.pelletier@yahoo.com.au	01-11-2012 07:35 AM janette.pelletier@yahoo.com.au	0	1
Re: mysql upgrade kills a working web page On 1/8/2012 9:05 PM, horus wrote: Please don't post all that code. No one here is going to spend time looking though it. We're all volunteers,... Jerry Stuckle	01-09-2012 10:36 AM horus	3	4
Error importing MySQLdb I have been trying for awhile now to get MySQLdb working. I am currently getting this error: Starting python: Traceback (most recent call last):... David George	01-08-2012 07:14 PM Denis McMahon	1	2
mysql_query("update... simple question ( 1 2 ) I thought there was a way to do an update in the same style format as an insert, meaning: $result = mysql_query("UPDATE MyTables (Username,... Michael Joel	01-06-2012 03:32 PM Michael Joel	12	13
Is this insert even possible Hi I've been banging my head against this for a couple of days, and I suspect it's not possible, but if it is I'd love to know how. I have three... Denis McMahon	01-06-2012 06:39 AM Tony Mountifield	1	2
Mysql.net uhhh ? Amazon? Usually I expect open source to have a .net or .org so just jumping on quick with the address mysql.net - Amazon.com loads. It is the real amazon as... Michael Joel	01-05-2012 07:12 PM Michael Joel	9	10
MySQL Manual? Can't find I can't seem to find a downloadable manual for Mysql. I see the online refrence but I have a very slow dialup connection and it would be much much... Michael Joel	01-05-2012 09:59 AM Jerry Stuckle	6	7
on answering a count of zero where a no-record is the case Good afternoon. The the query --- whose code you find at the end of this message --- yields a result such as tasks group ... Daniel Bastos	01-05-2012 08:15 AM Peter H. Coffin	3	4
a strange error message? ( 1 2 3 ) Hello I asked this question a few days ago but am not getting any further suggestions so am trying again! I have just exported a table as .sql from... Geoff	01-02-2012 08:12 PM Jerry Stuckle	26	27
Optmize querys of a big table On 29 dez, 14:43, Michael Vilain <vil... (AT) NOspamcop (DOT) net> wrote: Haaa, all index of all tables this database are the Primary Keys. Doesn't... renator	01-02-2012 06:32 AM renator	9	10
mysql finding username and password not returning record Username and Password are pasted in from a form. I know the record exitst and have double checked the username and password. If I remove the... Michael Joel	01-01-2012 10:43 PM Michael Joel	1	2
before update Trigger Hallo, have following problem: I have to send an updated Row to a history table. CREATE DEFINER=`root`@`xxxxxxx` TRIGGER `pp`.`buTrigger_Adresse` manfred	12-31-2011 07:07 AM Lennart Jonsson	1	2
table_rows of a table hi, all: Most of time, if you want to get the records of a table, 'select count(*) from ' is okay. While, I find use " select TABLE_NAME,... æ™“ç£Š è´¾	12-29-2011 03:23 AM Ãlvaro G. Vicario	2	3
Re: multiple column sort MySQL Michael Joel wrote: Alter table don't return any useful query results when using mysql_query(), at best you get true/false. The benefit of the above... J.O. Aho	12-28-2011 05:07 PM Kees Nuyt	2	3
Re: the way to go about his? Michael Joel wrote: Start with a table for states, name and id, fill it up at you get new entries for your database (keep in mind that this can... J.O. Aho	12-27-2011 11:19 AM J.O. Aho	0	1
Session Variable Non-Override Q: How can I make a database be strict about accepting valid data? A: In the config file for the server, find and edit to... Brian Smither	12-26-2011 03:30 PM onedbguru	1	2
match against with another clause I have a full text table that I wish to search by matches and by date. Specifically my sql looks like this: SELECT... j	12-26-2011 04:56 AM Luuk	1	2
what does this error message mean? Hello I have just exported a table as .sql from one server and imported it into mysql on another server. The table seems to have loaded OK but I... Geoff	12-26-2011 04:48 AM Geoff	2	3
How to get a self join without getting twice the rows I should? I haven't used SQL in many years and never used it that much, but I thoughtI new how to do this. Apparently I forgot if I ever knew. I have data... dvdavins@pobox.com	12-25-2011 12:16 PM dvdavins@pobox.com	2	3
Deleting records in multiple tables (and updating another table)? Hi, I'm attempting to create a web form to allow an administrative user to "clean up" the records of a (former) user, but I am uncertain about... David	12-23-2011 03:15 AM john	7	8
member's password Hi ! Sorry, my English is a real disaster. :-( Is it possible to recover a password in the database ? I can only see a serie of 40 letters and... docanski	12-22-2011 06:05 AM Brian Cryer	8	9
on naming fields Sirs, good afternoon. I'm missing a way to name field in SQL queries. For instance, say I wanted to write SELECT function() AS field GROUP... Daniel Bastos	12-22-2011 02:31 AM Erick T. Barkhuis	4	5
Problem with timestamp fields in last two-three weeks... I have a simple mySQL database on dedicated server.. In last two weeks I experienced strange behaviour resulting in changes in all my timestamp... Matija	12-21-2011 04:21 AM Matija	5	6
Possible source of invalid foreign key values Apart from setting @@FOREIGN_KEY_CHECKS to zero, is there any other setting or circumstance where MySQL will allow to insert invalid IDs in columns... Álvaro G. Vicario	12-19-2011 09:45 AM Axel Schwenke	6	7
Multiple if or case statements I'm new to this ng, sorry if I ask a faq, but I searched for an answer in mysql docs and on google to no avail. I created a query where the result... emmexx	12-18-2011 10:57 AM emmexx	9	10
how to accept a databasename in the input parameters of a procedure hi,all: I had used mysql procedure many times before, while how to accept databasename in the inputparams stll is puzzled. for instance: create... æ™“ç£Š è´¾	12-15-2011 01:40 AM æ™“ç£Š è´¾	0	1
join with subquery execution error This is i tried the query join with sub-query..i think it have some syntax error...? select count(*) from ( SELECT transactions.loyalty_id FROM... amvis	12-14-2011 04:24 AM Álvaro G. Vicario	2	3
Automatically archive older rows? This is for a table that holds message board posts. I was planning to set up an `archive` table (identical to the `posts` table), and then set up a... Jason C	12-13-2011 09:37 PM Peter H. Coffin	6	7
Join query problem with mysql i have two tables, customer and transaction.Both have primary key as id.The customer table have one field created_at. and the transaction table have... amvis	12-13-2011 08:50 AM Erick T. Barkhuis	1	2
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 12 Dec... me	12-12-2011 03:15 AM me	0	1
mysql query problem... ( 1 2 ) i have a table transactions. which have 2 fields id and loyalty_id. here the Id is primary key. my table like this. ID loyalty_id 1 1 2 ... amvis	12-11-2011 09:03 AM amvis	12	13
JOIN, or two separate queries? ( 1 2 ) This is for a message board, where I have 2 tables: "subjects", and "posts". Which is going to be faster and more efficient? // Two queries: SELECT... Jason C	12-11-2011 08:48 AM Jerry Stuckle	15	16
A feature table? I want to make a feature table but not quite sure how to design my table. As a hypothetical example imaging a group of... SpreadTooThin	12-10-2011 08:58 AM Lennart Jonsson	6	7

Page 1 of 128

101

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off