Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 5 of 128

105

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
get sum() grouped max() of group hello, I have table structure like below. Each row is one played game, each person can play many or none times in each month. id \| person \| ... Jeff Carpereret	07-02-2011 06:00 AM Axel Schwenke	1	2
Omit auto-increment values using mysqldump Hey there, I've just found a tip for omiting auto-increment column values using mysqldump: mysqldump -u root -pYourPasword database table_name... Endel Dreyer	07-01-2011 02:50 AM J.O. Aho	4	5
Database design question The tables in my DB, from a design point of view, fall into 3 categories. They are the real data, session information and a bunch of excel... Joseph Hesse	06-29-2011 08:45 PM Thomas 'PointedEars' Lahn	5	6
Data visualization best practices for Business Intelligence Data analysis. What’s the point of it? Your first reaction might be to scoff at, or dismiss this question as rhetorical, perhaps pointless. But... Jan	06-27-2011 07:46 AM Jan	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, 27 Jun... me	06-27-2011 04:32 AM me	0	1
odd display of mysql table contents? ( 1 2 3 ) Hello I have come across an new oddity, to me - perhaps someone can see why? I am displaying the contents from 2 different tables in a ... geoff@invalid.invalid	06-22-2011 08:25 AM Captain Paralytic	23	24
problem deleting a record using join? Hi, I get an error if I execute this: DELETE * FROM invoice JOIN user ON user.id = invoice.FK_user WHERE invoice.id=51 AND user.id=1 "#1064 - You... marc	06-22-2011 07:54 AM Captain Paralytic	4	5
Fulltext usage Hi all, I created a table with the following definition: CREATE TABLE word_table ( id int(10) unsigned NOT NULL auto_increment, word text CHARACTER... gervaz	06-21-2011 03:49 PM gervaz	2	3
MySQL Replication - promote slave Hi all, I need to document the switch between master and slave and I want to double check if the outlined procedure is correct. We have a simple... Radoulov, Dimitre	06-21-2011 02:14 PM Radoulov, Dimitre	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, 20 Jun... me	06-20-2011 04:33 AM me	0	1
about the last_insert_id() error hi, everyone. everytime it would return 0 after I insert a row and use the get_last_id() to get the inserted auto_increment id. I don't know what's... white_ideal	06-20-2011 03:20 AM Axel Schwenke	2	3
Determine primary key in an aggregate query I am doing a GROUP BY to determine the MAX value in a GROUP. How can I determine, with a query, the primary key of each row that has the MAX... Joe Hesse	06-15-2011 10:53 AM Axel Schwenke	2	3
[MariaDB] Problem setting up new user ( 1 2 ) Hi, I'm trying out MariaDB and I have a problem granting access to a user (that connects through JDBC). Here is what I did (connected as... Hans Castorp	06-14-2011 05:07 PM Malcolm Hoar	10	11
Yellowfin 5.2 Release Video Watch the Video http://www.youtube.com/watch?v=KHlpwxnKS5o Enhanced usability Yellowfin 5.2 also includes a number of enhancements directly... janpelletier@yahoo.ca	06-14-2011 08:43 AM janpelletier@yahoo.ca	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, 13 Jun... me	06-13-2011 04:39 AM me	0	1
How mysql is different that oracle Hi, Can you please tell me what is the difference between mysql and oracle database? Thanks in advance. Thanks, Rani Rani	06-12-2011 03:04 PM Hans Castorp	4	5
Select random rows to populate What would the SQL statement be to randomly select 30% of the records in table2 and calculate column X equal to string 'test' for just those random... noydb	06-11-2011 02:05 AM Lennart Jonsson	6	7
Character set, collation question Some of the tables in my database have different character sets and/or collation. The database is working fine but I am worried about some subtle... Joe Hesse	06-10-2011 01:49 PM Axel Schwenke	7	8
why we should start designing database and not direct start creating it? Il 09/06/2011 18.13, The Natural Philosopher ha scritto: Yeah I agree, but anyway I feel a troll smell hundreds yards far... Regards, M. Dnyakalamba	06-10-2011 03:08 AM Erick T. Barkhuis	5	6
Text Fields I am just getting started in using the "Text" type in MySQL. Is the following INSERT the proper way to enter newlines in text data? Is there a way... Joe Hesse	06-08-2011 08:57 AM Joe Hesse	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, 06 Jun... me	06-06-2011 04:34 AM me	0	1
further table design questions ( 1 2 3 4 ) Hello I had some very helpful comments in my earlier post but am still struggling to get a better table design. I have made a small step (?) by... geoff@invalid.invalid	06-01-2011 01:45 AM geoff@invalid.invalid	34	35
Storing parsed XML-elements as blobs Hello! I am looking for an efficient way of storing large amounts of data in mysql, so that it is quick to access and efficient in store. Im... Maccabi	05-30-2011 02:10 PM 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, 30 May... me	05-30-2011 04:39 AM me	0	1
How does ISAM database handle deleted records? Ok, as you might have guessed, I am working on something, that involves gathering more or less real time data, every 5 minutes, and storing it in a... The Natural Philosopher	05-28-2011 02:09 PM Jerry Stuckle	6	7
Why if it works in PHP, dioes it not work in C? In php I can use:- mysql_connect("localhost", $user,$password); mysql_select_db($database); but using C API I have to use... The Natural Philosopher	05-27-2011 05:18 PM The Natural Philosopher	8	9
Hacking/lost/forgotten root password. Hi I faced this issue once, I forgot the root password and was unable to recover it and since then I was thinking of how to resolve this issue and... vd	05-26-2011 11:45 AM Jerry Stuckle	4	5
too many columns/rows? ( 1 2 3 ) Hello I know that I could organise the data better but does phpmyadmin or mysql have a problem with a table which has 600 columns and 100... geoff@invalid.invalid	05-23-2011 02:18 PM Jerry Stuckle	26	27
Re: silly mistake in the mysql part? geoff (AT) invalid (DOT) invalid wrote: Maybe "order" is a restricted keyword. My practice is to never use real English words as fieldnames or... Beauregard T. Shagnasty	05-23-2011 01:06 PM geoff@invalid.invalid	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, 23 May... me	05-23-2011 04:34 AM me	0	1
Re: mysql table order and php sort() ? On 2011-05-23 09:19, geoff (AT) invalid (DOT) invalid wrote: A table has no order. If you want to order retrieved data you have to specify it with... Lennart Jonsson	05-23-2011 04:28 AM geoff@invalid.invalid	2	3
MySQL Backup -- Sanity Check I am relatively new to MySQL. My database uses Innodb and I have binary logging enabled. Here is my proposed backup strategy: # Raw backup cd... Malcolm Hoar	05-20-2011 03:48 PM Axel Schwenke	9	10
Why index is not used for sorting? Please help to optimize performance. Query is "select * from addresses order by address limit 1000 offset 90000" runs very slowly. Field 'address' is... SergeyPo	05-19-2011 05:52 AM Axel Schwenke	3	4
Error 1329 - No data - zero rows fetched, selected, or processed The following code is the basis for all of my stored procedures. I was running these scripts with no issue and now, they are all throwing a 1329. I... gp	05-18-2011 09:31 PM gp	0	1
Macquarie University generates new insights with Business Intelligence Macquarie University today launched the first phase of a university- wide reporting and analytics program, Datamart. Datamart, powered by... janpelletier@yahoo.ca	05-18-2011 08:01 AM janpelletier@yahoo.ca	0	1
Problem with JDBC driver and MySQL date_format function Hi, I have the following problem with a java application: Since I updated my mysql driver version 3 to version... Jens Riedel	05-17-2011 04:16 PM Luuk	1	2
how to count group maked by group by clause? I have a table called goals structured as follow: id (PK) player_id (FK) match_id (FK) For a given player_id, i want to know how many goals has... Mariano C.	05-17-2011 01:07 PM Lennart Jonsson	1	2
Re: some of the issues of NOT storing images in a secure database.. Willem Bogaerts wrote: He might have guessed it, but since the access would have been essentially via a script, putting security into the script... The Natural Philosopher	05-17-2011 10:45 AM The Natural Philosopher	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, 16 May... me	05-16-2011 04:28 AM me	0	1
Need help getting unique values Merchant table: 253 merchants - each merchant has one primary category Category table: 161 categories with images (one image per category) Merchants... Adrienne Boswell	05-13-2011 04:00 PM Luuk	3	4
Query Involving Group Hi, If I do the query: SELECT COUNT(*) FROM Persons GROUP BY LastName; I get a listing giving the count from each group. I want to determine the... Joseph Hesse	05-12-2011 02:21 PM Axel Schwenke	3	4
mysql tables corrupt question Dear All If I have thousand tables, how can I know which one is corrupted quickly? thanks from Peter (cmk128 (AT) hotmail (DOT) com) peter	05-11-2011 07:08 AM Axel Schwenke	4	5
newbie question hi, i have a mysql server and when I run on that server; # mysql -h localhost -u root -p and the type the password I get the mysql prompt. when i... adirtymindisajoyforever	05-10-2011 10:15 AM Axel Schwenke	3	4
DDL -> HTML? Hello, d'ya know any MySQL DDL -> HTML conversion tool? We'd like to generate some developer docs using an existing MySQL DDL (SQL) file... Jan Luehr	05-09-2011 02:07 PM Axel Schwenke	5	6
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 09 May... me	05-09-2011 04:27 AM me	0	1
SQL Problem ( 1 2 ) I guess it's my inexperience but I cannot figure out how to write SQL for the following case: I have two tables. Table1 has the numbers 1 through... bruce	05-08-2011 07:28 PM Geoff Muldoon	12	13
workbench tables to PDF ? Just curious to know if one were to create a table in mysql workbench, can that be imported directly into a PDF document created by Adobe's Acrobat... richard	05-08-2011 01:02 PM Luuk	4	5
deadlock on INSERT IGNORE ... SELECT ... WHERE NOT EXISTS ... Hi, I'm hoping I can get some pointers to documentation that I should review to understand the behavior of some SQL under MySQL. I've got an InnoDB... jimr	05-07-2011 09:19 PM Jerry Stuckle	6	7
same datadir for Windows 32, 64 and Linux - mysql 5.1 Hello everyone, I am using mySQL 5.1.56 community server. my mySQL`s are installed in the network (not as service) in Windows and Linux... Ricardo Pan	05-04-2011 02:30 PM Ricardo Pan	0	1
Extended Join Hi I am just doing my first steps in SQL (SQLite3) and have to following problem. I have the following two... Daniel Arnold	05-04-2011 11:53 AM Thomas 'PointedEars' Lahn	3	4

Page 5 of 128

105

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