Can someone recommend a the better of two ways of calculating a list of product totals:
By using the following SQL:
Code:
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I am trying to add a database. here is what I have so far for the sql file im uploading.
Code:
CREATE TABLE student(
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Can anyone recommend a good GUI for MySQL for Mac? I've been using CocoaMySQL, but it seems to be lacking.
Thanks,
Adam
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I need to store time in several tables and im trying to find out the best way to do it. I need to store the time in this format HH:MM (or HH:MM:SS). Im thinking of using the TIME field in ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have an old forum that I want to transfer the users over to my new forum which has 140 users theres about 200 more in th eold database, how would I go about combining the 2....so that it updates...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I want to optimize a very expensive query, the query joins 5 tables, each having tens of thousands of records, always returns about 15000 matches and performs several calculations on ea...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I get the below error when connecting to mysql database...
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Why is this? Username/Password are...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Let's say i have two tables,
table_one;
userid,userinput,indexno
table_two;
cond,qant,amp,indexno
the indexno in table_one and table_two are the same.if i choose to delete on...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I was wondering is it good practice to use NULL for unknown values?
In the PHP forum sticky it says:
Quote:
2) Declare all of your columns NOT NULL unless you need to ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I have never done a UNION query before and need help with it so that I can speed up a select query on one of my websites.
The query is as follows:
Quote:
s...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm running mysql 4.1 with logging enabled. The master server produces a log file which is used for replication. I was wondering if there is a way to make the logfile turn over without stopping th...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
I have a Booking form which sends data to a mySQL database using PHP.
The form consists of 'sessionid' which range from 'T1'- 'T24'.
these are selected by a different radio bu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have two tables. I want to grab all the users from the users table who are not found in the second table. It's just seems to be one of those days where I can't perform the simple tasks, I think ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi there. I read the stickies and searched the MySQL forum but couldn't find an answer to my problems. Hope you can advise me. I also read the Community Guidelines, being a newbie, and had a littl...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have today a database that containes paths (eg. file//K:/folder1/folder2/picture1.gif) to gif images in an directory on my server. Then I'm using a "a href" so the picture opens when c...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi
When I added indexes and foreign keys to my tables I also inserted ON UPDATE CASCADE and ON DELETE CASCADE.
However, when I tried testing that this works by entering:-
select * fro...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am literally newbie in database design. Just finished kevin yank's build your own database driven website using php and mysql. The book helped me to understand the imporatance of deisgn in a dat...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi experts out there,
I have two tables,lets say table users and students and i would like to know if i can associate the table.users and student are the same persons but their attribute in t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have text stored in a database that I'd like to be searchable. However, searching through long strings and blobs seem like a very inefficient way of doing things.
In MS Server there's an ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I need this query optimized using indexes. So I was wondering how I could optimize it to work with an index for speed.
The query is:
Quote:
select ided from ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm trying to use LCASE with DATE_FORMAT now, but the value is not being returned in lowercase.
Code:
SELECT LCASE( DATE_FORMAT( NOW( ) , '%b %e, %Y' ) ) AS `date`;
Returns: 'Nov 1...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi Everyone,
I am designing a e-Commerce site and have come up with an idea to share the cart data in a more persistent way then is usually implemented to reduce redundancy in the databas...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello.
I have database and i changed the tables but during change i deleted important table!!
before changed i created a copy of database by "mysqlhotcopy" command and stored it...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm trying to convert an old db scripted by someone else to my new code
In my new database, I store dates using a datetime field, while the old script used a number like this "1128615400&qu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hello guys,
i have an artist table which has artistid has primary key.
i need those artist whose statusverify is 'pending' and those artist whose statusverify is 'notpending'.The field statusv...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
