Home   |   Register   |   Today's Posts   |   Rules   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Search Forums > Search Results

Page 1 of 20 1 2311 Last »
Showing results 1 to 25 of 500
Search took 0.06 seconds. Search: Posts Made By: it-iss.com
Forum: MySQL 05-15-13, 12:15
Replies: 1
Views: 132
Posted By it-iss.com
What have you tried so far?

What have you tried so far?
Forum: MySQL 05-15-13, 12:12
Replies: 1
Views: 140
Posted By it-iss.com
What have you tried so far?

What have you tried so far?
Forum: MySQL 05-12-13, 07:09
Replies: 3
Views: 176
Posted By it-iss.com
What you need to do here is to first get per...

What you need to do here is to first get per customer id the maximum date and then join this back to the original tables to get all the fields:


SELECT csd.cust_id, csd.reading, csd.read_date...
Forum: MySQL 05-09-13, 16:50
Replies: 2
Views: 146
Posted By it-iss.com
Without more information there is no way of...

Without more information there is no way of knowing how to get the relationships to work. If table A contains information that allows you to select the record from table F directly then you may not...
Forum: MySQL 05-08-13, 15:37
Replies: 1
Views: 148
Posted By it-iss.com
You should take a look at your data. I suspect...

You should take a look at your data. I suspect that an index on (employee_id, booked and time) together would give you sufficiently low cardinality that it would return your results from a large...
Forum: MySQL 05-07-13, 14:15
Replies: 1
Views: 180
Posted By it-iss.com
It is possible. I have setup a test case but you...

It is possible. I have setup a test case but you could easily modify this slightly to make it fit inline with what you have there.

Basically what you do is use user variables which will act as the...
Forum: MySQL 05-07-13, 00:25
Replies: 2
Views: 168
Posted By it-iss.com
The clause WHERE expression IN (expr1,expr2)...

The clause WHERE expression IN (expr1,expr2) cannot accept wildcards and performs equality operations with the expressions inside the parenthesis. This is identical to writing the query WHERE...
Forum: MySQL 05-06-13, 15:52
Replies: 1
Views: 159
Posted By it-iss.com
Firstly you should this as mysqld_safe and not...

Firstly you should this as mysqld_safe and not mysqld safe. The second error is related to access permissions to /db/mysql/tmp/iboBah3h which either does not exist or if it is exists you have...
Forum: MySQL 05-06-13, 15:47
Replies: 2
Views: 196
Posted By it-iss.com
Do you close all connections and reset record set...

Do you close all connections and reset record set after you have performed your first iteration? It seems this is the likely source of your problem.
Forum: MySQL 05-06-13, 15:46
Replies: 8
Views: 315
Posted By it-iss.com
I would do this in an application where you...

I would do this in an application where you output the contents of each query in CSV format or your use MySQL to generate the 7-12 different queries to different files and then you merge these into a...
Forum: MySQL 05-01-13, 03:50
Replies: 4
Views: 235
Posted By it-iss.com
I have a mini tutorial which explains this MySQL...

I have a mini tutorial which explains this MySQL – FULL OUTER JOIN « IT Integrated Business Solutions (http://www.it-iss.com/mysql/mysql-full-outer-join/)
Forum: MySQL 04-29-13, 16:34
Replies: 2
Views: 148
Posted By it-iss.com
In MySQL this would be mysql> select...

In MySQL this would be


mysql> select name, concat(substring_index(name, '"', 1), substring(name, instr(name, '"')+1)) from teststring;...
Forum: MySQL 04-29-13, 14:22
Replies: 2
Views: 140
Posted By it-iss.com
Or select a random number. If the number is less...

Or select a random number. If the number is less or equal to 0.8 select a row from blue and if it is greater than 0.8 select one from red.
Forum: MySQL 04-29-13, 14:16
Replies: 6
Views: 338
Posted By it-iss.com
Did you run my query because that is exactly what...

Did you run my query because that is exactly what is would return. There is an issue with your data you should have included an additional row for Friday.
Forum: MySQL 04-28-13, 11:54
Replies: 6
Views: 338
Posted By it-iss.com
You will need to give an example as I do not...

You will need to give an example as I do not follow what you are asking for?
Forum: MySQL 04-28-13, 02:29
Replies: 6
Views: 338
Posted By it-iss.com
Hi, you should look at COUNT ... GROUP BY in...

Hi,

you should look at COUNT ... GROUP BY in your SQL.


SELECT labday, labtime, labroom, COUNT(*)
FROM studentSubject
WHERE studentID = studID
GROUP BY labday, labtime, labroom;
Forum: MySQL 04-26-13, 13:33
Replies: 2
Views: 182
Posted By it-iss.com
Hi, the problem here is that your INSERT...

Hi,

the problem here is that your INSERT statement is not correct. It appears you are referencing back to a field in the table you are inserting into.

If you explain what you are trying to...
Forum: MySQL 04-26-13, 00:34
Replies: 3
Views: 217
Posted By it-iss.com
You where clause is in the wrong place.

You where clause is in the wrong place.
Forum: MySQL 04-24-13, 18:44
Replies: 1
Views: 168
Posted By it-iss.com
There is a commercial tool from Zmanda Recovery...

There is a commercial tool from Zmanda Recovery Manager (ZRM) for MySQL. Alternatively you can use mysqldump to create your dump file which is then written to tape in a separate process using dsmc.
Forum: MySQL 04-23-13, 14:18
Replies: 5
Views: 217
Posted By it-iss.com
When you say you are leaving the roleid empty....

When you say you are leaving the roleid empty. Can you show us the INSERT statement that you executed. This should work. I suspect that instead of it being a NULL you are inserting some value which...
Forum: MySQL 04-21-13, 14:00
Replies: 3
Views: 299
Posted By it-iss.com
What you should do is create a staging table....

What you should do is create a staging table. This is a table where you load all the data from the CSV file. The table should always be emptied before uploading the data. Once the data has been...
Forum: MySQL 04-21-13, 02:33
Replies: 3
Views: 299
Posted By it-iss.com
I am not sure what you are asking for here? If...

I am not sure what you are asking for here? If you have two tables with the data already populated then use an UPDATE statement as follows:


UPDATE table1,
table2
SET table1.age =...
Forum: Microsoft SQL Server 04-19-13, 19:17
Replies: 10
Views: 405
Posted By it-iss.com
Show us the query and the actual message...

Show us the query and the actual message returned. Also where are you running this query from e.g. mysql utility, phpMyAdmin?
Forum: MySQL 04-19-13, 13:43
Replies: 2
Views: 253
Posted By it-iss.com
It is possible but very complex and would be...

It is possible but very complex and would be easier to do it in a program than in an SQL statement.
Forum: MySQL 04-19-13, 13:33
Replies: 4
Views: 289
Posted By it-iss.com
If you are on a Linux host, you could try using a...

If you are on a Linux host, you could try using a pipe.


mysqldump -u old_db_username -pold_db_password --database {old_db_name} | mysql -u new_db_username -pnew_db_password -h new_db_host -D...
Showing results 1 to 25 of 500
Page 1 of 20 1 2311 Last »

 
Forum Jump

 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.