10,938 Topics
 | |
| | When would you use ORDER BY in DELETE statement? |
| | How would you change a column from VARCHAR(10) to VARCHAR(50)? |
| | Hi!. I'm trying to get a connection from a Java application to a MySQL database. When I execute the method getConnection(url, user, pass) this is what I get: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mysql.user_objects' doesn't exist I have executed the perl script called mysql_install_db with the result: C:\Archivos de programa\MySQL\MySQL Server 5.1>perl scripts/mysql_install_db.pl … |
| | Hi, I want to create a scrapbook like orkut or in facebook. I am taking a text area on which the user have to write the text. The text can be any thing like "text with special characters as well as html codes. This text will be stored into mysql … |
| | Im suppose to search by name and active users, now the problem is I can search by name, but i dont know why active is givin me a problem.. My coding is like this, what is wrong? $sqlFilter .= ' AND (username LIKE "%'.$_SESSION['filter']['filterusername'].'%" OR active LIKE "%'.$_SESSION['filter']['filteractive'].'%" )'; username … |
| | I am having trouble with a certain query. The problem is that I am using an INNER JOIN with two tables that both have a column called "id". I want the query to return ALL the column names but in addition I also want table1.id to be returned as id1 …  |
| | Hi all, if anyone can assist I have a query which just will not resolve it self no matter what I have tried. I am testing this PHPmyadmin before I apply to the website if this helps Thanks in advance DJ The query that is being run produces duplicate row … |
| | basically this is the first time iam using the iSQL *Plus, i am confused and i just want to no, when you create a table how can you view the actual table you have created, and how do you put data into the table?.. |
| | Hello all, I have a page that allows the user to update their account detail. The prblem is that when the page loads the users inforamtion doesn't appear in the text fields. I've checked the code and i cant see any errors nor does php flag any errors. Can someone …  |
| | Hello All, I have been trying to copy a database from a local system to remote system using the mysqldump command.However, I am not able to do so.I just wanted to know syntactically where am I going wrong? Here are the commands I have tried: mysqldump database-name | ssh [email]myname@mysql.cs.abc.edu[/email] … |
| | Does any one know how to use SQLite? Can anyone tell me how to convert populated MySQL tables to SQLite tables without using a DBConvert software? |
| | We are an American company, doing business world wide, we have a lot of members coming on board in Russia, Estonia, Latvia, Africa and lots of other places. They are all asking for us to translate the web pages. So I programmed in a language translator, where we can give … |
| | I am having issues with the following code of mysql when using the "not like" mysql command. My snippet looks like this [CODE]$name = something $sql = "Select * from table1 where table1.field1 not like ' $name ' ";[/CODE] What it should look like in phpmyadmin is [CODE]Select * from … |
| | can any one give the code for join the table in left join method in phpmysql ? |
| | Hi guys... I know little to nothing about this and i was told to run this command, but I got this error when I did...does any know the correct syntax for this? I appreciate your help and thank you in advance! Error SQL query: CREATE TABLE wp_wpmq( id int( 11 …  |
| | I created a user login/registration system and the login works fine. But I can not seem to get the registration to insert the info into the database. It returns no errors and says the record is there but when you check from phpMyAdmin, the record is not there. Here is … |
| | Anybody know how to do the following: id (PK/autoincrement) file_id (FK/int) - same file id pops up loads of times statement (varchar) - just some text from the file status (tinyint 0/1/2) - depending on the statement = 0 or 1 or 2 into a single record for each file_id, … |
| | hi first of all i want to create a linking with two tables in database: 1 table : id,name 1 nick 2 john 3 michael 2 table (i want to use this table for dropdown list) id,job 1 engineer 2 scientist 3 coder how can i link them both? the … |
| | Specification: I wrote most of the code separately but seems am having difficulties linking it to my database: Write a simple E-commerce application, which may be a bookshop, music shop, clothes store, or anything else you wish. There should be a “user” interface to allow customers to select and purchase …  |
| | I wan to host my own content, but I can't figure out where to put my files. I'm using WAMP, [url]http://www.98.163.121.220.com/cgi-sys/defaultwebpage.cgi[/url] That's my site. How can I just host my own files? |
| | please any one help me i want display images from mysql database to my web page... i have no clear idea about that please help me.. i want script that will upload file and also display files in date vise. And also i want display my images like my attachment. …  |
| | Hi All, i want to develop a realtime stock updation chart with js,Ajax,MySQl and Eclipse. Environment with MySQL,JS and tomcat is established. Now how can i start with the use of Ajax into Eclipse and go through dis module is there any source example or code available ? Thank u … |
| | im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql.. i have this sql statement on my MsAccess [QUOTE]SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt FROM WItems INNER … |
| | im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql.. i have this sql statement on my MsAccess [QUOTE]SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt FROM WItems INNER … |
| | Hii I m using PHP-MySQL to make a class assignment. In this i have made a login control. It was working very fine. But i made an attempt to provide the password changing facility. Since then my project is not logging in. It shows in table the new password but …  |
| | I need helping fetching the URLs I have stored in my database and opening a new page. I am using a dynamic drop down menu for users to select a category and company. Once a user selects category(parent table) the child table opens up. The user then can click the …  |
| | Hello, I am working with visual studio 2008 and an external website host. The real issue is that I am trying to add a "data connection" from the mysql server on my host to visual studio. On the website host mysql is already installed and running, a Database has been …  |
| | hello i install mysql , jdk and tomcat. when i run java file it give message that no database connection available . where to put mysql connector and how to set class path in environment variable . plz help me |
| | Hi, SQL below returns 1, 2, 3 in three rows. I want to see only 3 because there are total 3 records. How can I solve this problem. Thanks [CODE]SELECT COUNT(*) as totalProduct FROM customers INNER JOIN uploads ON customers.id = uploads.fk_id GROUP BY name[/CODE] |
| | Hi all, categories_id (PK,AI),categories_name(varchar(150)), categories_order(int), categories_image(varchar(100)), categories_status(int) This is my table structure. My server side language is PHP. User has to insert values to this table where categories_order(int) is optional. If the user miss categories_order(int) then it will be filled with zero. On select query, all rows must to sorted …  |
The End.