7,368 Topics
 | |
| | Hi all, I have one problem on selecting larga data from mysql. I have inserted large data to mysql, and all data was inserted. I see it from phpmyadmin. but when i select that record from database it cannot display whole data.it doesnt show the end part of the data. …  |
| | |
 | hi. i'm gonna ask about creating a system in database using Java .. i have a problem about making system because they didn't thought us how to create system... |
 | I want to prepare MySQL Server 5.6 for thousands/millions of inserts. Ive found this: •innodb_doublewrite = 0 •innodb_buffer_pool_size = 50%+ system memory •innodb_log_file_size = 512M •log-bin = 0 •innodb_support_xa = 0 •innodb_flush_log_at_trx_commit = 0 Is there anything else I can do? Thank you |
| | I am using MySQL 5.0 on WinXP pro. Below is the script for creating the table CREATE TABLE `tbl_test` ( `gameID` VARCHAR(45) NOT NULL, `gameName` VARCHAR(100) NOT NULL, `gameStartDateTime` DATETIME NOT NULL ); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 1:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 8:00:00'); INSERT INTO `tbl_test`(`gameID`,`gameName`,`gameStartDateTime`) values('gameID1','gameName1','2008-01-01 12:00:00'); I would … |
 | Hello, I have tried to install mysql in linux and it said that I already installed it. Then the problem is I do not know the password to enter it. What should I do? davy@ubuntu:~$ mysql -uroot -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: … |
 | I am very confused with the pagination system of my site, the site consist two services android games and movies but in each they all have their categories for example the android games has categories as follows: * ANDRIOD GAMES * 1. Arcade 2. Sports 3. Action 4. Adventure 5. … |
| | I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you  |
 | Can you help to show how to upload multiple image with php and mysql, please? |
| | Hi I need to put google maps inside my website so that the user can add his location (manually) Then the location will be stored in the database so I can brows it in the display page.I've looking over the web but couldn't find the way to do it :( … |
 | 0 down vote favorite I have a table: CREATE TABLE `student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`id`) Now i want to create a stored procedure that will insert new column into this table with the next id (which is … |
 | I am interested in how to know the price of building a website with shipping cart, is there any thumb rule out there for a non-IT expert to evaluate it. you'd better give me some price with website reference, you could also inbox me if you like. thank you |
 | Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because … |
| | I have a query which i am trying to get the last date and when i do, the purchdate and LastPayDate is the same for all the data. the query is below: SELECT DISTINCT customer.custid,customer.compname,customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, preAgg1.LastPayDate,customer.depot, MAX(mastorders.lastsuppdate) AS purchdate, MAX(mastorders.id) FROM customer,mastorders,acctofficer, (SELECT DISTINCT T.custid, Max(T.timestamp) … |
| | I am tring to perform a calculation in my query. I've been working on it for hours, so I need another pair of eyes to see what I am missing. Everything in the query is working except for the g.courseFee part. The course fee is not being added to the … |
| | Hi guys i'm creating a new table in sql to allow users to register with my website, this is the sql code that I'm suing does this seem ok to you? CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE `dyscaculia`; CREATE TABLE IF NOT EXISTS `users` ( `Firstname` … |
| | What I'm trying to make is something like this. jsfiddle.net/zunrk/ I want to create a receipt that when you pick the data from the drop down it will show the details on other text box. The other problem is that i wanna create multiple textbox because there will be multiple … |
 | Hey guys, I am having some difficulties regarding a select query logic. Then I have a table with products and it has a column -> submodel with all kind of data in it.  What I want to achieve is to **STRIP** (with REGEXP?) all the strings starting with … |
| | Oldest question in the book. Google says: SELECT NOW()+ 0; And a bunch of other things like UNIX_TIMESTAMP() but doing a select on these, it only returns the seconds, not including the miliseconds. Basically, I need, from MySQL's side the milliseconds. How can I do this? |
 | hi there im currently do some simple webpage that can submit the data save into database into MYSQL Workbench. But currently i have an error for insert into table. The error is --------------------------- App_Web_kclqmsmh --------------------------- You have an error in your SQL syntax; check the manual that corresponds to your … |
| | hi guys i'm creating my own website and i want to let users register and for them to be able to let them take a quiz. I have created this sql code CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE `dyscaculia`; CREATE TABLE IF NOT EXISTS `users` ( … |
 | i have to backup my database via php codes but i always ended up with an empty file? <?php include "connection.php"; $command = 'mysqldump -u root -p ***** –all-databases > dump.sql'; exec($command) or die(mysql_error()); ?> any help would be great |
 | i am actually working for showing online for loged in user. This is my code: $qt="select userid from plus_login where tm > '$tm' and status='ON'"; $result = mysql_query($qt); while($row=mysql_fetch_array($result)) { $uid = $row['userid']; $qt1="select first_name, last_name from signup where user_id='$uid'"; $result1 = mysql_query($qt1); while($rows=mysql_fetch_array($result1)) { $_SESSION['name']=$rows[0]." ".$rows[1]; echo $_SESSION['name']."<br>"; } … |
 | Me again, I have the following which should generate a form and populate that form. <?php session_start(); include("db_connect.php"); if(($_SESSION['user_id']) && ($_SESSION['access_level'] == 1 )) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <head> <title>Teaching Int Limited - Home</title> <meta name="title" content="Teaching Int Limited"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta … |
 | Hello, I have used Single Translation Table Approach to make multilanguage site in PHP. You may see [here](http://www.apphp.com/tutorials/index.php?page=multilanguage-database-design-in-mysql#single_translation_table_approach) The current index page is not working. My objective is to have one example to use these tables and display one working page. For example: It should work like [this](http://demo.codeursolitaire.com/multilanguage/index.php) **by using … |
 | A while ago I explained how you could tag articles (see [this thread](http://www.daniweb.com/web-development/php/threads/387961/php-code-to-show-related-posts-on-a-blog)). Now you get a full working example. This code and the SQL script is also available on GitHub. The attached MySQL dump needs to be imported into your database, and you must update the credentials in the … |
| | Hi, I've run into absolute brickwall and am really desprate for your help please. I have a MYSQL Database with two Tables called user_comment and the second user_table. When a user register with the site, their details are kept in the user_table. the second table user_comment is so that users …  |
| | Hallo, This is funny. I export mysql codes to the webserver. Yet, I cannot run the codes correctly, there are some errors when I run the codes: Error SQL query: -- -- Database: `project_infracom` -- -- -------------------------------------------------------- -- -- Table structure for table `infracom_admin` -- CREATE TABLE IF NOT EXISTS … |
| | Hello guys i want create a table which willl consist of Regions and Location therefore when i take a region it should give me a list of locations under that region. i hope my question is clear enough THank you |
| | INSERT into tbl_inquiry (name,phone,email,subject,message) values ('apoorva','000012345','email@email.com','subject','hi what's up') |
The End.