Tagged Questions
4
votes
6answers
64 views
BASH - How to read file contents to insert results into mysql WHERE clause
I'm trying to make a file (call it accounts) and have a bash script (call it *name_checker*) loop through each line and make it into multiple strings to store in a variable called '$NAMES' for a mysql ...
-3
votes
1answer
61 views
Mysql data from table that contains a data [closed]
I've some thiing that I want to resolve;
I've made a search script and it works;
But I want to have the full data in other word I want to ratrieve all data from the databade in table that contains a ...
-10
votes
2answers
47 views
Displaying Data From a Database Search Results [closed]
I've made a search script but I want to display all the data of a result from the database by clicking in one of the search results.
I've tried with the GET function but I can't do it.
But it ...
-1
votes
1answer
38 views
Can't call PowerShell script for database access (MYSQL)
Using this database connection script I have found here. I have modified it and did the proper setting to let the script run but don't understand the error I am getting.
The script code is here:
...
-2
votes
1answer
34 views
PHP: Value from responce array is so slow [closed]
If I have an array, for example:
$ar['SOME_VALUE'];
How I can do $REQUEST for it or what to do, if server slow response and give this value after two seconds but my script get command to write it ...
0
votes
1answer
44 views
Run script with EntityManager JPA on Mysql
I'm trying to run a script (.sql file) but i have multiples errors since i tried many ways, here's my main sql script:
INSERT INTO `Unity` VALUES (11,'paq',0,'2013-04-15 ...
1
vote
2answers
37 views
MySQL - How to select Multiple rows from Multiple tables
I have a question about a SQL statement, for some reason my script is not working properly..
This is the Scenario; I have 6 tables
Patient
-PatientID
-PatientName
-EmployerID FK to ...
0
votes
2answers
30 views
How does MySQL take variables in bash?
Making a script to print out data from a MySQL db via bash, I met the following problem:
While I try to log in, it uses the password as the database to log in to.
Script is like this:
#!/bin/bash
...
3
votes
1answer
51 views
php script to modify cico dhcp pool
I'm trying to automate a process of a modem provisioning system.
the code below is my attempt with the exception of a form that i did not list that is passing the variables.
the DB portion of the ...
0
votes
2answers
115 views
Remove the first row from CSV file - php csv file upload issue
This script running fine but adding first row from excel file (header names). I want to make ignore first row in loop - Please check the script -
<?php
//connect to the database
$connect = ...
0
votes
3answers
101 views
CSV File With PHP and MySQL - Data not uploading properly in database
I download the script from - http://www.k-fez.com/?p=101 website and trying to upload CSV file on my server. It uploading file successfully but Blank - please check image
<?PHP
session_start();
...
0
votes
0answers
31 views
Matching CSV fields to a MySql database throough a template
we are using PHP and MySql for our application.
Problem:
we get some data, we put them in a CSV file, we upload them in our database through a template, then we upload the data online.
we have ...
0
votes
0answers
25 views
Need your help adapting a script for a calendar database please
I dont know much about the functions of MySQL so I wonder if anyone could help me create a simple script to populate a table with some dates for a calendar I'm making. Basically I found this on the ...
0
votes
0answers
20 views
Conditional command execution for installer
I was wondering if I could get help with my installer.
Right now it come packaged with the command line SVN client.
This package is to download, install, update, and configure the application ...
0
votes
1answer
38 views
Adding a NULL value for a datetime entry in an SQL table through Bash
I am attempting to populate an SQL table through reading text files via bash to hand off to the table. I have it all working except when trying to add a null value to a datetime field.
mysql --host ...
0
votes
1answer
44 views
How to use select statement result as a variable and pass it further to the script
please advise how to use select statement result as a variable and pass it further to the script. Simple script:
#!/bin/sh
# --mysql part START--
pwd="pass"
D="db"
mysql -uuser -p$pwd -D$D -s -N -e ...
0
votes
0answers
19 views
How to import Objects and Links in MySQL using a script?
I have 2 tables in a MySQL schema :
Table A :
CREATE TABLE IF NOT EXISTS `test`.`A` (
`id` INT(10) NOT NULL AUTO_INCREMENT ,
`Code` VARCHAR(45) NULL DEFAULT NULL ,
`Description` VARCHAR(45) ...
0
votes
1answer
16 views
MySQL Table Normalizing via plain sql error
I need to normalize my table. So I made a script (sql) which I execute.
I would like to INSERT all existing Clients from table A (old) into table B (new).
It is simply done with
INSERT INTO `A` ...
0
votes
1answer
68 views
MYSQL + PHP comparing live time and datetime stored in database
<?php
define('INCLUDE_CHECK',true);
error_reporting(0);
session_name('tzLogin');
session_start();
$user = $_SESSION['name'];
if($user or die('Please login to continue')) {
...
0
votes
1answer
41 views
SQL Help - inserting columns into a table based on distint column values
Hi im trying to do the following and am a bit stuck for idea:
I have a set of data like this:
Column1(int) Column2(int) Column3(Varchar)
0 1234 ABC-0
1 ...
0
votes
1answer
36 views
mysql / php - 3 tables (if number exists)
I have a problem,
i´m building an own register form for a browsergame.
I have to place the planet on register, that the user get.
so i have: 9 galaxies, each galaxy has 400 systems and each system ...
0
votes
1answer
43 views
Shell scrip extract data from a file
I just started programming in shell script and I have a file that looks like this:
stuff that doesn't matter
doesn't matter
matter
*LINE 35*School: xxxxx -> NAME: xxxxx AGE: xxx DESCRIPTION: ...
0
votes
2answers
35 views
mysql update does not work via php script,though it works through the mysql terminal [closed]
i have a mysql table with a column named approved. In case i use the mysql script
update tablename set columnname=1 where id=x
where x is an integer number,everything works.
The problem is when ...
0
votes
2answers
217 views
Executing sql script on a batch file with accent
I have some accent problem when I execute some sql script in a batch file ( the sql script create the database with tables and some inserts)
That's the batch file that execute the script file:
@echo ...
0
votes
1answer
60 views
Simple SQL Search tweak
I am playing around with PHPFreaks "Simple SQL Search" script. I was wondering how to refine the search methods after a query has been submitted.
Let say I have submitted a search term like "music", ...
0
votes
2answers
50 views
Can't change SQL to have an id as primary key(AI) rather than username
I recently started using Jpmaster77's Login Script, and it has shown to be very great. However, now I am trying to experiment with it. I am trying to create a new table at the beginning of the row ...
0
votes
1answer
466 views
Install MySQL service in Inno Setup
I would like to install MySQL service after install in Inno Setup. There is already similar question here, but no solution there works for me.
If I use sc create like that in the solution, then after ...
0
votes
2answers
29 views
extract specific data from a cell, MYSQL
ok, i have a table name ORDERS and i have a Column in the orders table named OrderedItems
within the ordered items the data looks like this example below
Flavor Name (10ml, 0mg nic)
Flavor Name ...
0
votes
0answers
86 views
PHP script to parse sql queries and separate queries
I want to write a php function that could parse select SQL queries.
Just for an example:
select * from tableA a, tableB b
where a.cola = b.colb
and cola = 'abcd'
to convert into:
select * from ...
0
votes
1answer
52 views
Google Script work with jdbc and database mysql
I work with google script and the JDBC connector to my MySQL database. I want to run a query using a variable, for example:
var rs = stmt.executeQuery("select*from Comuni where nomeComune=v");
How ...
