| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello, guys! Maybe somebody here would be able to answer my question.
I would like to know whether it's possible to couple mysqldump with...
Ewgenij Sokolovski
|
05-14-2008 09:00 AM
Ewgenij Sokolovski  | 4 | 34 |
| | | Hello
I`ve got some problem with mysql import data using LOAD DATA INFILE.
IGNORE <count> LINES clause doesn`t work like I expect and it...
gRabbi
|
05-14-2008 08:01 AM
gRabbi | 0 | 31 |
| | | I am getting the following error
: Can't connect to local MySQL server through socket
when i tried mysqlshow command
parag
|
05-14-2008 07:07 AM
Sadhna | 2 | 32 |
| | | Hi:
We have an application in our company and we use 32 byte keys,
generated from hibernate, being used as primary keys in our MySQL
database. As...
raviaw
|
05-13-2008 02:48 PM
raviaw | 2 | 20 |
| | | I would like to create an sql select that listed all group records as
a concatenated string, but I just can not work out how to do it.
eg Table1 ...
mcl
|
05-13-2008 02:16 PM
Rik Wasmus | 2 | 32 |
| | | I found a query on how to find the primary key of a table:
SELECT COLUMN_NAME
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = Database()
AND...
Loony2nz
|
05-13-2008 02:12 PM
Rik Wasmus | 1 | 33 |
| | | I am new with MySql and am having problems with the setup and testing.
I am running Solaris 10 on a Sun Blade 150.
I completed the installation...
msargent99@gmail.com
|
05-13-2008 02:03 PM
Jerry Stuckle | 6 | 34 |
| | | Windows Vista and MS Access on PC. I get to the dialogue to set up
ODBC connection to mySQL on XO host (cnchost) but I don't know what to
enter. I...
EleFanMan
|
05-13-2008 09:25 AM
EleFanMan | 0 | 31 |
| | | A simple subquery:
SELECT T2.id FROM T2 WHERE T2.fid IN
(SELECT T2.id FROM T2 WHERE T2.fid = 8);
MySQL returns:
Check the manual that corresponds...
howa
|
05-13-2008 05:54 AM
Rik Wasmus | 1 | 35 |
| | | The following from the manual works fine:
SELECT MAKEDATE(2001,365), MAKEDATE(2004,365);
However:
SELECT MAKEDATE(2001,365), MAKEDATE(2004,365) FROM...
Captain Paralytic
|
05-13-2008 04:49 AM
Captain Paralytic | 3 | 39 |
| | | Hello,
I have pages using AJAX and php to add data to MySQL database.
What's the best way to add the date/time fror each addition of...
Geoff Cox
|
05-12-2008 06:51 PM
Michael Austin | 6 | 51 |
| | | Hi
I have a real headache of a problem and was wondering if anyone can
help me.
I'm writing a system that saves stock items. Each item can have...
Nick S
|
05-12-2008 05:57 PM
Gordon Burditt | 6 | 28 |
| | | I need to merge table "B" into table "A" inserting any new records and
updating any existing ones. The two tables are identically formatted,
both...
Shane
|
05-12-2008 02:04 PM
Rik Wasmus | 4 | 28 |
| | | Hi there,
this statement works fine but I'm wondering is there any way to
simplify it?
SELECT score,
(SELECT name from players WHERE...
Ciaran
|
05-12-2008 02:02 PM
Rik Wasmus | 3 | 28 |
| | | Hi,
I'm trying to install MySQL 5.0 on a test server where there has been
no previous version of MySQL installed. I'm using the non-rpm version
and...
Sarah
|
05-12-2008 01:28 PM
Luuk | 3 | 27 |
| | | I have a Python application which seems to lose its connection
to the database exactly once per week. It's not an idle time issue;
there's a...
John Nagle
|
05-12-2008 01:25 PM
Luuk | 5 | 31 |
| | | Hi,
Hoping someone can assist me with a query I have.
I have two tables, both of which have at least one field of the same
name, type, etc, etc....
superman183
|
05-12-2008 07:25 AM
Captain Paralytic | 9 | 38 |
| | | Here is an example of my data:
entry_id cat_id
1 20
2 25
3 30
4 25
5 35
6 ...
Chuck Cheeze
|
05-11-2008 04:04 PM
Jerry Stuckle | 4 | 33 |
| | | Hello,
I am very new to distributed computing and mySQL, so *kindly* forgive
my ignorance.
Has anyone recently (or, ever) attempted this, or is...
SomeDeveloper
|
05-11-2008 06:33 AM
SomeDeveloper | 1 | 27 |
| | | I installed a MySQL server on my computer two months ago, but several
days before I installed XAMPP. Since XAMPP contains MySQL, I am afraid
that...
Erwin Moller
|
05-10-2008 11:14 PM
Jerry Stuckle | 2 | 38 |
| | | I would like to know if Perl's DBI supports an attribute that would
make a database handle read only.
That is, I am looking for a way to make a...
Ignoramus26246
|
05-10-2008 01:17 AM
Rik Wasmus | 12 | 61 |
| | | I am trying to organize a long page of php code I inherited. It
mostly has includes and if statements and it is hard to read. I want
to take this...
JRough
|
05-10-2008 12:21 AM
Rik Wasmus | 1 | 35 |
| | | After a little PHP education, my first project (to get my feet wet) is
to
make an employee time-tracking program for our small business.
*** ANY...
Mo
|
05-09-2008 05:05 PM
Mo | 10 | 49 |
| | | Hey All,
I have a little delema that I can't figure out. I have this query
currently:
SELECT p.id, p.styleno, t1.name AS category1, t2.name as...
cmgmyr
|
05-09-2008 04:27 PM
cmgmyr | 4 | 38 |
| | | Hi All,
I updated my version of mysql from 4.1.22 to 5.0.45 and found that my
tables are not being read now. I tried to go back to the...
Pankaj
|
05-09-2008 04:05 PM
Kees Nuyt | 1 | 31 |
| | | Hi All,
I'm a SQL newbie, so please be gentle with me! We have a CRM system
with Potentials and Contacts, and my boss wants a report laid out...
Redkins
|
05-09-2008 01:59 AM
Redkins | 2 | 29 |
| | | I am working on a script to process a data feed and load it into a
MySQL DB. It mostly works, except that for almost 20,000 lines of
data, I get 25...
Ted
|
05-08-2008 09:32 PM
Ted | 2 | 33 |
| | | Hi,
I'm writing to a MySQL database (version 5.0.51b on solaris10 built
from source) using multiple Java threads and, after successfully
inserting a...
alaric
|
05-08-2008 05:01 PM
Kees Nuyt | 2 | 34 |
| | | Hi .,
When I try to solve a sudoku of 9X9 ., I get a error with this
message.
Error Code : 1116
Too many tables; MySQL can only use 61 tables in a...
Kesavan
|
05-08-2008 09:56 AM
Rik Wasmus | 6 | 30 |
| | | Hi guys, I've created a table in my local database and filled it with a
great amount of data (too much!) and now I need to insert the same data
on my...
Carla
|
05-08-2008 09:04 AM
costas.palaskas@gmail.com | 6 | 32 |
| | | Hi.
I want to sort the following selection list:
A1
A10
A5
BA100
BA11
BA5
Asteras Amaliadas
|
05-08-2008 04:09 AM
Rik Wasmus | 1 | 35 |
| | | We are currently running on mysql 4.0-27 at my business. I have what should
seem to be a basic query, but am having trouble with syntax errors and...
GregoryD
|
05-07-2008 09:10 PM
Rik Wasmus | 4 | 30 |
| | | I am trying to select a single entry from the
"process_account_inspections" where the column "timestamp" is the Max
(resulting in the most recent...
Chuck Pearce
|
05-07-2008 04:07 PM
Paul Lautman | 1 | 34 |
| | | Hello, how much cost mySQL for comercial use?
Adax
|
05-07-2008 02:55 PM
Yaël Chéenne | 6 | 39 |
| | | Hi all,
I'm afraid I need some help with a string manipulation function in
mysql.
Suppose I have a column which contains a comma-separated set of...
cvh@LE
|
05-07-2008 09:58 AM
Peter H. Coffin | 9 | 30 |
| | | I've got a leafnode directory with usenet articles
named, roughly, 1-79389.
After running a sh script on the directory to populate a
table with...
Steve Ackman
|
05-07-2008 05:58 AM
Helmut Wais | 6 | 23 |
| | | Hallo, I am new to any database stuff. I work under
Win2k SP4.
I downloaded the latest stable release of MySQL 5.0
(mysql-5.0.51a-win32.zip) and...
Uwe Kotyczka
|
05-07-2008 04:35 AM
Uwe Kotyczka | 0 | 22 |
| | | Hi all,
I've been thinking about it, and I'm a bit stumped, and wondered if
anyone here could help.
I have two tables, an albums and a photos...
Wilhelm
|
05-07-2008 04:28 AM
Captain Paralytic | 2 | 21 |
| | | I've been trying to think of how to complete this with a single query,
but my knowledge of exactly which function would be useful here...
Warren
|
05-06-2008 04:57 PM
Rik Wasmus | 8 | 27 |
| | | Dear comp.databases.mysql,
Stylus Studio 2008 Release 2 is now available.The following highlights
some of the new features included in our...
DataDirect Technologies
|
05-06-2008 01:33 PM
DataDirect Technologies | 0 | 21 |
| | | Sorry but I'm very newbie for writing my own script
I try
$result = mysql_query("SELECT
cardnum,callednum,disposition,billseconds,truncate(billcost...
christian
|
05-06-2008 05:57 AM
Captain Paralytic | 3 | 98 |
| | | I'm using a php script which performs three xml queries to other three
servers to retrieve a set of ids and after I do a query to mysql of
the...
Caffeneide
|
05-06-2008 03:48 AM
Caffeneide | 3 | 24 |
| | | Hi all,
I have what I think is a rather a curly question:
Is there a way to select all days in a month (or week, year, any
period) without having...
supagroova
|
05-06-2008 03:27 AM
supagroova | 3 | 19 |
| | | Hello, I have problem with connection from MS Access to mySQL. In Access I
have connected tables to mySQL. In all tables strings columns have...
Adax
|
05-05-2008 05:08 PM
cvh@LE | 3 | 46 |
| | | Mr. X. wrote:
You have crossposted to five newsgroups. A lot of people will have
newsreaders set to ignore such widely crossposted messages....
RedGrittyBrick
|
05-05-2008 04:55 PM
Mr. X. | 4 | 20 |
| | | I am attempting to improve the internal security at our company by
requiring
SSL connections to our MySql database from ASP.Net. I have set up...
john22233328@yahoo.com
|
05-05-2008 02:01 PM
john22233328@yahoo.com | 0 | 18 |
 | | How good is the rand function of MySQL? How can it be improved?
Thx.
--
When you argue with a fool, chances are he's doing the same
Cosmic programmer
|
05-05-2008 01:24 PM
toby | 16 | 161 |
| | | Hello,
I have a site with 7 pages, on each of which users answer 4 questions.
The answers are submitted using AJAX and the php code below into...
Geoff Cox
|
05-05-2008 11:39 AM
Matthias Watermann | 15 | 37 |
| | | Hi,
The table that I have has a sample records like below:
Emp No. Unique ID From Date To...
Sandy80
|
05-05-2008 08:54 AM
Rik Wasmus | 3 | 21 |
| | | Hello again, another question: is it im mySQL mechanism
TransferSpreadsheet , similary as in MS Acces, to import data from excel to
mySQL?
MS...
Adax
|
05-04-2008 05:35 PM
Michael Austin | 1 | 29 |
