Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 49 of 129

« First

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
MySQL++ Stored Procedure, Command out of sync I'm trying to use MySQL++ with stored procedures on MySQL 5.0.45- community, but cannot get it to work properly. My stored procedure is: drop... shalayka@gmail.com	06-20-2008 02:45 PM shalayka@gmail.com	5	26
Multiple columns in WHERE clause - multiple column indexes For a given table, I may have one of the following queries selecting data: SELECT fields FROM table WHERE foo=bar SELECT fields FROM table WHERE... Karl Groves	06-20-2008 10:55 AM Gordon Burditt	3	22
Error in SQL ( 1 2 ) Hello! Im getting insane with this! I cant find the error when i try to update a record... Here it is: Invalid query: You have an error in your... Pépê	06-20-2008 10:41 AM Peter H. Coffin	12	72
multiple SELECT in one query Hi I have two tables: TABLE1 ID \| IDL \| IDC 1 1 2 2 2 1 3 1 1 TABLE2 Pao	06-20-2008 05:02 AM Pao	2	24
Versioning data on a relational database! On Thu, 19 Jun 2008 20:37:23 +0100, Sybaseguru wrote: Don't top post. I fixed it for you. And for the record, having to build a view over every... Jeach!	06-19-2008 07:33 PM Jerry Stuckle	4	20
MySQL license question. Hi all, I have a question regarding the MySQL license. Am allowed to used the Community edition of MySQL for a web application? In other words, if... Diego	06-19-2008 09:05 AM Peter H. Coffin	3	27
mysqldump gives wrong time? Hello, mysqldump gives time in DateTime field as 11:57:01 when it should be 12:57:01 - any idea why this happens? (my line command is mysqldump... Geoff Cox	06-19-2008 08:22 AM Geoff Cox	0	26
Performance impact of using 2 columns to join? Can anyone say how big of a performance hit joining tables by two columns is, compared to using one artificial key? What is the optimal index setup... Robert M.	06-19-2008 06:02 AM Jerry Stuckle	6	22
boolean data type yes or no I get an error in trying to add this column. I got the error below. Am I supposed to make the data type int? I tried that and I got an error as... JRough	06-18-2008 11:45 PM John Nagle	2	23
query multiple tables Is there any way to query 300 tables at once to check to see if there is any data that exists in them, and if so to list the tables that do? F Tahbaz	06-18-2008 10:34 PM Jerry Stuckle	1	26
MySQL++ stored procedure usage; command out of sync I'm trying to use MySQL++ with stored procedures on MySQL 5.0.45- community, but cannot get it to work properly. My stored procedure is: drop... shalayka@gmail.com	06-18-2008 11:15 AM shalayka@gmail.com	0	24
mysql client Hi, I'm sorry if my question has been asked too many times (as I imagine), but i couldn't find a quick answer. Can you suggest me a GUI mysql client... edoardo	06-18-2008 10:13 AM Peter H. Coffin	1	51
complicated INSERT - copy existing data while updating id fields I have two tables: products: product_id vendor_id options: option_id product_id option_name TriAdmin	06-18-2008 08:35 AM TriAdmin	2	22
Seperate database for each customer Indstillinger Hi, I am in the process of building a webapplication, specifically a business administration system, where clients subscribe on the application.... michael.ladum@gmail.com	06-17-2008 12:54 PM Jerry Stuckle	3	18
lowercase_table_names and MySQL performances ( 1 2 ) Hi everybody, I need to set lowercase_table_names variable to 1 on my mysql server to solve some problem of bad coding in a web application. I... signor G	06-17-2008 07:49 AM signor G	11	43
NOT IN is not working Hi: I am trying something like this: SELECT * FROM CLIENTS WHERE USER NOT IN (SELECT USER FROM USERS) but it is not working in my mysql 3.23. Why... boqueron	06-17-2008 04:04 AM Captain Paralytic	9	28
MyISAM concurrent insert From MySQL manual, it said it is possible to insert data at the end of a MyISAM table when other threads are reading at the same table, without any... howa	06-16-2008 09:53 PM Jerry Stuckle	1	28
help - importing fails via large batch file I'm doing a lot of conversion from my old DB data to mySQL and have generated import files, the import start with TRUNCATES (to kill off any bad... larry@portcommodore.com	06-16-2008 06:59 PM larry@portcommodore.com	5	22
Trying to speed up MySQL query - optimizer not using index, but don'tknow why I'm trying to speed up a MySQL query. Here's the table: CREATE TABLE ratingqueue ( domain VARCHAR(255) NOT NULL UNIQUE PRIMARY... John Nagle	06-16-2008 01:34 PM John Nagle	1	23
Ryhmän sfnet.viestinta.journalismi virallinen kuvaus Fortumille lunta tupaan. Valtio ostattaa sen ulos Fingridistä. Ja tutusti asia taas niin vaikeaa, ettei löytynyt edes tekstitv:n puolelta.... Markku Young	06-16-2008 12:23 PM Markku Young	0	26
Vb.Net Integration I've had a wonderful idea for one of my apps, and don't know if it possible to do what I want... The app currently uses a local database, and I want... Tym	06-16-2008 08:58 AM Tym	3	30
INSERT in two tables, using LAST_INSERT_ID() Hi All, now I'm stuck with this problem. I want to insert a new row in two tables. The first insert is no problem thanks to this code... yataaa	06-16-2008 06:50 AM Dikkie Dik	1	24
MySQL Match Against error I got 2 tabels: Books: Titel (Char) Autor (INT) Autors: IdnoAutor (int) NameAutor (Char) Harald	06-16-2008 03:17 AM Harald	0	27
generate unique number sequence (w/o auto increment) I have a scenario where a user will request the next number in the sequence. The user can have multiple numbers. The numbers will be stored in a... Keychain	06-15-2008 12:05 PM Keychain	5	19
Any real reason need to use UTF8 as table character set? Currently I am justing using Latin1 as Table character set to store UTF8 data, it work very well. I don't need those collation stuffs for my data,... setesting001@gmail.com	06-15-2008 01:01 AM Roy M	2	30
date_format I have just tried to use the date_format in my query and it doesn't return anything? Please can anyone see any obvious errors? $sql="SELECT... CH	06-14-2008 10:08 AM CH	1	31
Can I do this in one MySQL statement? I'm doing something here that can be done in two MySQL statements. Is it possible to do it in one? queuestate = 'queued" ## Python 'EXISTS SELECT... John Nagle	06-13-2008 07:49 PM John Nagle	2	22
Problem with string comparison ( 1 2 ) I have been using MySQL on and off for a number of years but I am stumped by this problem. I am doing a select which requires a join to a second... jammiepodger	06-13-2008 06:49 PM Michael Austin	18	37
stored procedure to input data in a join table? There is a many to many between cars and owners for rental purposes so I added the company_car join table. company: companyId company_type... JRough	06-13-2008 05:56 PM JRough	0	30
return multiple records from join as single row Hi I can't seem to get my head around this join. I basically want to select 2 records from the join as a row. let me explain. table people:... mcardeiro@yahoo.com	06-13-2008 01:11 PM Rik Wasmus	1	25
HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers , HCL, Aricent, Infosys and many more companies hiring fresh & experienced engineers , FIND UR DREAM JOBS AT GIVEN BELOW LINKS: - ... riturao4u@gmail.com	06-13-2008 10:42 AM riturao4u@gmail.com	0	26
Copy a row into the same table Hi all, is there any way to do the following in SQL: Create a new row by copying an existing row, in such a way that certain values of the existing... yataaa	06-13-2008 07:25 AM Rik Wasmus	5	27
Optimizing WHERE clause Hello, I have a rather complex query, with the following WHERE clause: WHERE abs(rlat - 0.65386230689201) < 0.0025 AND abs(rlon - -2.1367819742996)... S	06-13-2008 03:23 AM Rik Wasmus	1	26
random code for MYSQL ODBC Dear all, Using ODBC, the data from the mysql in Linux server are exacted to the Excel sheet in Windows XP. It is found that most extracted data... John Lee	06-12-2008 09:59 PM Jerry Stuckle	3	24
proper way to compile a UDF I had a UDF that I used on a Fedora Core 5 machine, and now that I've upgraded to a Redhat 5 workstation the command line I used to compile my udf... Greg Hennessy	06-12-2008 06:21 PM toby	1	30
Re: Is there any Webinterface? Your Name schreef: there are tools for checking the replication, i think (but am not sure!) NAGIOS is one of them checking setup, is different from... Luuk	06-12-2008 03:18 PM Luuk	1	28
mysql system tray monitor.... mysql system tray monitor is not working properly. Running XP home. This has been going on since day one. Start up system, look at system tray, NO... dba	06-12-2008 01:53 PM dba	0	26
Rejecting Attempted NULL Insert In a number of cases, with fields defined as NULL, mysql (5.0.41- community-nt) is rejecting NULL's in fields defined as DOUBLE, among others. Is... ashore	06-12-2008 10:22 AM Captain Paralytic	4	27
Mysql database in UTF8, PHP shows latin1 (iso-8859-1) ( 1 2 3 4 5 ) I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c... alex	06-12-2008 10:02 AM Marc	42	97
Nested Query with DESCRIBE Hello, guys. Is that possible? I would like to retrieve a name of a column in order to process it then in my program. What I have... Ewgenij Sokolovski	06-12-2008 03:28 AM Ewgenij Sokolovski	2	32
table size the same after deleting mots of the records? Hello, I deleted most of the records from a table but the table size remained about the same. I have now "dropped" the table and recreated it and... Geoff Cox	06-11-2008 03:08 PM Geoff Cox	7	22
Single database versus shared database for same table structure? We are planning to host data for 50 to 100 different companies on a single server. Each company will have their own set of data, but exact same table... Rodusa	06-11-2008 01:41 PM Gordon Burditt	5	25
Meaning of MySQL query browser time values What do the time values in the MySQL query browser mean? I'm getting 0 rows fetched in 0.0007s (4.3616s) on a query that's taking too long. What... John Nagle	06-11-2008 10:51 AM Peter H. Coffin	4	33
FREE Tutorials on HTML XHTML CSS JavaScript XML XSL ASP SQL ADOVBScript, SAP - ABAP and more... access all computer tutorials for free visit http://freecomputertutorialz1.blogspot.com/ Dhanabal	06-11-2008 05:45 AM Dhanabal	0	29
Slow query with MEMORY engine - why? I'm doing this query repeatedly on a MEMORY database. SELECT domain, requestor_ip_hash AS requestor FROM ratingqueue WHERE rating_state = 'queued'... John Nagle	06-10-2008 02:03 PM John Nagle	4	23
Can this query be done? Hi, I'm trying to do a very convoluted query. I want to add subtract values in pairs while selecting records and display the results in the query... Mtek	06-10-2008 11:33 AM Rik Wasmus	9	37
Replication set up, not replicating. I'm trying to set up replication where the MASTER is on a remote server and the SLAVE is on a local box in the office. Using this... mechphisto@gmail.com	06-10-2008 10:17 AM mechphisto@gmail.com	3	23
Beginners Help Hi, I'm new to both MySQL and Linux (Ubuntu), and having come from a Microsoft (Windows/SQL Server) background am finding even trivial operational... Shak	06-10-2008 08:54 AM Peter H. Coffin	1	33
need help creating query I need help writing a query that returns productIds for products that are in the same order as a given productId. (Customers who purchased this also... Nathan G	06-10-2008 04:39 AM Captain Paralytic	9	24
Novice getting ERRORS. I am trying to build a Employee Order Detail report. My first hurdle is as follows. The SO info I am getting isn't listed under the correct user. It... Mo	06-09-2008 04:41 PM Dan Rumney	1	26

Page 49 of 129

« First

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