Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 2 of 128

102

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
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
Comparing columns from 2 tables, using a wildcard I'm trying to select data from 2 separate tables, when one column is LIKE a column in the other table. For example, I have tableA and tableB. col2... Jason C	12-09-2011 06:18 AM Lennart Jonsson	2	3
diffrent hello, guys. what diffrence between INDEX and KEY in a table in mysql ? john	12-08-2011 01:55 AM Lennart Jonsson	1	2
[ANN] ODB C++ ORM 1.7.0 adds support for optimistic concurrency Hi, I am pleased to announce the release of ODB 1.7.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to... Boris Kolpackov	12-07-2011 05:47 AM Boris Kolpackov	0	1
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 05 Dec... me	12-05-2011 03:27 AM me	0	1
Covering an entire table with an index? ( 1 2 3 ) I've found myself in the curious situation where it makes sense for me to cover an entire database table with an index, like so: create table... Just Another Victim of the Ambient Morality	12-04-2011 10:42 PM Peter H. Coffin	25	26
Index after the fact? ( 1 2 ) My original schema / database / table create script did not include all my necessary keys. Is it too late to know specify new keys? Right now there... SpreadTooThin	12-03-2011 09:17 AM Jerry Stuckle	19	20
mysql column type On 12ÔÂ3ÈÕ, ÏÂÎç3Ê±29·Ö, Michael Vilain <vil... (AT) NOspamcop (DOT) net> wrote: john	12-03-2011 06:16 AM Tony Mountifield	5	6
mysql conferences? If you where to visit one mysql conference, which would it be? I've looked at: http://www.percona.com/live/mysql-conference-2012/ which looks good,... Lennart Jonsson	12-01-2011 12:05 PM Lennart Jonsson	0	1
Merging tables, then modifying links in 3rd table; OR, autoincrementbased on 2 columns being unique I have several message boards, and each board has 2 tables; one for subjects, one for posts. When I first built this many years ago, we decided to... Jason C	11-30-2011 03:45 PM Jerry Stuckle	4	5
Simple DDL stuff, what's wrong? Hi, Some mySQL tool created the following script with its Preview, however, it failed to execute without clear err msg as to how. Any idea? ... justaguy	11-29-2011 11:06 PM john	2	3
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 28 Nov... me	11-28-2011 03:17 AM me	0	1
One MS Access db to mySQL on Mac ( 1 2 ) Hi, I'm a database guy but have barely used mySQL. What I intend to do is this: export an Access database with 10 to 15 tables (not much seed... justaguy	11-26-2011 12:14 PM Peter H. Coffin	14	15
how insert data in two tables with single query in mysql Hi, i am trying to insert data two table with single query with foreign key reference but its not working my query is BEGIN TRANSACTION DECLARE... Pab	11-25-2011 04:11 AM Axel Schwenke	8	9
Get date from Year Week Day? I have a table with 3 columns YearNo, WeekNo, DayNo Is there any syntax I can use in a Query to return the date (yyyy-mm-dd) from these... R C Nesbit	11-23-2011 02:02 PM R C Nesbit	7	8
status stuck on "Sending Data" ( 1 2 3 4 5 ... Last Page) Hi, I have a table with 18 cols, (4x varchar(255), 1xtext and the others are int or tinyint (signed and unsigned). I do the following... Simon	11-21-2011 12:48 PM Jerry Stuckle	50	51
LOAD DATA LOCAL INFILE...IGNORE, how to find all rows that were inserted When I use LOAD DATA LOCAL 'file.csv' IGNORE INTO..., is there any way to return a list of the rows that were inserted? My table has about 28,000... Jason C	11-21-2011 10:26 AM Peter H. Coffin	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, 21 Nov... me	11-21-2011 03:13 AM me	0	1
failed crash recovery Hi all, I must first confess I am a a complete ignoramus when it comes to how data bases work. I have been quite happily using mythtv and gallery 2,... sid	11-20-2011 12:41 PM sid	3	4
Select * (with 2 matching columns) I have a table with 14 columns. I'm trying to select the rows (and sort them together) where 2 of those columns match. These aren't actual... Jason C	11-18-2011 05:58 PM Lennart Jonsson	9	10
[OT] ? == mysql notification. hi guys, I'm developing a system in C++ with MYSQL. For a feature I need that the system have to be notified when in the database occur a specified... softwareEngineer	11-18-2011 01:25 PM Jerry Stuckle	9	10
LOAD DATA INFILE... Can't get stat of '[filename]' (Errcode: 13) I have a file that I'm grabbing by FTP via cron, then formatting via PHP. Then, also in PHP, I'm trying to import the formatted CSV file into that... Jason C	11-18-2011 02:34 AM Jason C	8	9
SQL Syntax error? I'm trying to add a row to my table but I'm getting an SQL sytax error that I don't understand. Can you help? mysql> describe... SpreadTooThin	11-17-2011 03:18 PM Jerry Stuckle	8	9
When we're supposed to set default-character-set for the client Hi all, I'm trying to understand when I'm supposed to set/force default-character-set for the client. The documentation states (short url:... Radoulov, Dimitre	11-16-2011 06:38 AM Radoulov, Dimitre	2	3
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 14 Nov... me	11-14-2011 03:14 AM me	0	1
PROCEDURE ANALYSE() says TINYTEXT over VARCHAR(50) I have a table with 6 columns, and about 2 million rows. I've had one of these columns set to VARCHAR(50) for a few years now. When I run PROCEDURE... Jason C	11-13-2011 10:58 PM Jason C	0	1
Update from one table to another I have two tables with identical structure (one is an old backup), and I'm trying to update a column in one table with content from another. Like... Jason C	11-10-2011 03:41 AM Álvaro G. Vicario	7	8
All records for this Month. I have a table with a DATE column. I want to get a record set for all rows for this month. select * from TheTable where MeetingDate like... SpreadTooThin	11-09-2011 03:16 AM Axel Schwenke	9	10
Materialize view. ( 1 2 ) On 11/6/2011 9:26 PM, Centrino wrote: If I weren't a good consultant, my clients wouldn't be paying me what they do. ROFLMAO! I can say it... Centrino	11-08-2011 06:28 AM Jerry Stuckle	18	19
Multiple instances of MySQL server, datadir, and ibdata1 Hello folks I need to run multiple instances of MySQL 5.1 server (run as service, database type is InnoDB) on the same windows computer (Windows... anatoly	11-07-2011 12:08 PM Gordon Burditt	5	6
open_files_limit on Windows Hello mysql gurus! Mysql 5.1, windows 7/windows sever 2008. I have read the following... anatoly71@gmail.com	11-07-2011 04:41 AM Axel Schwenke	3	4
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 07 Nov... me	11-07-2011 03:13 AM me	0	1
Update from one table to another, then delete matched row from old? OK, this is sort of an addendum to the other "Update from one table to another" thread, but it's a little different so I thought that future readers... Jason C	11-04-2011 01:46 PM Luuk	1	2
Select from on table via 4 other tables... painfully slow query. Hi, I am looking for certain users that are connected via some other values. TABLE_A A_ID, type, ... (~124K rows) TABLE_B B_ID, A_ID, C_ID,... Simon	11-02-2011 03:12 AM Willem Bogaerts	5	6
Update to 5.1 I have a server with hosted clients, and it's still running MySQL v. 4.1.22. I really should update it, but I'm also thinking "if it ain't broke... Jason C	11-01-2011 10:27 AM Axel Schwenke	2	3
Is there a way to optimize that view/query? Hello, I would like to know if there is a better solution for my view. In the context, i have two table, one, is chart, a chart contains... galopin	11-01-2011 03:30 AM galopin	3	4
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 31 Oct... me	10-31-2011 02:13 AM me	0	1
Komplizierte Sortierung Hallo NG, ich habe folgendes Problem: Ich möchte eine Tabelle Abfragen und muss das Ergebnis in einer Weise sortiert ausgeben, für die ich nicht... Thomas Gehrmann	10-29-2011 03:06 AM Thomas Gehrmann	6	7
What is the MySql Cluster best disk type? I understand that MySql Cluster's primary data storage is RAM to speed up queries, but regarding the disk which is the best choice, SSD or HDD? Is... Bishop	10-28-2011 01:37 AM Axel Schwenke	1	2
how create index for substring of fields? (to say, from position 3 to8 of field). ( 1 2 ) Hello People, sorrry for this probably basic question, but I have search "index" mysql command and not found answer. Is there some way of redefine a... mig	10-27-2011 04:17 AM Axel Schwenke	18	19
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 24 Oct... me	10-26-2011 04:22 PM Jacek Krysztofik	1	2
Is it possible to define a view so that it uses a the table index? Hi. Y have a table with all the needed indexes defined in particular field let's say Afield I have defined a view from table WHERE Afield >= ... CENTRINO	10-25-2011 09:27 AM The Natural Philosopher	6	7
convert varchar field Hi, I'm administrating a mysql db via phpmyadmin and there's a VARCHAR field 'total' with some data stored in, i.e. 1432,26 (as Euro format). I want... remigio	10-25-2011 04:54 AM Álvaro G. Vicario	3	4
Incorrect key file for table I recently moved my MySQL database from a failing server to a new one. To move, I used rsync to copy everything from /var/lib/mysql/database_name to... Jason C	10-24-2011 04:40 PM Gordon Burditt	7	8
replication and table crash Hi all, a simple, stupid question: in a replication configuration, when a (single) table crashes on the master DB, what happen on the slave DB? I... DeepBlue	10-24-2011 01:21 PM Axel Schwenke	3	4
Gartner fuels Mobile Business Intelligence debate Top research and analyst firm, Gartner, has added fuel to the argument that Mobile Business Intelligence (BI) is set to become the primary method for... Jan	10-23-2011 08:53 AM Jan	0	1
How index substring (or part) of fields? - to say from position(3,5)of given field Hello People, I posted this question but it vanished in the net, so here is it again My question is probably a basic one, but I didn´t find a clue... mig	10-21-2011 04:00 PM mig	0	1
phpmyadmin help please. I am trying to get Phpmyadmin working on my mac and I have tried following tutorials but i keep getting the same errors... Here is my config.ini.php... Robert Bodley	10-21-2011 03:19 PM Jerry Stuckle	1	2

Page 2 of 128

102

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