7,368 Topics
| |
I have a db full of articles that have a category field. Is there anyway to select and display just the different categories? | |
How can a band create a mialing list to send out show responses thanks rob | |
SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296') After I run this the server has an intense lag and needs to be restarted or timeoutes occur. | |
Hello, I am going to study MySQL on my web server. I would like to ask if there is a useful GUI tool for MySQL to create/delete tables and browse entries on my database. | |
Hello, I heard SELECT COUNT(*) can take a lot of resources if your counting a table with lots and lots of rows (hundred thousands, millions). What if you add A WHERE clause to it? So something like: SELECT COUNT(*) FROM table WHERE pid = ? (pid is a index too … | |
I have a school problem, I'm not going to try and hide it. This is for Oracle9i: SQL class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. … | |
Can some one help me to set up a database in mysql. I need more of a logical help. | |
Hello, I tried searching but didn't see anything. How involved is it to copy a database to another server? Currently the database is on a cpanel server and I need to copy it to my new server. I copied the rest of the site and everything seems to be working … | |
Hi. I have tables like these: [B]table1 [/B]([U]table1_id[/U], table1_attribute1, table1_attribute2) [B]table2 [/B]([U]table2_id[/U], table1_id*, table2_attribute1, table2_attribute2) The primary key of the first table is table1_id. It is auto incrementing and it is also a foreign key for the other table - [B]table2[/B]. Let's say I want to add a new record … | |
HI, I'm still rookie guy with mysql database, I have a mysql script file called "MYBox" in notepad and I want to export to the one of folder directory but I don't know to do that from Does. I need someone help me what command do I need to type … | |
I was wondering what is the Database Storage Capacity for the following databases: MySQL 5 Microsoft Sql Server 2005 MS Access 2003 Thanx | |
Hi, I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB Connector 3.51. I'm facing a problem where whenever I issue a SELECT COUNT(*) statement from PowerBuilder | |
Can somebody please help me to little customize the view of the phpMyAdmin? Curently this is what I [URL="http://www.peterbudo.f2s.com/extra/myAdminC.jpg"]see [/URL] but I would like to have as [URL="http://www.peterbudo.f2s.com/extra/myAdminW.jpg"]this[/URL]. Simple, I don't like options to be displayed as list of links but as tabs. What shall I change in config? | |
do these tables look like they will work? i want theerror.errorcode to be a forgin key in the hostname.error but i don't know how to do the insert or if it's even posiable the way i have it set up. thank you, shark [INLINECODE] // Table: error Create Table: CREATE … | |
Hi, im running this website,,,worked so hard on it for about 5 months straight. i got it finally up and runnin, and the first 3 months went smooth. all of a sudden my MySQL DB drops...every table inside...just GONE. my site went down and error messages were received throughout my … | |
Hi, I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm not sure if that was the correct way doing it coz i seem to have problem … | |
Can any one tell me what is the lastest released version (not a alpha or beta version) of MYSQL? | |
i have a fied (book_number), the value is "aaa.bbbb.cccc.ddd", How can i sort the result order only by "bbbb" and ignore a, c, and d. thanks | |
Hey, I'm doing a simple INSERT command, can you tell me what's wrong with it? I won't bother you with the php right now, cause I'm simply trying to get it work in the MySQL command line. Here is the exact command: [CODE] INSERT INTO Birthdays(ID, firstname, lastname, birthday, group) … | |
Hi guys I just want to know few sources for online tutorial for SQL and SQL server. i am veyr new to this kind of stuff and trying to learn SQL and SQL server by myself. if i can get few links through which i can access online tutorial kind … | |
Hey everyone, I wasn't sure if this should go in the php section or this one, so hopefully this is right, if not, move it for me. I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information … | |
Hi there all you fine specimens of Web Developers. I have an issue that is of course a large one for me but, I'm sure all you experts will scoff at my ineptitude:) . I have been enlisted to create two web pages, both for family, and of course both … | |
Hi Im trying to import a .sql file into my mysql database version 4.0.16. and am continually getting an 1064 error. Ive tried the reference material from mysql.com but am still struggling to import it. I do have phpmyadmin version 2.5.4 installed however i would rather persevere with the shell. … | |
I have never used MySQL and am a little unfamiliar with the pros and cons of using it. Is it true that it has no front end? I know that it is free but would like to know what the options are if we use JSP, ODBC or VB as … | |
hello friend i have two website . both hosted on diff. server now what i need is to connect second website database from first website *** detail *** when user register on first website a insert query should also make on second website database. can you tell me how can … | |
I'm not sure if I should post this in PHP or MYSQL, oh well. I have a nfl predictions site, and I want to dynamically update my stadings from another table in the database. I have one table (called: matchData) with all of the matches with the following fields: lid … | |
Hi This is my first post. I need a help on db designing for one requirement. 1.) For a domain name i will be collecting three statistics every day for one year. I thought of creating table for a domain name with each column (for each date). These column will … | |
Hey, Does anyone know where the settings for MySQL's Query timeout is located? I think it should be in one of the ini files, but i don't know where i can find this. Thanks! AlPhA | |
Hello, I am developing a simple calender in my site which will display the next upcoming birthday of my member. I have a table which has 2 column cname | dob ------------------- Joe | 9/12/1982 Mathew | 2/17/1997 Pat | 8/23/1880 ------------------- What SQL Query should I use to get … | |
Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on … |
The End.