| |
thread by: josephloup |
last post May 8 '15 by: elliottkerr
Hi Experts,
I encountered the following problem when I'm trying to open SOME tables in MySQL database:
"Incorrect information in file .//.frm"
Other tables within the same database can be opened without any issues, only some tables have this problem. And this is not just happening in one database, but the other database on the same server...
|
thread by: irslan rafique |
last post May 14 '15 by: Luuk
Please help me to fetch data from table B to table A:
Its my input form coding(insertdata.php):
<?php include ( 'header.html');
include ('selectdriver.php');
include ('selectdestination.php');
include ('selectloading.php');
?>
|
thread by: tdrsam |
last post May 15 '15 by: tdrsam
I'm trying to get a web page working so that visitors to the website can leave reviews of the business, or read reviews others have left. But I'm having trouble getting it working on the production server, even though it worked in development.
Here's the code I'm using to inert the reviews into the database;
<?php
$dbc =...
|
thread by: martinpayne |
last post May 27 '15 by: computerfox
How can a read only MYISAM table become corrupt?
I have to do a myisamchk -r approx. once a week as the table gets marked as crashed.
I can't see how this is happening though as no changes are being made to it, it's read only.
It's running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so...
|
thread by: dragon52 |
last post Jun 3 '15 by: dragon52
I have a StudentsTable which has 3 fields to describe which class a student belongs to.
The first is session, in the db it is stored as 1 or 2.
afternoon,morning (values 1, 2)
Language, also stored as 1, 2.
English, Chinese (values 1, 2)
Class number which has values K1,K2,3,4,G...etc. This list is long and changes from time to time.
|
thread by: ToOSk3tChY |
last post Jun 21 '15 by: computerfox
Hello Bytes Community,
I am not programmer at all. I run a free forum as a hobby for organised racing and I'm just managing with HTML and CSS right now. I've been doing this since January, never touched a line of HTML really until then but I'm enjoying learning as I go.
So... this post is just a different method I'm trying, to see if I can...
|
thread by: babs115 |
last post Jun 26 '15 by: computerfox
I get these error each time I write the syntax in quotes. Please can someone help me?
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'book(
saleID int not null,isbn varchar(20) not null,quantity int not null,salePri' at
line 1
|
| |
thread by: imie44 |
last post Jun 29 '15 by: imie44
Dear All,
I have a strange problem. I have a Synology NAS server with SQL databases. When connecting from my client workstation with mysql workbench 6.2 CE it all works perfect and could access the database. Sometimes I have to execute flush-hosts but then again access granted. User previleges on database set '%'. Also telnet 3306 works fine...
|
thread by: gruevsotir |
last post Jul 6 '15 by: computerfox
I have functions saved under proc.
I am using MySQL Workbench. I just tried to alter a function which resulted in an error (something about it being unsafe and binary logging); however, when I clicked "Apply", it dropped my function... and then as I was searching for the relevant option setting, Workbench crashed!
What's the easiest way to...
|
thread by: rob9021 |
last post Jul 9 '15 by: rob9021
Hi Guys,
I am using Java in Eclipse to create tables in a MySQL Database. Everything has been working fine until it inexplicably stopped working the other day. My code runs but nothing happens to the database due to an error when I try to initialise the connection. The code actually runs to the end, the error is only viewable when I step...
|
thread by: radiantsoft |
last post Jul 25 '15 by: Luuk
I want to count size of all rows in mysql table? is it possible? how?
|
thread by: Aniia |
last post Jul 25 '15 by: Luuk
How to do paging in mysql store procedure??
input paramter will be (in pageno INT, IN no_records)
result will be for example i pass value 1 and 10 : first 10 records it will show.
or 2 and 10 then it will show 11 to 20 records.. please help..
|
thread by: sabarisan |
last post Jul 26 '15 by: Luuk
what is the procedure to connecting a database and application using byethost server
|
thread by: xcoop38 |
last post Aug 1 '15 by: Luuk
Trying to write a sql statement to return a result set comparing two dates where the 1st date is 31 days or greater than the 2nd date
|
thread by: babs115 |
last post Aug 9 '15 by: Siam9
My colleagues say it is wrong but not one of them can tell why and I don't know myself.
I attached the design and ERD for your correction ,please.
|
| |
thread by: Exequiel |
last post Aug 14 '15 by: Rabbit
I have bunch of data in the table in my database, the field is in a varchar type, the field has deimal numbers, has integers, has letters etc. i only want to check if the data in that field is a decimal, how can i check that using only mysql syntax? no php.
Any comment are so apprecitaed, thank you. :)
|
thread by: babs115 |
last post Aug 21 '15 by: RonB
HELP PLEASE!!!!!!!!!!!!!
Error
MySQL said: Documentation
#2003 - Can't connect to MySQL server on '127.0.0.1' (10061)
Connection for controluser as defined in your configuration failed.
|
thread by: viana2020 |
last post Aug 31 '15 by: RonB
i am trying to feed a number to database in this case my reference number which is of a (AAA/BBB/28AUG2015 - 4082) format,
which should be selected by user,and the date should be the system date while the last number should be auto-generated in that sequence.
the 1st and 2nd values are fixed.kindly i am unable to do that on phpmyadmin DB...
|
thread by: abreal |
last post Sep 12 '15 by: Luuk
Is it possible to install MySQL standard edition to a remote server using filezilla to upload files and putty to run and execute the setup MySQL?
if yes, how to run the installation
|
thread by: yelly |
last post Sep 12 '15 by: Luuk
My goal is to connect my SSIS package to a MySQL server running on a different machine (windows).
I am new to MySQL and my client's system admin doesn't know much about MySQL either. I've been trying to connect to using ODBC MySQL driver 5.3 but i keep getting this error: ERROR: Can't connect to MySQL server on '' (10061)
Do i need to have a...
|
thread by: daisyy |
last post Sep 12 '15 by: Luuk
I tried editing .ini file, it prompts access in denied. And if i try to chnage using command prompt that also it does no allow me to do so.I cannot even use "Show Max_allowed_packets". It says show is not recognized as internal and external command.
# For advice on how to change settings please see
#...
|
thread by: lgoddgreat |
last post Sep 15 '15 by: lgoddgreat
I was trying to create a website that enables the users to Input something in it, like user info. but it always gives an error whenever I try to test submit the inputted data's into the database.
'Could not Connect: Access denied for user 'smdg'@'localhost' (using password: YES)'
connection:
define('DB_NAME', 'testdb');
define('DB_USER',...
|
thread by: harman30 |
last post Sep 16 '15 by: harman30
I have created a search box now want to add search function to it that searches for text entered only in my site. I want to know how things are put together for search to work. I know we need to call data from tables we want to search, but do i need to create a table for this search function just read it somewhere, if it is so what is the purpose...
|
| |
thread by: harman30 |
last post Sep 16 '15 by: RonB
I am using the code below for search function but it is not protected from injections and I am not programming expert so can anyone help me on this my code is
<?php include ( "./inc/header.inc.php" ); ?>
<?php
if(!isset($_POST)) {
header("Location: main.php");
}
$search_sql="SELECT * FROM blogs WHERE title LIKE '%".$_POST."%' OR body...
|
thread by: viana2020 |
last post Sep 22 '15 by: viana2020
how do i change this to mysqli?
<?php
require 'connect.php';
session_start();
$username = "";
$password = "";
|