150 skills found · Page 3 of 5
Ao-ao-blare / Flask# 项目功能 * 员工管理培训管理系统员工，培训系统需要实现的主要功能包括： * 公司业总体培训课程的设置和安排。各部门部长课为员工安排相关培训课程 * 对选课结果进行统计报表。允许员工对培训安排的查询。 * 培训考核成绩的输入和查询。 * 用户个人信息的修改。 # 项目目录 ``` |—— sql # 存放相关数据库sql语句 |—— static # 存放静态资源文件 |—— |—— css |—— |—— images |—— |—— js |—— templates # 存放html文件 |—— |—— *.html |—— utils # 存放一些功能函数，查询以及更新 |—— config.py #配置文件 |—— app.py #启动程序 ``` # 项目环境 ``` -安装项目所需要的依赖包，命令如下： -pip install -r requirements.txt ``` #初始化数据库 - 在`sql/目录下`命令行进入mysql ``` mysql -u root -p ``` - 创建数据库 ``` create database trainplan; ``` - 插入数据 ``` use trainplan; source schema.sql; source insert_staff.sql; source insert_course.sql; source insert_dept.sql; source insert_train.sql; ``` #修改配置 ``` -把config.py的数据库密码改为你自己的数据库密码 -运行 app.py ```
badrulme / SQL Generator And EditorSQL Generator and Editor is a ERP migration tools. SQL geneartor provides SQL insert,update and delete statement very quickly. In Editor you can edit your any query easily. And this tools also provide SQL to SQL and SQL to Java-SQL query.
bennadel / Sequelize CommentA Sequelize plugin that allows you to insert a SQL comment before the basic CRUD operations (SELECT, INSERT, UPDATE, DELETE) in order to facilitate easier debugging of slow queries.
Aryia-Behroziuan / SQL Injection AttacksSQL Injection attack is the most common website hacking technique. Most websites use Structured Query Language (SQL) to interact with databases. SQL allows the website to create, retrieve, update, and delete database records. It used for everything from logging a user into the website to storing details of an eCommerce transaction. An SQL injection attack places SQL into a web form in an attempt to get the application to run it. For example, instead of typing plain text into a username or password field, a hacker may type in ‘ OR 1=1. If the application appends this string directly to an SQL command that is designed to check if a user exists in the database, it will always return true. This can allow a hacker to gain access to a restricted section of a website. Other SQL injection attacks can be used to delete data from the database or insert new data. Hackers sometimes use automated tools to perform SQL injections on remote websites. They will scan thousands of websites, testing many types of injection attacks until they are successful. SQL injection attacks can be prevented by correctly filtering user input. Most programming languages have special functions to safely handle user input that is going to be used in an SQL query.
borakasmer / ElasticSearchGeolocationIn this .Net Core 2.2 Console Application, we created a new ElastichSearch Index, for finding in 250 km distance Customers locations to our location with using ElasticSearch. And later we bulk inserted all document to ElastichSearch from Sql. And also the result didn't return to real distance. For this we used Haversine Formule. And finally we printed all filtered documents on to the screen.
riwfnsse / MYear.ODAC# .Net Database ORM for Oracle DB2 MySql SqlServer SQLite MariaDB; NYear.ODA 是一个数据库访问的 ORM 组件，能够通用常用的数据库 DB2、Oracle、SqlServer、MySql(MariaDB)、SQLite; 对不常用的数据库Informix、Sybase、Access也能简单的使用； 就目前而言，NYear.ODA 是支持 SQL 语法最完整的 C# ORM 组件;对于分库分表、或分布式数据库也留有很好的扩展空间。 分页、动态添加条件、子查询、无限连接查询、Union、Group by、having、In子查询、Exists、Insert子查询、Import高速导入都不在话下， 递归查询、case when、Decode、NullDefault、虚拟字段、数据库function、update 字段运算、表达式等都是 ODA 很有特色的地方。 允许用户注入SQL代码段，允许用户自己编写SQL代码等，同时也支持存储过程Procedure(或oracle的包） 由于很多开发者都比较喜欢 Lambda 的直观简单，ODA 的查询也扩展了此功能。
stephenpfahy / Web Applications ProjectThis is a repository for the project for the Web Applications module for the Higher Diploma in Science (Software Development). It is a client based website which was built using HTML5, CSS3 and JavaScript. The website is connected to a relational database via PHP which inserts, reads, updates, and deletes information entered by the user from the website into the relational database. The relational database used was created for the Database Design & Development Module. Stephen Fahy G00172772 WEB SITE DESIGN 13/12/2015 The projectmain file contains all the files for my South Dublin Housing Council website. This consists of my six html5 webpages. There is a homepage, a tenants page, a property page, a repairs page, a tradesman page and an equipment page. Each webpage is linked to each other by a sidebar on every webpage with links to the other pages. You enter the website via the homepage which then can access all the other webpages of the website. In the projectmain file there is the css file whch contains the external css design for the website, a images file which contains the images for my website, a js file which contains the javascript for the website, and a php file which contains the php insert statements and select statements for each webpage except the homepage. The website is linked to a database via HTML5 forms and my php code on each webpage except the homepage. The database can be accessed by opening the south_dublin_housing_council_repairs file which contains the datafiles or by importing the south_dublin_housing_council_repairs.sql file into your phpadmin in mysql. The website is designed for South Dublin Housing Council's employees so that they can view and update the council's database. The employees access the website via the council's private intranet network which can be used in the main South Dublin Housing Council building in Tallaght or in other council buildings in South Dublin. The employees access the website via the homepage which accesses the other webpages. On the other 5 webpages employees can view the council's database or they can update it. The majority of the website css design was done in an external css file in completesite.css. There was internal css design done in the website such as the table on the homepage using the <style> tag and there was inline css design using the style attribute such as the paragraph on line 108 on the property webpage. Javascript was used to add a link to googlemaps on the property page website so users could view the south Dublin area in Google maps. Php insert and select statements were used to update and view data in the database from a website. The php insert and select statements were used in all the pages except the homepage. All my html5 files have been validated using w3c markup validation service. The website is functional in all browsers but is best viewed in Google Chrome or Mozilla Firefox. CHANGES TO THE WEBSITE FROM THE WEBSITE DESIGN. The website design was not changed when the website was being created, but there was some slight changes made. They changes made are as follows: 1. In the property table the TENANT column was changed to TENANT_ID to have the same name has the TENANT_ID primary key in the tenant table. 2. In the property table the REPAIRS column was changed to REPAIR_ID to have the same name has the REPAIR_ID primary key in the repairs table. 3. In the repairs table the TRADEMAN column was changed to TRADESMAN_ID to have the same name has the TRADESMAN_ID primary key in the tradesman table. 4. In the trademan table the AVAILABILITY column was removed as the information provided with this column conflicted with information in the DATE and TIME columns in the repairs table. 5. In the tradesman table the EQUIPMENT column was changed to EQUIPMENT_ID to have the same name has the EQUIPMENT_ID primary key in the equipment table. 6. In the homepage of the website a table and extra headings were added to section div tag. Also a link was added to this section to bring the user to the next webpage. 7. In the tenant page there were a few changes made to the section div tag. A few extra paragrahs were added and links to view the database were added. There was a link added to go to next page. 8. In the property page there were a few changes made to the sectin div. A few extra paragraphs were added and links to view the database and to go to the homepage were added. 9. A javascript link to view google maps was added to the property page. 10.In the repairs page a few extra paragraphs were added and links to view the database and a link to go to the next page. 11.In the tradesman page a few extra paragraphs were added and links to view the database and a link to go to the next page. 12.In the equipment page a few extra paragraphs were added and links to view the database and a link to go to the next page.
hay / Json2sqlPHP script that converts a JSON file to a series of SQL INSERT staments
MWallin / GAS InsertValuesA custom function for Google Apps Script to make values ready for SQL INSERT (...) VALUES (...)
Rotifer / Spreadsheet2SQLGAS code to convert values in a spreadsheet to SQL statements. Header row is used to for the "CREATE TABLE" statement, data rows are used to create "INSERT" statements. Cangenerate SQLite, MySQL and PostgreSQL versions of SQL
daranzolin / DputsqlCreate 'CREATE TABLE' and 'INSERT INTO...VALUES' SQL statements from R objects
cristianoascari / Lista De Paises Em SqlLista de países em português (BR) no formato SQL (Insert).
imtkain / Fabric ReduxFramework for Power BI write-back using Fabric Translytical Task Flows. Includes SQL stored procedures, Python UDFs, DAX patterns, and governance templates for singleton and bulk INSERT/UPDATE/DELETE operations with CDC tracking.
selva221724 / EdaSQLedaSQL is a python library to bridge the SQL with Exploratory Data Analysis where you can connect to the Database and insert the queries. The query results can be passed to the EDA tool which can give greater insights to the user.
karenpayneoregon / SqlServerInsertFilesProvides code to insert files into SQL-Server database table
zigorou / P5 Sql Abstract Plugin Insertmultibulk insert and update support for SQL::Abstract
07akas / Basic Infosql insert records in to data base
AnastasiaLunina / SQLPracticing SQL . Create a flowchart for database, add relations, insert data, practicing queries.
sabiul / Insert Data Into MySQL From CSV File Using Python 3Insert data into MySQL from CVS file using python-3
drahmel / MongoSQLSQL interface for Mongo queries, updates, and inserts. Makes MongoDB more user friendly.
